Skip to content
Teads Reporting API v1

Filters and formats

Configure Teads Reporting API report requests and output formats.

Required request fields

Submit these fields when you create a report. See Dimensions and Metrics for the full list of supported values.

FieldTypeRequiredDescription
dimensionsarray<string>YesDimensions to group results by.
metricsarray<string>YesMetrics to return.
filters.date.startISO 8601 timestampYesInclusive lower bound.
filters.date.endISO 8601 timestampYesInclusive upper bound.
filters.date.timezoneIANA timezoneNoTimezone used to resolve daylight-saving shifts.
emailsarray<string>NoEmail recipients. Defaults to an empty list.
formatstringNocsv, jsonv1, or xlsx; defaults to xlsx.

All filters other than date are optional. Most filters use arrays of numeric resource IDs. Status filters are an exception: they use the status value stored in the database, such as 1 for active. The formats filter uses strings such as inread.

Resource filters

FieldTypeDescription
filters.ad_sourcesarray<int>Ad source IDs, such as Google DBM ID 3.
filters.ad_statusarray<int>Ad status IDs.
filters.adsarray<int>Ad IDs.
filters.adsourcesarray<int>Connection IDs.
filters.advertisersarray<int>Advertiser IDs.
filters.creativesarray<int>Creative IDs.
filters.insertionsarray<int>Insertion IDs.
filters.insertion_statusarray<int>Insertion status IDs.
filters.packsarray<int>Pack IDs.
filters.placementsarray<int>Placement IDs.
filters.placement_statusarray<int>Placement status IDs.
filters.publishersarray<int>Publisher IDs.
filters.scenariosarray<int>Scenario IDs.
filters.websitesarray<int>Website IDs.

Text filters

FieldTypeDescription
filters.browserarray<string>Browser names, such as Chrome.
filters.connection_buy_typearray<string>Connection buy types, such as rtb.
filters.countryarray<string>ISO 3166-1 alpha-2 country codes, such as US or FR.
filters.demand_sourcearray<string>Demand type, such as direct sold or programmatic.
filters.devicearray<string>Device names, such as Desktop.
filters.formatsarray<string>Format names, such as inread.
filters.operating_systemarray<string>Operating-system names, such as Windows.
filters.tagsarray<string>Tag IDs or names as supported by the account.

Format filtering warning

Filtering by formats can produce slow or failed requests because of the amount of computation required. If a request fails or takes too long, remove the format filter and filter the returned data afterward.

Output formats

CSV

Use format: "csv" for machine consumption:

day,advertiser_billable_volume,teads_billing-usd
2020-11-23T00:00:00Etc/GMT,30622,197.68621

JSONV1

Use format: "jsonv1" for a structured response containing the request configuration, lines, and totals:

{
  "filters": {
    "placements": [17270]
  },
  "dimensions": ["day", "placement"],
  "metrics": ["placementCall", "start", "complete", "click", "impression"],
  "date": {
    "start": "2020/01/01 00:00:00 +00:00",
    "end": "2020/01/01 23:59:59 +00:00"
  },
  "lines": [["2020/01/01", "17270 - Inread", "1 000", "99", "5"]],
  "totals": ["1 000", "99", "5"]
}

XLSX

xlsx is the default format and is convenient for human review. Teads Manager users receive reports in XLSX format.