How to use Query Builder to sync more historical data

The amount of historical data that initially syncs with Databox differs for each Data Source, depending on a number of factors. From there, more historical data is accumulated over time. Learn more here.

In order to achieve your reporting objectives, you may need access to more historical data than is available for Basic Metrics. For certain Data Sources, this is possible using Query Builder. Learn which Data Sources have Query Builders available here

    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.

For example, when a new Google Analytics Data Source is connected with Databox, 3 months worth of historical data is initially synced. In the example below, we'll create a Custom Metric to report on Sessions with longer Date Ranges, like Quarter to Date, Year to Date, etc., selected. 

 Navigate to Metrics > Query Builder   
 Click the green + New query button
 Select the appropriate Google Analytics Data Source
 We'll enter Sessions as the Custom Metric Name
 From the Metric drop-down list, we'll select Sessions
 For our Date Ranges, we'll select Week to Date, Month to Date, Quarter to Date, Year to Date, Last Month, Last Quarter, Last Year, and Last 12 Months
 We'll choose Previous Period from the Compare With drop-down, so data from the previous period of all select Date Ranges will be synced as well
 Click Run query to generate a Data Preview of the Custom Metric
 Once we confirm that these are the results we're looking for, we'll click Save
Pro Tip: Now we can easily create more Custom Metrics with the same Date Range specifications.
 On the Query Builder page, click on the arrow next to the Edit button
 Click Duplicate
 Update the Custom Metric Name,  Metric,  Dimension (optional), and Filter (optional)
 Click Run query to generate a Data Preview of the Custom Metric
 Once we confirm that these are the results we're looking for, we'll click Save
 Repeat steps 10-14 until you have built all of the Custom Metrics you need with more historical data
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