Connect AppsFlyer to Amazon S3 with Windsor.ai
Stream all your app attribution data from from AppsFlyer to Amazon S3
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 Amazon S3
Amazon S3 or Amazon Simple Store Service is offered by Amazon Web Services (AWS). It used by many web applications globally and provides scalable object storage. Sending you marketing analytics data to S3 allows data and marketing teams to join it together with other data sets already stored in S3.
It is very simple to connect AppsFlyer to Amazon S3, it can be done in a fast and easy manner with Windsor.ai.
In this article, we’ll explain how to get both platforms connected. The whole process should not take more than 5 minutes and you can choose between +70 different dimensions and metrics from AppsFlyer.
First step:
You need to select Appsflyer as Data Source in Windsor.ai and add App ID and API KEY in the relevant fields.
Select AMAZON S3 as a data destination.
Add the following information in the relevant fields :
- Amazon S3 Bucket name
- Amazon S3 Access Key
- Amazon S3 Secret Key
- Select the preferred refresh schedule 12H or 24H
- Add a Folder path to upload to, for example, Windsor-ai.(Optional)
- Add Backfill Data period(Optional)
Instruction: The list of selected fields must contain a date field.
You should also read :
How to connect Amazon MWS to Power BI
See Windsor.ai in action
AppsFlyer metrics and dimensions available for streaming into Amazon S3
| 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 Amazon S3
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.
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.