Skip to content
Book a demoStart free
Connectors

Apple Ads connector

Set up the Apple Ads connector in Kaivo: authentication, configuration, the 8 BigQuery tables it syncs, and answers to common questions.

Apple Ads connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Apple Ads data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

Sync your Apple Ads campaign data into BigQuery with Kaivo to track App Store ad spend and performance alongside your other channels.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the Apple Ads connector

Section titled “Getting started with the Apple Ads connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Apple Ads account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Apple Ads credentials. You provide:

Field Description
Client Id
A user identifier for the token request. See here

| | Client Secret |

A string that authenticates the user’s setup request. See here

|

When you set up the connector, you provide:

Field Description
Org Id
The identifier of the organization that owns the campaign. Your Org Id is the same as your account in the Apple Search Ads UI.

| | Start Date |

Any data before this date will not be fetched.

| | Lookback Window |

Attribution window in days (1–30). Smaller values shorten sync durations at the cost of missing late attributions.

| | Time Zone |

The timezone for the reporting data. Use ‘ORTZ’ for Organization Time Zone or ‘UTC’ for Coordinated Universal Time. Default is UTC.

|

Kaivo syncs 8 tables from Apple Ads into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

adgroups (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
automated_keywords_opt_in BOOL
campaign_id INT64
cpa_goal JSON
creation_time STRING
default_bid_amount__amount STRING
default_bid_amount__currency STRING
deleted BOOL
display_status STRING
end_time JSON
id INT64
modification_time STRING
name STRING
org_id INT64
pricing_model STRING
serving_state_reasons JSON
serving_status STRING
start_time STRING
status STRING
targeting_dimensions__admin_area JSON
targeting_dimensions__age JSON
targeting_dimensions__app_categories__excluded JSON
targeting_dimensions__app_categories__included JSON
targeting_dimensions__country JSON
targeting_dimensions__daypart JSON
targeting_dimensions__gender JSON
targeting_dimensions__locality JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: adgroups__targeting_dimensions__app_downloaders__excluded

Section titled “Subtable: adgroups__targeting_dimensions__app_downloaders__excluded”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: adgroups__targeting_dimensions__app_downloaders__included

Section titled “Subtable: adgroups__targeting_dimensions__app_downloaders__included”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: adgroups__targeting_dimensions__device_class__included

Section titled “Subtable: adgroups__targeting_dimensions__device_class__included”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
adgroups_report_daily (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
countryorregion STRING
metadata__ad_group_display_status STRING
metadata__ad_group_id INT64
metadata__ad_group_name STRING
metadata__ad_group_serving_state_reasons JSON
metadata__ad_group_serving_status STRING
metadata__ad_group_status STRING
metadata__automated_keywords_opt_in BOOL
metadata__campaign_id INT64
metadata__country_or_region STRING
metadata__cpa_goal JSON
metadata__default_bid_amount__amount STRING
metadata__default_bid_amount__currency STRING
metadata__deleted BOOL
metadata__end_time JSON
metadata__modification_time STRING
metadata__org_id INT64
metadata__pricing_model STRING
metadata__start_time STRING
ad_group_id INT64
date STRING
other BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: adgroups_report_daily__granularity

Section titled “Subtable: adgroups_report_daily__granularity”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avg_cpm__amount STRING
avg_cpm__currency STRING
avg_cpt__amount STRING
avg_cpt__currency STRING
date STRING
impressions INT64
lat_off_installs INT64
lat_on_installs INT64
local_spend__amount STRING
local_spend__currency STRING
tap_install_cpi__amount STRING
tap_install_cpi__currency STRING
tap_install_rate FLOAT64
tap_installs INT64
tap_new_downloads INT64
tap_redownloads INT64
taps INT64
ttr FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ads (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id FLOAT64
campaign_id FLOAT64
creation_time STRING
creative_id FLOAT64
creative_type STRING
deleted BOOL
id FLOAT64
modification_time STRING
name STRING
org_id FLOAT64
serving_status STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ads_report_daily (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata__ad_display_status STRING
metadata__ad_group_id FLOAT64
metadata__ad_id FLOAT64
metadata__ad_name STRING
metadata__ad_status STRING
metadata__campaign_id FLOAT64
metadata__country_or_region STRING
metadata__creation_time STRING
metadata__creative_id FLOAT64
metadata__creative_type STRING
metadata__deleted BOOL
metadata__modification_time STRING
metadata__org_id FLOAT64
metadata__product_page_id STRING
metadata__status STRING
ad_id FLOAT64
countryorregion STRING
date STRING
other BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avg_cpt__amount STRING
avg_cpt__currency STRING
date STRING
impressions FLOAT64
local_spend__amount STRING
local_spend__currency STRING
tap_install_cpi__amount STRING
tap_install_cpi__currency STRING
tap_install_rate FLOAT64
tap_installs FLOAT64
tap_new_downloads FLOAT64
tap_redownloads FLOAT64
taps FLOAT64
total_avg_cpi__amount STRING
total_avg_cpi__currency STRING
total_install_rate FLOAT64
total_installs FLOAT64
total_new_downloads FLOAT64
total_redownloads FLOAT64
ttr FLOAT64
view_installs FLOAT64
view_new_downloads FLOAT64
view_redownloads FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
campaigns (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_channel_type STRING
adam_id INT64
billing_event STRING
budget_amount JSON
creation_time STRING
daily_budget_amount__amount STRING
daily_budget_amount__currency STRING
deleted BOOL
display_status STRING
end_time JSON
id INT64
loc_invoice_details__billing_contact_email STRING
loc_invoice_details__buyer_email STRING
loc_invoice_details__buyer_name STRING
loc_invoice_details__client_name STRING
loc_invoice_details__order_number STRING
modification_time STRING
name STRING
org_id INT64
payment_model STRING
sapin_law_response STRING
serving_state_reasons JSON
serving_status STRING
start_time STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
campaigns_report_daily (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
countryorregion STRING
metadata__ad_channel_type STRING
metadata__app__adam_id INT64
metadata__app__app_name STRING
metadata__billing_event STRING
metadata__campaign_id INT64
metadata__campaign_name STRING
metadata__campaign_status STRING
metadata__country_or_region STRING
metadata__daily_budget__amount STRING
metadata__daily_budget__currency STRING
metadata__deleted BOOL
metadata__display_status STRING
metadata__modification_time STRING
metadata__org_id INT64
metadata__serving_state_reasons JSON
metadata__serving_status STRING
metadata__total_budget JSON
campaign_id INT64
date STRING
other BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: campaigns_report_daily__metadata__countries_or_regions

Section titled “Subtable: campaigns_report_daily__metadata__countries_or_regions”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: campaigns_report_daily__metadata__supply_sources

Section titled “Subtable: campaigns_report_daily__metadata__supply_sources”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: campaigns_report_daily__granularity

Section titled “Subtable: campaigns_report_daily__granularity”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avg_cpm__amount STRING
avg_cpm__currency STRING
avg_cpt__amount STRING
avg_cpt__currency STRING
date STRING
impressions INT64
lat_off_installs INT64
lat_on_installs INT64
local_spend__amount STRING
local_spend__currency STRING
tap_install_cpi__amount STRING
tap_install_cpi__currency STRING
tap_install_rate FLOAT64
tap_installs INT64
tap_new_downloads INT64
tap_redownloads INT64
taps INT64
ttr FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
keywords (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id INT64
bid_amount__amount STRING
bid_amount__currency STRING
campaign_id INT64
creation_time STRING
deleted BOOL
id INT64
match_type STRING
modification_time STRING
status STRING
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
keywords_report_daily (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
countryorregion STRING
metadata__ad_group_deleted BOOL
metadata__ad_group_id INT64
metadata__ad_group_name STRING
metadata__bid_amount__amount STRING
metadata__bid_amount__currency STRING
metadata__country_or_region STRING
metadata__deleted BOOL
metadata__keyword STRING
metadata__keyword_display_status STRING
metadata__keyword_id INT64
metadata__keyword_status STRING
metadata__match_type STRING
metadata__modification_time STRING
date STRING
insights__bid_recommendation__bid_max JSON
insights__bid_recommendation__bid_min JSON
insights__bid_recommendation__suggested_bid_amount JSON
keyword_id INT64
other BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: keywords_report_daily__granularity

Section titled “Subtable: keywords_report_daily__granularity”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avg_cpt__amount STRING
avg_cpt__currency STRING
date STRING
impressions INT64
lat_off_installs INT64
lat_on_installs INT64
local_spend__amount STRING
local_spend__currency STRING
tap_install_cpi__amount STRING
tap_install_cpi__currency STRING
tap_install_rate FLOAT64
tap_installs INT64
tap_new_downloads INT64
tap_redownloads INT64
taps INT64
ttr FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Apple Ads supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Apple Ads?

Section titled “How long does the initial sync take for Apple Ads?”

It depends on how much history is in your Apple Ads account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Apple Ads’s schema changes?

Section titled “What happens when Apple Ads’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Apple Ads, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Apple Ads instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Apple Ads connector in Kaivo and all of its synced data is deleted with it.

Combine Apple Ads spend with your other ad platforms to compare cost and results on one dashboard.

Use campaigns_report_daily and adgroups_report_daily to track impressions, taps, and installs over time.

Join keywords with keywords_report_daily to find which terms drive installs and which waste budget.

Monitor daily spend by campaign to catch overspend or underspend early.

Use Apple Ads data in your AI and BI tools

Section titled “Use Apple Ads data in your AI and BI tools”

Once Apple Ads data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Apple Ads data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Apple Ads connector pricing and plan details.