Overview: iTunes Connect Query Builder
With the iTunes Connect Query Builder, you can better manage the impact of content distributed through Apple’s online stores. In this article, we will discuss the functionality of the iTunes Connect Query Builder, and will then work through an example based on a specific use case.
IN THIS ARTICLE
1. Query Builder Overview
dimensionsparameter breaks down the metric by common criteria, such as Source Type, Web Referrer or Device. The metric output is recategorized based on the selected dimension value.
If a query has no
dimensionselected as a parameter, the returned custom metric will provide aggregate values, such as total Impressions in the given date range.
NOTE: For the "Tasks" Radio Button you can only select one date range, because you are tracking tasks, which due date is set to one specific date range.
The " Data Preview" section allows you to see all of the values that are being returned in for the query you have created. At the bottom, you can find the total values bolded. To see data previews for different date ranges, click on the different tabs at the top of the preview.
In this example, we'll work through one basic use case that highlights how to use the Query Builder to access and filter iTunes Connect data.
Let's say we want to see the number of Impressions for the current month, split up by the Web Referrers. However, rather than viewing data for all Web Referrers we only want to report on Google Web Referrers.
Finally, we want to limit results so we're only viewing Google Web Referrers. In order to do this, we'll add a Filter to only retain data if the Dimension (Web Referrer) contains "google" in the returned value.
When you're confident in the query you built, click " Save query." This creates a new custom metric in Databox that is accessible in the Designer tool.
Let's move over to the Designer to pull this custom metric onto a Databoard. After you select the correct iTunes Connect Data Source in the righthand Property Manager, you'll be able to find your new custom metric in the Custom tab of the metric dropdown list.
This will now populate the visualization type on your Databoard with the custom query values.