Overview: Adobe Analytics Query Builder
In this article, we will create a Custom Metric using Adobe Analytics Query Builder to highlight key features and functionalities of the tool. Our goal is to filter the number of Visits from iOS by Page.
You can find Query Builder under Data Manager ( link to Query Builder) or open it directly from our Designer tool.
IN THIS ARTICLE
1. Basic Options
We chose "Visits by Page (iOS)" for our query name.
Segments (optional): Segments allow you to identify subsets of visitors based on characteristics or website interactions identify who your visitors are (country, gender), what devices and services they use (browser, search engine, mobile device), where they navigated from (search engine, previous exit page, natural search), plus a lot more. For example, out of your entire set of users, one segment might be users from a particular country or city. Another segment might be users who visit your page and came from specific device, as in our example (iOS).
Read more about Segments in Adobe Analytics.
Read more about: Adding and Modifying Additional Date Range.
2. Advanced Options
In "Advanced options" you can find three different checkboxes which can help you build custom metric and customize data as you want to use it.
For selected intervals don't push daily values: In case we won't use line or bar charts with created metric and "today" and "yesterday" date ranges are not selected, we only need total values for selected date ranges.
*This is useful for users with lots of data to reduce fetch time*
- Pull hourly data: By default we don't pull hourly data for Abobe Analytics. This setting only applies to Today and Yesterday date ranges.
In our example, we select "Pull hourly data" option, because we want to use daily linechart visualisation, to see new customers on hourly basis.
- Selected metric is an average metric: Chose this option if the selected metric is an average metric (Avg. time on site, Bounce rate, Conversion rate, CPC, RPV, etc.)
When everything mentioned above is set, click "Run query" to show Data preview.
3. Data preview
In Data Preview you will see all values for selected metrics and date ranges. At the
If you want to sort values by date/time just click on the arrow next to "Date"
When your query is ready, click "Save query." Now a new metric has been created, with the metric name the same as the custom query name.
By default, a metric will be added in the Data Source where data is pulled. It is possible to change the target Data Source by clicking on "Change target data source" on the top right.
It is possible to rename Dimensions (best practice is to rename them before saving the query) by clicking "..." next to Dimensions and then selecting "Rename dimension".
This function is useful when you want to exclude one or more Dimensions. (For
Click on "..." next to "Value" and select "Round values." Enter the number of decimal places to be rounded to into field