Google Ads Beta Api Query

[rentca...@gmail.com]

Hello,

I'm trying to mimic the CLICK_PERFORMANCE_REPORT using the new api.

Below is the CLICK_PERFORMANCE_REPORT I'm using.
Select GclId, CampaignId, CreativeId, CriteriaId, AdGroupId, Device, AdNetworkType1, Date
from CLICK_PERFORMANCE_REPORT
during 20181210, 20181210

Below is what I have so far for the new api query
Select campaign.id, ad_group_id, ad_group_ad_ad.id, device, ad_group_criterion.keyword.text(this may only work with ad_group), ad_network_type, date
from ad_group_ad
where date = ‘2018-12-10’

Will the query above get me the desired results?
Do you have a mapping document from CLICK_PERFORMANCE_REPORT (or any report) to the Google Ads API fields?
How can I get the GclId using Google Ads API fields?
Is there an interface available I can use similar to AWQL.me where I can test my queries?

KDJ

[Luis Xander Talag (AdWords API Team)]

Hi,

I'm afraid, you cannot mimic the Click Performance Report from Google Ads API Beta as the GCLID field is currently not yet available in Ads API Beta. All the listed fields on this guide are currently the only available fields that you could get in a report. There is currently no field mapping from old and new API. Also, there is no interface available where you could run your query. However, you may try your query by downloading and using one of our client libraries.

For any updates on new features on Google Ads API Beta, you may follow our blog.

Thanks and regards,

Luis

AdWords API Team