Keyword View Query returning Empty Results

[Aarthi Ilangovan]

Hi Team, 

I am using the below GAQL query to retrieve fields from keyword view : 

"SELECT customer.id,
                       campaign.id,
                       campaign.base_campaign,
                       ad_group.id,
                       ad_group.base_ad_group,
                       ad_group_criterion.criterion_id,
                       ad_group_criterion.approval_status,
                       ad_group_criterion.system_serving_status,
                       campaign.status,
                       ad_group.status,
                       ad_group_criterion.status,
                       segments.ad_network_type,
                       segments.device,
                       ad_group_criterion.quality_info.quality_score,
                       bidding_strategy.type,
                       ad_group_criterion.effective_cpc_bid_micros,
                       ad_group_criterion.position_estimates.first_page_cpc_micros,
                       ad_group_criterion.position_estimates.first_position_cpc_micros,
                       ad_group_criterion.position_estimates.top_of_page_cpc_micros,
                       ad_group_criterion.labels,
                       ad_group_criterion.quality_info.post_click_quality_score,
                       ad_group_criterion.quality_info.search_predicted_ctr,
                       ad_group_criterion.quality_info.creative_quality_score,
                       ad_group_criterion.position_estimates.estimated_add_clicks_at_first_position_cpc,
                       ad_group_criterion.position_estimates.estimated_add_cost_at_first_position_cpc,
                       segments.date
                    FROM keyword_view
                    Where segments.date DURING YESTERDAY "

But for whatver customer IDs I pass it is returning empty responses. I used the query validator tool and it says that it is a "valid query"

Could you please help me ! 

Thanks 

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for reaching out to our API support team and for providing these details. Upon checking your query using the query validator, it appears that the query you are using is indeed valid.

So our team can take a closer look, could you also share your complete request and response logs, and the request-id? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation.

You may then send the requested information 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.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2blY8Z:ref

[Aarthi Ilangovan]

Hi Peter, 

I have sent the logs via Reply privately to author option. Hope you received it. 

Thanks !

[Google Ads API Forum Advisor]

Hi Aarthi,

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

Can you please provide email subject you sent logs privately, so that i can further investigate the issue?

Thanks,

Nirmitabahen Gaurav Google Ads API Team

ref:_00D1U1174p._5004Q2blY8Z:ref

[Aarthi Ilangovan]

"Private message regarding: Keyword View Query returning Empty Results " - This is the one

[Aarthi Ilangovan]

Hi Team, 

Kindly let me know for any updates.

Thanks !

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for the reply.

I think you missed the email sent by my colleague Sherwin. However, allow me to reiterate the response of my colleague and you can see it below:

“Thank you for providing us the logs. We tried it on our end and we got the same result. However, if we remove the 3 segments (segments.ad_network_type, segments.device, segments.date) we will get the actual result. What we can do is to advise you to try to remove the three segments to get the result.

You may also check this segmentation guide for more information.

Please let us know if this works for you.”

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2blY8Z:ref

[Aarthi Ilangovan]

Hi, 

I tried as you have mentioned. 

But again for these accounts - 5867235702,4001598351, empty responses. 

For the other 2 accounts, many field values are missing . Some are : 

                       ad_group_criterion.position_estimates.first_page_cpc_micros,

                       ad_group_criterion.position_estimates.first_position_cpc_micros,

                       ad_group_criterion.position_estimates.top_of_page_cpc_micros,

                       ad_group_criterion.quality_info.post_click_quality_score,

                       ad_group_criterion.quality_info.search_predicted_ctr,

                       ad_group_criterion.quality_info.creative_quality_score,

                       ad_group_criterion.position_estimates.estimated_add_clicks_at_first_position_cpc,

                       ad_group_criterion.position_estimates.estimated_add_cost_at_first_position_cpc 

 

Logs : 

[2022-07-21 15:49:29,846 - INFO] Request made: ClientCustomerId: 5867235702, Host: googleads.googleapis.com, Method: /google.ads.googleads.v10.services.GoogleAdsService/SearchStream, RequestId: W9XWkb_kMnrbRRjHJvM6JQ, IsFault: False, FaultMessage: None [2022-07-21 15:49:30,712 - INFO] Request made: ClientCustomerId: 4001598351, Host: googleads.googleapis.com, Method: /google.ads.googleads.v10.services.GoogleAdsService/SearchStream, RequestId: FSAMle8jSI2EsU7ZUCfGcA, IsFault: False, FaultMessage: None [2022-07-21 15:49:39,166 - INFO] Request made: ClientCustomerId: 4999818919, Host: googleads.googleapis.com, Method: /google.ads.googleads.v10.services.GoogleAdsService/SearchStream, RequestId: dVmP0lEOXmDjIkaQDhwJyw, IsFault: False, FaultMessage: None [2022-07-21 15:49:43,345 - INFO] Request made: ClientCustomerId: 8385904859, Host: googleads.googleapis.com, Method: /google.ads.googleads.v10.services.GoogleAdsService/SearchStream, RequestId: Gc1Mh-TMGQcLxdqUWRogMQ, IsFault: False, FaultMessage: None

Seems to be a bug as I get unexpected & invalid after entering a "valid" query !!

Regards,

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for that information.

With regards to accounts - 5867235702,4001598351 that giving empty responses, you may try below GAQL on your end, and let us know if you're still seeing empty response.

SELECT customer.id, campaign.id, campaign.base_campaign, ad_group.id, ad_group.base_ad_group, ad_group_criterion.criterion_id, ad_group_criterion.approval_status, ad_group_criterion.system_serving_status, campaign.status, ad_group.status, ad_group_criterion.status, ad_group_criterion.effective_cpc_bid_micros, ad_group_criterion.position_estimates.first_page_cpc_micros, ad_group_criterion.position_estimates.first_position_cpc_micros, ad_group_criterion.position_estimates.top_of_page_cpc_micros, ad_group_criterion.labels, ad_group_criterion.quality_info.post_click_quality_score, ad_group_criterion.quality_info.search_predicted_ctr, ad_group_criterion.quality_info.creative_quality_score, ad_group_criterion.position_estimates.estimated_add_clicks_at_first_position_cpc, ad_group_criterion.position_estimates.estimated_add_cost_at_first_position_cpc, segments.date FROM keyword_view WHERE segments.date DURING YESTERDAY

For second concern for other 2 accounts, many field values are missing, could you provide us the following?

• Complete request and response logs for each account where field values are missing
• Complete Ads UI screenshot showing field values on UI

Best,

Anthony Cyril Google Ads API Team

 

 

ref:_00D1U1174p._5004Q2blY8Z:ref

[Aarthi Ilangovan]

Hi Anthony, 

I used the above query and it is working. I have figured out the problem with other 2 accounts. 

Thanks !

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for sending updates on your concern. If you have additional questions regarding the topic being discussed in this thread, feel free to send those over to our team and we would be happy to assist you further.


Cheers,