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:

  1. 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

Connect Appsflyer to Looker Studio

AppsFlyer metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
Account IDTEXTThe App ID
Account NameTEXTThe App Name
Ad IDTEXTAd ID
Ad TypeTEXTAd Type
Advertising IDTEXTAdvertising ID
TEXTAd
AdsetTEXTAdset
Adset IDTEXTAdset ID
PartnerTEXTPartner (Agency)
Android IDTEXTAndroid ID
App IDTEXTThe App ID
App NameTEXTApp Name
App VersionTEXTApp Version
AppsFlyer IDTEXTAppsFlyer ID
Attributed Touch TimeTIMESTAMPAttributed Touch Time
Touch TypeTEXTTouch Type (requires access to the Master API)
Attribution LookbackTEXTAttribution Lookback
Average eCPINUMERICEffective Cost per Installation (eCPI) over a certain time frame. Available only if cost and installs are included in the call. 
ARPUNUMERICAverage revenue per user, for the users who installed in the selected time frame (LTV)
CampaignTEXTCampaign Name
Campaign IDTEXTCampaign ID
CarrierTEXTCarrier
ChannelTEXTChannel
CityTEXTCity
ClicksNUMERICNumber of clicks within the selected time frame
Cost CurrencyTEXTCost Currency
Cost ModelTEXTCost Model
Cost ValueNUMERICCost Value
CountryCOUNTRYCountry
Country CodeTEXTCountry Code
Conversion RateNUMERICConversion Rate
CTRPERCENTClick-Through Rate
Customer User IDTEXTCustomer User ID
DateDATEDate
Device ModelTEXTDevice Model
Device CategoryTEXTDevice Category
DMATEXTDMA
Event Counter - af_add_to_cartNUMERICNumber of occurrences of the event 'af_add_to_cart' (LTV)
Event Counter - af_complete_registrationNUMERICNumber of occurrences of the event 'af_complete_registration' (LTV)
Event Counter - af_content_viewNUMERICNumber of occurrences of the event 'af_content_view' (LTV)
Event Counter - af_initiated_checkoutNUMERICNumber of occurrences of the event 'af_initiated_checkout' (LTV)
Event Counter - af_loginNUMERICNumber of occurrences of the event 'af_login' (LTV)
Event Counter - af_purchaseNUMERICNumber of occurrences of the event 'af_purchase' (LTV)
Event NameTEXTEvent Name
Event RevenueNUMERICEvent Revenue
Event Revenue AUDNUMERICEvent Revenue AUD
Event Revenue CurrencyTEXTEvent Revenue Currency
Event SourceTEXTEvent Source
Event TimeTIMESTAMPEvent Time
Event TypeTEXTSpecifies if an event is organic or not
Event Value ObjectOBJECTEvent Value Object
HTTP ReferrerTEXTHTTP Referrer
IDFATEXTIDFA
IDFVTEXTIDFV
IMEITEXTIMEI
ImpressionsNUMERICNumber of impressions within the selected time frame
Install TimeTEXTInstall Time (requires access to the Master API)
InstallsNUMERICNumber of installs within the selected time frame
IPTEXTIP
Is Primary AttributionTEXTIs Primary Attribution
Is RetargetingTEXTIs Retargeting
LanguageTEXTLanguage
Loyal UsersNUMERICNumber of loyal users who installed within the selected time frame
Loyal Users/InstallsNUMERICLoyal users/installs
ARPDAU (Master API)NUMERICAverage 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)NUMERICAverage daily active users (DAU) within the selected time frame (requires access to the Master API)
Average DAU/MAU Rate (Master API)NUMERICAverage DAU/MAU rate (requires access to the Master API)
Activity Average MAU (Master API)NUMERICAverage 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)NUMERICAverage 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)NUMERICAverage 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)NUMERICAverage 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)NUMERICAverage 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)NUMERICAverage 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)NUMERICAverage 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)NUMERICNumber 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)NUMERICNumber 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)NUMERICNumber 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)NUMERICNumber 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)NUMERICNumber 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)NUMERICNumber 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)NUMERICRevenue reported within the selected time frame (requires access to the Master API)
Activity - Sales in USD - af_add_to_cart (Master API)NUMERICRevenue 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)NUMERICRevenue 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)NUMERICRevenue 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)NUMERICRevenue 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)NUMERICRevenue 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)NUMERICRevenue 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)NUMERICNumber of sessions performed within the selected time frame (requires access to the Master API)
Ad ID (Master API)TEXTAd ID (requires access to the Master API)
Ad (Master API)TEXTAd (requires access to the Master API)
Adset (Master API)TEXTAdset (requires access to the Master API)
Adset ID (Master API)TEXTAdset ID (requires access to the Master API)
KeywordsTEXTKeywords (requires access to the Master API)
Partner (Master API)TEXTPartner (Agency) (requires access to the Master API)
Touch Type (Master API)TEXTTouch Type (requires access to the Master API) (requires access to the Master API)
Average eCPI (Master API)NUMERICEffective 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)TEXTAverage revenue per user, for the users who installed in the selected time frame (LTV) (requires access to the Master API)
Campaign (Master API)TEXTCampaign Name (requires access to the Master API)
Campaign ID (Master API)TEXTCampaign ID (requires access to the Master API)
Channel (Master API)TEXTChannel (requires access to the Master API)
Clicks (Master API)NUMERICNumber of clicks within the selected time frame (requires access to the Master API)
Country (Master API)TEXTCountry (requires access to the Master API)
Conversion Rate (Master API)NUMERICConversion Rate (requires access to the Master API)
Event Counter - af_add_to_cart (Master API)NUMERICNumber of occurrences of the event 'af_add_to_cart' (LTV) (requires access to the Master API)
Event Counter - af_complete_registration (Master API)NUMERICNumber of occurrences of the event 'af_complete_registration' (LTV) (requires access to the Master API)
Event Counter - af_content_view (Master API)NUMERICNumber of occurrences of the event 'af_content_view' (LTV) (requires access to the Master API)
Event Counter - af_initiated_checkout (Master API)NUMERICNumber of occurrences of the event 'af_initiated_checkout' (LTV) (requires access to the Master API)
Event Counter - af_login (Master API)NUMERICNumber of occurrences of the event 'af_login' (LTV) (requires access to the Master API)
Event Counter - af_purchase (Master API)NUMERICNumber of occurrences of the event 'af_purchase' (LTV) (requires access to the Master API)
Impressions (Master API)NUMERICNumber of impressions within the selected time frame (requires access to the Master API)
Install Time (Master API)TEXTInstall Time (requires access to the Master API)
Installs (Master API)NUMERICNumber of installs within the selected time frame (requires access to the Master API)
Is Primary Attribution (Master API)TEXTIs Primary Attribution (requires access to the Master API)
Loyal Users (Master API)NUMERICNumber of loyal users who installed within the selected time frame (requires access to the Master API)
Loyal Users/Installs (Master API)NUMERICLoyal users/installs (requires access to the Master API)
Publisher ID (Master API)TEXTPublisher ID (requires access to the Master API)
ROI (Master API)NUMERICReturn on Investment over a certain time frame (requires access to the Master API)
Sales in USD - af_add_to_cart (Master API)NUMERICRevenue 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)NUMERICRevenue 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)NUMERICRevenue 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)NUMERICRevenue reported as part of the reported events 'af_initiated_checkout' (LTV) (requires access to the Master API)
Sales in USD - af_login (Master API)NUMERICRevenue reported as part of the reported events 'af_login' (LTV) (requires access to the Master API)
Sales in USD - af_purchase (Master API)NUMERICRevenue reported as part of the reported events 'af_purchase' (LTV) (requires access to the Master API)
Sessions (Master API)NUMERICNumber of sessions created by the users who installed within the selected time frame (LTV) (requires access to the Master API)
Source (Master API)TEXTMedia Source (requires access to the Master API)
Spend (Master API)NUMERICTotal cost in the selected time frame (requires access to the Master API)
Total Cost (Master API)NUMERICTotal cost in the selected time frame (alias for Spend) (requires access to the Master API)
Total Revenue (Master API)NUMERICLifetime revenue generated by the users who installed in the selected time frame (requires access to the Master API)
Transactions (Master API)NUMERICNumber of installs within the selected time frame (requires access to the Master API)
Uninstalls (Master API)NUMERICUninstalling users, who installed in the selected timeuninstalls_rate frame (requires access to the Master API)
Uninstall Rate (Master API)NUMERICUninstallation rate (requires access to the Master API)
Unique Users - af_add_to_cart (Master API)NUMERICNumber 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)NUMERICNumber of unique users who performed the event 'af_complete_registration' (LTV) (requires access to the Master API)
Unique Users - af_content_view (Master API)NUMERICNumber of unique users who performed the event 'af_content_view' (LTV) (requires access to the Master API)
Unique Users - af_initiated_checkout (Master API)NUMERICNumber of unique users who performed the event 'af_initiated_checkout' (LTV) (requires access to the Master API)
Unique Users - af_login (Master API)NUMERICNumber of unique users who performed the event 'af_login' (LTV) (requires access to the Master API)
Unique Users - af_purchase (Master API)NUMERICNumber of unique users who performed the event 'af_purchase' (LTV) (requires access to the Master API)
Match TypeTEXTMatch Type
OperatorTEXTOperator
Original URLTEXTOriginal URL
OS VersionTEXTOS Version
PlatformTEXTPlatform
Postal CodeTEXTPostal Code
Reengagement WindowTEXTReengagement Window
RegionTEXTRegion
Retargeting Conversion TypeTEXTRetargeting Conversion Type
ROINUMERICReturn on Investment over a certain time frame
Sales in USD - af_add_to_cartNUMERICRevenue reported as part of the reported events 'af_add_to_cart' (LTV)
Sales in USD - af_complete_registrationNUMERICRevenue reported as part of the reported events 'af_complete_registration' (LTV)
Sales in USD - af_content_viewNUMERICRevenue reported as part of the reported events 'af_content_view' (LTV)
Sales in USD - af_initiated_checkoutNUMERICRevenue reported as part of the reported events 'af_initiated_checkout' (LTV)
Sales in USD - af_loginNUMERICRevenue reported as part of the reported events 'af_login' (LTV)
Sales in USD - af_purchaseNUMERICRevenue reported as part of the reported events 'af_purchase' (LTV)
SDK VersionTEXTSDK Version
SessionsNUMERICNumber of sessions created by the users who installed within the selected time frame (LTV)
Site IDTEXTSite ID
SourceTEXTMedia Source
SpendNUMERICTotal cost in the selected time frame
StateTEXTState
Store Product PageTEXTStore Product Page
Total CostNUMERICTotal cost in the selected time frame (alias for Spend)
Total RevenueNUMERICLifetime revenue generated by the users who installed in the selected time frame
TransactionsNUMERICNumber of installs within the selected time frame
Unique Users - af_add_to_cartNUMERICNumber of unique users who performed the event 'af_add_to_cart' (LTV)
Unique Users - af_complete_registrationNUMERICNumber of unique users who performed the event 'af_complete_registration' (LTV)
Unique Users - af_content_viewNUMERICNumber of unique users who performed the event 'af_content_view' (LTV)
Unique Users - af_initiated_checkoutNUMERICNumber of unique users who performed the event 'af_initiated_checkout' (LTV)
Unique Users - af_loginNUMERICNumber of unique users who performed the event 'af_login' (LTV)
Unique Users - af_purchaseNUMERICNumber of unique users who performed the event 'af_purchase' (LTV)
User AgentTEXTUser Agent

Windsor.ai: Easily connect AppsFlyer to Google BigQuery

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 marketeers, whenever they want.

insights

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

Start a free trial today.

Integrate all your data and measure what matters.