Getting AdGroup Performance report for Custom Date - Adwords API using Python

[Varun Dhall]

Hello,

I am using standard python script to retrieve the data from my ad-words accounts.

Actually I want to fetch the data for a custom date like between '2016-06-01' to '2016-06-01' (YYYY-MM-DD)

Its really confusing and unclear how to modify this existing sample script 

# Create report definition.

  report = {

      'reportName': 'ADGROUP_PERFORMANCE_REPORT',

      'dateRangeType': 'CUSTOM_DATE',

      'reportType': 'ADGROUP_PERFORMANCE_REPORT',

      'downloadFormat': 'CSV',

      'selector': {

          'fields': ['Date', 'DayOfWeek', 'CampaignName', 'AdGroupName', 'Cost',

                     'Impressions', 'Clicks', 'AveragePosition', 'Conversions']

      }

  }

Its really great if someone can help me with proper report definition :)

Thanks!

[Umesh Dengale]

Hello,

You could use custom date range as -  'dateRange':,{'min':[startDate], 'max':[endDate]}

Refer below example code. Please check out Reporting basics guide for more details.

  report = {

      'reportName': 'ADGROUP_PERFORMANCE_REPORT',

      'dateRangeType': 'CUSTOM_DATE',

      'reportType': 'ADGROUP_PERFORMANCE_REPORT',

      'downloadFormat': 'CSV',

      'selector': {

          'fields': ['Date', 'DayOfWeek', 'CampaignName', 'AdGroupName', 'Cost',

                     'Impressions', 'Clicks', 'AveragePosition', 'Conversions'],

           'dateRange':{'min':'20160601','max':'20160601'}

      }

  }

Regards,

Umesh, AdWords API Team.

[Tushar Bhasin]

Hello, I get this error:

 'dateRange': {'min':'20170625','max':'20170625'}

                   ^

 SyntaxError: invalid syntax

Can you please explain?

[Shwetha Vastrad (AdWords API Team)]

Hi Tushar, 

Could you provide the complete report definition so I can take a look? 

Thanks,

Shwetha, AdWords API Team.

[Tushar Bhasin]

Hello Shwetha, 

Thank you for your reply, I am getting data using 'YESTERDAY' & 'TODAY' but not with custom date

Here is the definition:

report = {

        'reportName': 'CLICK_PERFORMANCE_REPORT',

        'dateRangeType': 'CUSTOM_DATE',

        'reportType': 'CLICK_PERFORMANCE_REPORT',

        'downloadFormat': 'CSV',

        'selector': {

            'fields': ['GclId', 'AccountDescriptiveName', 'CampaignId', 'CampaignName',

                       'AdGroupId', 'AdGroupName', 'CreativeId', 'CriteriaId',

                       'KeywordMatchType', 'AdNetworkType1', 'AdNetworkType2', 'Date',

                       'Device', 'Clicks', 'ClickType', 'Page', 'Slot', 'UserListId',

                       'LopCityCriteriaId', 'LopCountryCriteriaId', 'LopMostSpecificTargetId'],

            'dateRange' : {'min':'20170625','max':'20170625'}

        }

    }

Let me know 

Thanks 

[Shwetha Vastrad (AdWords API Team)]

Hi Tushar, 

I was not able to find any errors in the report definition. Since this is a syntax error and not an API error, please send me the complete code so I can take a look. 

[Tushar Bhasin]

Here is the complete code, please let me know about the problem?

def update_click_performance_report(account_name, client):

    report_downloader = client.GetReportDownloader(version='v201609')

    # Create report definition.

    report = {

        'reportName': 'CLICK_PERFORMANCE_REPORT',

        'dateRangeType': 'CUSTOM_DATE',

        'reportType': 'CLICK_PERFORMANCE_REPORT',

        'downloadFormat': 'CSV',

        'selector': {

            'fields': ['GclId', 'AccountDescriptiveName', 'CampaignId', 'CampaignName',

                       'AdGroupId', 'AdGroupName', 'CreativeId', 'CriteriaId',

                       'KeywordMatchType', 'AdNetworkType1', 'AdNetworkType2', 'Date',

                       'Device', 'Clicks', 'ClickType', 'Page', 'Slot', 'UserListId',

                       'LopCityCriteriaId', 'LopCountryCriteriaId', 'LopMostSpecificTargetId'],

            'dateRange' : {'min':'20170625','max':'20170625'}

        }

    }

    # Write report to a file

    if not os.path.exists('downloads'):

        os.makedirs('downloads')

    file = open('downloads/reports_click_performance_report.csv', 'wb')

    report_downloader.DownloadReport(

        report,

        file,

        skip_report_header=True,

        skip_column_header=True,

        skip_report_summary=True,

        include_zero_impressions=False)

    file.close()

[Shwetha Vastrad (AdWords API Team)]

Hi Tushar, 

I was able to download a report using the above code snippet. I would suggest that you post your question on the Python client library's issue tracker so the library owners can help you out. 

Regards,

Shwetha, AdWords API Team.