Re: Ad Performance Report missing some Enabled Ads

2012-10-25 Thread road11
A-ha! I see that now. Didn't even notice those notes in Excel when I 
downloaded the field list. 
 
Thanks, Jason.
 
Eric
 

On Wednesday, October 24, 2012 6:42:29 PM UTC-4, Jason Stedman wrote:

>
> Eric,
>
> Take a look at the specific fields you are retrieving. Certain fields will 
> prevent zero impression rows from showing up in reports.
>
> One way to get around this would be to pull all of those fields in one 
> report, then pull all the fields that do not prevent zero-impression rows 
> in another report, then just join them.
>
> The fields which prevent zero-impression rows have "Prevents 
> zero-impression rows from being returned." in the "Notes" column of the 
> tables on this page:
>
> https://developers.google.com/adwords/api/docs/appendix/reports
>
> Hope this helps!
>
> Jason
>

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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


Re: Ad Performance Report missing some Enabled Ads

2012-10-24 Thread Jason Stedman

Eric,

Take a look at the specific fields you are retrieving. Certain fields will 
prevent zero impression rows from showing up in reports.

One way to get around this would be to pull all of those fields in one 
report, then pull all the fields that do not prevent zero-impression rows 
in another report, then just join them.

The fields which prevent zero-impression rows have "Prevents 
zero-impression rows from being returned." in the "Notes" column of the 
tables on this page:

https://developers.google.com/adwords/api/docs/appendix/reports

Hope this helps!

Jason

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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


Ad Performance Report missing some Enabled Ads

2012-10-24 Thread road11
With the Adwords API (v201209 .Net), I'm doing two things...

   - bringing down all of our Campaigns, AdGroups, and Ads
   - bringing down our Ad Performance Report (include zero impressions = 
   true)

I'm putting all these into a SQL Server database with classic third normal 
form. However, I'm finding something missing...
 
When I compare the Ads brought down by the API, I compare them to the Ads 
in the Ad Performance. I'm finding that I've got some 85 ads the API says 
are ENABLED, with an AdGroup whose status is ENABLED, in a Campaign whose 
status is ACTIVE, yet those AdIds don't appear in the Ad Performance 
Report. They're missing. 
 
I'm definitely including a predicate in the report saying I want ENABLED 
ads. I can even go to the UI and find that they're definitely enabled. They 
have zero impressions, but I'm telling the Ad Performance Report to include 
those anyway, yet it's missing several. 
 
Any idea why?
 
Eric

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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