Wait... Why is it only returning these campaign types? ['PERFORMANCE_MAX', 'SEARCH', 'DISPLAY', 'VIDEO']
Maybe that is my issue... The GCLIDs I'm looking for wouldn't be under those. Why isn't it returning all campaign types that got clicks? I expect there to be `APP` in there as well. On Tuesday, May 16, 2023 at 2:15:33 PM UTC-7 Chad Wood wrote: > I should say, the end goal is that I can query the CLICK_VIEW for a > specific GCLID & Date combo, and it'll respond with that click's campaign > info (for attribution internally). > > On Tuesday, May 16, 2023 at 2:10:51 PM UTC-7 Chad Wood wrote: > >> Hello, >> >> I am trying to attribute clicks to conversions. >> I utilize this resource: >> https://developers.google.com/google-ads/api/fields/v13/click_view >> >> I have some GCLIDs that are for auditing / testing. These are created the >> same way as any other GCLID, by clicking an ad. I have the date that these >> clicks occurred and the GCLID. When I query the CLICK_VIEW resource for any >> of the GCLIDs, there are no matches. I get zero results. >> >> See my Query: >> Query 1: >> SELECT >> customer.id, >> segments.date, >> ad_group.type, >> click_view.gclid, >> campaign.resource_name, >> ad_group.resource_name, >> click_view.ad_group_ad, >> metrics.clicks >> FROM click_view >> WHERE >> segments.date = '2023-05-15' >> AND click_view.gclid = 'some_id_goes_here' >> >> So I had a different idea. I instead queried for all clicks to have >> occurred on the given date. I got tens of thousands of records back. See my >> query: >> Query 2: >> SELECT >> customer.id, >> segments.date, >> ad_group.type, >> click_view.gclid, >> campaign.resource_name, >> ad_group.resource_name, >> click_view.ad_group_ad, >> metrics.clicks >> FROM click_view >> WHERE >> segments.date = '2023-05-15' >> >> Then I checked against all those records, and my GCLIDs aren't in there. >> So after that, I tried querying for 10 entire days of clicks, one day at >> a time (as required). 5 days before the click occurred up to 5 days after, >> so surely the matching click must be returned, right? I combined all >> records, and sure enough theres no matches with the GCLIDs I have. >> >> I thought this was weird, so I compared likeness of the IDs my query >> returned with the IDs I have on record. What I found is that several of the >> IDs you delivered start the exact same as my IDs, up to the 28th character. >> This tells me that these IDs are related, and helps me confirm that I'm not >> working with the wrong ID here. >> >> So what gives. Why can't I match GCLIDs to perform attribution? It's as >> if the server returns everything except the GCLID I really want. >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/561123bd-fe7d-4b26-b840-37c2b09f8749n%40googlegroups.com.
