Release Notes

May 2023

We removed the legacy OAuth authorization mode due to OAuth deprecated in the Apple Search Ads API.

October 2022

Now, you can opt to return records without metrics by using the Show Records with no Metrics toggle in the setup form. See our Apple Search Ads setup guide for details.

September 2022

We have released pre-built, dbt Core*-compatible data models for Apple Search Ads. Find the models in Fivetran's dbt hub. Learn more about our dbt Core integration in our Transformations for dbt Core documentation.

*dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

March 2022

We have added the following new tables:

• AD_HISTORY
• CREATIVE_HISTORY
• PRODUCT_PAGE_HISTORY
• PRODUCT_PAGE_LOCALE

We have added a new report, AD_LEVEL_REPORT.

We have added two new fields, avg_cpm_amount and avg_cpm_currency, for all reports.

August 2021

Our Apple Search Ads connector now supports multithreading. We can now use multiple parallel API requests to fetch data from your Apple Search Ads account to your destination, which makes your syncs faster. The connector’s sync speed depends on your Apple Search Ads API quota and account metadata.

We have upgraded our Apple Search Ads connector from version 3 to 4 of the Apple Search Ads API. For more information, see Apple Search Ads API documentation.

We have added support for OAuth 2.0.

July 2020

The Apple Search Ads connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Apple Search Ads's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.

To learn more, see our priority-first sync documentation.

March 2020

When setting up your connector, you can now select which organizations you'd like to sync. Previously, Fivetran synced all organizations by default.

December 2019

We have added a new table, CREATIVE_SET_REPORT, to support the Creative Set Report.

October 2019

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

September 2019

We have upgraded the connector to Apple Search Ads API version 2, since version 1 of the API has been deprecated. For more information, see Apple Search Ads' API documentation.

With this API update, we now support negative keywords fetched by campaigns and ad groups.

Apple has deprecated the following fields from the CAMPAIGN_HISTORY table, so we have removed them:

• referenceLabel
• storefront
• billingContactEmail (part of the loc_invoice_details field)
• billingContactName (part of the loc_invoice_details field)

May 2019

We added support for API v2.

We have added the following new fields to the CAMPAIGN_REPORT,AD_GROUP_REPORT, SEARCH_TERM_REPORT, and KEYWORD_REPORT tables:

• new_downloads
• re_downloads
• lat_on_installs
• lat_off_installs

We have added a new table, COUNTRY_OR_REGION_HISTORY.

Apple Search Ads no longer support the storefront column in the CAMPAIGN_HISTORY table. You can see its data in the country_or_region column of the COUNTRY_OR_REGION_HISTORY table .

February 2019

In the CAMPAIGN_HISTORY table, we changed the loc_invoice_detail_order_number column from INT to STRING.

January 2019

We have removed the deprecated display_status field from the AD_GROUP_HISTORY and CAMPAIGN_HISTORY tables.

August 2018

We have renamed the following tables: