Re: Reource: CLICK_VIEW not delivering all clicks? Cant Attribute!

154 views
Skip to first unread message
Message has been deleted
Message has been deleted
Message has been deleted
Message has been deleted

Google Ads API and AdWords API Forum

unread,
May 18, 2023, 7:56:31 AM5/18/23
to Google Ads API and AdWords API Forum
Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/vJXE3cSiCGg)from the forum as it wasn't routed to our support queue.

Regards,
Google Ads API Team
On Wednesday, May 17, 2023 at 10:55:01 PM UTC+8 chadwo...@gmail.com wrote:
Hello, I'm still looking for a solution to this one. Why doesn't the CLICK_VIEW resource return clicks made on APP campaigns?
Am I doing something wrong?

On Tuesday, May 16, 2023 at 3:48:13 PM UTC-7 Chad Wood wrote:
Lastly, these are the GCLIDs I can not find:

['CjwKCAjwjYKjBhB5EiwAiFdSfi-Hctvg64YoaaP-RvsWar97Q8Ox_bIOy69fDy9p7e7PZjfPxk3DZRoCcDsQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfvNCKcOomKmzjZS4PFGtdveMsljDUqzRhRxGChGyAzJa09zx1DdmJRoCkq4QAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfnzYbw7W6lfmVBJQtTWeLoO5g5TUPl9eEJmu0axWWz5laFpac4aJVBoCRyIQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfmowLqPRdvRN0gBaDsnnQ9cWlHv58uThqctDl6yUCZs5hVrTifHOABoCfzwQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfsIEsjkCIvldwLHLbVwfpXdNixnrj7pZP4wxlPVKIGUSzp45gx5yRBoCXdwQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfoH9-Chwi5TGd7smBmBfGqKW_q5CDuAl3V3oYPAbKO7i3kN-Wf1wAxoCcOUQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfvLRmNApOytLm8DJ4dXI0Q4MyIEx7r1sz32shh4OvAUzo4MZkbm8XhoCZRIQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfnnmE3Px40ypvaWwyEW56m1sMYXX0IJb2wMaxuO-UifmXlKumTqbqRoCs8IQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfr3XesGH52ORzzMWW2sNAa17P5T1kdYbAUe811kbQ_9tuQ-QsFc6XRoCDJkQAvD_BwE', 'CjwKCAjw6vyiBhB_EiwAQJRopk7Y8gq0U_i1HPEaItkU97XDsX50AydOoRrCVT7o3Q588W-Ikc47PBoCYp8QAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfnH5koTLJTjSmxBqUuqPALREqqgq1mPQXIOqrTs0X-Lqh6gHQtJRjhoC5mkQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfi1xKLSRVji-Z7d6aiymD5nmif9wYZqXF48_oMz3-lXMMwZ0i2YLKBoCuAcQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfq1GxXqzXYAHAoFCQFeBenP35uE57CTCXLeQfFUl69gIh9KQaAPakxoCaLMQAvD_BwE', 'CjwKCAjw6vyiBhB_EiwAQJRoplzHemdiDzK9EtGplDzPxDtFA3KWLrRPnSe-IS0a1rC_NyX1srHPqxoCljkQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfkW8cfaP1wKIgXolshCt_bOLMXib5NTf7THuYGultBe4wRAYfaZ11RoCFcwQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfmNFfkiAU14c5-U6FEBJ6-2VF3gAcsSLtwaHyp2gNYxbrBXbk-MIRRoC8FEQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSflIbDggHy8nTyZl9ILFpKVd7mmUZhYaiiyJKMTVV3T_Z4xrVxzSSFxoC5zsQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfqbDSq8iHNY5d5U3lruxFc_45nxJHcZXCew1krypMtA1skP55PUchRoCU-8QAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfl6X1fbIQ1Quy-AMwMvLQIbmJ-DXOJAUh9mDPOfSrZpJAZZGS3p-EBoC4ooQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfu_yXf8ImFhEWFra--DuHcwq1rJIxHtuWLAWONIkedKMbyA_JL3nMBoCu5wQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfo6fu9Xi1-FEg1KczbOWfWAhQYD3fFWkJpfbfb5w-D8bESowHEZp5hoClRIQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfuQpRrpGReDzaV6hXPkHyjDHZ_y_PGcrYMXEl2FH-pD74z9h_hL5sBoCi0cQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfvhJbHY4fcjv_CDCcEvu94BLe64lraCQXKRgvEwjt6JhbczAJfxV_BoCm5UQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfnj0pNBBGAXC0U4JIBi918hHv0WxlFfgTGW1dsxOP3SLNt_P-3Ze_RoC6W0QAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfs0HWuZbJga35WjJPTld4CZiBjkVqmQck0dhK32bUtMsWDk29SEncBoCnZoQAvD_BwE', 'CjwKCAjwjYKjBhB5EiwAiFdSfqWYVvJBPW_eZYMrfichNV9Kht8JAewvKOHBZy-zJC9x_IUoyP8R0BoCw08QAvD_BwE']

