Adjust v1

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 (https://help.adjust.com/en/article/kpi-service#authentication) and app token (https://help.adjust.com/en/article/app-settings#view-your-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: https://help.adjust.com/en/article/kpi-service#overview-queries

Fields:

Sub-fields:

1. Networks:

   1. Campaigns:

      1. AdGroups:

         1. Creatives

            1. AppKpis
   2. EventKpis

      Each RECORD of EventKpis:
   3. AdKpis
   4. CostKpis
   5. FraudKpis
2. _EventQueries

   Documentation: https://help.adjust.com/en/article/kpi-service#event-queries

Fields:

Sub-fields:

1. Networks:

   1. Campaigns

      1. AdGroups

         1. Creatives
      2. Events
2. _CohortQueries

   Documentation: https://help.adjust.com/en/article/kpi-service#cohort-queries

Fields:

Sub-fields:

1. Networks:

   1. Campaigns

      1. AdGroups

         1. Creatives
   2. Periods