Relation between click data from 'click_view' and 'ad_group_ad'.

[Suvigya Agrawal]

I am using below queries to pull 'ad_group_ad' and 'click_view' data.

Adgroup:

SELECT campaign.name, campaign.id, campaign.start_date, campaign.end_date, campaign.status, ad_group.name, ad_group.id, ad_group.status, ad_group_ad.ad.id, ad_group_ad.status, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.final_urls, metrics.impressions, metrics.clicks, metrics.ctr, metrics.cost_micros, metrics.conversions, metrics.all_conversions, metrics.average_cpc, segments.date FROM ad_group_ad WHERE segments.date>='d1' and segments.date<='d2'

Click:

SELECT click_view.ad_group_ad, click_view.gclid, click_view.keyword, click_view.keyword_info.match_type, click_view.keyword_info.text, ad_group.id, ad_group.name, ad_group.status, campaign.advertising_channel_type, campaign.end_date, campaign.id, campaign.name, campaign.start_date, campaign.status, metrics.clicks, segments.date FROM click_view WHERE segments.date='d1'

If we compare total click from both of these queries for same date range, it should match or it can be different?

Thanks.

[Google Ads API Forum Advisor]

Hi,

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

By reviewing your query, I understand that your concern is regarding the ad_group_ad and click_view. Kindly note that the ad_group_ad and click_view are different resources. The ad_group_ad query may include clicks from multiple date ranges while a click view with metrics aggregated at each click level, including both valid and invalid clicks. For non-Search campaigns, metrics.clicks represents the number of valid and invalid interactions. Queries including ClickView must have a filter limiting the results to one day and can be requested for dates back to 90 days before the time of the request. You may refer to this document to know more about click_view. Please note that clicks may be different depending on the date range and filter you are using.

Also, I would like to inform you that both the provided queries are valid. You can use Query Validator to validate your query. 

Hope this helps. Please get back to us if you have any queries.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02pWUtf:ref"

Thanks,
 

Google Ads API Team

[Princess Muyo]

Hi,

Following up to this topic, can you shed some lights on my inquiries below please:

1. I'm filtering the same date range (segment.date)  from ad_group_ad and click_view, but still gets different metrics.clicks totals. Does this has something to do with click validity? Or am I missing other filter parameters?

2. If click_view contains both valid and invalid clicks, are all ad_group_ad clicks considered valid?

3. Is there a way (a field/column perhaps) to identify if a click from click_view is valid or not?

4. Is it possible that an adgroup_id present in ad_group_ad, will not be available in click_view?

Thanks in advance!

Princess

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us..

Please find below responses for your queries:

1. I'm using the same date range on click_view and adgroup_ad, however, I'm still getting different totals on metrics.clicks. Am I missing other filter parameters, or does this have something to do with click validity on  click_view?

Different totals of metrics.clicks between click_view and adgroup_ad can arise due to several reasons:

• Click validity: click_view may include both valid and invalid clicks, whereas adgroup_ad only counts valid clicks. Invalid clicks are those that are filtered out due to factors like bot traffic, repeated clicks, or clicks from ineligible sources.
• Duplicate clicks: click_view may count a single click multiple times if it occurs across different devices or browsers. Adgroup_ad, on the other hand, deduplicates clicks to ensure accurate reporting.
• Click attribution: click_view and adgroup_ad may use different click attribution models, leading to discrepancies in click counts. For instance, click_view might attribute a click to the last ad interacted with, while adgroup_ad might attribute it to the first ad clicked.

2. If click_view contains both valid and invalid clicks, are all metrics.clicks from adgroup_ad considered valid?

Yes, all metrics.clicks from adgroup_ad are considered valid clicks. This means they have passed through Google Ads' click validation process and are deemed genuine user interactions with your ads.

3. Is there a way (a field/column perhaps) to identify if a click is valid or not?

Unfortunately, there's no direct field or column in click_view that explicitly indicates whether a click is valid or invalid.

4. Is it possible for an adgroup_ad_id to be present in  adgroup_ad, but not available in click_view  even using the same date range?

Yes, it's possible for an adgroup_ad_id to be present in adgroup_ad but not available in click_view even using the same date range. This can happen if the ad group or ad was inactive or paused during the specified date range in click_view, resulting in no clicks being recorded.

I hope this helps. Kindly get back to us if you have any further queries.

[Princess Muyo]

Hi,

Thank you so much for the information. These are really helpful.

Follow-up to item # 3, if there's no direct field/column in click_view that we can use to indicate whether a click is valid or not, is there another table o resource in the Query Builder which we can use to pull valid clicks and GCLID at the same time?

Kind regards,

Princess