I've found that any query doesn't return data for paused campaigns. It's as if they don't exist. If I use CUSTOMER, I get the correct total cost across campaigns. However, if I use CAMPAIGN or another table, the paused campaigns are not present in the results, whereas the active campaigns are. I am using my MCC account linked to a client's MCC account (which contains all the campaigns).
Il giorno giovedì 4 aprile 2024 alle 12:46:23 UTC+2 Google Ads API Forum Advisor ha scritto: > Hi, > > Thank you for reaching out to the Google Ads API support team. > > You can use the below query to fetch the campaigns that are 'PAUSED' from > the user_location_view report. > > - SELECT campaign.status, segments.date, campaign.name, > metrics.cost_micros, user_location_view.country_criterion_id, > metrics.conversions, metrics.impressions, metrics.clicks, > metrics.conversions_value FROM user_location_view WHERE campaign.status = > 'PAUSED' AND segments.date >= '2024-04-01' AND segments.date <= > '2024-04-02' > > Make sure that the data for PAUSED campaigns is actually available in the > report that you are trying to fetch via the Ads API. > > I hope this helps. > > > This message is in relation to case > "ref:!00D1U01174p.!5004Q02tOqeS:ref" (ADR-00229850) > > Thanks, > > [image: Google Logo] Google Ads API Team > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/b56bdc17-98ce-4a5e-93fe-b77af73f0d73n%40googlegroups.com.