The CriterionId for ad performance report migration

[Hao Long]

HI Google Support Team,

This conversation is ask help for how to get CriterionId(segments.keyword.ad_group_criterion in Google Ads API) in Google Ads API.

we have Google AdWords query as below need migrate to Google Ads API:

select
Date
, CriterionId
, Id
, AdGroupId
, CampaignId
, AccountCurrencyCode
, Cost
, Clicks
, Impressions
, Device
, Interactions
, InteractionRate

from ad_performance_report

and Google Ads API query transfer as below:

select
segments.date,
segments.keyword.ad_group_criterion,
ad_group_ad.ad.id,
ad_group.id,
campaign.id,
customer.currency_code,
metrics.cost_micros,
metrics.clicks,
metrics.impressions,
segments.device,
metrics.interactions,
metrics.interaction_rate
from ad_group_ad

WHERE segments.date DURING LAST_7_DAYS

By data comparison we found  if include segments.keyword.ad_group_criterion, in select clause, it will led some records could not download. once we removed this field from select clause the data volume is very close between the data download from AdWords and Ads API.

As CriterionId is very important field we will used in downstream logic we need download this field as Google AdWords API. for my understanding field segments.keyword.ad_group_criterion should query from keyword_view? if yes could you please help guide how to map this field back to data feed download from ad_group_ad?

Thanks

Hao

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out. Can you verify that the rows that are not being included are in fact keyword criteria? This may be due to an intentional change from the AdWords API to the Ads API. The AdWords API was unintentionally exposing non-keyword criteria, which may explain the additional rows that you observed in the AdWords API. The Ads API enforces that the criterion is actually a keyword, and this logic matches the UI. Can you please also verify that the Ads API matches the Ads UI for your report?

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

 

ref:_00D1U1174p._5004Q2YpAbz:ref

[don....@gmail.com]

Hello Matt, what if Criteria Type to trigger Ad was not search keyword, but User List or Household income for example, how to get such campaigns as part of the ad_group_ad report knowing  criterion id at the same time?

Is it possible with Google Ads Api? Because we are seeing similar behavior that campaigns/ads with not search keyword criterion gets excluded from ad_group_ad report. Could you explain reasoning behind this or refer to the corresponding doc?

Thank you!

[Google Ads API Forum Advisor]

Hello,

The Ads API reports are all multi-attributional. This differs from the AdWords API which contained single attribution reports (i.e. one criterion took full credit for the impression). Hence, it is not possible to get a single criterion associated with an impression. This shift to multi-attributional reporting is discussed in the migration guide. Keyword criteria are the exception to this. 

Regards,

[don....@gmail.com]

Thank you for the reply? But does the same apply for click_view report as well?
I posted question regarding it in this thread too
https://groups.google.com/u/1/g/adwords-api/c/OjHqrlNSgks/m/c3D8zMmOBQAJ

in the click_view report you can get criteria that triggered click only if its of the type KEYWORD or USER_LIST, but why not some other too? Like for example USER_INTEREST, WEBPAGE, INCOME_RANGE etc

[Google Ads API Forum Advisor]

Hi Don,

Thank you for the reply.

I can see that this concern has already been raised to multiple threads. With this, I would suggest continuing the discussion of specific concerns to one thread only for better tracking of updates.

Moving forward, I would like to reiterate the reply of colleague and you can see it below:
"To help you in this concern, could you please provide the complete report definition in AWQL format that you have used in AdWords API to retrieve the following entities associated with the click:

AGE_RANGE

AUDIENCE
CONTENT_LABEL
CUSTOM_AFFINITY
CUSTOM_AUDIENCE
DEVICE
GENDER
INCOME_RANGE
LANGUAGE
PLACEMENT
USER_INTEREST
WEBPAGE
YOUTUBE_CHANNEL
YOUTUBE_VIDEO

It can also be helpful if you can provide a sample generated report where we can see the entities associated with the clicks."

You may send 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.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2YpAbz:ref