Campaign report is missing all the campaigns associated with an account

[Poojitha Gandra]

Hi Team,

We are not receiving any campaign data for the below account even though we have a lot of active campaign's running for this account

login_customer_id=8631872757

account: 4000923014

RequestId: i00m1E6delT8zFOhlPJ6Sg

Logs:

[2023-02-14 16:48:44,484] {bash_operator.py:157} INFO - {"asctime": "2023-02-14 16:48:44,482", "exc_info": null, "funcName": "log_successful_request", "levelname": "INFO", "lineno": 230, "message": "Request made: ClientCustomerId: 4000923014, Host: googleads.googleapis.com, Method: /google.ads.googleads.v12.services.GoogleAdsService/SearchStream, RequestId: i00m1E6delT8zFOhlPJ6Sg, IsFault: False, FaultMessage: None", "pathname": "/Users/poojithagandra/.pex/nerdwallet/delphi/1.2.2970/installed_wheels/c022af0e91f4bbc204999e98f2ec1a43e3458df0e0e34932e241bd4573c6b7f9/google_ads-19.0.0-py3-none-any.whl/google/ads/googleads/interceptors/logging_interceptor.py", "name": "google.ads.googleads.client", "process": 80695, "processName": "MainProcess", "tags": {}, "thread": 140704604952768, "threadName": "MainThread"}

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/GnZgrGohFis) from the forum as it wasn't routed to our support queue.

Regards,
Carmela

Google Ads API Team

[Google Ads API and AdWords API Forum]

Hi,

Thank you for posting your concern.

Regarding your concern, you mentioned that you are not receiving any campaign data even though you have a lot of active campaigns running for this account. Having said that, can you please provide the uncropped Google Ads UI screenshot showing the campaigns data and the complete request and response logs with request ID and request header generated on your end so our team can provide guidance accordingly? 

You may then send the requested logs via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Carmela

Google Ads API Team

On Wednesday, February 15, 2023 at 9:00:09 AM UTC+8 pga...@nerdwallet.com wrote:

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/GnZgrGohFis) from the forum as it wasn't routed to our support queue.

Regards,
Carmela

Google Ads API Team

On Wednesday, February 22, 2023 at 12:40:54 AM UTC+8 pga...@nerdwallet.com wrote:

Thanks for your response and please find the below:

1. Screenshot of UI is attached

2.  Request:

[2023-02-21 08:38:23,134 - DEBUG] Request
-------
Method: /google.ads.googleads.v12.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
  "developer-token": "REDACTED",
  "login-customer-id": "8631872757",
  "x-goog-api-client": "gl-python/3.7.15 grpc/1.51.1 gax/2.10.1 gccl/19.0.0 pb/4.21.10",
  "x-goog-request-params": "customer_id=4000923014"
}
Request: customer_id: "4000923014"
query: "select campaign.id,segments.date, campaign.name, customer.descriptive_name, campaign.status,customer.currency_code, customer.descriptive_name,customer.time_zone,metrics.active_view_measurability,campaign.serving_status, segments.ad_network_type, segments.ad_network_type, bidding_strategy.name,campaign.bidding_strategy,campaign.bidding_strategy_type,segments.device,campaign.manual_cpc.enhanced_cpc_enabled, customer.id, campaign.url_custom_parameters, campaign.start_date,campaign.end_date, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign.campaign_budget from campaign WHERE  segments.date = \'2023-02-12\'"

3. Response:

Response
-------
Headers: {
  "request-id": "b2ViEddhCrdCt8Efmddi8Q"
}
Response: None

[2023-02-21 08:38:23,134 - INFO] Request made: ClientCustomerId: 4000923014, Host: googleads.googleapis.com, Method: /google.ads.googleads.v12.services.GoogleAdsService/SearchStream, RequestId: b2ViEddhCrdCt8Efmddi8Q, IsFault: False, FaultMessage: None

