adjust-icon

Pivot report endpoint

Pivot Report Service provides an API to get aggregated data from different sources: KPI Service metrics, KPI Service cohorts, SKAdNetwork, and Ad Spend.

The reports endpoint enables you to combine data from many services in a single report. Request installs, revenue, ad spend, and SKAdNetwork data divided by day, app, and ad network.

Fetch pivot report

Endpoint
GET https://automate.adjust.com/reports-service/pivot_report

The GET method returns filtered data from the report service in JSON format.

Filters

Dimensions

Dimensions allow a user to break down metrics into groups using one or several parameters. For example, the number of installs by date, country and network.

Metrics

Metrics are used to assess and compare the performance of campaigns you run and measure with Adjust.

At least 1 metric is required in each API request. The most common metrics are:

  • installs
  • clicks
  • impressions

A full list of metrics is available in the Datascape metrics glossary.

Response format

Response format
{
   "rows": [
      {
         "attr_dependency": {},
         "app": "App Name",
         "partner_name": "AppLovin",
         "campaign": "Campaign Name (Campaign ID)",
         "campaign_id_network": "Campaign ID",
         "campaign_network": "Campaign Name",
         "installs": "64",
         "cost": "1000"
      }
   ],
   "totals": {
      "installs": 64,
      "cost": 1000
   },
   "warnings": [],
   "totals_per_dimension": {}
}

Response codes

This endpoint returns the following responses:

Example

cURL
$ curl \
--header 'Authorization: Bearer <adjust_api_token>' \
-L -X GET 'https://automate.adjust.com/reports-service/pivot_report?cost_mode=network&app_token__in={app_token1},{app_token2}&date_period=2021-05-01:2021-05-02&dimensions=app,partner_name,campaign,campaign_id_network,campaign_network&metrics=installs,network_installs,network_cost,network_ecpi&index=app' \
Success response
{
   "rows": [
      {
         "Test App": {
            "rows": [
               {
                  "attr_dependency": {
                     "app_network": ["google_play:com.test.app"]
                  },
                  "campaign_id_network": "123",
                  "campaign_network": "Campaign Name",
                  "campaign": "Campaign Name (123)",
                  "partner_name": "MyPartner",
                  "installs": 10,
                  "network_installs": 0,
                  "network_cost": 0,
                  "network_ecpi": 0
               }
            ]
         }
      }
   ],
   "totals": {
      "installs": 10,
      "network_installs": 0,
      "network_cost": 0,
      "network_ecpi": 0
   },
   "totals_per_dimension": {
      "campaign_id_network": {
         "Organic": {
            "installs": 10,
            "network_installs": 0,
            "network_cost": 0,
            "network_ecpi": 0
         }
      },
      "campaign_network": {
         "Organic": {
            "installs": 10,
            "network_installs": 0,
            "network_cost": 0,
            "network_ecpi": 0
         }
      },
      "app": {
         "adjust Demo App": {
            "installs": 10,
            "network_installs": 0,
            "network_cost": 0,
            "network_ecpi": 0
         }
      },
      "campaign": {
         "Organic": {
            "installs": 10,
            "network_installs": 0,
            "network_cost": 0,
            "network_ecpi": 0
         }
      },
      "partner_name": {
         "Organic": {
            "installs": 10,
            "network_installs": 0,
            "network_cost": 0,
            "network_ecpi": 0
         }
      }
   }
}