Apple Search Ads

Apple Search Ads are sponsored ads for driving awareness and downloads for apps within Appleā€™s App Store. This allows you to promote your applications at the top of the search results on the App Store.

You can use Hevo Pipelines to replicate your Apple Search Ads reports such as campaign reports and search term reports into the desired Destination system for scalable analysis. For this, you must authorize Hevo to access data from your Apple Search Ads account.

For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.


Prerequisites


Configuring Apple Search Ads as a Source

Perform the following steps to configure Apple Search Ads as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Apple Search Ads.

  4. In the Configure your Apple Search Ads Source page, specify the following:

    Configure Source

    • Pipeline Name: A unique name for your Pipeline.

    • Upload PEM file: The PEM file extracted from your Apple Search Ads API certificate.

    • Upload key file: The key file extracted from your Apple Search Ads API certificate.

    • Organizations: The account(s) for which the apple search ads data needs to be synced.

    • Historical Sync Duration: The duration for which the past data must be ingested. Default is All Available Data.

  5. Click TEST & CONTINUE.

  6. Proceed to configuring the data ingestion and setting up the Destination.


Creating and Downloading the Apple Search Ads API Certificate

The Apple Search Ads API certificate allows Hevo to establish a two-way SSL authentication and replicate your Apple Search Ads data into your desired Destination system.

Step 1. Create the Apple Search Ads API Certificate

To create the Apple Search Ads API certificate:

  1. Log in to your Apple Search Ads Account.

  2. In the drop-down on the top right, click Settings against your selected account.

    Click settings

  3. In the Account Settings page, click the API tab.

  4. Click Create API Certificate.

    Create API certificate

  5. In the Create API Certificate window, specify the following:

    API certificate window

    • API certificate name: A unique name for your API certificate.

    • Select Account Read Only to grant read-only access to all Apple Search Ads Accounts associated with your Apple ID.
      Else, to grant read-only access only to specific Apple Search Ads Account(s):

      • Select Limited Access.

      • In the Limited Access drop-down, select <Your Apple Search Ads Account>.

      • In the Role drop-down, select Read Only.

  6. Click Create.

Step 2. Download the Apple Search Ads API Certificate

To download the Apple Search Ads API certificate:

  1. Select the created certificate, and then, in the Actions drop-down, select Download certificate.

    Download certificate

  2. Your Apple Search Ads API certificate gets downloaded in ZIP format. The ZIP file contains

    • <file_name>.key

    • <file_name>.pem

You need to extract the downloaded ZIP file and upload the key file and the PEM file to Hevo while configuring Apple Search Ads Source settings.


Data Replication

Historical Data: When the Pipeline is created, Hevo fetches all past data created since June 15, 2016 for your account till the current date and loads it into your Destination.

Incremental Data: Once the historical load is completed, all new and updated records are synchronized with your Destination. Hevo ingests data every 6 hours by default.

Refresh: Hevo refreshes the data for all the objects on a rolling basis to update any conversions attributed to clicks within the last 30 days.


Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:


Data Model

Hevo uses the following data model to ingest data from your Apple Search Ads account:

Table Description
Ad Group Contains all the ad group entities associated with a campaign, and the ad group for each campaign group.
AdGroup Report Contains daily report of each ad group.
Campaign Group Contains all the campaign groups and the Access Control List(ACL) of the authenticated Apple Search Ads account.
Campaign Contains details about all the campaigns assigned to a campaign group.
Campaign Report Contains daily report of each searched campaign.
Creative Set Report Contains daily report of creative sets used in your campaign.
Keyword Report Contains daily report of each keyword associated with an Ad Group.
Search Terms Report Contains daily report of search terms used in the App Store.
Targeting Keyword Contains details about the targeting keywords associated with each ad group. Targeting keywords display ads based on relevant search terms used.

Limitations

None.

Last updated on 02 Aug 2021