Reduce time fetch campaign

25 views
Skip to first unread message

Nguyen Vien

unread,
Feb 27, 2024, 3:25:51 AM2/27/24
to Google Ads API and AdWords API Forum
I am fetching campaign data through google-ads-python with search_stream, And I have the following query: 
SELECT campaign.name,
campaign_budget.amount_micros,
campaign.status,
metrics.cost_micros
FROM campaign
WHERE
segments.date DURING LAST_7_DAYS
ORDER BY
metrics.cost_micros DESC

It will fetch campaigns meeting with condition in where clause. It will have campaign with all statuses of campaign. If I add more one condition to where clause to just fetch campaign with status enabled and paused (AND campaign.status IN ('ENABLED', 'PAUSED')), that will reduce time fetch campaign instead of fetching campaigns from all statues ? Thanks
Reply all
Reply to author
Forward
0 new messages