{
"workflowId": "my-first-workflow0001",
"sqlQuery": "SELECT advertiser, campaign, sum(total_cost) as spend, sum(impressions) as impressions, count(DISTINCT user_id) as reach FROM dsp_impressions GROUP BY advertiser, campaign"
},
"timeWindowTimeZone": "UTC",
"timeWindowType": "MOST_RECENT_WEEK"
}
curl --location -g --request POST 'https://www.amazon.com/ap/oa/amc/reporting/{{instanceId}}/workflows' \
--header 'Amazon-Advertising-API-ClientId: {{client_id}}' \
--header 'Amazon-Advertising-API-MarketplaceId: {{marketplace_id}}' \
--header 'Amazon-Advertising-API-AdvertiserId: {{advertiser_id}}' \
--header 'Authorization: Bearer {{access_token}}' \
--header 'Content-Type: application/json' \
--data-raw '{
"workflowId": "my-first-workflow0001",
"sqlQuery": "SELECT advertiser, campaign, sum(total_cost) as spend, sum(impressions) as impressions, count(DISTINCT user_id) as reach FROM dsp_impressions GROUP BY advertiser, campaign"
},
"timeWindowTimeZone": "UTC",
"timeWindowType": "MOST_RECENT_WEEK"
}'
{}