+
Stream marketing data from AppsFlyer to Snowflake
About AppsFlyer
About SnowFlake
Connect AppsFlyer to Snowflake in 2023
It is very simple to connect AppsFlyer 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 AppsFlyer 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 to Snowflake. In case there is an error you will be notified.
AppsFlyer metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Account ID | TEXT | The App ID |
| Account Name | TEXT | The App Name |
| Ad ID | TEXT | Ad ID |
| Ad Type | TEXT | Ad Type |
| Advertising ID | TEXT | Advertising ID |
| Ad (appsflyer) | TEXT | Ad |
| Adset | TEXT | Adset |
| Adset ID | TEXT | Adset ID |
| Partner | TEXT | Partner (Agency) |
| Android ID | TEXT | Android ID |
| App ID | TEXT | The App ID |
| App Name | TEXT | App Name |
| App Version | TEXT | App Version |
| AppsFlyer ID | TEXT | AppsFlyer ID |
| Attributed Touch Time | TIMESTAMP | Attributed Touch Time |
| Touch Type | TEXT | Touch Type (requires access to the Master API) |
| Attribution Lookback | TEXT | Attribution Lookback |
| Average eCPI | NUMERIC | Effective Cost per Installation (eCPI) over a certain time frame. Available only if cost and installs are included in the call. |
| ARPU | NUMERIC | Average revenue per user, for the users who installed in the selected time frame (LTV) |
| Campaign | TEXT | Campaign Name |
| Campaign ID | TEXT | Campaign ID |
| Carrier | TEXT | Carrier |
| Channel | TEXT | Channel |
| City | CITY | City |
| Clicks | NUMERIC | Number of clicks within the selected time frame |
| Cost Currency | TEXT | Cost Currency |
| Cost Model | TEXT | Cost Model |
| Cost Value | NUMERIC | Cost Value |
| Country | COUNTRY | Country |
| Country Code | COUNTRY | Country Code |
| Conversion Rate | NUMERIC | Conversion Rate |
| CTR | PERCENT | Click-Through Rate |
| Customer User ID | TEXT | Customer User ID |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | Date |
| Day of month | TEXT | Day of the month |
| Device Model | TEXT | Device Model |
| Device Region | REGION | Region |
| Device Category | TEXT | Device Category |
| DMA | TEXT | DMA |
| Event Counter - af_add_to_cart | NUMERIC | Number of occurrences of the event 'af_add_to_cart' (LTV) |
| Event Counter - af_complete_registration | NUMERIC | Number of occurrences of the event 'af_complete_registration' (LTV) |
| Event Counter - af_content_view | NUMERIC | Number of occurrences of the event 'af_content_view' (LTV) |
| Event Counter - af_initiated_checkout | NUMERIC | Number of occurrences of the event 'af_initiated_checkout' (LTV) |
| Event Counter - af_login | NUMERIC | Number of occurrences of the event 'af_login' (LTV) |
| Event Counter - af_purchase | NUMERIC | Number of occurrences of the event 'af_purchase' (LTV) |
| Event Name | TEXT | Event Name |
| Event Revenue | NUMERIC | Event Revenue |
| Event Revenue AUD | NUMERIC | Event Revenue AUD |
| Event Revenue Currency | TEXT | Event Revenue Currency |
| Event Source | TEXT | Event Source |
| Event Time | TIMESTAMP | Event Time |
| Event Type | TEXT | Specifies if an event is organic or not |
| Event Value Object | OBJECT | Event Value Object |
| HTTP Referrer | TEXT | HTTP Referrer |
| IDFA | TEXT | IDFA |
| IDFV | TEXT | IDFV |
| IMEI | TEXT | IMEI |
| Impressions | NUMERIC | Number of impressions within the selected time frame |
| Install Time | TIMESTAMP | Install Time (requires access to the Master API) |
| Installs | NUMERIC | Number of installs within the selected time frame |
| IP | TEXT | IP |
| Is Primary Attribution | TEXT | Is Primary Attribution |
| Is Retargeting | TEXT | Is Retargeting |
| Language | TEXT | Language |
| Loyal Users | NUMERIC | Number of loyal users who installed within the selected time frame |
| Loyal Users/Installs | PERCENT | Loyal users/installs |
| ARPDAU (Master API) | NUMERIC | Average revenue per daily active user - the average revenue of a given day out of all unique users (requires access to the Master API) |
| Activity Average DAU (Master API) | NUMERIC | Average daily active users (DAU) within the selected time frame (requires access to the Master API) |
| Average DAU/MAU Rate (Master API) | NUMERIC | Average DAU/MAU rate (requires access to the Master API) |
| Activity Average MAU (Master API) | NUMERIC | Average monthly active users within the selected time frame (one MAU day represents the unique users in the preceding 30 days) (requires access to the Master API) |
| Activity - Average Unique Users - af_add_to_cart (Master API) | NUMERIC | Average unique users performing a given event within the selected time frame, for the event 'af_add_to_cart' (requires access to the Master API) |
| Activity - Average Unique Users - af_complete_registration (Master API) | NUMERIC | Average unique users performing a given event within the selected time frame, for the event 'af_complete_registration' (requires access to the Master API) |
| Activity - Average Unique Users - af_content_view (Master API) | NUMERIC | Average unique users performing a given event within the selected time frame, for the event 'af_content_view' (requires access to the Master API) |
| Activity - Average Unique Users - af_initiated_checkout (Master API) | NUMERIC | Average unique users performing a given event within the selected time frame, for the event 'af_initiated_checkout' (requires access to the Master API) |
| Activity - Average Unique Users - af_login (Master API) | NUMERIC | Average unique users performing a given event within the selected time frame, for the event 'af_login' (requires access to the Master API) |
| Activity - Average Unique Users - af_purchase (Master API) | NUMERIC | Average unique users performing a given event within the selected time frame, for the event 'af_purchase' (requires access to the Master API) |
| Activity - Event Counter - af_add_to_cart (Master API) | NUMERIC | Number of events generated by users within the selected time frame, for the event 'af_add_to_cart' (requires access to the Master API) |
| Activity - Event Counter - af_complete_registration (Master API) | NUMERIC | Number of events generated by users within the selected time frame, for the event 'af_complete_registration' (requires access to the Master API) |
| Activity - Event Counter - af_content_view (Master API) | NUMERIC | Number of events generated by users within the selected time frame, for the event 'af_content_view' (requires access to the Master API) |
| Activity - Event Counter - af_initiated_checkout (Master API) | NUMERIC | Number of events generated by users within the selected time frame, for the event 'af_initiated_checkout' (requires access to the Master API) |
| Activity - Event Counter - af_login (Master API) | NUMERIC | Number of events generated by users within the selected time frame, for the event 'af_login' (requires access to the Master API) |
| Activity - Event Counter - af_purchase (Master API) | NUMERIC | Number of events generated by users within the selected time frame, for the event 'af_purchase' (requires access to the Master API) |
| Activity Revenue (Master API) | NUMERIC | Revenue reported within the selected time frame (requires access to the Master API) |
| Activity - Sales in USD - af_add_to_cart (Master API) | NUMERIC | Revenue reported as part of the reported events within the selected time frame, for the events 'af_add_to_cart' (requires access to the Master API) |
| Activity - Sales in USD - af_complete_registration (Master API) | NUMERIC | Revenue reported as part of the reported events within the selected time frame, for the events 'af_complete_registration' (requires access to the Master API) |
| Activity - Sales in USD - af_content_view (Master API) | NUMERIC | Revenue reported as part of the reported events within the selected time frame, for the events 'af_content_view' (requires access to the Master API) |
| Activity - Sales in USD - af_initiated_checkout (Master API) | NUMERIC | Revenue reported as part of the reported events within the selected time frame, for the events 'af_initiated_checkout' (requires access to the Master API) |
| Activity - Sales in USD - af_login (Master API) | NUMERIC | Revenue reported as part of the reported events within the selected time frame, for the events 'af_login' (requires access to the Master API) |
| Activity - Sales in USD - af_purchase (Master API) | NUMERIC | Revenue reported as part of the reported events within the selected time frame, for the events 'af_purchase' (requires access to the Master API) |
| Activity Sessions (Master API) | NUMERIC | Number of sessions performed within the selected time frame (requires access to the Master API) |
| Ad ID (Master API) | TEXT | Ad ID (requires access to the Master API) |
| Ad (Master API) | TEXT | Ad (requires access to the Master API) |
| Adset (Master API) | TEXT | Adset (requires access to the Master API) |
| Adset ID (Master API) | TEXT | Adset ID (requires access to the Master API) |
| Keywords | TEXT | Keywords (requires access to the Master API) |
| Partner (Master API) | TEXT | Partner (Agency) (requires access to the Master API) |
| Touch Type (Master API) | TEXT | Touch Type (requires access to the Master API) (requires access to the Master API) |
| Average eCPI (Master API) | NUMERIC | Effective Cost per Installation (eCPI) over a certain time frame. Available only if cost and installs are included in the call. (requires access to the Master API) |
| ARPU (Master API) | TEXT | Average revenue per user, for the users who installed in the selected time frame (LTV) (requires access to the Master API) |
| Campaign (Master API) | TEXT | Campaign Name (requires access to the Master API) |
| Campaign ID (Master API) | TEXT | Campaign ID (requires access to the Master API) |
| Channel (Master API) | TEXT | Channel (requires access to the Master API) |
| Clicks (Master API) | NUMERIC | Number of clicks within the selected time frame (requires access to the Master API) |
| Country (Master API) | COUNTRY | Country (requires access to the Master API) |
| Conversion Rate (Master API) | PERCENT | Conversion Rate (requires access to the Master API) |
| Event Counter - af_add_to_cart (Master API) | NUMERIC | Number of occurrences of the event 'af_add_to_cart' (LTV) (requires access to the Master API) |
| Event Counter - af_complete_registration (Master API) | NUMERIC | Number of occurrences of the event 'af_complete_registration' (LTV) (requires access to the Master API) |
| Event Counter - af_content_view (Master API) | NUMERIC | Number of occurrences of the event 'af_content_view' (LTV) (requires access to the Master API) |
| Event Counter - af_initiated_checkout (Master API) | NUMERIC | Number of occurrences of the event 'af_initiated_checkout' (LTV) (requires access to the Master API) |
| Event Counter - af_login (Master API) | NUMERIC | Number of occurrences of the event 'af_login' (LTV) (requires access to the Master API) |
| Event Counter - af_purchase (Master API) | NUMERIC | Number of occurrences of the event 'af_purchase' (LTV) (requires access to the Master API) |
| Impressions (Master API) | NUMERIC | Number of impressions within the selected time frame (requires access to the Master API) |
| Install Time (Master API) | TIMESTAMP | Install Time (requires access to the Master API) |
| Installs (Master API) | NUMERIC | Number of installs within the selected time frame (requires access to the Master API) |
| Is Primary Attribution (Master API) | TEXT | Is Primary Attribution (requires access to the Master API) |
| Loyal Users (Master API) | NUMERIC | Number of loyal users who installed within the selected time frame (requires access to the Master API) |
| Loyal Users/Installs (Master API) | PERCENT | Loyal users/installs (requires access to the Master API) |
| Publisher ID (Master API) | TEXT | Publisher ID (requires access to the Master API) |
| ROI (Master API) | NUMERIC | Return on Investment over a certain time frame (requires access to the Master API) |
| Sales in USD - af_add_to_cart (Master API) | NUMERIC | Revenue reported as part of the reported events 'af_add_to_cart' (LTV) (requires access to the Master API) |
| Sales in USD - af_complete_registration (Master API) | NUMERIC | Revenue reported as part of the reported events 'af_complete_registration' (LTV) (requires access to the Master API) |
| Sales in USD - af_content_view (Master API) | NUMERIC | Revenue reported as part of the reported events 'af_content_view' (LTV) (requires access to the Master API) |
| Sales in USD - af_initiated_checkout (Master API) | NUMERIC | Revenue reported as part of the reported events 'af_initiated_checkout' (LTV) (requires access to the Master API) |
| Sales in USD - af_login (Master API) | NUMERIC | Revenue reported as part of the reported events 'af_login' (LTV) (requires access to the Master API) |
| Sales in USD - af_purchase (Master API) | NUMERIC | Revenue reported as part of the reported events 'af_purchase' (LTV) (requires access to the Master API) |
| Sessions (Master API) | NUMERIC | Number of sessions created by the users who installed within the selected time frame (LTV) (requires access to the Master API) |
| Source (Master API) | TEXT | Media Source (requires access to the Master API) |
| Spend (Master API) | NUMERIC | Total cost in the selected time frame (requires access to the Master API) |
| Total Cost (Master API) | NUMERIC | Total cost in the selected time frame (alias for Spend) (requires access to the Master API) |
| Total Revenue (Master API) | NUMERIC | Lifetime revenue generated by the users who installed in the selected time frame (requires access to the Master API) |
| Transactions (Master API) | NUMERIC | Number of installs within the selected time frame (requires access to the Master API) |
| Uninstalls (Master API) | NUMERIC | Uninstalling users, who installed in the selected timeuninstalls_rate frame (requires access to the Master API) |
| Uninstall Rate (Master API) | PERCENT | Uninstallation rate (requires access to the Master API) |
| Unique Users - af_add_to_cart (Master API) | NUMERIC | Number of unique users who performed the event 'af_add_to_cart' (LTV) (requires access to the Master API) |
| Unique Users - af_complete_registration (Master API) | NUMERIC | Number of unique users who performed the event 'af_complete_registration' (LTV) (requires access to the Master API) |
| Unique Users - af_content_view (Master API) | NUMERIC | Number of unique users who performed the event 'af_content_view' (LTV) (requires access to the Master API) |
| Unique Users - af_initiated_checkout (Master API) | NUMERIC | Number of unique users who performed the event 'af_initiated_checkout' (LTV) (requires access to the Master API) |
| Unique Users - af_login (Master API) | NUMERIC | Number of unique users who performed the event 'af_login' (LTV) (requires access to the Master API) |
| Unique Users - af_purchase (Master API) | NUMERIC | Number of unique users who performed the event 'af_purchase' (LTV) (requires access to the Master API) |
| Match Type | TEXT | Match Type |
| Month | TEXT | Number of the month |
| Operator | TEXT | Operator |
| Original URL | TEXT | Original URL |
| OS Version | TEXT | OS Version |
| Platform | TEXT | Platform |
| Postal Code | TEXT | Postal Code |
| Reengagement Window | TEXT | Reengagement Window |
| Retargeting Conversion Type | TEXT | Retargeting Conversion Type |
| ROI | PERCENT | Return on Investment over a certain time frame |
| Sales in USD - af_add_to_cart | NUMERIC | Revenue reported as part of the reported events 'af_add_to_cart' (LTV) |
| Sales in USD - af_complete_registration | NUMERIC | Revenue reported as part of the reported events 'af_complete_registration' (LTV) |
| Sales in USD - af_content_view | NUMERIC | Revenue reported as part of the reported events 'af_content_view' (LTV) |
| Sales in USD - af_initiated_checkout | NUMERIC | Revenue reported as part of the reported events 'af_initiated_checkout' (LTV) |
| Sales in USD - af_login | NUMERIC | Revenue reported as part of the reported events 'af_login' (LTV) |
| Sales in USD - af_purchase | NUMERIC | Revenue reported as part of the reported events 'af_purchase' (LTV) |
| SDK Version | TEXT | SDK Version |
| Sessions | NUMERIC | Number of sessions created by the users who installed within the selected time frame (LTV) |
| Site ID | TEXT | Site ID |
| Source | TEXT | Media Source |
| Spend | NUMERIC | Total cost in the selected time frame |
| State | TEXT | State |
| Store Product Page | TEXT | Store Product Page |
| Today | DATE | Today's date |
| Total Cost | NUMERIC | Total cost in the selected time frame (alias for Spend) |
| Total Revenue | NUMERIC | Lifetime revenue generated by the users who installed in the selected time frame |
| Transactions | NUMERIC | Number of installs within the selected time frame |
| Unique Users - af_add_to_cart | NUMERIC | Number of unique users who performed the event 'af_add_to_cart' (LTV) |
| Unique Users - af_complete_registration | NUMERIC | Number of unique users who performed the event 'af_complete_registration' (LTV) |
| Unique Users - af_content_view | NUMERIC | Number of unique users who performed the event 'af_content_view' (LTV) |
| Unique Users - af_initiated_checkout | NUMERIC | Number of unique users who performed the event 'af_initiated_checkout' (LTV) |
| Unique Users - af_login | NUMERIC | Number of unique users who performed the event 'af_login' (LTV) |
| Unique Users - af_purchase | NUMERIC | Number of unique users who performed the event 'af_purchase' (LTV) |
| User Agent | TEXT | User Agent |
| 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 AppsFlyer to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ 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.