Google Analytics (GA4) CSV to Dashboard

GA4 doesn't export one fixed report, every tab (Traffic acquisition, Pages and screens, Demographics, Ecommerce) exports its own dimension and metric columns as CSV. That's a real difference from Search Console's fixed Queries/Pages format, so this page covers the most commonly exported view, Traffic acquisition, and points you to the field picker for anything else.

Step 1: Export a Report

Open Reports → Acquisition → Traffic acquisition, then use the export icon (top right of the table) to download CSV. This report's columns typically include Session default channel group, Sessions, Engaged sessions, and Total revenue.

Step 2: Pick a Breakdown

Sessions by Channel

Upload a Traffic acquisition export and Pivot Table opens pre-configured to sum Sessions by channel group.

Any Other Report

Open Pivot Table directly for Pages and screens, Ecommerce, or Demographics exports, the field picker adapts to whatever columns that report contains.

Compare Two Periods

Diff this month's export against last month's to see which channels gained or lost sessions.

Also Have Search Console? →

Cross-reference organic sessions against Search Console's query-level data.

Frequently Asked Questions

Why does the column set depend on which report I export?

GA4 lets you export the CSV of whatever report tab you're currently viewing, and each report has its own dimension and metric columns (Traffic acquisition uses channel groups, Pages and screens uses page paths, and so on). There's no single fixed "GA4 export" schema the way there is for, say, a Search Console query export.

Does this need GA4 API access?

No. Export whichever report you're viewing as CSV from the GA4 interface (the export icon in the top right of most reports), then upload the file here.

Need a custom breakdown?

Open Pivot Table directly and pick any rows, columns, and measures from your export.

Open Pivot Table

Turn this into a saved workflow

Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.