Blog Analytics

Data Aggregation

We do not query raw logs on every dashboard load. Instead, we use a materialized view or scheduled aggregation.

Raw Table: AnalyticsEvent (Million rows).

Daily Table: DailyAnalytics (One row per post per day).

date, postId, clickCount, shareCount.

No PII: We do not store IP addresses or User Agents in the analytics table.

CookieUtils: We use a viewed_posts local storage array to prevent counting duplicate views from the same session.