+
Stream all your data from Apple Search Ads to Snowflake
About Apple Search Ads
About 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:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- 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 Windsor.ai.
2. In Select Destination select Snowflake as destination
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
| name | type | description |
|---|---|---|
| Account ID | TEXT | The Account ID |
| Account Name | TEXT | The Account Name |
| Ad Group Display Status | TEXT | The state of the operation. |
| Ad Group Id | TEXT | The unique identifier for the ad group the search term belongs to. |
| Ad Group Name | TEXT | The name of the ad group, which is unique within the campaign. Responses don't include deleted ad groups. |
| Ad Group Serving State Reasons | TEXT | A list of reasons that displays when an ad group isn't running. |
| Ad Group Serving Status | TEXT | The status of whether the ad group is serving. |
| Ad Group Status | TEXT | The status of the ad group. |
| App | TEXT | The App Name |
| Automated Keywords Opt In | BOOLEAN | The 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. |
| Campaign | TEXT | The Campaign Name |
| Campaign ID | TEXT | The Campaign ID |
| Clicks | NUMERIC | The Number of Clicks |
| Conversion Rate | PERCENT | The Conversion Rate |
| Country or Region | REGION | A group of countries and regions. |
| Cost Per Acquisition | NUMERIC | The Average Cost Per Acquisition |
| CPA Goal | NUMERIC | The cost-per-acquisition goal. |
| Cost Per Thousand Impressions | NUMERIC | The Average Cost Per Thousand Impressions |
| Cost Per Tap | NUMERIC | The Average Cost Per Tap |
| Currency | TEXT | Campaign currency |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | The Date |
| Day of month | TEXT | Day of the month |
| Default Bid Amount | NUMERIC | The default maximum cost per tap or impression bid for the ad group. |
| Deleted | BOOLEAN | An indicator of whether the search term is soft-deleted. |
| End Time | TIMESTAMP | The scheduled end date and time for the ad group. |
| Impressions | NUMERIC | The Number of Impressions |
| Installs | NUMERIC | The Number of installs |
| Keyword | TEXT | The targeting or negative keywords. |
| Keyword Display Status | TEXT | The state of the keyword display operation. |
| Keyword Id | TEXT | The unique identifier for a keyword that belongs to an ad group. |
| Lat off installs | NUMERIC | (Deprecated) The Lat Off Installs |
| Lat on installs | NUMERIC | (Deprecated) The Lat On Installs |
| Match Type | TEXT | An automated keyword and bidding strategy. See Ad Groups for Search Match use cases. |
| Month | TEXT | Number of the month |
| New Downloads | NUMERIC | The Number of New Downloads |
| Number of Installs | NUMERIC | The Number of installs |
| Org Id | NUMERIC | The identifier of the organization that owns the campaign. Your orgId is the same as your account in the Apple Search Ads UI. |
| Re Downloads | NUMERIC | The Number of Re Downloads |
| Search Term Source | TEXT | The source of the keyword to use as a search term. |
| Search Term Text | TEXT | The search terms to use for app searches. |
| Source | TEXT | The name of the Windsor connector returning the row |
| Spend | NUMERIC | The Media Spend |
| Start Time | TIMESTAMP | The scheduled start date and time for the ad group. |
| Number of Tap Installs | NUMERIC | The Number of tap installs |
| Taps | NUMERIC | The Number of Taps |
| Today | DATE | Today's date |
| Total Cost | NUMERIC | The Media Spend |
| Tap Through Rate | PERCENT | The Tap Through Rate |
| Number of View Installs | NUMERIC | The Number of view installs |
| Week | TEXT | Week (Sun-Sat). |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | Year |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year 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
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.