User Location View and Paused Campaigns

[Andrea Greco]

How do I retrieve campaigns that are paused from the User Location View? I used this query, but it only returns campaigns with an ACTIVE status.

QUERY:

SELECT 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 segments.date >= '2024-04-01' and segments.date <= '2024-04-02'

[Google Ads API Forum Advisor]

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,
 

Google Ads API Team

[Andrea Greco]

Hi,

I tried your query for the period from March 1, 2024, to March 2, 2024. But the query doesn't return anything. Attached, you will find a copy of the report made with Google Ads.

• 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-03-01' AND segments.date <= '2024-03-02'

[Andrea Greco]

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:

[Google Ads API Forum Advisor]

Hi,

Note that the provided screenshot doesn't have campaign information like name and status. So, in order to assist you further, kindly provide us with the uncropped UI screenshot of the report that you are trying to fetch via the API. Include all the fields and metrics that you have used in the query while generating the report in the UI. Please highlight the PAUSED campaign in the screenshot, which you are unable to fetch via the API.

Additionally, send us the complete API logs (request and response with request-id and request header) generated at your end while executing the query.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

You can send the details via Reply privately to the author option, or direct private reply to this email.