Overview: Query Builder for Adobe Analytics

HOW TO

How to access the Query Builder for Adobe Analytics

Navigate to Metrics > Query Builder to access the Query Builder. Click the green + New Custom Metric button and select your connected Adobe 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 these steps.  

How to use the Query Builder for Adobe Analytics 

A
  Custom Metric Name: Enter a name for your Custom Metric. This Custom Metric name will be available in the Designer after saving. 
B
  Segment: Segments allow you to identify subsets of visitors based on characteristics or website interactions. Select a Segment from your connected Adobe Analytics Account.
C
  Element: Select an Element to add as a Filter for your Custom Metric. Filters restrict the data that gets included in the Custom Metric. All data that is returned is tested against the Filter(s). Multiple Filters can be combined using AND boolean logic. 
D
  Metric: Select a Metric, such as AOV, Visits, or Bounce Rate. 
E
  Date Range: Select up to 8 Date Ranges that will be available for the Custom Metric. The Date Ranges selected are the only periods of time that data is synced for this Custom Metric. 
F
   Compare With (Optional) : Select a comparison period to measure each Date Range against, like Previous Period or Same Period Last Year. Data for the comparison period will be synced for each Date Range that is selected. 
This data can be used on a Line Chart or Bar Chart to show past performance. It is also used to calculate the percentage growth or loss of the current Date Range performance vs the comparison Date Range performance. If no Compare With parameter is selected, comparison percentages cannot be displayed for the Custom Metric. 
G
  For selected intervals don't push daily values: Select this checkbox if the Metric selection is an average, such as "Avg. Time on Site," "Bounce Rate," "CPC," etc. 
H
  Pull hourly: This only applies to "Today" and "Yesterday" Date Ranges.
I
  Selected Metric is an average Metric: Select this checkbox if the Metric selection is an average, such as "Avg. Time on Site," "Bounce Rate," "CPC," etc. 
I
  Data Preview: After clicking Run query, a Data Preview of the Custom Metric will be displayed. Daily Metric values are displayed in this section, along with the total Metric values for the Date Range in bold at the bottom. You can view the Data Preview for different Date Ranges by clicking on the tabs at the top of the Data Preview. 

How to create a Custom Adobe Analytics Metric [Example]

In this example, we'll create a Custom Metric to report on Visitors to our Category Pages tracked in the Adobe Analytics Account. Within Adobe Analytics, a Segment has been set up to specify "Category Pages."

1
 Navigate to Metrics > Query Builder   
2
 Click the green + New query button
3
 Select the appropriate Adobe Analytics Data Source
4
 In order to accurately explain what this Custom Metric is reporting on, we'll name the Custom Metric "Visitors to Category Pages" 
5
 Next, we'll select Category Pages from the Segment drop-down list
6
 We don't want to add an Element Filter, so we'll leave this blank
7
 Select Visitors from the Metric drop-down list
8
 From the Date Range drop-down list we'll select any Date Ranges that we want available for this Custom Metric.
9
 In order to get a better understanding of current performance, we'll choose Previous Period from the Compare With drop-down list.  
10
 We want to view daily data, so we will not check the first checkbox. 
11
 We haven't selected "Today" or "Yesterday" as Date Range options for the Custom Metric, so we will not check the second checkbox. 
12
 "Visitors" is not an average, so we will not check the third checkbox.
13
 Click Run query to generate a Data Preview of the Custom Metric. 
14
 Once we confirm that these are the results we're looking for, we'll click Save to save the Custom Metric. 

How to add a Custom Adobe Analytics Metric to a Databoard

Learn how to add a Custom Metric to a Databoard here

Additional Information

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