How to move GA4 Reports Builder reports to Trafficledger

By Jake Marsh · Updated

To move reports from Google's GA4 Reports Builder for Google Sheets, open the spreadsheet that has its Report Configuration sheet, then Extensions, Trafficledger, Open Trafficledger. A banner says the spreadsheet has Google's sheet and how many reports it holds. Click Import them, tick the reports you want and click Import selected. Each one keeps its tab name and the classic cell layout, so formulas and charts that read those tabs keep working.

What gets imported

Trafficledger reads the same rows Google's add-on uses, one report per column:

Row in Report ConfigurationBecomes
Report NameThe report and its tab name
Property IDThe GA4 property
Start Date, End Date, or a date presetThe report's dates
Metrics, DimensionsThe same fields
Metric Filter, Dimension FilterThe same filters, in the same text syntax, or the same FilterExpression JSON
Order, LimitThe same sort and row limit

The reports go into Trafficledger's own Trafficledger Reports sheet. Google's Report Configuration sheet is left as it was.

Steps

  1. Open the spreadsheet where you used Google's add-on. Trafficledger only reads the spreadsheet it's open in.
  2. Open Trafficledger from the Extensions menu and allow read-only Google Analytics access.
  3. Click Import them in the banner on the Reports pane.
  4. Check the list. Each report shows its property and any notes, such as a field that was renamed. A report whose tab name is already in Trafficledger is greyed out, so nothing is imported twice.
  5. Click Import selected.
  6. Click Run all reports. The tabs fill in the classic layout: totals in row 12, headers in row 15 and data from row 16, with the same summary cells at the top.
  7. Check a chart or formula that reads one of the tabs, then add a schedule under Schedule if Google's add-on was refreshing it for you.

Old Universal Analytics report sheets

Spreadsheets from the older Google Analytics add-on hold Universal Analytics reports with ga: field names. Universal Analytics stopped collecting data in 2023, so those reports can't run as they are. Trafficledger converts each ga: field to its GA4 name where GA4 has a real equivalent, such as ga:sessions to sessions, and lists any field that has none so you can choose a replacement. You'll also need to pick the GA4 property for each report, since a Universal Analytics view ID doesn't carry over.

After the move

Imported reports work like any other Trafficledger report. Open one with Edit to add a comparison with the previous period or last year, which adds previous and change columns next to each metric. Switch Layout to Table for a plain table with a frozen header and filter, once nothing depends on the old cell positions. To keep the reports up to date on their own, see how to refresh a GA4 report in Google Sheets automatically.

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

Do I need to uninstall Google's add-on first?

No. The two can sit in the same spreadsheet. Once Trafficledger writes to the report tabs, turn off any schedule in Google's add-on so they don't take turns overwriting the same cells.

What if a report fails after the import?

The Status row under that report says what went wrong in plain words, such as a metric that can't be combined with a dimension, or a property you no longer have access to.

Are custom dimensions and metrics kept?

Yes, if they exist on the property. Trafficledger reads the property's own field list, which includes its custom dimensions and metrics.

Can I import into a different spreadsheet?

No. The import reads the Report Configuration sheet of the spreadsheet Trafficledger is open in and writes the reports there, so tabs and formulas stay together.


More Trafficledger guides


More Google guides