ImpressionReach/ UniqueCookies returning "--" for segment by day, all time data, shows correct value in the UI

137 views
Skip to first unread message

Suchit Puri

unread,
Mar 26, 2016, 2:53:23 PM3/26/16
to AdWords API Forum
Hi ,

We are using the adwords api version 509 to fetch the impressionReach / UniqueCookies to show the unique users who saw the campaign. The problem is that the adwords UI is giving us the exact values but the CSV report/ API is giving US "--" when we fetch the all Time report as well as segment by day data.

Can you guys tell whats happening here, is this a bug in the api ?


Another question is that for some data points it returns < 100 but in total it computes the correct total, so how should we compute the daily sum of < 100 data points on our end ?

Cheers
Suchit

Yin Niu

unread,
Mar 28, 2016, 9:53:25 AM3/28/16
to AdWords API Forum
Hi Suchit, 

Could you please send the report definition and the reports to show the difference between API and UI? 

For the data points that return <100, which field are you referring to? 

Thanks,
Yin, AdWords API Team. 

Suchit Puri

unread,
Mar 29, 2016, 4:16:51 AM3/29/16
to AdWords API Forum

Hi Yin,

Pasting the UI and report screenshots here.

if you see in the below screenshots you will see that the UI is getting the data for "UniqueCookies: column for last 14 days, i have added a segment by day.



Now  when i download the all time report segmented by day for the same campaign from the UI or API i get the attached CSV. If you look in the CSV you will see that all the UniqueCookies, attribute values are "--" instead of actual values.




Please let me know if you need any other data points.

Thanks
Suchit
Campaign report (13).csv

Yin Niu

unread,
Mar 29, 2016, 9:37:07 AM3/29/16
to AdWords API Forum
Hi Suchit, 

Could you please send me the report definition and the clientCustomerID? I am not able to find "Interaction Types" field in Campaign Performance Report fields list. 

For impressionReach, "<100" is special value when the number of cookes is less than 100. Notice that ImpressionReach field is not compatible with ClickType. 
Message has been deleted
Message has been deleted

Suchit Puri

unread,
Mar 30, 2016, 8:05:57 AM3/30/16
to AdWords API Forum
Hi Yi,
I have sent you the report definition in private reply.

The question still remains the same. The ImpressionReach is coming as '--" when you pull a simple reports from the UI or pull it from the API. But the UI shows correct values.
 

Regards
Suchit Puri

Nadine Sundquist (AdWords API Team)

unread,
Mar 30, 2016, 4:21:48 PM3/30/16
to AdWords API Forum
Hi Suchit,

Thanks for providing the screenshots and the report. I noticed that in the AdWords user interface you chose last 14 days, while in the API you chose ALL_TIME. If you change your choice in the AdWords user interface to be All Time, you'll notice that you now get back '--' for everything, which matches your API request. When you choose All time for any request to AdWords, some fields will not be calculated for various reasons such as processing time to calculate the request. You could also change your API request to say LAST_14_DAYS to match your AdWords user interface request. When you do that in your API request, you'll start getting back numbers just like in the AdWords user interface.

Cheers,
Nadine, AdWords API Team 

Suchit Puri

unread,
Mar 31, 2016, 1:18:26 AM3/31/16
to 'Nadine Sundquist (AdWords API Team)' via AdWords API Forum, adwordsapiad...@google.com
Hi Nadine,

Thanks for the answer, so we have an analytics tool which is importing day wise data for the client from adwords api. Now when the client connects is account for the first time we import "all time" data segmented by day for him , and there we get “—“ for unique cookies.

Now once the we get the all time daily data we just fetch only the current day data, which seems to work fine.

Now are you suggesting that All Time segment by day will now show the correct “UniqueCookies/ImpressionReach” and we should fetch only 14 days of data ?


Thanks
Suchit Puri


--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api...@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/dd7eeb8f-c375-401b-8468-868dd0db990f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Nadine Sundquist (AdWords API Team)

unread,
Mar 31, 2016, 9:36:55 AM3/31/16
to AdWords API Forum, adwordsapiad...@google.com
Hello Suchit,

That does make sense that you would retrieve that information for all time when someone is connecting for the first time. Yes, some data such as "Unique Cookies/Impression Reach" will not be calculated when you choose All time. That is the case for both our user interface and the API. I only suggested 14 days because your screenshot showed 14 days. I checked your account, and that account has data from January 1st of this year to present for that particular field.

Best,
Nadine, AdWords API Team

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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.

Suchit Puri

unread,
Apr 3, 2016, 2:39:35 PM4/3/16
to Nadine Sundquist, AdWords API Forum
Hi Nadine,

So the use case is that the client comes in to Adalyz, he links his adwords account. He then all the analysis, historic and present for his campaigns. Now since its the first time we are fetching the data for him , we fetch the daily data for all time.

Since the Adwords UI shows the unique cookies values, we also need to show it in our tool. Now as you said if we fetch the all time daily data for ImpressionReach/UniqueCookies then we dont get any values. But if we fetch for smaller intervals we might get some values. I will try breaking calls to smaller interval.

Now another problem is that suppose we get UniqueCookies for days as < 100 , how do we compute the total unique cookies for that time interval.

Day 1- Unique Cookies = 20
Day 2- Unique Cookies = < 100
Day 3 Unique Cookies = 30
Day 4 Unique Cookies = 30
Day 5 Unique Cookies = 50

now when show the aggregated values  = day 1 to day 5 = 20 + < 100 + 30  + 30 + 30 + 50 = ?


Regards
Suchit


Hi Nadine,

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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api...@googlegroups.com.

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to

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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/e8647b89-84bf-4892-9f0e-58f98cfb8fba%40googlegroups.com.

Nadine Sundquist (AdWords API Team)

unread,
Apr 4, 2016, 9:50:56 AM4/4/16
to AdWords API Forum, adwordsapiad...@google.com
Hi Suchit,

Have you tried picking All time in the AdWords user interface? It won't give you any values, either. So, if you do All time for the user using the AdWords API, it won't be any different than the AdWords user interface. That should at least set an expectation for the users of your tool that what you are displaying and what they are seeing through the AdWords user interface is the same.

As for breaking down the calls into smaller intervals, that's a cool, creative solution to your problem. Unfortunately, there isn't an easy way of knowing what <100 is if you're trying to add up all of the days. There's an AdWords Help Center article that has an explanation on how the reach is calculated. You may be able to take advantage of the mathematical explanation. Check it out here.

Hoping that helps,
Nadine, AdWords API Team
Hi Nadine,

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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to

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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages