Connect AppsFlyer to Google Sheets with Windsor.ai

appsflyer

+

google sheets

Finally, all your marketing data from AppsFlyer available in Google Sheets

About AppsFlyer

AppsFlyer is a market leader in mobile advertising attribution and analytics. AppsFlyer helps marketers to pinpoint their targeting, optimize their ad spend and boost their ROI. AppsFlyer helps App-Developers, Brands and Ad-Agencies attribute installs to campaigns and optimize their users’ acquisition funnel.

About Google Sheets

Google Sheets is a web based spreadsheet tool. It allows end users to create spreadsheets, pivot tables, charts and run Google App Script code to automate various functions.

First Step:

You need to select Appsflyer as a Data Source and App ID and API Key.

Instructions to grant access

  1. Enter your app ID from AppsFlyer.

  2. Enter your AppsFlyer V1 API key from your AppsFlyer Settings

  3. Click add.

Repeat this process for all the AppsFlyer apps to connect.

Detailed instructions with screenshots are available on our Wiki.

Second step:

Select Google sheets as a data destination.

Third Step:

You can choose between two options:

Option 1: Advanced and for large data volumes

  1. Click this link to install the Google Sheets add-on
  2. Enter your API key: defab2f1e4d0b69f2aa9fcca30c8abe0f996
  3. Start using the add-on in Google Sheets from the Add-ons menu in a Google Sheets document and select your fields

Option 2: Quickstart

Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.
The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.You can add any field that is available in the data sources you have added.


=IMPORTDATA(“https://connectors.windsor.ai/all?api_key=defab2f1e4d0b69f2aa9fcca30c8abe0f996&date_preset=last_7d&fields=date,campaign,clicks,spend&_renderer=googlesheets”)

Instruction: The list of selected fields must contain a date field.

Connect any Data to Google Sheets

Connect appslfyer to Tableau

Templates for AppsFlyer and Google Sheets

Windsor.ai: Connecting all marketing data

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.