# Appsflyer

### Snapshot

| Features                        | Details                              |
| ------------------------------- | ------------------------------------ |
| Release Status                  | Released                             |
| Source API Version              | v5                                   |
| Table Selection                 | Yes                                  |
| Column Selection                | Yes                                  |
| Edit Integration                | Yes                                  |
| Replication Type Selection      | No                                   |
| Authentication Parameters       | <p>AppsFlyer App Id<br>App Token</p> |
| Replication Type                | Key Based Incremental                |
| Replication Key                 | Date                                 |
| Suggested Replication Frequency |                                      |

| Tables/APIs Supported    |                       |
| ------------------------ | --------------------- |
| InstallsReport           | InAppEventsReport     |
| UninstallEventsReport    | OrganicInstallsReport |
| OrganicInAppEventsReport | InvalidInstallsReport |
| InvalidInAppEventsReport |                       |

### Integrate AppsFlyer with Daton

1. Sign in to Daton.
2. Select AppsFlyer from the Integrations page.
3. Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.&#x20;
4. Provide AppsFlyer App Id and Token.
5. Post successful authentication, you will be prompted to choose from the list of available tables.
6. Select all the required fields for each table.
7. Submit the integration.

### Workflow

1. Integrations would be in the Pending state initially and will be moved to the Active state as soon as the first job loads data successfully onto the configured warehouse.
2. Users would be able to edit/pause/re-activate/delete integration anytime.
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.

### AppsFlyer Data

**InstallsReport**

Purpose: Can fetch the details of data including time of installation, type of device, operating system, region, city, country, and more.

Source API Documentation  <https://support.appsflyer.com/hc/en-us/articles/207034506#Introduction>

Replication: Key-Based Replication

Replication Key: LastRunDate

**Fields**

| Name                          | Target Datatype |
| ----------------------------- | --------------- |
| attributed\_touch\_type       | STRING          |
| attributed\_touch\_time       | DATETIME        |
| install\_time                 | DATETIME        |
| event\_time                   | DATETIME        |
| event\_name                   | STRING          |
| event\_value                  | STRING          |
| event\_revenue                | STRING          |
| event\_revenue\_currency      | STRING          |
| event\_revenue\_usd           | STRING          |
| event\_source                 | STRING          |
| is\_receipt\_validated        | BOOLEAN         |
| af\_prt                       | STRING          |
| media\_source                 | STRING          |
| af\_channel                   | STRING          |
| af\_keywords                  | STRING          |
| campaign                      | STRING          |
| af\_c\_id                     | STRING          |
| af\_adset                     | STRING          |
| af\_adset\_id                 | STRING          |
| af\_ad                        | STRING          |
| af\_ad\_id                    | STRING          |
| af\_ad\_type                  | STRING          |
| af\_siteid                    | STRING          |
| af\_sub\_siteid               | STRING          |
| af\_sub1                      | STRING          |
| af\_sub2                      | STRING          |
| af\_sub3                      | STRING          |
| af\_sub4                      | STRING          |
| af\_sub5                      | STRING          |
| af\_cost\_model               | STRING          |
| af\_cost\_value               | STRING          |
| af\_cost\_currency            | STRING          |
| contributor1\_af\_prt         | STRING          |
| contributor1\_media\_source   | STRING          |
| contributor1\_campaign        | STRING          |
| contributor1\_touch\_type     | STRING          |
| contributor1\_touch\_time     | DATETIME        |
| contributor2\_af\_prt         | STRING          |
| contributor2\_media\_source   | STRING          |
| contributor2\_campaign        | STRING          |
| contributor2\_touch\_type     | STRING          |
| contributor2\_touch\_time     | DATETIME        |
| contributor3\_af\_prt         | STRING          |
| contributor3\_media\_source   | STRING          |
| contributor3\_campaign        | STRING          |
| contributor3\_touch\_type     | STRING          |
| contributor3\_touch\_time     | DATETIME        |
| region                        | STRING          |
| country\_code                 | STRING          |
| state                         | STRING          |
| city                          | STRING          |
| postal\_code                  | STRING          |
| dma                           | STRING          |
| ip                            | STRING          |
| wifi                          | BOOLEAN         |
| operator                      | STRING          |
| carrier                       | STRING          |
| language                      | STRING          |
| appsflyer\_id                 | STRING          |
| advertising\_id               | STRING          |
| idfa                          | STRING          |
| android\_id                   | STRING          |
| customer\_user\_id            | INTEGER         |
| imei                          | STRING          |
| idfv                          | STRING          |
| platform                      | STRING          |
| device\_type                  | STRING          |
| os\_version                   | STRING          |
| app\_version                  | STRING          |
| sdk\_version                  | STRING          |
| app\_id                       | STRING          |
| app\_name                     | STRING          |
| bundle\_id                    | STRING          |
| is\_retargeting               | BOOLEAN         |
| retargeting\_conversion\_type | STRING          |
| af\_attribution\_lookback     | STRING          |
| af\_reengagement\_window      | STRING          |
| is\_primary\_attribution      | BOOLEAN         |
| user\_agent                   | STRING          |
| http\_referrer                | STRING          |
| original\_url                 | STRING          |

