Dimension-specific reports

In Kokai, you can set up your integration to quickly download predefined reports at any given time to check the performance of your campaigns and ad groups. Each report is tailored to a specific dimension such as contextual categories, creatives, ad formats, ad groups, and more. For each dimension, these reports provide detailed metrics including number of impressions, clicks, conversions, bid CPM, and so on for your campaigns and ad groups.

The following table lists some of the specifications you need to know about dimension-specific reports.

Report Specification Details Notes
Data update frequency Daily (1-day delay) None.
File format Excel XLSX None.
Report availability Immediately You can download these reports on demand without scheduling.
Retrieval method Download No manual configuration is required to download these reports.
Lookback 7 days or 30 days The lookback periods are organized into two tabs in the Excel file.
Field customization None. Since these are predefined reports, you cannot add or change metrics within them.
TIP: After you download the report, you can toggle which metrics you want to view in the Pivot Table settings within the Excel file.

Available report types (dimensions)

The following table provides an alphabetical list of each dimension available as a report, summarizes the report contents, indicates the levels (advertisers, campaigns, ad groups) at which the report is available, and provides the corresponding value to select for the ReportType property when downloading a report.

Report (Dimension) Report Contents Advertiser Campaign Ad Group API Value
Ad Format The ad formats of the creatives in your campaigns and ad groups. N/A Available Available AD_FORMAT
Ad Group An individual ad group or all ad groups across the advertiser's campaigns. Available Available Available AD_GROUP
Contextual Categories The contextual categories you are using in your campaign or ad group. N/A Available Available CONTEXTUAL
Creatives The creatives assigned to the specified campaign or ad group. N/A Available Available CREATIVE
Device Details The devices and their respective ad environments your campaign or ad groups are targeting. N/A Available Available DEVICE_DETAILS
Geography The geographic areas your campaign or ad groups are targeting. N/A Available Available GEO
Languages The language codes and their respective supply vendors your campaign or ad groups are targeting. N/A Available Available LANGUAGE
Recency The recency groups of an individual ad group or all ad groups in your campaign. N/A Available Available RECENCY
Time and Day The time, day, and week when impressions, clicks, conversions, and other events occurred. N/A Available Available TIME_AND_DAY
Viewability The fold placements of the ads in your campaign or ad group. N/A Available Available VIEWABILITY
Weather The weather conditions grouped by temperatures your ad group or campaign is targeting. N/A Available Available WEATHER

Available metrics

TIP: To view an example of a dimension-specific report, download the campaign Creative report example.

Here's the list of metrics, in the order they appear as columns in each report, that track the performance of each dimension in your campaigns and ad groups:

Download a report

To retrieve a dimension-specific performance report, use the GraphQL API to complete the following steps:

  1. Use one of the following mutations based on the level (advertiser, campaign, ad group) of data you want to retrieve:
    • advertiserReportExecute
    • campaignReportExecute
    • adGroupReportExecute
  2. Include the following input arguments:
    • The ID of the advertiser, campaign, or ad group, depending on the mutation.
    • The ReportType value of the report you want to retrieve. For details, see Available dimensions.
  3. Include the url field that returns the URL needed to download the report.

Request example

Here's an example of downloading an Ad Format report for a specific campaign by its ID.

mutation {
  campaignReportExecute(input: { id: "CAMPAIGN_ID_PLACEHOLDER", report: AD_FORMAT }) {
    data {
      url
    }
  }
}

Response example

A successful response returns the URL to download the report.

{
  "data": {
    "url": "https://ttd-turtle.s3.amazonaws.com/uploads/529dbc15-46ca-4ba2-bf30-432529c1ce86?AWSAccessKeyId=AKIAQBVJTGNIFFVUCISM&Expires=1718652962&Signature=joga281PscvA1%2FVJtXHeOqpkztI%3D"
  }
}

FAQs

How often is the data refreshed for these reports?

The data or metrics in each dimension-specific report are updated daily.

Are dimension-specific reports part of My Reports?

No, dimension-specific reports are predefined and available immediately. In contrast, My Reports allows you to customize reports, but you can only retrieve them by scheduling them. For solution comparison, see the Getting Started with Reporting Solutions page.

Do I need to create a report schedule to download these performance reports?

No, you can download these reports on demand without scheduling.

Can I change the metrics in the report before I download it?

No, you cannot change the metrics before you download the report, however, after you download the report, you can toggle to view more metrics in the Pivot Table of the report.

Can I download reports from a different bucket other than Amazon S3?

Yes, you can also download dimension-specific reports from Azure buckets provided in the URL.