Unable to extract PAUSED Data from Google Ads using API call

[digitalreachpremium premium]

Hi

I am writing to seek your assistance with an issue I am experiencing when trying to extract data using the Google Ads API. Specifically, I am unable to retrieve data for campaigns or ad groups that are in the PAUSED status.

I am using the API call [describe your API call] to fetch data from my Google Ads account. While I am able to successfully retrieve data for active campaigns and ad groups, I am unable to access data for those that have been paused. This is causing a significant gap in our reporting and analysis processes.

Could you please provide guidance on how to properly configure the API call to include PAUSED data in the results? Any information on potential adjustments I may need to make would be greatly appreciated.

Thank you for your attention to this matter. I look forward to your prompt response.


Thanks and Regards
Digital reach premium

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Note that you can fetch the campaigns and ad groups that are in PAUSED status via the Google Ads API. Kindly refer to the below queries.

Query to fetch the campaigns in PAUSED status:

SELECT campaign.name, campaign.id, campaign.status FROM campaign WHERE campaign.status = 'PAUSED'

Query to fetch the ad groups in PAUSED status:

SELECT ad_group.campaign, ad_group.name, ad_group.id, ad_group.status FROM ad_group WHERE ad_group.status = 'PAUSED'

I hope this helps.

 

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

Thanks,
 

Google Ads API Team

[digitalreachpremium premium]

hi 

i need segment date according with this, while am adding segment date only "ENABLED" status data can be pull from the backend

[Google Ads API Forum Advisor]

Hi,

In order to replicate the issue from our end, kindly provide us with the complete API logs (request and response with request-id and request header) generated at your end so that we can verify why you are getting an status as 'ENABLED'.

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.

[digitalreachpremium premium]

Dear Google Ads Team,

I hope this email finds you well. I am reaching out to seek your assistance regarding a query I am working on within my organization. The goal is to extract data for campaigns with a status of "PAUSED" while utilizing the segment resource in my query.

Given the sensitivity of our organization's data and policies, I am unable to provide my logs for reference. Here is the query I am currently using

i will paste my sql query here

SELECT
    campaign_criterion.location.geo_target_constant,
    campaign.id,
    campaign.name,
    campaign_criterion.status,
    campaign_criterion.bid_modifier,
    metrics.clicks,
    metrics.impressions,
    metrics.ctr,
    metrics.average_cpc,
    metrics.cost_micros,
    segments.date
FROM
    location_view
WHERE
    campaign_criterion.status != 'REMOVED'

Please go through it and give me a solution

[Google Ads API Forum Advisor]

Hi,

To extract campaign data with "PAUSED" status by using segments. Kindly refer to the below sample query:

{

  "query": "SELECT campaign.id, campaign.name, segments.date, campaign.status, metrics.impressions 
FROM campaign WHERE campaign.status = 'PAUSED' and segments.date between '2024-02-10' and '2024-04-30'"

}

I have tried the above query from my end and I am able to get the PAUSED status for a campaign.

You can try making a request using the Method: customers.googleAds.search and Method: customers.googleAds.searchStream. Also, you can use Query Builder to create your query and Query Validator to validate your query.

Kindly note that to get the paused status you need to add campaign.status in place campaign_criterion.status.

[Google Ads API Forum Advisor]

Hi,

In order to replicate the issue at our end, kindly provide the customer ID.

[digitalreachpremium premium]

hi

i cant't provide   customer ID , because i am working in a in as organization, my question is here am using " location_view" resource ,but here unable to pull "PAUSED" data according with segemnt date,

please go though my query

comapains_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 FROM location_view WHERE campaign.status != 'REMOVED' and segments.date between '2024-02-10' and '2024-04-30'"

if i remove  segments.date i call pull "PAUSED" data, please provide a solution for this

[Google Ads API Forum Advisor]

Hi,

I have replicated your issue and I am able to get the 'paused' data while including the segments.date for "resourceName": "customers/5882499660/campaigns/21084946503". Please see the below sample logs for information: 

"query": "SELECT campaign_criterion.location.geo_target_constant, campaign.id, campaign.name, campaign_criterion.status, 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-04-02' AND '2024-05-01'"


{
      "campaign": {
        "resourceName": "customers/5882499660/campaigns/21084946503",
        "status": "PAUSED",
        "name": "E_Kin_TVS_Raider_Brand_DemandGen_Mah_Jhar_Mar24",
        "id": "21084946503"
      },

You can try making a request using this endpoints Method: customers.googleAds.search or Method: customers.googleAds.searchStream by passing the customer Id.

[digitalreachpremium premium]

hi

i have checked the same resource name in my query , but is campaign status is "2" , it means "ENABLED", what are the possible reason for this?

also please remove the above comment  from this

[Google Ads API Forum Advisor]

Hi,

After checking the .csv file you have provided, I would like to inform you that the campaign 'E_Kin_TVS_Raider_Brand_DemandGen_Mah_Jhar_Mar24' has campaign_criterian_status value is 2 and campaign_status value is 3 which indicates as 'PAUSED' status.