Connect Apple Search Ads to Snowflake

apple search ads Field Reference logo

Stream all your data from Apple Search Ads to Snowflake

Connect Apple Search Ads to Snowflake

It is very simple to connect Apple Search Ads to Snowflake, it can be done in a fast and easy manner with


First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 


Second step

1.You need to select Apple Search Ads as a Data Source and Grant Access to

Apple Search Ads Onboarding


2. In Select Destination select Snowflake as destination

snowflake integration


3.Enter all the credentials required and click Save


4. Your data will now be streamed from Apple Search Ads to Snowflake. In case there is an error you will be notified.

Apple Search Ads metrics and dimensions available for streaming into Snowflake

Connect your data


Account IDTEXTThe Account ID
Account NameTEXTThe Account Name
Ad Group Display StatusTEXTThe state of the operation.
Ad Group IdTEXTThe unique identifier for the ad group the search term belongs to.
Ad Group NameTEXTThe name of the ad group, which is unique within the campaign. Responses don't include deleted ad groups.
Ad Group Serving State ReasonsTEXTA list of reasons that displays when an ad group isn't running.
Ad Group Serving StatusTEXTThe status of whether the ad group is serving.
Ad Group StatusTEXTThe status of the ad group.
AppTEXTThe App Name
Automated Keywords Opt InBOOLEANThe parameter for enabling and disabling Search Match. If true, the system automatically adds optimized keywords in addition to those you explicitly add to the ad group.
CampaignTEXTThe Campaign Name
Campaign IDTEXTThe Campaign ID
ClicksNUMERICThe Number of Clicks
Conversion RatePERCENTThe Conversion Rate
Country or RegionREGIONA group of countries and regions.
Cost Per AcquisitionNUMERICThe Average Cost Per Acquisition
CPA GoalNUMERICThe cost-per-acquisition goal.
Cost Per Thousand ImpressionsNUMERICThe Average Cost Per Thousand Impressions
Cost Per TapNUMERICThe Average Cost Per Tap
CurrencyTEXTCampaign currency
Data SourceTEXTThe name of the Windsor connector returning the row
DateDATEThe Date
Day of monthTEXTDay of the month
Default Bid AmountNUMERICThe default maximum cost per tap or impression bid for the ad group.
DeletedBOOLEANAn indicator of whether the search term is soft-deleted.
End TimeTIMESTAMPThe scheduled end date and time for the ad group.
ImpressionsNUMERICThe Number of Impressions
InstallsNUMERICThe Number of installs
KeywordTEXTThe targeting or negative keywords.
Keyword Display StatusTEXTThe state of the keyword display operation.
Keyword IdTEXTThe unique identifier for a keyword that belongs to an ad group.
Lat off installsNUMERICThe Lat Off Installs
Lat on installsNUMERICThe Lat On Installs
Match TypeTEXTAn automated keyword and bidding strategy. See Ad Groups for Search Match use cases.
MonthTEXTNumber of the month
New DownloadsNUMERICThe Number of New Downloads
Number of InstallsNUMERICThe Number of installs
Org IdNUMERICThe identifier of the organization that owns the campaign. Your orgId is the same as your account in the Apple Search Ads UI.
Re DownloadsNUMERICThe Number of Re Downloads
TEXTThe source of the keyword to use as a search term.
TEXTThe search terms to use for app searches.
SourceTEXTThe name of the Windsor connector returning the row
SpendNUMERICThe Media Spend
Start TimeTIMESTAMPThe scheduled start date and time for the ad group.
TapsNUMERICThe Number of Taps
TodayDATEToday's date
Total CostNUMERICThe Media Spend
Tap Through RatePERCENTThe Tap Through Rate
WeekTEXTWeek (Sun-Sat).
Day of week and day numberTEXTWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
Day of week and day number, ISOTEXTWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
Week ISOTEXTWeek, ISO format (Mon-Sun).
YearmonthTEXTYear and month, e.g. 2024|3
Year of weekTEXTThe year that contains first day of the week (Sun-Sat).
Year of week, ISOTEXTThe year that contains first day of the ISO week (Mon-Sun).
Year weekTEXTYear and week for US weeks (Sun-Sat), e.g. 2024|15
Year week ISOTEXTYear and week for ISO weeks (Mon-Sun), e.g. 2024|20

Easily connect Apple Search Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.


Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Apple Search Ads and Snowflake Integrations