**InAppEventsReport**

Purpose: Can fetch the details of the report that contains all the actions performed by your non-organic users, which were sent to AppsFlyer from the SDK or via the server-to-server API, or via native web view.

Source API Documentation  <https://support.appsflyer.com/hc/en-us/articles/115004574886-In-App-Events-Raw-Data-Report>

Replication: Key-Based Replication

Replication Key: LastRunDate

**Fields**

| Name                          | Target Datatype |
| ----------------------------- | --------------- |
| attributed\_touch\_type       | STRING          |
| attributed\_touch\_time       | DATETIME        |
| install\_time                 | DATETIME        |
| event\_time                   | DATETIME        |
| event\_name                   | STRING          |
| event\_value                  | STRING          |
| event\_revenue                | STRING          |
| event\_revenue\_currency      | STRING          |
| event\_revenue\_usd           | STRING          |
| event\_source                 | STRING          |
| is\_receipt\_validated        | BOOLEAN         |
| af\_prt                       | STRING          |
| media\_source                 | STRING          |
| af\_channel                   | STRING          |
| af\_keywords                  | STRING          |
| campaign                      | STRING          |
| af\_c\_id                     | STRING          |
| af\_adset                     | STRING          |
| af\_adset\_id                 | STRING          |
| af\_ad                        | STRING          |
| af\_ad\_id                    | STRING          |
| af\_ad\_type                  | STRING          |
| af\_siteid                    | STRING          |
| af\_sub\_siteid               | STRING          |
| af\_sub1                      | STRING          |
| af\_sub2                      | STRING          |
| af\_sub3                      | STRING          |
| af\_sub4                      | STRING          |
| af\_sub5                      | STRING          |
| af\_cost\_model               | STRING          |
| af\_cost\_value               | STRING          |
| af\_cost\_currency            | STRING          |
| contributor1\_af\_prt         | STRING          |
| contributor1\_media\_source   | STRING          |
| contributor1\_campaign        | STRING          |
| contributor1\_touch\_type     | STRING          |
| contributor1\_touch\_time     | DATETIME        |
| contributor2\_af\_prt         | STRING          |
| contributor2\_media\_source   | STRING          |
| contributor2\_campaign        | STRING          |
| contributor2\_touch\_type     | STRING          |
| contributor2\_touch\_time     | DATETIME        |
| contributor3\_af\_prt         | STRING          |
| contributor3\_media\_source   | STRING          |
| contributor3\_campaign        | STRING          |
| contributor3\_touch\_type     | STRING          |
| contributor3\_touch\_time     | DATETIME        |
| region                        | STRING          |
| country\_code                 | STRING          |
| state                         | STRING          |
| city                          | STRING          |
| postal\_code                  | STRING          |
| dma                           | STRING          |
| ip                            | STRING          |
| wifi                          | BOOLEAN         |
| operator                      | STRING          |
| carrier                       | STRING          |
| language                      | STRING          |
| appsflyer\_id                 | STRING          |
| advertising\_id               | STRING          |
| idfa                          | STRING          |
| android\_id                   | STRING          |
| customer\_user\_id            | INTEGER         |
| imei                          | STRING          |
| idfv                          | STRING          |
| platform                      | STRING          |
| device\_type                  | STRING          |
| os\_version                   | STRING          |
| app\_version                  | STRING          |
| sdk\_version                  | STRING          |
| app\_id                       | STRING          |
| app\_name                     | STRING          |
| bundle\_id                    | STRING          |
| is\_retargeting               | BOOLEAN         |
| retargeting\_conversion\_type | STRING          |
| af\_attribution\_lookback     | STRING          |
| af\_reengagement\_window      | STRING          |
| is\_primary\_attribution      | BOOLEAN         |
| user\_agent                   | STRING          |
| http\_referrer                | STRING          |
| original\_url                 | STRING          |

