Beginner needs Help with 1 Query

[Philipp Oberthür]

Hi!

i got help with 1 Query please, im absolute beginner and i got this for my Google Sheet

{"query": " SELECT campaign.name, campaign_budget.amount_micros, campaign.status, campaign.optimization_score, campaign.advertising_channel_type, metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros,metrics.conversions,campaign.bidding_strategy_type FROM campaign WHERE segments.date DURING LAST_7_DAYS AND campaign.status != 'REMOVED' " }

But actually I just need an output about the daily Google Ads cost. Best updated every second.

Is something like this possible? If so, does anyone have an idea for the code?

[Google Ads API Forum Advisor]

Hi Philipp,

Thank you for reaching out to our API support team.

You may use segments.date if you want to specify the date that you want or segments.day_of_week if you want the data for a specific day. I hope this helps.


Best,

Anthony Cyril Google Ads API Team

ref:_00D1U1174p._5004Q2dI7gS:ref