Get destination url report for only paused adgroups

2012-08-05 Thread sumit gupta 
Hi ,

I am using python client library and I am trying to get destination url 
report for only only those adgroup which are paused .I am using below code-

report_downloader = client.GetReportDownloader(
  'https://adwords.google.com', 'v201109')

  # Create report definition.
  report = {
  'reportName': 'DESTINATION_URL_REPORT',
  'dateRangeType':'YESTERDAY',
  'reportType': 'DESTINATION_URL_REPORT',
  'downloadFormat': 'CSV',
  'selector': {
  'fields': 
['AdGroupId','AdGroupStatus','EffectiveDestinationUrl','Clicks','Impressions']
  },
  # Enable to get rows with zero impressions.
  'includeZeroImpressions': 'false',

  
  
  }

this gives me destination url report for all the urls where impressions was 
not zero. I want this report only for paused adgroups.

Can anyone help??

Thanks,
Sumit

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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: Get destination url report for only paused adgroups

2012-08-05 Thread Ewan Heming 
Hi Sumit,

You just need to add a 
predicatehttps://developers.google.com/adwords/api/docs/reference/latest/ReportDefinitionService.Predicateto
 the selector to filter your report. I'm not too familiar with Python, 
but I thing the following should work:

report_downloader = client.GetReportDownloader(
  'https://adwords.google.com', 'v201109')

  # Create report definition.
  report = {
  'reportName': 'DESTINATION_URL_REPORT',
  'dateRangeType':'YESTERDAY',
  'reportType': 'DESTINATION_URL_REPORT',
  'downloadFormat': 'CSV',
  'selector': {
  'fields': 
['AdGroupId','AdGroupStatus','EffectiveDestinationUrl','Clicks','Impressions'],
  'predicates': [{
 'field': 'AdGroupStatus',
 'operator': 'EQUALS',
 'values': ['PAUSED']
  }]
  },
  # Enable to get rows with zero impressions.
  'includeZeroImpressions': 'false', 
  }

If you're feeling adventurous, you could also try out the new 
AWQLhttps://developers.google.com/adwords/api/docs/guides/awqlin the latest 
version of the API (v201206); here's an 
examplehttp://code.google.com/p/google-api-ads-ruby/source/browse/adwords_api/examples/v201206/reporting/download_criteria_report_with_awql.rb?spec=svn788ed3a1df1a04de0cad9481bdc953559135eaafr=788ed3a1df1a04de0cad9481bdc953559135eaafthat
 shows how you could go about it.

Regards,

Ewan

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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: Get destination url report for only paused adgroups

2012-08-05 Thread Ewan Heming 
Sorry, the Python AWQL example 
is: 
http://code.google.com/p/google-api-ads-python/source/browse/trunk/examples/adspygoogle/adwords/v201206/reporting/download_criteria_report_with_awql.py

On Sunday, August 5, 2012 5:52:03 PM UTC+1, Ewan Heming wrote:

 Hi Sumit,

 You just need to add a 
 predicatehttps://developers.google.com/adwords/api/docs/reference/latest/ReportDefinitionService.Predicateto
  the selector to filter your report. I'm not too familiar with Python, 
 but I thing the following should work:

 report_downloader = client.GetReportDownloader(
   'https://adwords.google.com', 'v201109')

   # Create report definition.
   report = {
   'reportName': 'DESTINATION_URL_REPORT',
   'dateRangeType':'YESTERDAY',
   'reportType': 'DESTINATION_URL_REPORT',
   'downloadFormat': 'CSV',
   'selector': {
   'fields': 
 ['AdGroupId','AdGroupStatus','EffectiveDestinationUrl','Clicks','Impressions'],
   'predicates': [{
  'field': 'AdGroupStatus',
  'operator': 'EQUALS',
  'values': ['PAUSED']
   }]
   },
   # Enable to get rows with zero impressions.
   'includeZeroImpressions': 'false', 
   }

 If you're feeling adventurous, you could also try out the new 
 AWQLhttps://developers.google.com/adwords/api/docs/guides/awqlin the latest 
 version of the API (v201206); here's an 
 examplehttp://code.google.com/p/google-api-ads-ruby/source/browse/adwords_api/examples/v201206/reporting/download_criteria_report_with_awql.rb?spec=svn788ed3a1df1a04de0cad9481bdc953559135eaafr=788ed3a1df1a04de0cad9481bdc953559135eaafthat
  shows how you could go about it.

 Regards,

 Ewan



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