Overview: Query Builder for App Store Connect
We have identified reliability issues with the App Store Connect integration that results in the Data Source displaying an error (“2FA token has expired’ or “Fatal connect error, please try again (timeout)“. This appears to be a universal issue with the App Store Connect API.
In order to ensure we provide our users with stable, reliable data, we have decided to temporarily remove the App Store Connect integration from our list of available integrations. Therefore, it is not possible to connect new App Store Connect Data Sources.
We are working to determine if there is a more stable way to access App Store Connect data and will restore the integration if so. You can upvote the development for this integration here. Please contact Support directly with any questions.
With the Query Builder for App Store Connect, you can create Custom App Store Connect Metrics using a combination of Metrics, Dimensions, and Filters.
Some popular use cases for the Query Builder for App Store Connect include creating Custom Source, Device, and Campaign-specific Metrics.
How to access the Query Builder for App Store Connect
Navigate to Metrics > Query Builder to access the Query Builder. Click the green + New Custom Metric button and select your connected App Store Connect 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
How to use the Query Builder for App Store Connect
Pro Tip: Add the word "by" in between the Metric and Dimension in order to determine an appropriate Custom Metric Name. From the Metric and Dimension examples outlined above, we could create the Custom Metrics "Installations by Device," "Crashes by App Version," or "In-App Purchases by Campaign."
Pro Tip : If you don't know which Filters to put in place for your use case, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your App Store Connect Account for each field. Learn more here.
How to create a Custom App Store Connect Metric [Example]
In this example, we'll create a Custom Metric to report on Installations tracked in the App Store Connect Account split up based on the Region where the User accessed the app.
How to add a Custom App Store Connect Metric to a Databoard
Learn how to add a Custom Metric to a Databoard here.