Ask
20
@analytics_ari ·

My analytics only shows daily data points and I want weekly or monthly — is that possible?

I want to look at a standard acquisition report as a line chart aggregated by month rather than by day. Over a long period the daily view is unreadable noise and the shape I care about is the trend.

This seems like it should be a basic option and I cannot find it. I am not sure whether I am missing a control or whether the granularity is genuinely fixed.

What are the actual options here?

4 answers Share
Report

Answering anonymously — a moderator will review it first.

  • @analytics_ari · 4w ago

    You are not missing anything obvious — granularity control in the standard reports of the current generation of analytics tools has been much weaker than in the previous one, and this is one of the most common complaints about the transition.

    The behaviours worth knowing:

    • Granularity is often inferred from the date range rather than chosen. Selecting a long range sometimes switches the chart to weekly or monthly automatically, and selecting a short one forces daily. So the lever is the range, not a granularity control.
    • Exploration or custom report builders generally do expose the dimension directly — you add a week or month dimension and chart against that. This is the reliable route when the standard reports will not cooperate.
    • Vendor documentation has at times stated plainly that only daily data is available in certain views. If you are in one of those views, no amount of hunting will help.

    UI details in this area change frequently, so treat any specific instruction you find, including this one, as needing a check against the current interface.

    29
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @smallweb_suvi · 4w ago

    The durable answer, and the one I would recommend if this matters to you regularly: get the data out and chart it yourself.

    Most analytics platforms offer an export or an API. Pull the daily figures into a spreadsheet or a small dashboard, aggregate by week or month there, and you control the granularity permanently. It also survives the next interface redesign, which is not a small consideration given how often these tools are reorganised.

    For a small site this is a one-off afternoon and then a scheduled export. For anything where the trend is the thing you actually look at, it is worth doing rather than fighting the reporting UI every quarter.

    24
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @proxy_pol · 4w ago

    One statistical note that is worth applying whichever route you take: weekly aggregation is usually more informative than monthly for web traffic.

    Web traffic has a strong day-of-week pattern, and weekly buckets remove it cleanly because every bucket contains exactly one of each day. Monthly buckets contain a varying number of weekends, so month-over-month comparisons carry a calendar artefact that looks like a trend.

    If you are trying to see the shape rather than report a figure, a seven-day rolling average over daily data is better than either, because it removes the weekly cycle without throwing away resolution.

    19
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report
  • @dns_derya · 4w ago

    Worth checking one thing before building anything: how long your data is retained.

    Some analytics configurations discard detailed event data after a fairly short period by default, keeping only aggregates. If you plan to chart multi-year trends, verify the retention setting now rather than discovering the gap in eighteen months, because the data cannot be recovered afterwards.

    12
    Share
    Reply

    Answering anonymously — a moderator will review it first.

    Report