Re: Difference between conversions reported in Overview, Tools and Settings and API.

2023-01-26 Thread john wedderburn
Hi there,

Thanks for the speedy answer. Much appreciated.

Images attached, same date range, same account.

Overview (set to purchases/sales):
[image: Overview.png]

Tools and settings > conversions

[image: conversions.png]

Could this be an attribution issue? 

With regard to my 2nd question, I've observed that when I import data via 
Stitch I get a 100% match with the overview reporting from the Ads front 
end. When I use BigQuery data connector I do not. Could this be because the 
Stitch data requires me to enter an attribution window, with the default as 
30 days. When I leave it to default it matches, which makes me think that 
the difference is in attribution and that I need to code an attribution 
window in the data from BigQuery.

thanks,
John.




On Thursday, January 26, 2023 at 6:02:12 PM UTC+1 adsapi wrote:

> Hi John,
>
>
> Thanks for reaching out to the Google Ads API team. I hope you are doing 
> well today.
>
>
> With regards to your concern, to better check this issue, could you please 
> provide a full screenshot of the Google Ads UI of the data that you claim 
> is not matching? I ask this information to further investigate this issue 
> and to provide accurate specific recommendation on this.
>  
>
> Regards,
> [image: Google Logo] 
> Darwin 
> Google Ads API Team 
>   
>
>
> ref:_00D1U1174p._5004Q2iNzMm:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/8cff8727-5213-43a3-9eac-659e20cc3801n%40googlegroups.com.


RE: Difference between conversions reported in Overview, Tools and Settings and API.

2023-01-26 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
Hi John,


Thanks for reaching out to the Google Ads API team. I hope you are doing well 
today.


With regards to your concern, to better check this issue, could you please 
provide a full screenshot of the Google Ads UI of the data that you claim is 
not matching? I ask this information to further investigate this issue and to 
provide accurate specific recommendation on this.

Regards,

Darwin
Google Ads API Team
ref:_00D1U1174p._5004Q2iNzMm:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/OTWkX0RP3RB000YyKcyjxQTqayCIY0EkxnxA%40sfdc.net.


Difference between conversions reported in Overview, Tools and Settings and API.

2023-01-26 Thread john wedderburn
Hi all.

I'm using the BigQuery data transfer to pull Google Search Ads data. I'm 
then using SQL to create reporting tables which includes conversion data.

My challenge is that I cannot get a match to the conversions number, 
reported for the same account and date range, shown in the Overview of the 
Google Search Ads front end.
It's not completely off, but I expectation is that I should be able to get 
an exact match. I note that I am much closer to the figure reported in the 
tools and settings  > conversions report.

In the API I got almost a perfect match after I selected only conversions 
from Interactions rather than Impressions. 

On a daily level I get a perfect match on some days, whereas other days 
fail. I suspected that this might be something to do with cross device 
tracking, but could not see any relationship there.

So, questions:

1. What is the reason for the difference in conversions number between the 
front end Overview report and the tools and settings > conversions report? 
Is this an attribution issue?

2. Has anyone got any ideas on the filters or otherwise code I should be 
using to get a match between the API output and the overview data?

When I run it through Supermetrics I get a match between the conversions 
data and the overview - so I figure the answer must be in how the 
conversion metric needs to be filtered from the API to recreate whatever 
default the overview has.

Many thanks in advance!











-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/cdf6ac33-9496-441e-9cdb-a2ad43d8f086n%40googlegroups.com.