**UninstallEventsReport**

Purpose: Can fetch the details of uninstall raw data for all non-organic installs

Source API Documentation  <https://support.appsflyer.com/hc/en-us/articles/115000807786-Non-Organic-Uninstall-Raw-Data-Reports>

Replication: Key-Based Replication

Replication Key: LastRunDate

**Fields**

| Name                          | Target Datatype |
| ----------------------------- | --------------- |
| attributed\_touch\_type       | STRING          |
| attributed\_touch\_time       | DATETIME        |
| install\_time                 | DATETIME        |
| event\_time                   | DATETIME        |
| event\_name                   | STRING          |
| event\_value                  | STRING          |
| event\_revenue                | STRING          |
| event\_revenue\_currency      | STRING          |
| event\_revenue\_usd           | STRING          |
| event\_source                 | STRING          |
| is\_receipt\_validated        | BOOLEAN         |
| af\_prt                       | STRING          |
| media\_source                 | STRING          |
| af\_channel                   | STRING          |
| af\_keywords                  | STRING          |
| campaign                      | STRING          |
| af\_c\_id                     | STRING          |
| af\_adset                     | STRING          |
| af\_adset\_id                 | STRING          |
| af\_ad                        | STRING          |
| af\_ad\_id                    | STRING          |
| af\_ad\_type                  | STRING          |
| af\_siteid                    | STRING          |
| af\_sub\_siteid               | STRING          |
| af\_sub1                      | STRING          |
| af\_sub2                      | STRING          |
| af\_sub3                      | STRING          |
| af\_sub4                      | STRING          |
| af\_sub5                      | STRING          |
| af\_cost\_model               | STRING          |
| af\_cost\_value               | STRING          |
| af\_cost\_currency            | STRING          |
| contributor1\_af\_prt         | STRING          |
| contributor1\_media\_source   | STRING          |
| contributor1\_campaign        | STRING          |
| contributor1\_touch\_type     | STRING          |
| contributor1\_touch\_time     | DATETIME        |
| contributor2\_af\_prt         | STRING          |
| contributor2\_media\_source   | STRING          |
| contributor2\_campaign        | STRING          |
| contributor2\_touch\_type     | STRING          |
| contributor2\_touch\_time     | DATETIME        |
| contributor3\_af\_prt         | STRING          |
| contributor3\_media\_source   | STRING          |
| contributor3\_campaign        | STRING          |
| contributor3\_touch\_type     | STRING          |
| contributor3\_touch\_time     | DATETIME        |
| region                        | STRING          |
| country\_code                 | STRING          |
| state                         | STRING          |
| city                          | STRING          |
| postal\_code                  | STRING          |
| dma                           | STRING          |
| ip                            | STRING          |
| wifi                          | BOOLEAN         |
| operator                      | STRING          |
| carrier                       | STRING          |
| language                      | STRING          |
| appsflyer\_id                 | STRING          |
| advertising\_id               | STRING          |
| idfa                          | STRING          |
| android\_id                   | STRING          |
| customer\_user\_id            | INTEGER         |
| imei                          | STRING          |
| idfv                          | STRING          |
| platform                      | STRING          |
| device\_type                  | STRING          |
| os\_version                   | STRING          |
| app\_version                  | STRING          |
| sdk\_version                  | STRING          |
| app\_id                       | STRING          |
| app\_name                     | STRING          |
| bundle\_id                    | STRING          |
| is\_retargeting               | BOOLEAN         |
| retargeting\_conversion\_type | STRING          |
| af\_attribution\_lookback     | STRING          |
| af\_reengagement\_window      | STRING          |
| is\_primary\_attribution      | BOOLEAN         |
| user\_agent                   | STRING          |
| http\_referrer                | STRING          |
| original\_url                 | STRING          |

