Issue with Extracting PAUSED Data from Google Ads API Using Location View Resource

[digitalreachpremium premium]

Dear Google Ads Team,

I am writing to seek your assistance with an issue I am facing while trying to extract PAUSED data from Google Ads using the API call. Specifically, I am working with the "location view" resource and using the following query:

SELECT campaign_criterion.location.geo_target_constant,
       campaign.id,
       campaign.name,
       campaign.status,
       campaign_criterion.bid_modifier,
       metrics.clicks,
       metrics.impressions,
       metrics.ctr,
       metrics.average_cpc,
       metrics.cost_micros,

       segments.date
FROM location_view
WHERE campaign.status != 'REMOVED'
AND segments.date BETWEEN '2024-02-10' AND '2024-04-30';

However, I am only able to pull data for "ENABLED" campaigns and not for campaigns with a "PAUSED" status when using this query. If I remove segement date column, I am able to retrieve data for PAUSED campaigns.

Could you please provide guidance on how I can modify my query to pull PAUSED data while maintaining segemnts  date in the query? Any insights or solutions you can offer would be greatly appreciated.

[Google Ads API Forum Advisor]

Hi,

Thank you for contacting the Google Ads API support team.

I notice that you've already raised this concern in another thread titled 'Unable to extract PAUSED Data from Google Ads using API call'. We've already provided a response there regarding this issue. To streamline communication and avoid redundancy, please refer back to that thread for any updates or further discussions on this topic. ​ ​ 
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tIs2Z:ref" (ADR-00233547)

Thanks,
 

Google Ads API Team