How to build a monthly GA4 report in Google Sheets

By Jake Marsh · Updated

To build a monthly GA4 report in Google Sheets, create a Trafficledger report with Dates set to Last month and Compare with set to Previous period for month over month, or Same dates last year for year over year. Add the metrics and dimensions you report on, click Save report, and schedule it monthly on day 1. Each metric gets a current column, a previous column and a change column.

An example report

A report on where last month's visitors came from, compared with the month before:

SettingValue
Report nameMonthly channels
DatesLast month
Compare withPrevious period
DimensionsSession default channel group
MetricsSessions, Total users, Key events
Sort by-sessions

The tab it writes has one row per channel with Sessions, Sessions (previous) and Sessions change side by side, then the same three columns for each other metric.

Steps

  1. Open Trafficledger from the Extensions menu and click New report.
  2. Pick the property and name the report. The name becomes the tab name.
  3. Set Dates to Last month. This is the whole previous calendar month, so a run on any day of the month gives the same range.
  4. Set Compare with. Previous period compares with the month before. Same dates last year compares with the same month a year earlier. Last year, same weekdays shifts by 52 weeks, so a month that had five weekends is compared with days that line up.
  5. Add dimensions and metrics. Search the list for names you see in GA4, such as "Session source / medium" or "Page path". Fields that can't go together are greyed out as you pick.
  6. Filter if needed. Use the filter builder, or type a dimension filter such as country==Germany,country==France (comma means OR) or a metric filter such as sessions>10;engagementRate>0.5 (semicolon means AND).
  7. Click Save report, then Run now.
  8. Schedule it under Schedule: monthly, on day 1 or 2, after an hour of your choosing.

Several monthly views in one spreadsheet

Each report is its own tab, so one spreadsheet can hold a channel report, a top pages report filtered with pagePath=^/blog and a country report, all refreshed together. A summary tab that reads from them with ordinary formulas or charts updates when they do.

Need more than one month in rows instead? Add the Year month dimension and set Dates to Last 12 full months: each month becomes a row you can chart as a trend.

What it costs

Trafficledger is $55 a month or $528 a year per Google account. Free trial: 30 uses or 14 days, whichever comes first. No card needed. Every plan and the install link are on the Trafficledger page.

Trafficledger: GA4 Reports in Sheets

Google Analytics 4 reports in Google Sheets: saved reports, comparisons and scheduled refresh $55 a month or $528 a year per Google account.


Questions

Why are my numbers different from the GA4 screen?

Check that the date range, filters and metric match what the GA4 report uses. Users and sessions are counted per range, so adding a dimension or changing the range changes the totals. When Google samples or thresholds the data, Trafficledger notes it on the tab.

Can I report on more than 10 metrics?

One report holds up to 10 metrics and 9 dimensions, which is Google's limit. Split them across two reports with the same dates.

Will a monthly report get every page, or only the top ones?

Every row, unless you set a Row limit. Trafficledger keeps requesting until the results run out.

Can I choose my own comparison dates?

Yes. Choose Custom range... in Compare with and type two dates, such as 2025-09-01 to 2025-09-30.


More Trafficledger guides


More Google guides