Connect Appsflyer to Looker Studio with Windsor.ai
Directly connect your AppsFlyer data, in minutes, and in an easy-to-use format.
All your marketing data in one place, just in a few clicks.
In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.
Automate and save time.
No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Use all your data where and when you need it.
We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).
About AppsFlyer
Appsflyer, founded in 2011 in San Francisco, California by Oren Kaniel and Reshef Mann, is a mobile app analytics and marketing software company that provides attribution and tracking services for mobile apps. It provides a number of services, such as audience segmentation, retention tracking, buyer journey mapping, and attribution modeling, to name a few. The app includes a module that allows teams to attribute app installs to specific marketing campaigns and media sources.
Learn more about Appsflyer.
About Looker Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Looker Studio
Why integrate AppsFlyer data with Looker Studio?
- Integrating AppsFlyer data with Looker Studio can help you better understand what your users are doing on your website and apps. You can also use this data to improve the effectiveness of your advertising campaigns.
- By tracking user behavior across multiple channels, you can gain a more comprehensive picture of customer engagement and improve the effectiveness of your marketing efforts.
- You can run powerful reports with Looker Studio to see how your campaigns are performing and how effective your marketing strategy is.
- When AppsFlyer data and Looker Studio’s powerful analytics tools meet, you can discover insights about your users that will help you improve your overall campaign performance.
About the AppsFlyer - Looker Studio Connector
The Appsflyer Looker Studio Connector pulls Metrics and Dimensions for AppsFlyer. The Insights are retrieved at an app and campaign level. The Insights are retrieved at an app and campaign level. Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector the user should have:
- Access to an AppsFlyer account is needed. During the installation, the user will be asked to enter the App IDs and the API key. (Visit our privacy policy and terms of use)
- Google account for Apple Search Ads to Looker Studio integration.
- A Windsor account. Start your free trial now.
How to connect AppsFlyer data to Google Data Studio?
You need to select Appsflyer as a Data Source and grant access to Windsor.ai.
Select the fields on the right to later use in your data source. For example, you can include metrics such as Clicks, Event Source, or Cost Model.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Windsor.ai: All your marketing data in one place
Power up your marketing performance with result-driven marketing solutions
- Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
- The setup is done in minutes. No coding is required.
- Currently, we support more than 3000 dimensions and metrics.
- See the value and return on every marketing touchpoint.
- Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.
Google Data Studio Templates for AppsFlyer
Do you plan to connect and visualize your AppsFlyer data in Looker Studio?
These free and customizable Looker Studio AppsFlyer templates will assist you in visualizing your data for easy reporting and analysis.
Google Data Studio Tutorials for AppsFlyer
Would you like to take your Looker Studio AppsFlyer dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available AppsFlyer Metrics and Dimensions
| 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 |