Use the Google Analytics 4 data source to pull your website analytics data, such as events, sessions, and users. Centralize your analytics data from all of your accounts and combine it with other marketing platforms.
Once you’ve connected to Google Analytics 4, you’re ready to create your first query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.
Try these queries
See the following use cases for examples on how to set up queries.
See event count
Take a look at your event count compared to the previous period.
The “Event count” metric shows the count of events.
For best results in Looker Studio, use the scorecard chart type.
- Set the date range to Last month.
- Select the Event count metric.
- Set the Comparison date range to Previous period.
See views for properties
Explore how your Google Analytics 4 properties have been viewed over time. In this example, we take a look at this month until today.
The “Views” metric shows the number of app screens or web pages your users viewed. Repeated views of a single page or screen are counted (screen_view + page_view events).
For best results in Looker Studio, use the time series chart type.
- Set the date range to This month to date.
- Select the Views metric.
- Select the GA4 property and Date dimension to split the query results by property and date
See sessions and conversion per campaign
View how many sessions and conversions your campaigns have generated in the last 7 days.
The “Conversions” metric shows the count of conversion events. The “Sessions” metric shows the number of sessions that began on your site or app (event triggered: session_start).
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 7 days.
- Select the Conversions and Sessions metrics.
- Select the Session campaign name dimension to split the query results by session campaign name.
Set up scheduled refreshes for your reports
You can set up scheduled refreshes for your reports created in Google Sheets and Excel. Follow the instructions on how to create and manage scheduled reports in Google Sheets and how to set up scheduled report triggers in Excel.
In Looker Studio, you can have a copy of your report emailed to you and important stakeholders at regular intervals.
See the Supermetrics blog for the ultimate guide to Google Analytics 4, comparison between Google Analytics 4 and Adobe Analytics, and ways to bring your Google Analytics 4 data to Looker Studio.
You might also be interested in: