# Adjust v1 | Features | Details | | ------------------------------- | -------------------------------------------- | | Release Status | In-dev | | Source API Version | v1 | | Table Selection | Yes | | Column Selection | Yes | | Edit Integration | Yes (Tables, filters) / No (Columns, Fields) | | Replication Type Selection | No | | Authentication Parameters | API Key | | Replication Type | Key Based Incremental | | Replication Key | Date | | Suggested Replication Frequency | 2-4 hrs | ### Tables/APIs Supported: \--- | --- \ There are three types of tables (queries) that you can integrate: 1. Overview 2. Events 3. Cohorts These largely mirror different sections in the Adjust dashboard, and allow you to see the relevant KPIs directly. Data will be fetched in combinations of selected Attribution source, Attribution type, Reattributed and Period filter (in case of cohort queries). ### Integrate Adjust with Daton \------ | ------ 1. Sign in to Daton 2. Select Adjust from Integrations page 3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later 4. Provide API Key for authorizing Daton () and app token () to extract data periodically 5. Post successful authentication, you will be prompted to choose from the list of available Adjust queries (tables) 6. Select from the list of kpis (columns) available for your app along with a combination of filters for each table and your UTC offset 7. Submit the integration 8. For integrating additional apps, one has to create a new integration from step-2. ### Workflow \------ | ------ 1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to 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 ### Adjust Data \------ | ------ Each combination of filters would be used to query the trackers' data for that particular app as a table in the selected warehouse. The data will be stored incrementally in a batch of 10 days in the warehouse as following base fields in their respective tables- 1. Networks (top level) 2. Campaigns (sublevel 1) 3. Adgroups (sublevel 2) 4. Creatives (sublevel 3) #### Tables 1. \_OverviewQueries Documentation: **Fields:** | Name | Target Datatype | | :---------------------: | :-------------: | | Name | STRING | | Currency | STRING | | StartDate | DATE | | EndDate | DATE | | Attribution source | STRING | | Attribution type | STRING | | Reattributed | STRING | | utc\_offset | STRING | | Networks | RECORD | | \_daton\_user\_id | NUMERIC | | \_daton\_batch\_runtime | NUMERIC | | \_daton\_batch\_id | NUMERIC | **Sub-fields:** 1. Networks: | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | AppKpis | RECORD | | EventKpis | RECORD | | AdKpis | RECORD | | CostKpis | RECORD | | FraudKpis | RECORD | | Campaigns | RECORD | 1. Campaigns: | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | AppKpis | RECORD | | EventKpis | RECORD | | AdKpis | RECORD | | CostKpis | RECORD | | FraudKpis | RECORD | | AdGroups | RECORD | 1. AdGroups: | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | AppKpis | RECORD | | EventKpis | RECORD | | AdKpis | RECORD | | CostKpis | RECORD | | FraudKpis | RECORD | | Creatives | RECORD | 1. Creatives | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | AppKpis | RECORD | | EventKpis | RECORD | | AdKpis | RECORD | | CostKpis | RECORD | | FraudKpis | RECORD | 1. AppKpis | Name | Target Datatype | | :--------------------------------------: | :-------------: | | sessions | FLOAT | | clicks | FLOAT | | installs | FLOAT | | uninstalls | FLOAT | | deattributions | FLOAT | | impressions | FLOAT | | uninstall\_cohort | FLOAT | | reinstalls | FLOAT | | click\_conversion\_rate | FLOAT | | impression\_conversion\_rate | FLOAT | | ctr | FLOAT | | reattribution\_reinstalls | FLOAT | | reattributions | FLOAT | | revenue\_events | FLOAT | | revenue | FLOAT | | all\_revenue | FLOAT | | cohort\_revenue | FLOAT | | daus | FLOAT | | waus | FLOAT | | maus | FLOAT | | limit\_ad\_tracking\_installs | FLOAT | | limit\_ad\_tracking\_install\_rate | FLOAT | | limit\_ad\_tracking\_reattributions | FLOAT | | limit\_ad\_tracking\_reattribution\_rate | FLOAT | | gdpr\_forgets | FLOAT | | cohort\_ad\_revenue | FLOAT | | cohort\_all\_revenue | FLOAT | 2. EventKpis | Name | Target Datatype | | :--------------------------: | :-------------: | | revenue | RECORD | | events | RECORD | | revenue\_per\_event | RECORD | | revenue\_events | RECORD | | first\_events | RECORD | | revenue\_per\_revenue\_event | RECORD | Each RECORD of EventKpis: | Name | Target Datatype | | :-------: | :-------------: | | EventName | STRING | | Value | FLOAT | 3. AdKpis | Name | Target Datatype | | :-------------: | :-------------: | | all\_revenue | FLOAT | | ad\_revenue | FLOAT | | ad\_impressions | FLOAT | | ad\_rpm | FLOAT | 4. CostKpis | Name | Target Datatype | | :--------------------: | :-------------: | | install\_cost | FLOAT | | click\_cost | FLOAT | | impression\_cost | FLOAT | | cost | FLOAT | | paid\_installs | FLOAT | | paid\_clicks | FLOAT | | paid\_impressions | FLOAT | | ecpc | FLOAT | | ecpm | FLOAT | | ecpi | FLOAT | | cohort\_gross\_profit | FLOAT | | return\_on\_investment | FLOAT | | rcr | FLOAT | | roas | FLOAT | 5. FraudKpis | Name | Target Datatype | | :---------------------------------------------------: | :-------------: | | rejected\_installs | FLOAT | | rejected\_installs\_anon\_ip | FLOAT | | rejected\_installs\_too\_many\_engagements | FLOAT | | rejected\_installs\_distribution\_outlier | FLOAT | | rejected\_reattributions | FLOAT | | rejected\_reattributions\_anon\_ip | FLOAT | | rejected\_reattributions\_too\_many\_engagements | FLOAT | | rejected\_reattributions\_distribution\_outlier | FLOAT | | rejected\_reattributions\_click\_injection | FLOAT | | rejected\_install\_rate | FLOAT | | rejected\_install\_anon\_ip\_rate | FLOAT | | rejected\_install\_too\_many\_engagements\_rate | FLOAT | | rejected\_install\_distribution\_outlier\_rate | FLOAT | | rejected\_install\_click\_injection\_rate | FLOAT | | rejected\_reattribution\_rate | FLOAT | | rejected\_reattribution\_anon\_ip\_rate | FLOAT | | rejected\_reattribution\_too\_many\_engagements\_rate | FLOAT | | rejected\_reattribution\_distribution\_outlier\_rate | FLOAT | | rejected\_reattribution\_click\_injection\_rate | FLOAT | 2. \_EventQueries Documentation: **Fields:** | Name | Target Datatype | | :---------------------: | :-------------: | | Name | STRING | | Currency | STRING | | StartDate | DATE | | EndDate | DATE | | Attribution source | STRING | | Attribution type | STRING | | Reattributed | STRING | | utc\_offset | STRING | | Networks | RECORD | | \_daton\_user\_id | NUMERIC | | \_daton\_batch\_runtime | NUMERIC | | \_daton\_batch\_id | NUMERIC | **Sub-fields:** 1. Networks: | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | Events | RECORD | | Campaigns | RECORD | 1. Campaigns | Name | Target Datatype | | :------: | :-------------: | | Name | STRING | | Events | RECORD | | AdGroups | RECORD | 1. AdGroups | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | Events | RECORD | | Creatives | RECORD | 1. Creatives | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | Events | RECORD | | Creatives | RECORD | 2. Events | Name | Target Datatype | | :--------------------------: | :-------------: | | EventName | STRING | | first\_events | FLOAT | | revenue\_per\_revenue\_event | FLOAT | | revenue\_events | FLOAT | | revenue | FLOAT | | events | FLOAT | | revenue\_per\_event | FLOAT | 2. \_CohortQueries Documentation: **Fields:** | Name | Target Datatype | | :---------------------: | :-------------: | | Name | STRING | | Currency | STRING | | StartDate | DATE | | EndDate | DATE | | Attribution source | STRING | | Attribution type | STRING | | Reattributed | STRING | | utc\_offset | STRING | | period | STRING | | Networks | RECORD | | \_daton\_user\_id | NUMERIC | | \_daton\_batch\_runtime | NUMERIC | | \_daton\_batch\_id | NUMERIC | **Sub-fields:** 1. Networks: | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | Periods | RECORD | | Campaigns | RECORD | 1. Campaigns | Name | Target Datatype | | :------: | :-------------: | | Name | STRING | | Periods | RECORD | | AdGroups | RECORD | 1. AdGroups | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | Periods | RECORD | | Creatives | RECORD | 1. Creatives | Name | Target Datatype | | :-------: | :-------------: | | Name | STRING | | Periods | RECORD | | Creatives | RECORD | 2. Periods | Name | Target Datatype | | :--------------------------------: | :-------------: | | Period | STRING | | time\_spent\_per\_session | FLOAT | | converted\_user\_size | FLOAT | | conversion\_per\_user | FLOAT | | conversion\_distribution | FLOAT | | converted\_users | FLOAT | | revenue\_events\_per\_paying\_user | FLOAT | | events | FLOAT | | conversion\_per\_active\_user | FLOAT | | revenue\_events\_per\_active\_user | FLOAT | | revenue\_events\_per\_user | FLOAT | | first\_uninstalls\_total | FLOAT | | first\_reinstalls | FLOAT | | first\_uninstalls\_total | FLOAT | | reinstalls | FLOAT | | reinstalls\_total | FLOAT | | gdpr\_forgets | FLOAT | | gdpr\_forgets\_total | FLOAT | | first\_uninstalls | FLOAT | | uninstalls\_total | FLOAT | | uninstalls | FLOAT | | reattributions\_per\_deattribution | FLOAT | | deattributions\_per\_user | FLOAT | | revenue\_events | FLOAT | | reattributions\_per\_user | FLOAT | | deattributions | FLOAT | | reattributions | FLOAT | | events\_per\_active\_user | FLOAT | | events\_per\_user | FLOAT | | events\_per\_converted\_user | FLOAT | | paying\_users | FLOAT | | paying\_user\_rate | FLOAT | | paying\_user\_size | FLOAT | | paying\_users\_retention\_rate | FLOAT | | cohort\_size | FLOAT | | retained\_users | FLOAT | | retention\_rate | FLOAT | | sessions | FLOAT | | sessions\_per\_user | FLOAT | | revenue | FLOAT | | revenue\_total | FLOAT | | revenue\_per\_user | FLOAT | | revenue\_per\_paying\_user | FLOAT | | revenue\_total\_in\_cohort | FLOAT | | revenue\_events\_total\_in\_cohort | FLOAT | | lifetime\_value | FLOAT | | paying\_user\_lifetime\_value | FLOAT | | time\_spent | FLOAT | | time\_spent\_per\_user | FLOAT |