How to identify Dimension names using Query Builder
Using the Dimension field in the Query Builder, you can get more insight into the exact data that's being synced from the Data Source's API. This information can help troubleshoot and determine any Filters that should be put in place.
IN THIS ARTICLE
How to troubleshoot Custom Metrics using the Dimension field
Dimensions allow you to re-categorize the returned Metric values based on a similar attribute. Examples of Dimensions are "Country," "Source" and "Campaign." These Dimensions allow you to create attributed Metrics that store lists of data, such as "Sessions by Country," "Leads by Source," and "Impressions by Campaign." Any of these Metrics could be added to a Pie Chart or a Table to produce a Datablock that reports on the Metric value split up by the Dimension parameter.
After clicking the green Run query button for a Custom Metric in the Query Builder, a Data Preview is generated at the bottom of the screen. The Data Preview allows you to get a more granular view into exactly what is being synced from the Data Source's API.
When a Dimension is not selected for a Custom Metric, the Data Preview simply shows the Dates + Metric Values that are returned from the Data Source's API.
When a Dimension is selected for a Custom Metric, the Data Preview expands to show the Dates + Dimensions + Metric Values that are returned for the Custom Metric.
Since Dimensions are typically Strings, this can give you more insight into exactly what's being tracked by the selected Dimension and what's being returned from the Data Source's API.
How to troubleshoot Custom Metrics using the Dimension field [Example]
Let's say I want to report on the number of New Users on the pricing page of my website.
Since I have 1 specific page that I want to analyze, I know I need to add a Filter to the Custom Metric instructing the system to only retain data for New Users tracked to this specific page. However, I've run into a roadblock because I don't know the exact parameters to put in place to Filter data for this one page.