Connect AppsFlyer to Google BigQuery with Windsor.ai
Stream all your app attribution data from from AppsFlyer to Google BigQuery
About AppsFlyer
Twitter is a microblogging and social media platform. Users connect and reach out with short messages, which Twitter calls Tweets. Business users use Twitter to capture and analyse data. AppsFlyer allows advertisers to advertise their products to targeted audiences on the Twitter platform.
About Google BigQuery
Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.
First step:
You need to select Appsflyer as a Data Source and Grant Access to Windsor.ai.
Second Step:
you will need to go to Select Destination to choose where do you want to send your data.
Third Step:
In this case Select Google BigQuery As A Data Destination
(Don’t forget to grant access to bq-upload@windsor-ai-bigquery.iam.gserviceaccount.com)
Make sure you follow the instructions on the screen. Once you complete the setup your data will start streaming in the interval you specify. You can always come back and change the settings at a later stage.
Fourth Step:
- As a connector URL you can use any URL providing a JSON. Either from the connectors or for example a URL with cached and transformed data from charts.windsor.ai.
Stream Your Data to Google BigQuery
Accessing any fields from your marketing platforms for your data pipelines
AppsFlyer metrics and dimensions available for streaming into Google BigQuery
| 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 | 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 | TEXT | 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 | TEXT | Country Code |
| Conversion Rate | NUMERIC | Conversion Rate |
| CTR | PERCENT | Click-Through Rate |
| Customer User ID | TEXT | Customer User ID |
| Date | DATE | Date |
| Device Model | TEXT | Device Model |
| 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 | TEXT | 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 | NUMERIC | 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) | TEXT | Country (requires access to the Master API) |
| Conversion Rate (Master API) | NUMERIC | 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) | TEXT | 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) | NUMERIC | 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) | NUMERIC | 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 |
| 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 |
| Region | TEXT | Region |
| Retargeting Conversion Type | TEXT | Retargeting Conversion Type |
| ROI | NUMERIC | 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 |
| 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 |
Windsor.ai: Easily connect AppsFlyer to Google BigQuery
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 marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.