{"id":8244,"date":"2019-10-24T13:49:00","date_gmt":"2019-10-24T13:49:00","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=8244"},"modified":"2025-04-17T14:50:57","modified_gmt":"2025-04-17T14:50:57","slug":"download-adwords-report-using-google-api-odbc-xml-driver","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/","title":{"rendered":"Download AdWords report using Google Ads API, ODBC, and XML Driver"},"content":{"rendered":"

Introduction<\/h2>\n
UPDATE:<\/strong>\u00a0ZappySys has released a brand new API Connector for Google AdWords<\/a> which makes it much simpler to\u00a0Read\/Write Google AdWords Data in SSIS\/ODBC<\/strong> compared to the steps listed in this article. You can still use steps from this article but if you are new to API or want to avoid learning curve with API then use newer approach.<\/p>\n

Please visit this page to see all<\/a>\u00a0Pre-Configured ready to use API connectors which you can use in SSIS API Source<\/a> \/ SSIS API Destination<\/a> OR\u00a0API ODBC Driver<\/a> (for non-SSIS Apps such as Excel, Power BI, Informatica).
\n<\/div><\/div>\n

In the previous article, we learned how to get data from AdWords <\/a>in SSIS<\/a> and basically control your AdWords account programmatically, outside the dashboard. In this one, we will continue on how to download AdWords report by using Google Ads API, ODBC, and ZappySys XML Driver. Let’s not waste our time and cut to the chase!<\/p>\n

Prerequisites<\/h2>\n
    \n
  1. Google Ads<\/a> account up and running.<\/li>\n
  2. ZappySys ODBC PowerPack<\/a>\u00a0installed.<\/li>\n<\/ol>\n

    Step-by-Step – Download AdWords report<\/h2>\n

    Get Developer Token<\/h3>\n

    The first important step to access any Google Ads Account is to request a developer token.\u00a0Click this link<\/a>\u00a0for step by step information. Watch a short video to get an overview of the entire process to access data via API.<\/p>\n

    Get Client Customer Id<\/h3>\n

    Login into a non-manager<\/strong><\/em> account at https:\/\/ads.google.com<\/a> and get your Client Customer Id:<\/p>\n

    \"\"<\/a>

    Getting Google Ads (formerly AdWords) Client Customer Id<\/p><\/div>\n

    Copy it to a notepad, we will use it later.<\/p>\n

    Open ODBC Data Sources Manager<\/h3>\n
    Search for \"odbc\" in your start menu and click on ODBC (64 bits). If you can't find this then you can also go to Start Menu > ZappySys > ODBC PowerPack > Click on ODBC Data Sources (64-Bit)<\/span>.\r\n
    \r\n\"Open\r\n<\/a>\r\n

    Open ODBC Data Source<\/p>\r\n\r\n<\/div><\/div>\n

    Create ODBC Data Source based on ZappySys\u00a0XML Driver<\/h3>\n
    Select tab User DSN<\/em>\u00a0if you want to create a data source only for your user, or select System DSN to create a data source for all users or for OS services (e.g. SQL Server Agent):\r\n
    \r\n\"\"\r\n

    Creating ZappySys XML Driver based data source<\/p>\r\n<\/div><\/div>\n

    Configure authentication in the ODBC data source<\/h3>\n

    Let’s authenticate first:<\/p>\n

      \n
    1. Select OAuth<\/strong> in Connection Type<\/em> property.<\/li>\n
    2. Click Click to Configure<\/strong> link.<\/li>\n
    3. In OAuth Provider<\/em> property select Google<\/strong>.<\/li>\n
    4. Then either select Use Default OAuth App<\/strong> or Use Custom OAuth App<\/strong>. For the latter, you will need to create a Google OAuth App yourself<\/a>. It’s perfectly safe to use the default application, but if your company policy does not allow it, you may consider creating it yourself.<\/li>\n
    5. In Scopes<\/em> enter:
      \nhttps:\/\/www.googleapis.com\/auth\/adwords<\/code><\/li>\n
    6. Then hit Generate Token<\/strong> and hit allow once asked.<\/li>\n<\/ol>\n
      \"\"<\/a>

      Download AdWords report – Configuring authentication in ODBC data source<\/p><\/div>\n

      Proceed with HTTP request configuration<\/h3>\n

      Then go on with configuring the data source:<\/p>\n

      \"\"<\/a>

      Configuring HTTP request in ODBC data source to download an AdWords report<\/p><\/div>\n

        \n
      1. Give your data source a name<\/li>\n
      2. Then input this URL to download the report:
        \nhttps:\/\/adwords.google.com\/api\/adwords\/reportdownload\/v201809<\/code>
        \nIf the above URL does not work,         get the working one from Google’s documentation<\/a>.<\/li>\n
      3. Input POST<\/strong> as HTTP Request Method<\/em>.<\/li>\n
      4. In Body enter this text:
        \n__rdxml=<reportDefinition xmlns=\"https:\/\/adwords.google.com\/api\/adwords\/cm\/v201809\">
        \n<selector>
        \n<fields>CampaignId<\/fields>
        \n<fields>Impressions<\/fields>
        \n<fields>Clicks<\/fields>
        \n<fields>Cost<\/fields>
        \n<predicates>
        \n<field>CampaignStatus<\/field>
        \n<operator>IN<\/operator>
        \n<values>ENABLED<\/values>
        \n<values>PAUSED<\/values>
        \n<\/predicates>
        \n<\/selector>
        \n<reportName>My Campaign Performance Report<\/reportName>
        \n<reportType>CAMPAIGN_PERFORMANCE_REPORT<\/reportType>
        \n<dateRangeType>LAST_7_DAYS<\/dateRangeType>
        \n<downloadFormat>XML<\/downloadFormat>
        \n<\/reportDefinition><\/code>
        \nThis will display the data of CAMPAIGN_PERFORMANCE_REPORT report (campaign Id, impressions, clicks, and cost) for the last 7 days, for all campaigns that are enabled or paused. Make sure to visit the         Google documentation page<\/a>, which contains the information about how to\u00a0download a different kind of report, how to configure predicates, etc.<\/li>\n
      5. In Body Content Type<\/em> property select Form (application\/x-www-form-urlencoded)\u00a0<\/strong>option.<\/li>\n
      6. In HTTP Headers<\/em> enter your developerToken<\/strong> and clientCustomerId<\/strong> retrieved in previous steps.<\/li>\n<\/ol>\n

        Select data filter in ODBC data source<\/h3>\n

        Then hit Select Filter<\/strong> button and select row<\/strong> node, so that Array Filter<\/em> is set to $.report.table.row[*]<\/strong><\/p>\n

        \"\"<\/a>

        Filtering on AdWords report data<\/p><\/div>\n

        If asked whether you want to treat the\u00a0row<\/strong> element as an array, click “yes”. You can also go to the\u00a0Xml Array Handling<\/strong> tab and see if the element row<\/strong> is specified there.<\/p>\n

        The Results<\/h2>\n

        To view the results press Preview<\/strong> tab and then click Preview Data<\/strong>:<\/p>\n

        \"\"<\/a>

        Previewing AdWords report data<\/p><\/div>\n

        Now you can use this data source and get the data into an Excel sheet<\/a>, Power BI report<\/a>, SQL Server<\/a> (would need to create a data source in ZappySys Data Gateway<\/a> instead) or elsewhere<\/a>.<\/p>\n

        Reusing the data source<\/h2>\n

        If your client application supports, you can override data source settings, such as HTTP body, in SQL query using WITH<\/strong> clause. In that case, you won’t need to create multiple data sources for different kind of reports; e.g.:<\/p>\n

        SELECT\u00a0*\u00a0FROM\u00a0$ (RequestData='@c:\\files\\report-definition.txt')<\/code><\/p>\n

        SELECT\u00a0*\u00a0FROM\u00a0$ (RequestData='__rdxml=<reportDefinition xmlns=\"https:\/\/adwords.google.com\/api\/adwords\/cm\/v201809\">
        \n<selector>
        \n<fields>CampaignId<\/fields>
        \n<fields>Cost<\/fields>
        \n<\/selector>
        \n<reportName>My Campaign Performance Report<\/reportName>
        \n<reportType>CAMPAIGN_PERFORMANCE_REPORT<\/reportType>
        \n<dateRangeType>LAST_7_DAYS<\/dateRangeType>
        \n<downloadFormat>XML<\/downloadFormat>
        \n<\/reportDefinition>')<\/code><\/p>\n

        Build a SQL query using the\u00a0Query Builder<\/strong>:<\/p>\n

        \"\"

        Use Query Builder to construct SQL query and override data source properties<\/p><\/div>\n

        Conclusion<\/h2>\n

        In this article, we learned how to download AdWords report using ODBC PowerPack and Google API. We created an ODBC data source based on XML Driver, then configured the OAuth authentication, HTTP request and data filtering without a single line of code. Then we previewed AdWords “Campaign Performance Report” data and finally, considered how to reuse the data source we created. Visit\u00a0https:\/\/zappysys.com\/blog\/category\/odbc-powerpack\/odbc-app-integration\/<\/a> for examples of how to integrate data sources based on ZappySys Drivers into applications.<\/p>\n

        References<\/h2>\n

        https:\/\/developers.google.com\/adwords\/api\/docs\/guides\/reporting<\/a><\/p>\n

        https:\/\/developers.google.com\/adwords\/api\/docs\/appendix\/reports<\/a><\/p>\n

        https:\/\/developers.google.com\/adwords\/api\/docs\/appendix\/reports\/campaign-performance-report<\/a><\/p>\n

         <\/p>\n

         <\/p>\n

         <\/p>\n","protected":false},"excerpt":{"rendered":"

        Introduction In the previous article, we learned how to get data from AdWords in SSIS and basically control your AdWords account programmatically, outside the dashboard. In this one, we will continue on how to download AdWords report by using Google Ads API, ODBC, and ZappySys XML Driver. Let’s not waste our time and cut to […]<\/p>\n","protected":false},"author":3,"featured_media":8247,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[390,276,278],"tags":[565,107,154,302,564],"yoast_head":"\r\nDownload AdWords report using Google Ads API, ODBC, and XML Driver | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Download AdWords report using Google Ads API, ODBC, and XML Driver. Use ZappySys products to show AdWords data in Excel, Power BI or load it to SQL Server.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Download AdWords report using Google Ads API, ODBC, and XML Driver | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Download AdWords report using Google Ads API, ODBC, and XML Driver. Use ZappySys products to show AdWords data in Excel, Power BI or load it to SQL Server.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2019-10-24T13:49:00+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-04-17T14:50:57+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"584\" \/>\r\n\t<meta property=\"og:image:height\" content=\"341\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/\",\"url\":\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/\",\"name\":\"Download AdWords report using Google Ads API, ODBC, and XML Driver | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png\",\"datePublished\":\"2019-10-24T13:49:00+00:00\",\"dateModified\":\"2025-04-17T14:50:57+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c146068d4cb053724ae5ce85759c3ada\"},\"description\":\"Download AdWords report using Google Ads API, ODBC, and XML Driver. Use ZappySys products to show AdWords data in Excel, Power BI or load it to SQL Server.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png\",\"width\":584,\"height\":341},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Download AdWords report using Google Ads API, ODBC, and XML Driver\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c146068d4cb053724ae5ce85759c3ada\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/60165d46d0b33aefb91df61a22b0e1f4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/60165d46d0b33aefb91df61a22b0e1f4?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"url\":\"https:\/\/zappysys.com\/blog\/author\/gliaskus\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Download AdWords report using Google Ads API, ODBC, and XML Driver | ZappySys Blog","description":"Download AdWords report using Google Ads API, ODBC, and XML Driver. Use ZappySys products to show AdWords data in Excel, Power BI or load it to SQL Server.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/","og_locale":"en_US","og_type":"article","og_title":"Download AdWords report using Google Ads API, ODBC, and XML Driver | ZappySys Blog","og_description":"Download AdWords report using Google Ads API, ODBC, and XML Driver. Use ZappySys products to show AdWords data in Excel, Power BI or load it to SQL Server.","og_url":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/","og_site_name":"ZappySys Blog","article_published_time":"2019-10-24T13:49:00+00:00","article_modified_time":"2025-04-17T14:50:57+00:00","og_image":[{"width":584,"height":341,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/","url":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/","name":"Download AdWords report using Google Ads API, ODBC, and XML Driver | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png","datePublished":"2019-10-24T13:49:00+00:00","dateModified":"2025-04-17T14:50:57+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c146068d4cb053724ae5ce85759c3ada"},"description":"Download AdWords report using Google Ads API, ODBC, and XML Driver. Use ZappySys products to show AdWords data in Excel, Power BI or load it to SQL Server.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/10\/download-adwords-report-using-google-api-and-odbc-clientCustomerId.png","width":584,"height":341},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/download-adwords-report-using-google-api-odbc-xml-driver\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Download AdWords report using Google Ads API, ODBC, and XML Driver"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c146068d4cb053724ae5ce85759c3ada","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/60165d46d0b33aefb91df61a22b0e1f4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/60165d46d0b33aefb91df61a22b0e1f4?s=96&d=mm&r=g","caption":"ZappySys"},"url":"https:\/\/zappysys.com\/blog\/author\/gliaskus\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8244"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=8244"}],"version-history":[{"count":16,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8244\/revisions"}],"predecessor-version":[{"id":11356,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8244\/revisions\/11356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/8247"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=8244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=8244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=8244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}