Google Ads Query Ad Schedule fetch

[beyond Clicks]

Currently my query reads as;

SELECT campaign.id, campaign.name, campaign.status, metrics.cost_micros, campaign_budget.amount_micros, metrics.search_impression_share FROM campaign WHERE campaign.serving_status = SERVING AND segments.date DURING TODAY ORDER BY campaign.id

I'm looking for whatever value will get me the ad schedule but have been totally unable to find it, does anybody know what it would be? I'm using the Google Ads API as oppose to adwords and the documentation is still lacking.

[Google Ads API Forum Advisor Prod]

Hi,

Thanks for posting your concern.

On the Google Ads API perspective, you can use the ad_schedule_view report as it summarizes the performance of campaigns by AdSchedule criteria. You can also include the queries from the provided report to the ad_schedule_view report as campaign resource is supported here.

Let me know if you have further questions.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q25YdRY:ref

[beyond Clicks]

Whenever I've attempted to add ad_schedule_view to the query I placed in my question, I get a 400 error back, the documentation doesn't clearly show how it should be formatted. .campaign.ad_schedule_view in the select doesn't work, nor does simply trying to put ad_schedule_view in the FROM clause.

Could you specify how I would add a request to ad_schedule_view within an ad words query?

[Google Ads API Forum Advisor Prod]

Hello,

Here is an example query you can use to get ad schedule data. 
SELECT
     ad_schedule_view.resource_name,
     campaign.serving_status,
     campaign.id
FROM
    ad_schedule_view
WHERE
    campaign.serving_status = 'SERVING'

You can create valid queries using the Interactive Query Builder here.

Cheers,
Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q25YdRY:ref