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

A
 Custom Query Name: Write a name for your Custom Metric in this field. You will find this name/title as a Metric option in the Designer after saving the query.
We chose "Visits by Page (iOS)" for our query name.
B

 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.

C
 Elements (optional): Data elements are the building blocks for rules. Data elements let you create a data dictionary (or data map) of commonly used items on a page, regardless of where they originate (query strings, URLs, or cookie values) for any object that is contained on your site. It is possible to filter data by elements with a Query Builder and Elements are automatically shown in Dropdown.
Check more about Data Elements in Adobe Analytics here.
D
 Metric (required): Select a metric from your connected Adobe Analytics data source, such  as   Bounce Rate  or    Visits .  A metric can be used in combination with other elements or segments, but only where valid combinations apply for that metric. 
E
 Date Range (required): To display your data the way you like, you will need to choose a date range. Just click on the "Date Range" field. Selected intervals will be enabled for a new metric.
F
 Compare With (optional): Select a date range to compare your previously selected interval to. This date range will be used for "previous line"  on line  and bar charts, and for calculating change %. Options are:  None and  Previous period.

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  bottom  you can check total values. Just click on tabs for switching date range.

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.

Transformations

Rename Dimension:

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".

Skip Dimension:

This function is useful when you want to exclude one or more Dimensions. (For  example  if you want to show data for all Countries except one). Click on  "..." next to "Dimension" and select "Skip dimension".

Round values:

Click on  "..." next to "Value" and select "Round values." Enter the number of decimal places to be rounded to into field  in  popup and values will be rounded accordingly.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us