**OrganicInstallsReport**

Purpose: Can fetch the details of the report also includes the attribution type (click or view), the media source, campaign, ad set, and ad type.

Source API Documentation  <https://support.appsflyer.com/hc/en-us/articles/115002095726-Organic-Raw-Data-Reports>

Replication: Key-Based Replication

Replication Key: `LastRunDate`

**Fields**

| Name                          | Target Datatype |
| ----------------------------- | --------------- |
| attributed\_touch\_type       | STRING          |
| attributed\_touch\_time       | DATETIME        |
| install\_time                 | DATETIME        |
| event\_time                   | DATETIME        |
| event\_name                   | STRING          |
| event\_value                  | STRING          |
| event\_revenue                | STRING          |
| event\_revenue\_currency      | STRING          |
| event\_revenue\_usd           | STRING          |
| event\_source                 | STRING          |
| is\_receipt\_validated        | BOOLEAN         |
| af\_prt                       | STRING          |
| media\_source                 | STRING          |
| af\_channel                   | STRING          |
| af\_keywords                  | STRING          |
| campaign                      | STRING          |
| af\_c\_id                     | STRING          |
| af\_adset                     | STRING          |
| af\_adset\_id                 | STRING          |
| af\_ad                        | STRING          |
| af\_ad\_id                    | STRING          |
| af\_ad\_type                  | STRING          |
| af\_siteid                    | STRING          |
| af\_sub\_siteid               | STRING          |
| af\_sub1                      | STRING          |
| af\_sub2                      | STRING          |
| af\_sub3                      | STRING          |
| af\_sub4                      | STRING          |
| af\_sub5                      | STRING          |
| af\_cost\_model               | STRING          |
| af\_cost\_value               | STRING          |
| af\_cost\_currency            | STRING          |
| contributor1\_af\_prt         | STRING          |
| contributor1\_media\_source   | STRING          |
| contributor1\_campaign        | STRING          |
| contributor1\_touch\_type     | STRING          |
| contributor1\_touch\_time     | DATETIME        |
| contributor2\_af\_prt         | STRING          |
| contributor2\_media\_source   | STRING          |
| contributor2\_campaign        | STRING          |
| contributor2\_touch\_type     | STRING          |
| contributor2\_touch\_time     | DATETIME        |
| contributor3\_af\_prt         | STRING          |
| contributor3\_media\_source   | STRING          |
| contributor3\_campaign        | STRING          |
| contributor3\_touch\_type     | STRING          |
| contributor3\_touch\_time     | DATETIME        |
| region                        | STRING          |
| country\_code                 | STRING          |
| state                         | STRING          |
| city                          | STRING          |
| postal\_code                  | STRING          |
| dma                           | STRING          |
| ip                            | STRING          |
| wifi                          | BOOLEAN         |
| operator                      | STRING          |
| carrier                       | STRING          |
| language                      | STRING          |
| appsflyer\_id                 | STRING          |
| advertising\_id               | STRING          |
| idfa                          | STRING          |
| android\_id                   | STRING          |
| customer\_user\_id            | INTEGER         |
| imei                          | STRING          |
| idfv                          | STRING          |
| platform                      | STRING          |
| device\_type                  | STRING          |
| os\_version                   | STRING          |
| app\_version                  | STRING          |
| sdk\_version                  | STRING          |
| app\_id                       | STRING          |
| app\_name                     | STRING          |
| bundle\_id                    | STRING          |
| is\_retargeting               | BOOLEAN         |
| retargeting\_conversion\_type | STRING          |
| af\_attribution\_lookback     | STRING          |
| af\_reengagement\_window      | STRING          |
| is\_primary\_attribution      | BOOLEAN         |
| user\_agent                   | STRING          |
| http\_referrer                | STRING          |
| original\_url                 | STRING          |

