Read Sponsored Products report (legacy API)

Request and read a Sponsored Products performance report. Choose the report type (e.g. keywords), report date, and the metrics you want.

SELECT * FROM get_report
WITH(
  RecordType='keywords',
  ReportDate='<<today-1d,FUN_TO_DATE>>',
  Metrics='impressions,clicks,cost'
)