Sprinklr + AppsFlyer Integration
Updated
We have integrated the AppsFlyer Data Locker within Sprinklr to empower marketers to maximize the return on their marketing investments. It provides independent measurement solutions and innovative tools to grow and protect your business.
With Sprinklr’s integration with AppsFlyer, you are able to view your AppsFlyer install, in-app event metrics, and dimensions within Sprinklr alongside your social performance metrics. Advertisers are able to view this data in Sprinklr Ads Manager and Ads Reporting as well. You can also optimize your social campaigns using this data with Sprinklr’s Smart Budget Allocation tool and Rule Engine.
Sprinklr’s integration with AppsFlyer is unidirectional i.e. only we receive data from AppsFlyer. No data from Sprinklr or social data is transferred back to AppsFlyer.
To learn more about getting this capability enabled in your environment, please work with your Success Manager. |
Getting Started
Upon reaching out to your Success Manager, please provide them with the following information:
AWS Access Key, Home Folder, Bucket Name, and Bucket Secret.
List of Metrics, Dimensions, and Events you are currently reporting on.
Verify that the above are available as a report within AppsFlyer Data Locker with af_ad_id column.
If possible, provide an export of AppsFlyer install and event data for one social campaign that has run within the last 30 days. This will be used for data verification. Please include af_c_id and af_ad_id as columns within the report.
Sprinklr + AppsFlyer Integration Background
AppsFlyer is not able to forward Facebook, Twitter, Snapchat, and Yahoo directly to third parties due to data policies from these platforms. Hence, these platforms will show up as 'Organic' media sources, which is why you must have the AppsFlyer Data Locker in order to integrate AppsFlyer with Sprinklr.
AppsFlyer's product Data Locker is an AWS S3 instance set up and maintained by AppsFlyer. For more information, see Data Locker. AppsFlyer will perform daily data dumps of the client’s data into this S3 bucket, which the client can give Sprinklr access to. Within Data Locker users can add dimensions within their reports corresponding to Social Channel Ad, Ad Set, and Campaign ID.
Through our integration, we fetch, map, and store the data in the following ways:
Term | Description |
Data Fetching |
|
Data Mapping | Sprinklr maps the data from the af_ad_id columns present in the data locker. If af_ad_id is not mapped to a specific Ad Variant, the data will not be stored within Sprinklr. |
Timezone | Data from AppsFlyer is imported into Sprinklr in UTC (Coordinated Universal Time), however, we convert the data to the associated ad account timezone. For example, if the conversion happened at 1 am GMT on Aug 1st and the Ad Account is in EST, we will show the event occurring at 8 pm EST on July 31st. |
Supported Channels | Sprinklr will map to the specific ad id of all the supported channels for whatever data is present. |
Backfill | Sprinklr is only able to fetch the last 30 days' data as Data Locker deletes data after 30 days. Once enabled, Sprinklr will automatically fetch the data for the last 30 days. Depending on the amount of data, it may take 3-4 days to backfill the last 30 days. |
Supported Dimensions and Metrics for Reporting
Available Dimensions
Dimensions | Description |
AppsFlyer Ad ID | The Ad ID as reported by AppsFlyer. |
AppsFlyer Ad Name | The Ad Name as reported by AppsFlyer. |
AppsFlyer Ad Set ID | The Ad Set ID as reported by AppsFlyer. |
AppsFlyer Ad Set Name | The Ad Set Name as reported by AppsFlyer. |
AppsFlyer Campaign ID | The Campaign ID as reported by AppsFlyer. |
AppsFlyer Campaign Name | The Campaign Name as reported by AppsFlyer. |
AppsFlyer Application | The name of the AppsFlyer application. |
AppsFlyer Attributed Touch Type | The type of touch attributed by AppsFlyer. Possible values: click/impression/TV/pre-installed. Re-engagement: click, an impression (re-attribution only). |
AppsFlyer Event Name | The name of the AppsFlyer event that took place. Any action that a user performs in an app: purchase, sign-in, passing a game level. |
AppsFlyer Event Source | The source of the AppsFlyer event - either SDK or S2S. |
AppsFlyer Channel | The AppsFlyer channel of the media source. Example: YouTube for Google, Instagram for Facebook |
AppsFlyer Platform | The AppsFlyer platform with possible values as iOS, Android, or Windows Mobile. |
AppsFlyer Attribution Lookback | The AppsFlyer lookback window for click attribution. The window duration is the maximum CTIT (click time to install) for the new user to be attributed to the source displaying the ad/link. |
AppsFlyer Country | The country where the install or event occurred. Provide in Country Code. Example: GB, US. |
AppsFlyer State | The state where the install or event occurred. This information is based on IP from the SDK. |
AppsFlyer Currency | The AppsFlyer event revenue currency as reported to the SDK. |
AppsFlyer Event Time | The timestamp for an occurred in-app AppsFlyer event. |
AppsFlyer Device Type | The commercial model name of the device where the install or event occurred. Example: SM-GM284 or iPhone7 |
AppsFlyer Media Source | The media source attributed to the mobile app install or post-install event. |
Available Metrics
Metrics | Description |
AppsFlyer Install | The number of AppsFlyer installs that occurred. |
AppsFlyer Event Count | The number of AppsFlyer events that occurred. |
AppsFlyer Cost Value | The AppsFlyer Cost in original currency. Supports up to 4 digits after the decimal point. Example: 320.5095 |
AppsFlyer Event Revenue | The amount of revenue using AppsFlyer Event Revenue Currency. |
AppsFlyer in Ads Manager
AppsFlyer reporting is supported within Ads Manager at all ad entity levels (Paid Initiative, Ad Set, and Ad Variant).
As data is fetched at the Ad Variant level; the Ad Set and Paid Initiative data will be an addition of all the Ad Variants contained within each entity.
AppsFlyer's Data Optimization
Smart Budget - AppsFlyer data can be used within Sprinklr’s Smart Budget Allocation. Optimizations will be made with the data available within Sprinklr.
Rule Engine - AppsFlyer metrics are available within the Paid Rule Engine. Conditions will only be met with the data available within Sprinklr.
AppsFlyer in Ads Reporting
Within Ads Reporting, AppsFlyer data is supported at all ad entity levels including the Account level.
AppsFlyer data can be added to the widget with any social metric. However, it cannot be added to the same widget as that containing channel-specific dimension breakdowns. For example, Facebook Gender, Facebook Age, etc.
AppsFlyer metrics can be added in the same widget as other third-party data metrics.
AppsFlyer metrics can also be used within Custom Metrics. For example, Cost Per AppsFlyer Install = (Spent / AppsFlyer Install). Use Currency as the metric type.