Connect Apple Search Ads to Snowflake

apple search ads Field Reference logo
+
snowflake

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 Windsor.ai.

 

First Step

Follow the Tutorial Below:

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

 

  • Get the username Import Snowflake 1

 

  • Get the password Import Snowflake 2

 

  • Get the account Import Snowflake 3

 

  • Get the warehouse Import Snowflake 4

 

  • Get the database Import Snowflake 5

 

  • Get the schema Import Snowflake 6

 

  • Get the table name Import Snowflake 7

 

Second step

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

Apple Search Ads Windsor.ai Onboarding

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3.Enter all the credentials required and click Save
Snowflake connector

 

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

 

nametypedescription
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
DateDATEThe Date
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 TimeDATEThe 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 IdNUMERICThe 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.
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.
SpendNUMERICThe Media Spend
Start TimeDATEThe scheduled start date and time for the ad group.
TapsNUMERICThe Number of Taps
Total CostNUMERICThe Media Spend
Tap Through RatePERCENTThe Tap Through Rate

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.

insights

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

Build your Apple Search Ads and Snowflake Integrations