How to Pull Google Analytics Reports
Trying to understand how visitors find and interact with your website is essential for growth, and Google Analytics is the command center for that data. But knowing the insights are in there and actually getting them out are two different things. This guide will walk you through exactly how to pull the most important reports from Google Analytics 4 without getting lost in the menus.
First, a Quick Tour of the GA4 Interface
If you recently switched from the older Universal Analytics, you’ve noticed that GA4 looks quite different. The navigation is streamlined into a few key areas on the left-hand menu. For reporting, you'll mainly be using two sections:
- Reports: This is where you’ll find all of the standard, pre-built summary reports that answer common questions about acquisition, engagement, and user demographics. It’s the best place to start for a high-level overview.
- Explore: This section is for creating custom, advanced reports. It offers more flexibility with 'Free form' explorations, 'Funnel explorations,' and 'Path explorations' that let you dig much deeper into your data. It's more powerful but comes with a steeper learning curve.
For this guide, we'll focus on the pre-built reports in the 'Reports' section, as they cover the most frequent needs of marketers and business owners.
How to Pull Essential Google Analytics Reports
Let's walk through finding and pulling three of the most valuable standard reports in GA4. Each one answers a critical question about your business.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
1. The Traffic Acquisition Report: "Where does my website traffic come from?"
This is arguably the most important report for any marketer. It tells you which channels are driving visitors to your site, helping you understand what's working and where you should focus your efforts.
How to Find It:
- On the left-hand menu, navigate to Reports.
- Under the 'Life cycle' dropdown, click on Acquisition.
- Select the Traffic acquisition report.
Instantly, you'll see a table showing your traffic sources grouped by 'Session default channel grouping.' This includes channels like Organic Search, Direct, Paid Search, Organic Social, and Referral.
Practical Tips:
- Change the primary dimension: The default view shows channel groupings, but you can get more specific. Click the small dropdown arrow next to 'Session default channel grouping' and change it to something like 'Session source / medium' to see the exact domains (e.g., google / organic, facebook.com / referral).
- Add a secondary dimension: Want to see which channels bring in the most mobile traffic? Click the '+' icon next to the primary dimension and add a secondary dimension like 'Device category.' Now you can see a breakdown of traffic sources by desktop, mobile, and tablet.
- Adjust the date range: In the top right corner, you can easily change the date range to view performance for last week, last month, the last quarter, or a custom period.
2. The Pages and Screens Report: "What content are people viewing most?"
This report helps you discover your most popular pages and understand what content resonates with your audience. It's perfect for identifying your top-performing blog posts, landing pages, or product pages.
How to Find It:
- On the left-hand menu, go to Reports.
- Under the 'Life cycle' dropdown, click on Engagement.
- Select the Pages and screens report.
You'll see a list of your website pages ordered by the number of 'Views.' This report also shows you critical engagement metrics like 'Users,' 'Average engagement time,' and 'Conversions' per page.
Practical Tips:
- Identify popular content: By default, the list is sorted by views, showing you a straightforward list of your most-visited pages. This is a great starting point for your content strategy.
- Find your most engaging content: Click the 'Average engagement time' column header to sort the table. Pages that rise to the top here are the ones that hold visitors' attention the longest. These pieces of content are likely high-value and worth promoting further.
- Discover conversion drivers: If you have conversion events set up (like form submissions or purchases), sorting by the 'Conversions' column will reveal which pages are most effective at driving your business goals.
3. The Demographics Details Report: "Who is visiting my website?"
Understanding your audience is key to effective marketing. This report gives you a high-level view of your visitors' locations, helping you tailor your messaging, ad targeting, and content.
How to Find It:
- On the left-hand menu, navigate to Reports.
- Under the 'User' dropdown, click on User attributes.
- Select the Demographic details report.
By default, this report shows a breakdown of your users by country. You can see not only a list of countries but also key metrics like the number of users, sessions, engagement rate, and conversions for each location.
Practical Tips:
- Find new markets: Surprised to see a significant number of users from a country you aren't actively targeting? This could be a sign of an emerging market worth exploring for your business.
- Change the dimension to 'City': Use the dropdown menu at the top of the table to switch the primary dimension from 'Country' to 'City' to get a more granular look at where your local traffic comes from.
- Combine with traffic sources: Use the secondary dimension feature to add 'Session default channel grouping' to this report. This will show you, for instance, how much of your traffic from the United Kingdom comes from Organic Search versus Paid Social.
How to Export Your Google Analytics Reports
Once you’ve configured a report to show exactly what you need, pulling the data is simple. Whether you need it for a presentation or to manipulate it in a spreadsheet, here’s how to export it:
- Navigate to the report you want to download.
- In the top right corner of the report, click the Share this report icon (it looks like a box with an arrow pointing up).
- A small menu will appear. Click on Download File.
- You will be prompted to choose a format: Download PDF or Download CSV.
Choose PDF for a static, presentation-ready snapshot of your report. Choose CSV if you want the raw data to use in Google Sheets or Microsoft Excel for deeper analysis or to combine with data from other sources.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Common Hurdles with GA Reporting
Pulling individual reports isn't too complicated, but it can quickly become part of a time-consuming manual workflow. Many teams find themselves facing a few common challenges:
- The Reporting Treadmill: Many marketers spend their Monday mornings pulling the same set of CSVs from Google Analytics, Facebook Ads, and Shopify, then spend hours wrangling that data in a spreadsheet just to build a weekly performance report. By the time it's finished, the week is half over.
- Data Silos: Google Analytics is fantastic at telling you what happens on your website, but it doesn't know how much you spent on Facebook Ads to get that traffic. To see the full picture - from ad click to final sale - you have to manually stitch together data from different platforms.
- The Unavoidable Learning Curve: While standard reports are accessible, getting custom answers often requires diving into the 'Explore' section, which can feel less intuitive and requires a deeper understanding of dimensions and metrics.
Final Thoughts
Getting comfortable with the reports section in Google Analytics 4 is a critical skill for understanding your website's performance. By regularly pulling reports on your traffic sources, content engagement, and audience demographics, you can make smarter, data-driven decisions to grow your business.
That manual process of downloading reports and connecting dots is exactly why we built Graphed. We wanted to eliminate the busywork. Instead of endlessly exporting CSVs, you just connect your sources like Google Analytics, Shopify, and your ad platforms one time. From there, you can ask for the dashboards and reports you need in plain English - like 'Compare organic traffic and conversion rate between Mexico and Latin America in the last month and show results on different charts,' and we instantly create real-time, shareable dashboards. This saves you time spent on manual data wrangling and frees you up to work on the strategy that actually drives results.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.