columns not received ['campaign.id', 'segments.date', 'campaign.name', 'customer.descriptive_name', 'campaign.status', 'customer.currency_code', 'customer.time_zone', 'metrics.active_view_measurability', 'campaign.serving_status', 'segments.ad_network_type', 'bidding_strategy.name', 'campaign.bidding_strategy', 'campaign.bidding_strategy_type', 'segments.device', 'campaign.manual_cpc.enhanced_cpc_enabled', 'customer.id', 'slot', 'campaign.url_custom_parameters', 'campaign.start_date', 'campaign.end_date', 'campaign.advertising_channel_sub_type', 'campaign.advertising_channel_type', 'campaign.campaign_budget']

[Google Ads API and AdWords API Forum]

Hi,

Thank you for getting back to our team. Please be informed that I will have to delete your recent post as it contains the logs and UI screenshot.

Regarding your issue, first, I noticed that the date range in your API request is 02-12-2023 while in the UI screenshot it is 02-14-2023 to 02-20-2023. Kindly note that when comparing UI and API data, the date range for both should be the same. Otherwise, you will really encounter discrepancies.

Also, I tried your request and also got empty results. So I tried removing all the segments in your query as can be seen in the below query. Upon doing so, I got the data. That said, I would suggest using the below query:

Select campaign.id, campaign.name, customer.descriptive_name, campaign.status,customer.currency_code, customer.descriptive_name,customer.time_zone,metrics.active_view_measurability,campaign.serving_status,bidding_strategy.name,campaign.bidding_strategy,campaign.bidding_strategy_type,campaign.manual_cpc.enhanced_cpc_enabled, customer.id, campaign.url_custom_parameters, campaign.start_date,campaign.end_date, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign.campaign_budget from campaign WHERE  segments.date BETWEEN '2023-02-14' AND '2023-02-20'

Furthermore, to conclude, this is because of the Segmentation effect whereas when adding some segments, the metrics in the summary row may decrease.

Regards,

Carmela

Google Ads API Team

On Wednesday, February 22, 2023 at 12:40:54 AM UTC+8 pga...@nerdwallet.com wrote:

Thanks for your response and please find the below:

1. Screenshot of UI is attached

2.  Request:

[2023-02-21 08:38:23,134 - DEBUG] Request
-------
Method: /google.ads.googleads.v12.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
  "developer-token": "REDACTED",
  "login-customer-id": "8631872757",
  "x-goog-api-client": "gl-python/3.7.15 grpc/1.51.1 gax/2.10.1 gccl/19.0.0 pb/4.21.10",
  "x-goog-request-params": "customer_id=4000923014"
}
Request: customer_id: "4000923014"
query: "select campaign.id,segments.date, campaign.name, customer.descriptive_name, campaign.status,customer.currency_code, customer.descriptive_name,customer.time_zone,metrics.active_view_measurability,campaign.serving_status, segments.ad_network_type, segments.ad_network_type, bidding_strategy.name,campaign.bidding_strategy,campaign.bidding_strategy_type,segments.device,campaign.manual_cpc.enhanced_cpc_enabled, customer.id, campaign.url_custom_parameters, campaign.start_date,campaign.end_date, campaign.advertising_channel_sub_type, campaign.advertising_channel_type, campaign.campaign_budget from campaign WHERE  segments.date = \'2023-02-12\'"

3. Response:

Response
-------
Headers: {
  "request-id": "b2ViEddhCrdCt8Efmddi8Q"
}
Response: None

[2023-02-21 08:38:23,134 - INFO] Request made: ClientCustomerId: 4000923014, Host: googleads.googleapis.com, Method: /google.ads.googleads.v12.services.GoogleAdsService/SearchStream, RequestId: b2ViEddhCrdCt8Efmddi8Q, IsFault: False, FaultMessage: None

