Release Notes

August 2024

We have changed how we calculate the value of the primary key, _fivetran_id, of the EVENT table. We now calculate the _fivetran_id value as the hash of the following columns:

• app_id
• app_type
• appsflyer_id
• event_name
• event_time
• event_value
• campaign_type
• conversion_type

We have made this change to ensure we do not skip upserting any events. If you notice any events missing from your EVENT table, re-sync the table.

NOTE: Re-syncing the EVENT table only re-syncs the event data from Data Locker and Webhooks. Additionally, we only sync the last 30 days' worth of event data for Webhooks.

The AppsFlyer connector now supports table-level data blocking. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables.

May 2024

We now perform rollback syncs for the GEO_DAILY table to capture the latest Lifetime Value (LVT) records that change due to attribution. The default rollback window is 2 days. However, you can customize your rollback window within the range of 2 to 90 days. To support this enhancement, we have added a new field, Rollback Window, to the connector setup form. For more information, see our setup instructions.

November 2023

The AppsFlyer connector now supports custom configuration of the Connection Name field in the setup form to sync Data Locker events. By default, we will continue to populate data-locker-hourly/ as the connection name. You can also opt to customize the connection name in the setup form.

August 2023

We can now sync Cohort analytics aggregate reports from Data Locker into the COHORT_EVENT table.

May 2023

We can now sync the raw data and aggregate data reports from the Pull API V2. For more information, see our AppsFlyer documentation and the REST API configuration parameters.

March 2023

We can now sync the SKAdNetwork (SKAN) attribution events from Data Locker and Webhooks. We are gradually rolling out this feature to all existing connectors. For more information, see our AppsFlyer documentation.

January 2022

AppsFlyer has changed the retention period for Data Locker events (stored in the AppsFlyer S3 bucket) from 30 days to 14 days. We now retrieve events from the last 14 days. Previously, we retrieved events from the last 30 days.

November 2021

We now use the is_primary_attribution column of the EVENT table for primary key hashing. To generate the hash of the primary key, we use the following logic :

• For an event on or before 2021-11-10T00:00:00Z, we use the existing column list.
• For an event after 2021-11-10T00:00:00Z, we use the existing column list and the is_primary_attribution column.

January 2021

The AppsFlyer connector now supports syncing Data Locker events from your custom AWS S3 buckets. Previously, we only supported Data Locker events from AppsFlyer-managed buckets. See our setup instructions for more information.

April 2020

You can now configure your AppsFlyer connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

February 2020

Data collection using Push API V1.0 and Data Locker V1.0 has been deprecated. We will continue to support all deprecation changes for the next three months, so be sure to make the required schema changes by May 31, 2020.

Use Push API V2.0 and Data Locker V2.0 to continue using the service. Connectors must register the Push API V2.0 specific URL generated by Fivetran, with AppsFlyer. For more details see AppsFlyer Push API V2.O documentation.

We now sync data from Push API V2.0 and Data Locker V2.0 into a common table EVENT.

We have deprecated the following tables:

• DATA_LOCKER_V1_EVENTS
• DATA_LOCKER_V2_EVENTS
• WEBHOOK_EVENTS

August 2019

We have deprecated service version 0 of our AppsFlyer connector. This connector will stop functioning after October 1, 2019.

June 2019

We have released a new version of the AppsFlyer connector and have made the following schema changes:

• We have split the EVENT table from the old version into two new tables:

  • DATA_LOCKER_EVENTS
  • WEBHOOK_EVENTS

  The DATA_LOCKER_EVENTS table captures events from AppsFlyer Data Locker. The WEBHOOK_EVENTS table captures webhook events.

• We have removed the following tables:

  • WEBHOOK_EVENT_ATTRIBUTE
  • S3_EVENT_ATTRIBUTE

The new version supports AppsFlyer Data Locker 2.0.

The new version resolves a data integrity issue with events and webhooks. Fivetran now better captures events from AppsFlyer Data Locker and webhooks.

December 2018

AppsFlyer is a mobile app tracking and attribution analytics platform.

Read our AppsFlyer connector documentation.