Re: CreativeApprovalStatus filtering by UNCHECKED in the AdsPerformanceReport

2012-11-21 Thread Sanjay J
Cool, thanks for looking at this David!



On Tuesday, November 20, 2012 8:29:45 AM UTC-8, David Torres wrote:
>
> Hi Sanjay,
>
> As you noticed the filtering by CreativeApprovalStatus only works on 
> certain conditions and actually not filtering the way you expect, that is 
> why I recommend you not using it.
>
> Best,
>
> - David
>
> On Friday, November 16, 2012 8:51:45 PM UTC-5, Sanjay J wrote:
>>
>> I think that CreativeApprovalStatus filtering works under certain 
>> conditions for me, and in fact have been using it for a while.  For 
>> example, the following query with CreativeApprovalStatus does produce 
>> results for me, (and the documentation for the reports says it can be 
>> filterable by this field):
>>
>> {'reportName': 'Name: AD_PERFORMANCE_REPORT', 'dateRangeType': 'TODAY', 
>> 'includeZeroImpressions': 'true', 'selector': {'predicates': [{'operator': 
>> 'IN', 'field': 'CreativeApprovalStatus', 'values': ['FAMILY_SAFE']}], 
>> 'fields': ['AdGroupId', 'AdGroupName', 'AdGroupStatus', 'AdType', 
>> 'CampaignId', 'CampaignName', 'CampaignStatus', 'Description1', 
>> 'Description2', 'DisplayUrl', 'Headline', 'Id', 'ImageAdUrl', 
>> 'ImageCreativeName', 'Status', 'Url', 'CreativeApprovalStatus']}, 
>> 'reportType': 'AD_PERFORMANCE_REPORT', 'downloadFormat': 'CSV'}
>>
>> However, as soon as I change the filter to 'APPROVED' (which seems valid 
>> according to the reports definition csv provided in the documentation, I 
>> stop getting results.  So 'FAMILY_SAFE' seems to result in 'APPROVED' 
>> creatives, and none of the other filters seem to work.  
>>
>> Thanks for looking into this!
>> Sanjay
>>
>>
>>
>> On Friday, November 16, 2012 3:44:25 PM UTC-8, David Torres wrote:
>>>
>>> Hi Sanjay,
>>>
>>> Filtering by CreativeApprovalStatus is not allowed, but I just tried a 
>>> pulling a report alike yours but with no predicate 
>>> for CreativeApprovalStatus and I got all my ads including the ones under 
>>> review. Could you check without including the predicate at all?
>>>
>>> Best,
>>>
>>> - David Torres - AdWords API Team
>>>
>>> On Monday, November 12, 2012 2:24:25 PM UTC-5, Sanjay J wrote:
>>>>
>>>> Bump. 
>>>>
>>>> I have a feeling that this may be a bug in the API, but would really 
>>>> appreciate if someone could comment/confirm.  
>>>>
>>>> Thanks!
>>>> Sanjay
>>>>
>>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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: CreativeApprovalStatus filtering by UNCHECKED in the AdsPerformanceReport

2012-11-16 Thread Sanjay J
I think that CreativeApprovalStatus filtering works under certain 
conditions for me, and in fact have been using it for a while.  For 
example, the following query with CreativeApprovalStatus does produce 
results for me, (and the documentation for the reports says it can be 
filterable by this field):

{'reportName': 'Name: AD_PERFORMANCE_REPORT', 'dateRangeType': 'TODAY', 
'includeZeroImpressions': 'true', 'selector': {'predicates': [{'operator': 
'IN', 'field': 'CreativeApprovalStatus', 'values': ['FAMILY_SAFE']}], 
'fields': ['AdGroupId', 'AdGroupName', 'AdGroupStatus', 'AdType', 
'CampaignId', 'CampaignName', 'CampaignStatus', 'Description1', 
'Description2', 'DisplayUrl', 'Headline', 'Id', 'ImageAdUrl', 
'ImageCreativeName', 'Status', 'Url', 'CreativeApprovalStatus']}, 
'reportType': 'AD_PERFORMANCE_REPORT', 'downloadFormat': 'CSV'}

However, as soon as I change the filter to 'APPROVED' (which seems valid 
according to the reports definition csv provided in the documentation, I 
stop getting results.  So 'FAMILY_SAFE' seems to result in 'APPROVED' 
creatives, and none of the other filters seem to work.  

Thanks for looking into this!
Sanjay



On Friday, November 16, 2012 3:44:25 PM UTC-8, David Torres wrote:
>
> Hi Sanjay,
>
> Filtering by CreativeApprovalStatus is not allowed, but I just tried a 
> pulling a report alike yours but with no predicate 
> for CreativeApprovalStatus and I got all my ads including the ones under 
> review. Could you check without including the predicate at all?
>
> Best,
>
> - David Torres - AdWords API Team
>
> On Monday, November 12, 2012 2:24:25 PM UTC-5, Sanjay J wrote:
>>
>> Bump. 
>>
>> I have a feeling that this may be a bug in the API, but would really 
>> appreciate if someone could comment/confirm.  
>>
>> Thanks!
>> Sanjay
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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: CreativeApprovalStatus filtering by UNCHECKED in the AdsPerformanceReport

2012-11-12 Thread Sanjay J
Bump. 

I have a feeling that this may be a bug in the API, but would really 
appreciate if someone could comment/confirm.  

Thanks!
Sanjay

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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


CreativeApprovalStatus filtering by UNCHECKED in the AdsPerformanceReport

2012-11-09 Thread Sanjay J
Hello,

I'm retrieving the Ads Performance Report, and filtering by the 
CreativeApprovalStatus to include 'UNCHECKED' ads (which are those in the 
pending review stage).  I've tried a few different ways to include the ads 
in the pending review state without luck.  I'm using the Python AdWords 
client and print out the operation to the download report request.  

{'reportName': 'Ads performance data', 'dateRangeType': 'TODAY', 
'includeZeroImpressions': 'true', 'selector': {'predicates': [{'operator': 
'IN', 'field': 'Status', 'values': ['ENABLED', 'PAUSED']}, {'operator': 
'IN', 'field': 'AdGroupStatus', 'values': ['ENABLED', 'PAUSED']}, 
{'operator': 'IN', 'field': 'CreativeApprovalStatus', 'values': 
['NON_FAMILY_SAFE', 'FAMILY_SAFE', 'APPROVED', 'UNCHECKED']}, {'operator': 
'IN', 'field': 'CampaignId', 'values': ['105300171', '105300291', 
'59695491', '105300411']}], 'fields': ['AdGroupId', 'AdGroupName', 
'AdGroupStatus', 'AdType', 'CampaignId', 'CampaignName', 'CampaignStatus', 
'Description1', 'Description2', 'DisplayUrl', 'Headline', 'Id', 
'ImageAdUrl', 'ImageCreativeName', 'Status', 'Url']}, 'reportType': 
'AD_PERFORMANCE_REPORT', 'downloadFormat': 'CSV'}

Please let me know if you'd like any other details.  Would really 
appreciate some help as I'm not sure what to try next.

Thanks!
Sanjay

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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