Store Visits API Report

[Alec Thomas]

Hello,

I'm trying to query the total number of store visit conversions by campaign for a day.

Currently, I'm running:

SELECT CampaignId, CampaignName, Date, AllConversionValue 

FROM CAMPAIGN_PERFORMANCE_REPORT 

WHERE ConversionTrackerId IN [239] 

DURING 20190202,20190202

and I'm getting:

"CAMPAIGN_PERFORMANCE_REPORT (Feb 2, 2019)"

Campaign ID,Campaign,Day,All conv. value

Total, --, --,0.00

We got the conversion tracker ID from here: https://developers.google.com/adwords/api/docs/reference/v201809/ConversionTrackerService.ConversionTracker#id

We have also tried to run this for Calls from Ads (179) on a campaign that we know has those conversions and have received nothing except for headers.

Is there a better way to query the data we're looking for?

Thanks,

Alec Thomas

[googleadsapi...@google.com]

Hi Alec,

A possible reason on why this is not showing in your reports is probably because the ConversionTrackerId field does not support zero impressions. Due to which you might not see the ConversionTrackerIds of accounts having zero impressions. You could use ConversionTrackerService.get() to get all the conversion trackers and can match them to the accounts for which they belongs using conversionTypeOwnerCustomerId field. Let me know if you have any further questions.

Regards,

Dannison

AdWords API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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 "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/8c7047ca-8f8d-41d0-aa7e-036c92c837bc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Carmine Pagliaro]

Hi Alec,

I have the same problem. The ConversionTRackerId changed for me, but I dont know why.

In according to Team advice I do the following.

I add ConversionTrackerId field in my select query to obtain the really ConversionTrackerId for StoreVisit, then I set the new value instead of 239 in the where condition.

Carmine

[Alec Thomas]

Hi Dannison,

Seems to me that the customer ID will be 0 for Store Visits ("0 if this is a system-defined conversion type"). Do you have a good way of identifying the id of the store visits conversion tracker without the ownerCustomerId field?

[Alec Thomas]

hi Carmine,

Thanks for the help. When you query the ConversionTrackerId in the report, how do you know which one is for Store Visits? Also, are you running the same report to get the IDs and get the conversion stats (CAMPAIGN_PERFORMANCE)?

[googleadsapi...@google.com]

Hi Alec,

Before proceeding, could you provide the clientCustomerId you used to download your Campaign Performance Report so I could better investigate the issue? You may provide them using the Reply privately to author option.

Regards,

Dannison

AdWords API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/782ab6d1-2f6b-4143-a7c7-fdb47af2dd12%40googlegroups.com.