**OrganicInAppEventsReport**

Purpose: Can fetch the details of the raw data report for all organic installs and In-App Events.

Source API Documentation  <https://support.appsflyer.com/hc/en-us/articles/115002095726-Organic-Raw-Data-Reports>

Replication: Key-Based Replication

Replication Key: LastRunDate

**Fields**

| Name                          | Target Datatype |
| ----------------------------- | --------------- |
| attributed\_touch\_type       | STRING          |
| attributed\_touch\_time       | DATETIME        |
| install\_time                 | DATETIME        |
| event\_time                   | DATETIME        |
| event\_name                   | STRING          |
| event\_value                  | STRING          |
| event\_revenue                | STRING          |
| event\_revenue\_currency      | STRING          |
| event\_revenue\_usd           | STRING          |
| event\_source                 | STRING          |
| is\_receipt\_validated        | BOOLEAN         |
| af\_prt                       | STRING          |
| media\_source                 | STRING          |
| af\_channel                   | STRING          |
| af\_keywords                  | STRING          |
| campaign                      | STRING          |
| af\_c\_id                     | STRING          |
| af\_adset                     | STRING          |
| af\_adset\_id                 | STRING          |
| af\_ad                        | STRING          |
| af\_ad\_id                    | STRING          |
| af\_ad\_type                  | STRING          |
| af\_siteid                    | STRING          |
| af\_sub\_siteid               | STRING          |
| af\_sub1                      | STRING          |
| af\_sub2                      | STRING          |
| af\_sub3                      | STRING          |
| af\_sub4                      | STRING          |
| af\_sub5                      | STRING          |
| af\_cost\_model               | STRING          |
| af\_cost\_value               | STRING          |
| af\_cost\_currency            | STRING          |
| contributor1\_af\_prt         | STRING          |
| contributor1\_media\_source   | STRING          |
| contributor1\_campaign        | STRING          |
| contributor1\_touch\_type     | STRING          |
| contributor1\_touch\_time     | DATETIME        |
| contributor2\_af\_prt         | STRING          |
| contributor2\_media\_source   | STRING          |
| contributor2\_campaign        | STRING          |
| contributor2\_touch\_type     | STRING          |
| contributor2\_touch\_time     | DATETIME        |
| contributor3\_af\_prt         | STRING          |
| contributor3\_media\_source   | STRING          |
| contributor3\_campaign        | STRING          |
| contributor3\_touch\_type     | STRING          |
| contributor3\_touch\_time     | DATETIME        |
| region                        | STRING          |
| country\_code                 | STRING          |
| state                         | STRING          |
| city                          | STRING          |
| postal\_code                  | STRING          |
| dma                           | STRING          |
| ip                            | STRING          |
| wifi                          | BOOLEAN         |
| operator                      | STRING          |
| carrier                       | STRING          |
| language                      | STRING          |
| appsflyer\_id                 | STRING          |
| advertising\_id               | STRING          |
| idfa                          | STRING          |
| android\_id                   | STRING          |
| customer\_user\_id            | INTEGER         |
| imei                          | STRING          |
| idfv                          | STRING          |
| platform                      | STRING          |
| device\_type                  | STRING          |
| os\_version                   | STRING          |
| app\_version                  | STRING          |
| sdk\_version                  | STRING          |
| app\_id                       | STRING          |
| app\_name                     | STRING          |
| bundle\_id                    | STRING          |
| is\_retargeting               | BOOLEAN         |
| retargeting\_conversion\_type | STRING          |
| af\_attribution\_lookback     | STRING          |
| af\_reengagement\_window      | STRING          |
| is\_primary\_attribution      | BOOLEAN         |
| user\_agent                   | STRING          |
| http\_referrer                | STRING          |
| original\_url                 | STRING          |

