Well, maybe I thought too soon. I tested this theory out just to see if I can get a proof of concept working. I can't find any matches for some reason.
I got a sample GCLID (one I manually generated by clicking an ad) and queried for all GCLIDs from the day I did that. For whatever reason, the GCLID I created can't be found. Whats ever weirder is that the schema between my ID and the IDs your API sent me back are very obviously the same. My ID was 91 characters long. I did a scan to find the number of Click IDs that at least start similar to mine and here's what I found: 'C': 128176, 'Cj': 128176, 'Cjw': 58617, 'CjwK': 58617, 'CjwKC': 58617, 'CjwKCA': 58617, 'CjwKCAj': 58617, 'CjwKCAjw': 58617, 'CjwKCAjwg': 13744, 'CjwKCAjwge': 13744, 'CjwKCAjwge2': 13744, 'CjwKCAjwge2i': 13744, 'CjwKCAjwge2iB': 13744, 'CjwKCAjwge2iBh': 13744, 'CjwKCAjwge2iBhB': 13744, 'CjwKCAjwge2iBhBB': 13744, ... 'CjwKCAjwge2iBhBBEiwAfXDBRxY': 18, 'CjwKCAjwge2iBhBBEiwAfXDBRxYK': 0, Basically, up to the 27th character, my ID is consistent with several of your IDs. So why can't I find a perfect match? Its very odd. On Tuesday, May 16, 2023 at 10:30:19 AM UTC-7 Chad Wood wrote: > Hello, > > I recently learned that the Google Ads click_view > <https://developers.google.com/google-ads/api/fields/v13/click_view#click_view.user_list> > > resource contains access to campaign and ad_group attributes. Such that, > the following is a valid query: > > """ > SELECT > click_view.gclid, > campaign.id, > campaign.name, > ad_group.id, > ad_group.name, > click_view.ad_group_ad, > click_view.keyword_info.match_type, > click_view.keyword > FROM click_view > WHERE > segments.date = '2023-05-15' > AND click_view.gclid = 'some_gclid_here_mehh' > """ > > This is an amazing resource, and completely changes the game for me. I can > look up individual GCLIDs and retrieve the campaign, ad_group, ad, keyword, > and even some location data? This is an order of magnitude better than > attributing traffic with UTMs. Rather than throwing UTMs into the wild-west > that is modern day browsers and hoping for the best as visitors navigate > around, its now possible to just log the GCLID and query for the necessary > bits of data from server-side. Wow. > > My thing with this though is that the documentation DOES NOT state that > this should be possible. I check the documentation for click_view and I > don't see anything stating that it is exposed to the `campaign` and > `ad_group` attributes. So, can we be sure that this isn't some fluke? Will > this functionality eventually be removed? Or is it safe to develop on top > of this with the expectation that it's going to stick around? > > I know you can only query for one day at a time, but that also seems like > it's hardly an issue. In theory, we can pull an entire days (yesterdays) > GCLIDs every day and store the data for 7 days or so. If we get any > conversions, we can cross reference the conversion's GCLID with our 7-day > datastore of GCLIDs. Is this allowed, as far as Google is concerned? > > Thanks for answered. I'm eager to hear back. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/27713ffa-e8e4-48b0-a3f4-b3f555bf8221n%40googlegroups.com.