On Tuesday, May 16, 2023 at 3:29:46 PM UTC-7 Chad Wood wrote:
Logs attached. It includes the request id (-AtwxqY89D7Vo1qypqAu5g).
On Tuesday, May 16, 2023 at 3:06:20 PM UTC-7 Chad Wood wrote:

Hello,

I am trying to attribute clicks to conversions.
I utilize the CLICK_VIEW resource for this.

I'm utilizing some independently verifiable GCLIDs which I've record of.
These GCLIDs are from an APP campaign and were collected on 2023-05-14.
I've attached a screenshot of my APP campaigns what were running on that day.

See my Query:
SELECT                                                   
  customer.id,                                            
  segments.date,                                        
  ad_group.type,                                        
  click_view.gclid,                                       
  campaign.resource_name,                       
  campaign.advertising_channel_type,         
  ad_group.resource_name,                        
  click_view.ad_group_ad,                           
  metrics.clicks                                           
FROM click_view                                        
WHERE                                                      
  segments.date = '2023-05-14'                     

  AND click_view.gclid = 'some_id_goes_here'

However, I never get a match. Response is always empty. 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, and all I changed was I removed `AND click_view.gclid = 'some_id_goes_here'` from the query.

However, I cross referenced the click data with my verifiable GCLIDs, and still no match. The IDs are very similar, up to the 28th character, but no actual matches between our lists.

So, I wondered by this point, is this resource even delivering `APP` campaign metrics?
I checked the resource documentation and found that it has access to `
campaign.app_campaign_setting.app_store`. This makes me think it *should* have access, or why else could we retrieve the campaign's "app_store"?

Then I checked the actual response's unique values within the `campaign.advertising_channel_type` field. It's only returning:
['PERFORMANCE_MAX', 'SEARCH', 'DISPLAY', 'VIDEO']

I'm not  sure what I'm missing here, but it seems like the CLICK_VIEW resource just isn't giving me all the clicks I queried for. Whats going on and why can't I look up GCLIDs reliably (or at all for that matter)?

Thanks







Google Ads API and AdWords API Forum

unread,
May 18, 2023, 12:41:32 PM5/18/23
to Google Ads API and AdWords API Forum
Hi,

Thank you for raising this issue to the Google Ads API support team. Please be informed that I had to delete your previous post with your complete logs for security purposes.

Regarding your concern, I've tried replicating your query and I encountered the CUSTOMER_NOT_FOUND error. That said, can you confirm if your customer id is indeed 5779999814? Also, in order for our team to better investigate this issue, can you please provide the below information?
  • Complete request and response logs with request ID and request header generated on your end with the correct customer id
  • Complete screenshots (without cropping) from the Google Ads UI showing the data

You can provide 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.

Links included in this email:
request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
request ID - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id
request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

Message has been deleted
Message has been deleted

Google Ads API Forum Advisor

unread,
May 22, 2023, 10:59:00 AM5/22/23
to chadwo...@gmail.com, adwor...@googlegroups.com

Hi Chad,

Thank you for reaching out to us.

I can see that your concern has already been raised in another thread with the same subject "CLICK_VIEW not delivering all clicks? Cant Attribute!". For this, I would suggest continuing the discussion on the one email thread you sent, for better tracking of updates.
 

This message is in relation to case "ref:_00D1U1174p._5004Q2lJV9c:ref"

Thanks,
 
Google Logo Google Ads API Team


Google Ads API Forum Advisor

unread,
May 22, 2023, 11:15:47 AM5/22/23
to chadwo...@gmail.com, adwor...@googlegroups.com

Hi,

Thank you for responding back. 

Upon checking, it appears that the attached file contains logs for the customer ID 5779999814. With this, I have tried your sample query on my end using the customer ID 577-666-9804 but there is no returned data. That said, could you provide us with the complete request and response logs with request ID and request header generated on your end for the customer ID 577-666-9804 along with the complete screenshots (without cropping) from the Google Ads UI showing the data? This is so we could have full visibility and provide more appropriate recommendations.

You can provide 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.

Additionally, please be informed that I had to delete your previous post with the complete logs attached for security purposes.

Reference Links:

This message is in relation to case "ref:_00D1U1174p._5004Q2lJVBd:ref"


Thanks,
 
Google Logo Google Ads API Team


Reply all
Reply to author
Forward
0 new messages