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 Configuration | Becomes |
|---|---|
| Report Name | The report and its tab name |
| Property ID | The GA4 property |
| Start Date, End Date, or a date preset | The report's dates |
| Metrics, Dimensions | The same fields |
| Metric Filter, Dimension Filter | The same filters, in the same text syntax, or the same FilterExpression JSON |
| Order, Limit | The 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
- Open the spreadsheet where you used Google's add-on. Trafficledger only reads the spreadsheet it's open in.
- Open Trafficledger from the Extensions menu and allow read-only Google Analytics access.
- Click Import them in the banner on the Reports pane.
- 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.
- Click Import selected.
- 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.
- 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
- How to build a monthly GA4 report in Google Sheets
- How to refresh a GA4 report in Google Sheets automatically
More Google guides
- How to compare two Google Sheets for differences (Tabmeld)
- How to make a copy of a template tab for each name in a list (Tabherd)
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)