Overview: Query Builder for Google Analytics 4
With the Query Builder for Google Analytics 4, you can create Custom Google Analytics 4 Metrics using a combination of Metrics, Dimensions, and Filters.
Some popular use cases for the Query Builder for Google Analytics 4 include creating content-specific Metrics, reporting on Events, etc.
How to access the Query Builder for Google Analytics 4
Navigate to Metrics > Query Builder to access the Query Builder. Click the green + New Custom Metric button and select your connected Google Analytics 4 Account from the Data Source drop-down list.
Query Builder is available on the Professional and Performer plans. Request a trial of Query Builder by following
How to use the Query Builder for Google Analytics 4
Pro Tip: Add the word "by" in between the Metric and Dimension in order to determine an appropriate Custom Metric Name. From the Metric and Dimension examples outlined above, we could create the Custom Metrics "Sessions by Campaign," "Active Users by Age," or "Event Counts by Page Path."
Most tables in Google Analytics organize Dimensions into rows and Metrics into columns. To replicate the Google Analytics table below in Databox, you would need to create 6 Custom Metrics: "Users by User Type," "New Users by User Type," "Sessions by User Type," "Bounce Rate by User Type," "Pages / Session by User Type," and "Avg Session Duration by User Type."
Invert Metric (Optional): By default, the percentage change value displayed on Datablocks is green when the Metric value has increased and red when the Metric value has decreased. If the Custom Metric you created has opposite trends, select this option. Learn more here.
Pro Tip : If you don't know which Filters to put in place for your use case, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Google Analytics Account for each field. Learn more here .
How to create a Custom Google Analytics 4 Metric [Example]
In this example, we'll create a Custom Metric to report on Active Users tracked in the Google Analytics Account split up based on the Day of week, since we want to see on which days users are most active.
How to add a Custom Google Analytics 4 Metric to a Databoard
Learn how to add a Custom Metric to a Databoard here.
- (not set) is a placeholder name that Google Analytics uses when it hasn't received any information for the Dimension you have selected. Google's API displays (not-set) for campaigns syncing with Google Analytics through an external integration with Google Ads, Google Search Console, etc. For Google Analytics Campaigns, the actual name of the Campaign is displayed. Learn more about the (not set) behavior in Google here.
- When a Metric contains "Age," "Gender," or "Interests" as a Dimension, a threshold may be applied in Google Analytics, and some data may be withheld from the report.
This happens when your website has low traffic. As a result, thresholds are applied to your report by Google Analytics to prevent anyone viewing a report from inferring the demographics or interests of individual users. This is a limitation set by Google Analytics.
In Google Analytics, when a threshold is applied to a report, a yellow icon is displayed at the top of the report, along with a notice below the report title. If no threshold is applied, a green icon is displayed.
To clean up your reports in Databox, you can exclude or rename the (not set) Dimension for Custom Metrics by following these steps.