Read Sponsored Products report (beta API)

Generate and retrieve a Sponsored Products report using the newer reporting API. Specify the report name, report type (e.g. campaigns), and basic configuration.

SELECT * FROM get_beta_report
WITH(
  ReportName='Test Name',
  ReportType='spCampaigns',
  TimeUnit='SUMMARY',
  GroupByCampaignReportType='campaign',
  GroupByCampaignMetrics='impressions,clicks,cost'
)