Best Practices

This section provides information on API performance for report generation time and report size (number of rows).

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,
  }
}