columns not received ['campaign.id', 'segments.date', 'campaign.name', 'customer.descriptive_name', 'campaign.status', 'customer.currency_code', 'customer.time_zone', 'metrics.active_view_measurability', 'campaign.serving_status', 'segments.ad_network_type', 'bidding_strategy.name', 'campaign.bidding_strategy', 'campaign.bidding_strategy_type', 'segments.device', 'campaign.manual_cpc.enhanced_cpc_enabled', 'customer.id', 'slot', 'campaign.url_custom_parameters', 'campaign.start_date', 'campaign.end_date', 'campaign.advertising_channel_sub_type', 'campaign.advertising_channel_type', 'campaign.campaign_budget']

On Wednesday, February 15, 2023 at 8:51:03 AM UTC-8 Google Ads API and AdWords API Forum wrote:

[Poojitha Gandra]

Thank you very much Carmela.

 I will validate and try the query from my side and reach back again.  

Is there a reason why only this affects one account but not others?  And also this has been going on since only the beginning of January and not before. 

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/GnZgrGohFis) from the forum as it wasn't routed to our support queue.

Regards,
Carmela

Google Ads API Team

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us. I hope that you are doing well today.

Moving forward to your concern, there could be a lot of reasons why it happens only to a single account and it is also depends on the data of the account has. However, if you are using other accounts with the same query, could you please provide us the complete request and response logs with request ID and request header generated on your end using another customer id which is able to fetch a report with the same query you used?

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Kind regards,

Sherwin Vincent Google Ads API Team

ref:_00D1U1174p._5004Q2jFq5L:ref

[Poojitha Gandra]

Not sure if you received my previous email so sending the logs again.

Below are my logs for the accounts we have:

Thanks,

Poojitha Gandra

[Heder Dyego Santos (C)]

Hello,

There seems to be an issue with "Audience Performance" Report for account 4000923014 (NerdWallet CC).

We're not receiving many campaigns in the Audience Report, these campaigns started in 2022-09-19 and 2022-09-20.

This is the GAQL query we're using to extract them:

SELECT
  segments.date,
  customer.currency_code,
  customer.descriptive_name,
  customer.time_zone,
  ad_group.id,
  ad_group.name,
  ad_group.status,
  segments.ad_network_type,
  metrics.all_conversions_from_interactions_rate,
  metrics.all_conversions,
  metrics.all_conversions_value,
  ad_group.base_ad_group,
  campaign.base_campaign,
  bidding_strategy.id,
  bidding_strategy.name,
  bidding_strategy.type,
  campaign.id,
  campaign.name,
  campaign.status,
  metrics.clicks,
  metrics.cost_micros,
  ad_group_criterion.effective_cpm_bid_micros,
  ad_group_criterion.effective_cpm_bid_source,
  customer.descriptive_name,
  segments.device,
  customer.id,
  ad_group_criterion.final_mobile_urls,
  ad_group_criterion.final_urls,
  metrics.gmail_forwards,
  metrics.gmail_saves,
  metrics.gmail_secondary_clicks,
  metrics.impressions,
  metrics.interaction_rate,
  metrics.interactions,
  metrics.interaction_event_types,
  ad_group.targeting_setting.target_restrictions,
  ad_group_criterion.status,
  ad_group.tracking_url_template,
  ad_group.url_custom_parameters,
  metrics.value_per_all_conversions,
  metrics.value_per_conversion,
  metrics.video_view_rate,
  metrics.video_views,
  metrics.view_through_conversions,
  ad_group_criterion.bid_modifier,
  ad_group_criterion.user_list.user_list,
  ad_group_criterion.user_interest.user_interest_category,
  ad_group_criterion.custom_affinity.custom_affinity,
  ad_group_criterion.custom_intent.custom_intent,
  ad_group_criterion.criterion_id
FROM
  ad_group_audience_view

[Heder Dyego Santos (C)]

Complementing my previous message: during this same period and with the same GAQL query, we normally obtained data for these accounts: 6893877149, 2479806842, 7940469371