**InvalidInstallsReport**

Purpose: Can fetch the details of all invalid installations.

Source API Documentation  <https://support.appsflyer.com/hc/en-us/articles/115004703926#targeting-targeting-validation-rules-export-data>

Replication: Key-Based Replication

Replication Key: LastRunDate

**Fields**

| Name                          | Target Datatype |
| ----------------------------- | --------------- |
| attributed\_touch\_type       | STRING          |
| attributed\_touch\_time       | DATETIME        |
| install\_time                 | DATETIME        |
| event\_time                   | DATETIME        |
| event\_name                   | STRING          |
| event\_value                  | STRING          |
| event\_revenue                | STRING          |
| event\_revenue\_currency      | STRING          |
| event\_revenue\_usd           | STRING          |
| event\_source                 | STRING          |
| is\_receipt\_validated        | BOOLEAN         |
| af\_prt                       | STRING          |
| media\_source                 | STRING          |
| af\_channel                   | STRING          |
| af\_keywords                  | STRING          |
| campaign                      | STRING          |
| af\_c\_id                     | STRING          |
| af\_adset                     | STRING          |
| af\_adset\_id                 | STRING          |
| af\_ad                        | STRING          |
| af\_ad\_id                    | STRING          |
| af\_ad\_type                  | STRING          |
| af\_siteid                    | STRING          |
| af\_sub\_siteid               | STRING          |
| af\_sub1                      | STRING          |
| af\_sub2                      | STRING          |
| af\_sub3                      | STRING          |
| af\_sub4                      | STRING          |
| af\_sub5                      | STRING          |
| af\_cost\_model               | STRING          |
| af\_cost\_value               | STRING          |
| af\_cost\_currency            | STRING          |
| contributor1\_af\_prt         | STRING          |
| contributor1\_media\_source   | STRING          |
| contributor1\_campaign        | STRING          |
| contributor1\_touch\_type     | STRING          |
| contributor1\_touch\_time     | DATETIME        |
| contributor2\_af\_prt         | STRING          |
| contributor2\_media\_source   | STRING          |
| contributor2\_campaign        | STRING          |
| contributor2\_touch\_type     | STRING          |
| contributor2\_touch\_time     | DATETIME        |
| contributor3\_af\_prt         | STRING          |
| contributor3\_media\_source   | STRING          |
| contributor3\_campaign        | STRING          |
| contributor3\_touch\_type     | STRING          |
| contributor3\_touch\_time     | DATETIME        |
| region                        | STRING          |
| country\_code                 | STRING          |
| state                         | STRING          |
| city                          | STRING          |
| postal\_code                  | STRING          |
| dma                           | STRING          |
| ip                            | STRING          |
| wifi                          | BOOLEAN         |
| operator                      | STRING          |
| carrier                       | STRING          |
| language                      | STRING          |
| appsflyer\_id                 | STRING          |
| advertising\_id               | STRING          |
| idfa                          | STRING          |
| android\_id                   | STRING          |
| customer\_user\_id            | INTEGER         |
| imei                          | STRING          |
| idfv                          | STRING          |
| platform                      | STRING          |
| device\_type                  | STRING          |
| os\_version                   | STRING          |
| app\_version                  | STRING          |
| sdk\_version                  | STRING          |
| app\_id                       | STRING          |
| app\_name                     | STRING          |
| bundle\_id                    | STRING          |
| is\_retargeting               | BOOLEAN         |
| retargeting\_conversion\_type | STRING          |
| af\_attribution\_lookback     | STRING          |
| af\_reengagement\_window      | STRING          |
| is\_primary\_attribution      | BOOLEAN         |
| user\_agent                   | STRING          |
| http\_referrer                | STRING          |
| original\_url                 | STRING          |

