Hi Dave,
Thank you for reaching out. Please find my response to your questions below:
You could use the following query:
SELECT campaign.id, metrics.cost_micros, metrics.clicks, segments.week
FROM campaign
WHERE segments.week >= ‘2020-06-15’ AND segments.week <= ‘2020-06-25’
It is suggested to query the currency_constant resource to fetch the currency constant data.
Thanks and regards,
Xiaoming, Google Ads API Team