Best Practices

This article describes best practices for generating reports using the DSP Reporting API.

Time Series Report

Size

Normal

Description

dimensionTypeIds is an empty array. The number of report rows is determined by the time interval and normal granularity.

{
  "reportOption": {
    "dimensionTypeIds": [],
    "metricTypeIds": [ 44, 1, 2 ],
    ...
  }
}

Group By Report

Size

Huge

Description

dimensionTypeIds array has 1 or more values. Report row count is the product of cardinality of each dimension and time-axis. This would create a large report.

Top N Report

Size

Normal

Description

dimensionTypeIds array has only 1 value and there is limitSpec. The report size is the specified limit multiplied by size of time-axis. The example generates a report of Top 10 cities of Ad spending for some time period.

{
  "dimensionTypeIds": [21],
  "limitSpec": {
    "columns": [
      {
        "metricTypeId": 44
      }
    ],
    "limit": 10,
  }
}