Connect AppsFlyer to Google BigQuery with Windsor.ai

appsflyer

+

bigquery

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.

AppsFlyer metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
ARPDAUNUMERICAverage 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 DAUNUMERICAverage daily active users (DAU) within the selected time frame (requires access to the Master API)
Average DAU/MAU RateNUMERICAverage DAU/MAU rate (requires access to the Master API)
Activity Average MAUNUMERICAverage 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_cartNUMERICAverage 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_registrationNUMERICAverage 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_viewNUMERICAverage 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_checkoutNUMERICAverage 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_loginNUMERICAverage 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_purchaseNUMERICAverage 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_cartNUMERICNumber 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_registrationNUMERICNumber 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_viewNUMERICNumber 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_checkoutNUMERICNumber 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_loginNUMERICNumber 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_purchaseNUMERICNumber of events generated by users within the selected time frame, for the event 'af_purchase' (requires access to the Master API)
Activity RevenueNUMERICRevenue reported within the selected time frame (requires access to the Master API)
Activity - Sales in USD - af_add_to_cartNUMERICRevenue 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_registrationNUMERICRevenue 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_viewNUMERICRevenue 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_checkoutNUMERICRevenue 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_loginNUMERICRevenue 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_purchaseNUMERICRevenue reported as part of the reported events within the selected time frame, for the events 'af_purchase' (requires access to the Master API)
Activity SessionsNUMERICNumber of sessions performed within the selected time frame (requires access to the Master API)
AdTEXTAd (requires access to the Master API)
Ad IDTEXTAd ID (requires access to the Master API)
AdsetTEXTAdset (requires access to the Master API)
Adset IDTEXTAdset ID (requires access to the Master API)
Campaign IDTEXTCampaign ID (requires access to the Master API)
ChannelTEXTChannel (requires access to the Master API)
KeywordsTEXTKeywords (requires access to the Master API)
PartnerTEXTPartner (Agency)
Publisher IDTEXTPublisher ID (requires access to the Master API)
App IDTEXTThe App ID
ARPUNUMERICAverage revenue per user, for the users who installed in the selected time frame (LTV)
Touch TypeTEXTTouch Type (requires access to the Master API)
Average eCPINUMERICEffective Cost per Installation (eCPI) over a certain time frame. Available only if cost and installs are included in the call. 
CampaignTEXTCampaign Name
ClicksNUMERICNumber of clicks within the selected time frame
CountryTEXTCountry
Conversion RateNUMERICConversion Rate
CTRNUMERICClick-Through Rate
DateDATEDate
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)
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
Is Primary AttributionTEXTIs Primary Attribution (requires access to the Master API)
Loyal UsersNUMERICNumber of loyal users who installed within the selected time frame
Loyal Users/InstallsNUMERICLoyal users/installs
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)
SessionsNUMERICNumber of sessions created by the users who installed within the selected time frame (LTV)
SourceTEXTMedia Source
SpendNUMERICTotal cost in the selected time frame
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
UninstallsNUMERICUninstalling users, who installed in the selected time frame (requires access to the Master API)
Uninstall RateNUMERICUninstallation rate (requires access to the Master API)
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)

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.