# 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 (<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:**

|           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: <https://help.adjust.com/en/article/kpi-service#event-queries>

**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: <https://help.adjust.com/en/article/kpi-service#cohort-queries>

**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      |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/advertising/adjust.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.