Connector Improvement: Uniqueness of the link between keyword and label in Google Ads Account connector
PlannedThe Google Ads Account connector does not provide enough information to uniquely associate a label with a keyword.
Indeed, the Google Ads Account connector provides an ad_group_criterion_label_history table that allows to associate a keyword_id (ad_group_criterion_id) with a label_id. However, the keyword_id is not a unique id and can be confused between multiple accounts, campaigns or adgroups (https://stackoverflow.com/questions/8111884/are-adwords-keyword-adgroup-campaign-ids-unique-across-multiple-accounts).
In this way, in case one would like to access the performance of keywords with a certain label, the performances are biased because all keywords with the same id are considered.
A solution to this problem would be to add one or more columns to the ad_group_criterion_label_history table such as adgroup_id or campaign_id.
Could an enhancement be implemented ?
Thank you !
-
Official comment
Hi Aymeric, Drew from the Product Team here!
Thanks for this insight. I'm sharing this with engineering to do additional research into the data issue here. Since this looks like a potential data integrity issue we'll take a look at it and prioritize accordingly.
Please sign in to leave a comment.
Comments
1 comment