**InvalidInAppEventsReport**

Purpose: Can fetch the details of all in-app events generated from invalid installations only

Source API Documentation  <https://support.appsflyer.com/hc/en-us/articles/115004703926#targeting-targeting-validation-rules-export-data>

Replication: Key-Based Replication

Replication Key: LastRunDate

**Fields**

| Name                          | Target Datatype |
| ----------------------------- | --------------- |
| attributed\_touch\_type       | STRING          |
| attributed\_touch\_time       | DATETIME        |
| install\_time                 | DATETIME        |
| event\_time                   | DATETIME        |
| event\_name                   | STRING          |
| event\_value                  | STRING          |
| event\_revenue                | STRING          |
| event\_revenue\_currency      | STRING          |
| event\_revenue\_usd           | STRING          |
| event\_source                 | STRING          |
| is\_receipt\_validated        | BOOLEAN         |
| af\_prt                       | STRING          |
| media\_source                 | STRING          |
| af\_channel                   | STRING          |
| af\_keywords                  | STRING          |
| campaign                      | STRING          |
| af\_c\_id                     | STRING          |
| af\_adset                     | STRING          |
| af\_adset\_id                 | STRING          |
| af\_ad                        | STRING          |
| af\_ad\_id                    | STRING          |
| af\_ad\_type                  | STRING          |
| af\_siteid                    | STRING          |
| af\_sub\_siteid               | STRING          |
| af\_sub1                      | STRING          |
| af\_sub2                      | STRING          |
| af\_sub3                      | STRING          |
| af\_sub4                      | STRING          |
| af\_sub5                      | STRING          |
| af\_cost\_model               | STRING          |
| af\_cost\_value               | STRING          |
| af\_cost\_currency            | STRING          |
| contributor1\_af\_prt         | STRING          |
| contributor1\_media\_source   | STRING          |
| contributor1\_campaign        | STRING          |
| contributor1\_touch\_type     | STRING          |
| contributor1\_touch\_time     | DATETIME        |
| contributor2\_af\_prt         | STRING          |
| contributor2\_media\_source   | STRING          |
| contributor2\_campaign        | STRING          |
| contributor2\_touch\_type     | STRING          |
| contributor2\_touch\_time     | DATETIME        |
| contributor3\_af\_prt         | STRING          |
| contributor3\_media\_source   | STRING          |
| contributor3\_campaign        | STRING          |
| contributor3\_touch\_type     | STRING          |
| contributor3\_touch\_time     | DATETIME        |
| region                        | STRING          |
| country\_code                 | STRING          |
| state                         | STRING          |
| city                          | STRING          |
| postal\_code                  | STRING          |
| dma                           | STRING          |
| ip                            | STRING          |
| wifi                          | BOOLEAN         |
| operator                      | STRING          |
| carrier                       | STRING          |
| language                      | STRING          |
| appsflyer\_id                 | STRING          |
| advertising\_id               | STRING          |
| idfa                          | STRING          |
| android\_id                   | STRING          |
| customer\_user\_id            | INTEGER         |
| imei                          | STRING          |
| idfv                          | STRING          |
| platform                      | STRING          |
| device\_type                  | STRING          |
| os\_version                   | STRING          |
| app\_version                  | STRING          |
| sdk\_version                  | STRING          |
| app\_id                       | STRING          |
| app\_name                     | STRING          |
| bundle\_id                    | STRING          |
| is\_retargeting               | BOOLEAN         |
| retargeting\_conversion\_type | STRING          |
| af\_attribution\_lookback     | STRING          |
| af\_reengagement\_window      | STRING          |
| is\_primary\_attribution      | BOOLEAN         |
| user\_agent                   | STRING          |
| http\_referrer                | STRING          |
| original\_url                 | STRING          |