When using Google Analytics 4 it can be surprisingly difficult to create a table that shows multiple different parameters of the same event as dimensions.

As an example, let’s say that you have a news app, and your authors create content in three categories: “sports”, “politics”, or “fashion”. Every time a user shares an article, you fire an event called “share” with the parameters “content_type” and “content_author”. You might want to pull a table like the example below so that you can view how many shares an author has received in each category.

The solution to this problem is to use “_UNNEST(event_params)_” for each parameter that you would like to include in your chart.
If you’re familiar with UNNEST you can keep reading, but if this concept is new to you then you’ll want to take a look at my post on How to Flatten a BigQuery Table with UNNEST.

Viewing Multiple Parameters on the Same Event in BigQuery

In this BigQuery example, I’ve plugged in the parameters ‘page_location’ and ‘page_title’ so that you can experiment with any dataset containing a web stream, but you can modify these as needed.

Alternatively, if you are selecting a large number of parameters (more than 2) I prefer to use subqueries because they keep the query simple. For example:

Viewing Multiple Parameters on the Same Event in Looker Studio

In Looker Studio, the only way to make this work properly is to use a Custom Query.

One very cool feature about custom queries is that you can set parameters with them. Parameters are like variables that you can change without modifying your SQL. As an example, you can use parameters to modify the date range, or run the same query on multiple event names. You can even create a chart, copy it, and change the parameters of the duplicate chart so that the same query displays two different charts on the same page of your report.

The steps below show you how to use a custom query with parameters to solve the problem of pulling multiple parameters on the same event in Looker Studio. I’ve also created an Example Looker Studio Report that you can copy and modify.

1. Start by adding a new BigQuery Data Source

2. Copy the following code block

3. In Looker Studio, select “Custom Query”

Paste in the code as shown below. You will need to replace ‘helpful-helper-516.analytics_sample’ with your Google Cloud Platform project ID and dataset ID.

4. Lastly, you will need to enable your parameters

Start by checking the “Enable data parameters” checkbox as shown above. Then create three more parameters like this (you can change the “Default Value” column if needed):

Once that is saved you can try it out. When you click on the table to edit the data you will notice a new menu where you can enter “Parameters” under “ADD A FILTER”. You can see that your default values are automatically selected, but just type anything in that box to view new parameters or events.

Now try to copy this chart and change the parameters to see how flexible this approach is.

Other Resources for BigQuery and GA4

Here are a few other posts that I’ve created for using BigQuery with data from Google Analytics 4:

• Cross-Stream First-Touch Attribution with Google Analytics 4 and BigQuery
• How the WITH Clause Can Simplify Your SQL Queries
• BigQuery + GA4: How To Get the First or Most Recent Event for a User
• How to Use the Over clause to Create a Moving Average in BigQuery
• Looker Studio + BigQuery + GA4: Viewing a Parameter Across Multiple Events
• Looker Studio + BigQuery + GA4: How to View Multiple Parameters on the Same Event
• How to Flatten a BigQuery Table with UNNEST