Schema to extract search keyword attributes through API

[Atul Shukla]

I want to extract average CPC and average CPM for the search keywords through API. 

While comparing data from UI report for search keyword and data fetched through API using keyword_view schema there were no matching records found. 

Which schema should I refer to pull the average CPC and average CPM  for search  keywords through API?

[Google Ads API Forum Advisor]

Hi Atul, 

Thanks for reaching out to the Google Ads API Team. I hope you are doing well today.

I understand that you want to extract average CPC and average CPM for the search keywords through API. However, for our team to provide accurate information and recommendations on this matter, could you please  provide us with complete or uncropped screenshots from the Google Ads UI?

“Please note that Google Ads API mirrors the Google Ads UI. Meaning by using the Google Ads API, you can get and manage the data that you are seeing in the UI.”

Your response is highly appreciated. Have a great day.
 

This message is in relation to case "ref:_00D1U1174p._5004Q2m9zV1:ref"

Thanks,
 

Google Ads API Team

[Google Ads API Forum Advisor]

Hi Atul,

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

[Atul Shukla]

Hello All, 

 

I have shared the screenshot privately with the author but didn't hear anything back. 

Can you please let me know the status?

Thanks

Atul 

---

From: Google Ads API Forum Advisor <ads...@forumsupport.google>
Sent: 09 June 2023 11:23 PM
To: adwor...@googlegroups.com <adwor...@googlegroups.com>
Cc: Atul Shukla <Atul....@aplaceformom.com>
Subject: RE: schema to extract search keyword attributes through api

 

CAUTION: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

[Google Ads API Forum Advisor]

Hi Atul,

Thank you for providing the requested UI screenshot.

Regarding your concern, you mentioned that when you compare the data from the UI with the data pulled from the API, the data are not matching. Having said that, for our team to better and further investigate this issue on our end, could you please provide the uncropped/whole Google Ads UI screenshot and the complete API logs below?

• request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
• response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
• request ID - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id
• request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

Note that these logs can be requested or provided to the developer handling the Google Ads API transactions when logging of the API requests has been enabled. You may check here (https://developers.google.com/google-ads/api/docs/best-practices/logging#client_library_logging) and click your client library for the specific guideline to enable it.

For REST interface requests, you can enable logging via the curl command by using the -i flag. This will cause the tool to include HTTP response headers in the output.

In addition, I would like to specify first the following when comparing the value of the UI and API:

• Comparing the API and UI on the same level as much as possible
• The segments and fields of the API and UI should be the same
• The date range is also the same

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.

This message is in relation to case "ref:_00D1U1174p._5004Q2m9zV1:ref"