Overview: Query Builder for Google Analytics
With the Query Builder for Google Analytics, you can create Custom Google Analytics Metrics using a combination of Metrics, Dimensions, Segments, and Filters.
Some popular use cases for the Query Builder for Google Analytics include creating content-specific Metrics, reporting on custom Goal Conversions, and accessing additional Date Ranges for Google Analytics Metrics.
How to access the Query Builder for Google Analytics
Navigate to Metrics > Query Builder to access the Query Builder. Click the green + New Custom Metric button and select your connected Google Analytics Account from the Data Source drop-down list.
Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following
How to use the Query Builder for Google Analytics
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 Default Channel Grouping," "Pageviews by Page," or "Pages / Session by Device Category."
Most tables in Google Analytics organize Dimensions into rows and Metrics into columns. In order 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): This checkbox should be selected if a lower Metric value indicates positive growth / performance (i.e., Unsubscribers, Cost per Conversion, etc.) Inverting the Custom Metric in Databox will make it so an increase in the Metric value will show a red percentage change color on a Databolock, while a decrease in the Metric value will show a green percentage change color on a Datablock.
Learn more about creating Segments in Google Analytics here.
Learn more about the significance of the Metric Sort Order 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 Metric [Example]
In this example, we'll create a Custom Metric to report on New Users tracked in the Google Analytics Account split up based on the Country where the User accessed the website. We only want to view this data for New Users that found the website through Organic Search.
How to add a Custom Google Analytics Metric to a Databoard