{"id":7524,"date":"2021-10-13T14:23:14","date_gmt":"2021-10-13T12:23:14","guid":{"rendered":"https:\/\/adformatic.com\/?page_id=7524"},"modified":"2025-09-11T11:00:13","modified_gmt":"2025-09-11T09:00:13","slug":"google-ads-add-on-for-google-sheets","status":"publish","type":"page","link":"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/","title":{"rendered":"Google Ads add-on for Google Sheets"},"content":{"rendered":"<p>\r\n<section class=\"sh-section sh-section-d0cb35cf95b3603d6d2fd1e6cccb32d0 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container-fluid\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-46557d1593737a3f889467b3c4a69b7f fw-col-xs-12 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-cf8f0537398d091cc04aa09bcb623f9f\" class=\"sh-text-block\">\r\n\t<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Google Ads add-on for Google Sheets<\/span><\/h1><\/div>\r\n\r\n<div id=\"text-block-f15fa6926532404663fb0792d76672a5\" class=\"sh-text-block\">\r\n\t<p style=\"text-align: center;\"><span style=\"color: #ffffff; font-size: 18px;\">Download Google Ads data to Google Sheets. <\/span><\/p><\/div>\r\n\r\n<div id=\"button-8ceb1b1e74a2d671d70e68d8b3e8a437\" class=\"sh-button-container  sh-button-style-1\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/adformatic_ppc_audit_for_google_ads\/481173569963\" target=\"_blank\" class=\"sh-button sh-button-xlarge sh-button-icon-right\">\r\n\r\n\t\t\t\t\t\t\t<span class=\"sh-button-icon\">\r\n\t\t\t\t\t<i class=\"fa fa-angle-right\"><\/i>\r\n\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tGET THE ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-a574b5abb998461150f60ab8986c470c fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-041b0540cafc569c0c2bf1dcb0f10313 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-cdf2c18fef7c5a730627ffa5c94fcb05\" class=\"sh-text-block\">\r\n\t<p style=\"text-align: left;\"><span style=\"font-size: 28px;\">This Google Sheets add-on helps you view and edit Google Ads data more easily in Google Sheets.<\/span><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-988b432093ff13aad23f16327f5beed8 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<ul class=\"sh-list sh-list-style1\" id=\"list-1753367c6d654d1eda2110a47b1a83e2\">\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tEasy to use report configurator.\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tSchedule your reports to automatically refresh (up to hourly).\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tReceive an email when your report is ready.\t\t<\/li>\r\n\t\t\t<li class=\"sh-list-item\">\r\n\t\t\t<span class=\"sh-list-icon\">\r\n\t\t\t\t<i class=\"fa fa-check\"><\/i>\r\n\t\t\t<\/span>\r\n\t\t\tEdit report configurations with the sidebar or in the sheet.\t\t<\/li>\r\n\t<\/ul>\r\n\r\n<div id=\"button-9df356c8dd175883a06ee10468832b5b\" class=\"sh-button-container  sh-button-style-1\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/adformatic_for_google_ads\/481173569963\" target=\"_blank\" class=\"sh-button sh-button-xlarge \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tINSTALL THE ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-d1b98238556239376b2679b219bbadb2 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-40fadc42245b88e4c11a9ee28ce29e41 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-8fa83f1ede9604f02e0f921fdd6b5f1c\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tTry for free\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-0451e915841616e12e203ab5fd9d5474\" class=\"sh-text-block\">\r\n\t<p data-nosnippet=\"\">You can use this Google Ads add-on for Google Sheets free of charge for 14 days. In order to continue using it beyond the trial period, please subscribe.<\/p><\/div>\r\n\r\n<div id=\"button-33a84c6b8b30f786d4140187eef4001c\" class=\"sh-button-container  sh-button-style-1\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/portal.adformatic.com\/subscribe\/google-ads-add-on-for-google-sheets\" target=\"_blank\" class=\"sh-button sh-button-xlarge sh-button-icon-right\">\r\n\r\n\t\t\t\t\t\t\t<span class=\"sh-button-icon\">\r\n\t\t\t\t\t<i class=\"fa fa-angle-right\"><\/i>\r\n\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tPLANS &amp; PRICES\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-968e76a6d004102aca111c7b4172a1d7 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-76b7a8bf9969ced939f340e402985f16 fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-80cacb7ccc1f52c78321a06f7d9ea96d\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tNavigate directly to\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-6d0cfda71ff06aaab66f73de19da9edf\" class=\"sh-text-block\">\r\n\t<p><a href=\"#install-add-on\">Install the Google Sheets add-on<\/a><\/p><p><a href=\"#create-report\">Create reports<\/a><\/p><p><a href=\"#edit-report\">Edit reports<\/a><\/p><p><a href=\"#delete-report\">Delete reports<\/a><\/p><p><a href=\"#run-report\">Run reports<\/a><\/p><p><a href=\"#schedule-report\">Schedule reports to run automatically<\/a><\/p><p><a href=\"#report-configuration-options\">Rapport configuration options<\/a><\/p><p><a href=\"#performance-max-reports\">Performance Max reports<\/a><\/p><p><a href=\"#alerts\">Alerts<\/a><\/p><p><a href=\"#audit\">Create a Google Ads audit<\/a><\/p><p><a href=\"#contact\">Ask a question or request a feature<\/a><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-764a4aa014e7a2ddae6da279bc21b673 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-4dcc9cac38ee7244ef06b771cdad08b5 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"install-add-on\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-dc9243bae3337b4f13549d0289216471 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-d3ed8b40bfdf00d573b9eced06ec9de8\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\t Install the Google Sheets add-on\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-6307753356a879793dcc121c7b38f8a5\" class=\"sh-text-block\">\r\n\t<p>To use the Google Ads add-on, you must first add it to your spreadsheet. The following instructions will guide you through the process:<\/p><ol><li>Create a new Google spreadsheet (or open an existing one).<\/li><li>In the menu bar choose: Extensions &gt; Add-ons &gt; Get add-ons<\/li><li>Find the \u201cGoogle Ads\u2122 reporting by Adformatic\u201d add-on in the add-on gallery and select it.<\/li><li>On the add-on description page, click install in the top right corner to add this add-on to your spreadsheet.<\/li><li>A dialog should appear asking for permission for the add-on to access your Google Ads data. Click on \"Allow\".<\/li><li>The add-on is now installed. The \"Google Ads\u2122 reporting by Adformatic\" submenu should now appear in the Extensions menu.<\/li><\/ol><p>You can also go directly to the add-on in the Google Workspace Marketplace. Here you can install the add-on. The add-on is then available in every Google Spreadsheet under \"Extensions\".<\/p><\/div>\r\n\r\n<div id=\"button-e2079eabe33beb62749e0ebe26950cfb\" class=\"sh-button-container  sh-button-style-1 sh-animated fadeIn\"data-wow-duration=\"0.5s\">\r\n\t<div class=\"sh-element-margin\">\r\n\t\t<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/reporting_for_google_analytics_4\/126881055683\" target=\"_blank\" class=\"sh-button sh-button-xlarge \">\r\n\r\n\t\t\t\r\n\t\t\t\t\t\t\t<span class=\"sh-button-text\">\r\n\t\t\t\t\tINSTALL THE ADD-ON\t\t\t\t<\/span>\r\n\t\t\t\r\n\t\t\t\r\n\t\t<\/a>\r\n\t\t\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-9d654ae909e17b7dc1fc5189632d3c40 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-0f0d1a93949db9ed58ae67161ccac4a6 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"create-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-8409f290157bb54996d3310c882f7109 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-6c70d0c17040ceb698fc813f05c3530a\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tCreate Google Ads reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-28c2acfc9a7c61ad4d9a58649e56ad4b\" class=\"sh-text-block\">\r\n\t<p>Reports can be created manually in the configuration sheet or using the add-ons sidebar. To use the sidebar, select \"Extensions'' &gt; \"Google Ads\u2122 reporting by Adformatic\" &gt; \"Create report\" in the menu bar.<br \/>This will display a sidebar on the right side with which you can easily create a report configuration. The sidebar helps with the following:<\/p><ul><li>Look up Google Ads account information.<\/li><li>Selecting fields, segments and metrics.<\/li><li>Apply filters.<\/li><li>Determine the sorting of the report.<\/li><\/ul><p>When you are done, click on the button \"Add report to sheet\" and your report configuration will appear in the sheet called \u201cGoogle Ads report configuration\u201d (if this sheet does not already exist, it will be created).<\/p><p>You can go through these steps again to add another Google Ads report. You can also copy the information in the sheet to a new column and edit it in the sheet.<br \/>Not all cells are filled by the sidebar. The fields that are not filled by the sidebar can be entered in the sheet.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-54277b264c68401a7dfd3ec9067bc2b3 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-64b1d34699937876a76c168d60e13aff fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"edit-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-7699815d2927bad73cac4d85f915443d fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-8a99ac85ea0af1ac46c533ef5095ed03\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tEdit Google Ads reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-b46b29f1aaef8629ffad86692e046083\" class=\"sh-text-block\">\r\n\t<p>There are two ways to edit reports after you create them:<\/p><ul><li>Through the add-on menu, you can select 'Manage reports'. A sidebar will open with a list of the reports currently in your sheet. You can click the edit option for the report you wish to edit and the sidebar will display your current report configuration. You can make adjustments in the sidebar and save the report configuration to the sheet.<\/li><li>Another option is to edit the report configuration directly in the sheet.<\/li><\/ul><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-993a524f523555a864b82409325434d6 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-23f415f9c5cff405170a4c66238a4c09 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"delete-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-9619ad01cd85aaac88f3aec0176aba03 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-9dbc1fdf8fe9cb36d209ccc52fae0f49\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tDelete Google Ads reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-61bef996f5154dfb63d56d70797296f3\" class=\"sh-text-block\">\r\n\t<p>There are two ways to edit reports after you create them:<\/p><ul><li>Through the add-on menu, you can select 'Manage reports'. A sidebar will open with a list of the reports currently in your sheet. You can click the delete option for the report you wish to delete. After you confirm your intention to delete the report, the report configuration will be removed from your sheet.<\/li><li>Another option is to delete the report configuration directly in the sheet.<\/li><\/ul><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-ff7cec25b842edf7f273a6735a57ec42 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-5b05f2eaf14cfc97d829150f18046a78 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"run-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-7246c0d07a813b9b8e804955bf0810d0 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-689dedf62560c2f452eedc1839300704\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tRun reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-92af37fc956c54f94b328f455d579267\" class=\"sh-text-block\">\r\n\t<p>Go to \"Extensions\" &gt; \"Google Ads\u2122 reporting by Adformatic\" &gt; \"Run reports\" in the menu to run all the reports you have created.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-f9d7ef1633cea369800382fe9b050357 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-e71f6b7313774c6097f79b3040043da5 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"schedule-report\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-b289f1802352af216e14ab9e0e4fbcba fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-0a4d28fc8ed5de790acfcd4153699148\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tSchedule reports to run automatically\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-fb3efb8d1b5608b818c6f1f9f6f17c2d\" class=\"sh-text-block\">\r\n\t<p>Reports can be scheduled to run automatically. To do this, go to \"Extensions\" &gt; \"Google Ads\u2122 reporting by Adformatic\" &gt; \"Set schedule\".<br \/>A dialog will open in which you can indicate three things:<\/p><ul><li>Turning a schedule on and off.<\/li><li>Choose the frequency, day and time.<\/li><li>Set whether you want to receive an email if the execution of a report fails.<\/li><\/ul><\/div>\r\n\r\n<div id=\"text-block-da55bb269e84fd9efae510934a18520b\" class=\"sh-text-block\">\r\n\t<p><span style=\"font-weight: 400;\">If you also set alerts, then these will run on the same schedule. <\/span><span style=\"font-weight: 400;\">While both, reporting and alerts, can be run in one spreadsheet, using separate spreadsheets is recommended.<\/span><\/p><\/div>\r\n\r\n<div id=\"text-block-eb944f3c085c51793438b0b1b2656a0b\" class=\"sh-text-block\">\r\n\t<p>The schedule uses the time zone of the spreadsheet. To update the time zone got to: \"File\" &gt; \"Settings\" in the Google Sheets menu. If no time zone is set the schedule uses Coordinated Universal Time (UTC). If you change the time zone, you will have to set the schedule again to use the new time zone.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-a70dd42b7a85f424fd020f806ca4bb33 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-a9806f81228336fe03e01171d057c259 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"report-configuration-options\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-b0d906829f2cf8a7e29880d5d86dc047 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-e0cc4be05cc9576bf449af1cb207dcb5\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tReport configuration options\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div class=\"sh-table-element sh-table-element-style1 fw-table\" id=\"table-776d247d1be93049634f7f60440a2669\">\r\n\t<table>\r\n\t\t\t\t\t\t\t\t\t<thead>\r\n\t\t\t\t\t<tr class=\"heading-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th class=\"desc-col\">\r\n\t\t\t\t\t\t\t\tOption\t\t\t\t\t\t\t<\/th>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th class=\"default-col\">\r\n\t\t\t\t\t\t\t\tRequired\t\t\t\t\t\t\t<\/th>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th class=\"default-col\">\r\n\t\t\t\t\t\t\t\tDescription\t\t\t\t\t\t\t<\/th>\r\n\t\t\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t<\/thead>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tReport name\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe name you give to the report. The name must be unique. If the name is not unique, a sequence number is automatically added to make it unique.\r\nThe report name is also the name of the sheet to which the data is written.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tLogin ID\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe ID of the Google Ads account you are logged in with. This can be a Google Ads account or manager account. Please enter the id in this format: XXX-XXX-XXXX.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tCustomer id\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe ID of the Google Ads account. You can use the sidebar to find out the id. You can also find the ID in the Google Ads UI. Please enter the id in this format: XXX-XXX-XXXX.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tCustomer name\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe name of the Google Ads account. The account name is filled in by the sidebar. If you enter a report configuration directly to the sheet and leave the account name empty. it will be fetched on the first run of the report.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tStart date\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe start date for retrieving Google Ads data. You can specify a specific start date formatted as YYYY-MM-DD or as a relative date.\r\n<br>\r\nOptions for specifying a relative date:\r\n<ul>\r\n<li>XdaysAgo (X is a positive integer, for example 7daysAgo)<\/li>\r\n<li>yesterday<\/li>\r\n<li>sundayLastWeek<\/li>\r\n<li>mondayLastWeek<\/li>\r\n<li>fridayLastWeek<\/li>\r\n<li>SaturdayLastWeek<\/li>\r\n<\/ul>\r\n\r\n<a href=\"#relative-dates\">View all possible options for relative dates.<\/a>\r\n<br>\r\n<br>\r\nYou can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1)\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tEnd date\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe end date for retrieving Google Ads data. You can specify a specific end date formatted as YYYY-MM-DD or as a relative date.\r\n<br>\r\nOptions for specifying a relative date:\r\n<ul>\r\n<li>XdaysAgo (X is a positive integer, for example 7daysAgo)<\/li>\r\n<li>yesterday<\/li>\r\n<li>sundayLastWeek<\/li>\r\n<li>mondayLastWeek<\/li>\r\n<li>fridayLastWeek<\/li>\r\n<li>SaturdayLastWeek<\/li>\r\n<\/ul>\r\n\r\n<a href=\"#relative-dates\">View all possible options for relative dates<\/a>\r\n<br>\r\n<br>\r\nYou can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1)\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tCompare start date\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThis is the start date of the date range you want to compare your Google Ads data with.\r\n<br>\r\nYou can specify a specific date formatted as YYYY-MM-DD or as a relative date.\r\n<br>\r\nOptions for specifying a relative date:\r\n<ul>\r\n<li>XdaysAgo (X is a positive integer, for example 7daysAgo)<\/li>\r\n<li>yesterday<\/li>\r\n<li>sundayLastWeek<\/li>\r\n<li>mondayLastWeek<\/li>\r\n<li>fridayLastWeek<\/li>\r\n<li>SaturdayLastWeek<\/li>\r\n<\/ul>\r\n\r\n<a href=\"#relative-dates\">View all possible options for relative dates<\/a>\r\n<br>\r\n<br>\r\nYou can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1)\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tCompare end date\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThis is the end date of the date range you want to compare your Google Ads data with.\r\n<br>\r\nYou can specify a specific date formatted as YYYY-MM-DD or as a relative date.\r\n<br>\r\nOptions for specifying a relative date:\r\n<ul>\r\n<li>XdaysAgo (X is a positive integer, for example 7daysAgo)<\/li>\r\n<li>yesterday<\/li>\r\n<li>sundayLastWeek<\/li>\r\n<li>mondayLastWeek<\/li>\r\n<li>fridayLastWeek<\/li>\r\n<li>SaturdayLastWeek<\/li>\r\n<\/ul>\r\n\r\n<a href=\"#relative-dates\">View all possible options for relative dates<\/a>\r\n<br>\r\n<br>\r\nYou can also use the date functions of Google Sheets to specify this value programmatically. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1)\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tReport type\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tHere you can define the report type. This is the 'FROM' part of the GAQL query send to the Google Ads API. You can choose any report type listed here: https:\/\/developers.google.com\/google-ads\/api\/fields\/v13\/overview\r\n\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tColumns\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tYes\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe columns are all the fields, segments and metrics for your report. This is the 'SELECT' part of the GAQL query send to the Google Ads API. You can use the sidebar to select the columns, or enter the columns directly in the configuration sheet.\r\nYou can also use the Google Ads API documentation or the <a href=\"https:\/\/developers.google.com\/google-ads\/api\/fields\/v13\/overview_query_builder\" target=\"_blank\">Google Ads Query Builder<\/a> to get the right column names.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tFilters\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe filters allows you to limit the data returned from Google Ads. This is the 'WHERE' part of the GAQL query send to the Google Ads API. \r\nYou can use the sidebar to add the filters, or add the filters directly in the configuration sheet. You can use the Google Ads API documentation or the <a href=\"https:\/\/developers.google.com\/google-ads\/api\/fields\/v13\/overview_query_builder\" target=\"_blank\">Google Ads Query Builder<\/a> to add the filters directly to the sheet.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tSort\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe sort option allows you to determine in which order the rows are returned. This is the 'ORDER BY' part of the GAQL query send to the Google Ads API. \r\nYou can use the sidebar to add the sorting, or add the sorting directly in the configuration sheet. You can use the Google Ads API documentation or the <a href=\"https:\/\/developers.google.com\/google-ads\/api\/fields\/v13\/overview_query_builder\" target=\"_blank\">Google Ads Query Builder<\/a> to add the sorting directly to the sheet.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tLimit\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe maximum number of rows for the report. If this parameter is left empty, all rows are shown.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tEmail addresses\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe email addresses to which this report should be sent. The report is only sent if the report contains at least 1 row of data. Leave this field blank to not send the report.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tHide report Header\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tBy default, extra information and the totals are shown above the report. Set the value to \"TRUE\" to hide this report header. The report then starts at row 1.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tFirst column\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tBy default, the report data begins in the first column. However, you can alter this by specifying a different starting column number, such as 3, for the report to begin in column 3.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tDisable formatting\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThe report data is automatically styled for easy reading in Google Sheets, including currency symbols and thousand separators. To disable this feature, set the value to \"TRUE\".\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tSkip report\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tIf TRUE, the report in the corresponding column is not executed.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr class=\"default-row\">\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"desc-col\">\r\n\t\t\t\t\t\t\tLast update on\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t<td class=\"default-col\">\r\n\t\t\t\t\t\t\tThis is a read only field. This field is filled by the add-on, so you can easily when a report was last updated.\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\t<\/table>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-86f4a7fa78c95663d331c784c8b543ae fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-22cbfb091b9aa1d254fd1be62105e1f0 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"relative-dates\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-83b40854bdc75ef8093b21297def82ab fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-b47e4f0887abfdf69bcb4cc7bfd44994\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tOverview available relative dates\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-533d347e79aea5612455f0755c282b4d\" class=\"sh-text-block\">\r\n\t<p>Relative dates:<\/p><ul><li><strong>X<\/strong>daysAgo (X is a positive integer, for example 7daysAgo)<\/li><li>today<\/li><li>yesterday<\/li><li><div>mondayThisWeek<\/div><\/li><li><div>lastSunday<\/div><\/li><li>sundayLastWeek<\/li><li>mondayLastWeek<\/li><li>fridayLastWeek<\/li><li>saturdayLastWeek<\/li><li>sunday<strong>X<\/strong>WeekAgo (X is a positive integer, for example sunday3WeekAgo)<\/li><li>monday<strong>X<\/strong>WeekAgo (X is a positive integer)<\/li><li>friday<strong>X<\/strong>WeekAgo (X is a positive integer)<\/li><li>saturday<strong>X<\/strong>WeekAgo (X is a positive integer)<\/li><li><div><div>firstDayThisMonth<\/div><\/div><\/li><li>firstDayLastMonth<\/li><li>lastDayLastMonth<\/li><li>firstDay<strong>X<\/strong>MonthsAgo (X is a positive integer)<\/li><li>lastDay<strong>X<\/strong>MonthsAgo (X is a positive integer)<\/li><li>firstDayThisYear<\/li><\/ul><p>Relative dates last year<\/p><ul><li>XdaysAgoLastYear (X is a positive integer, for example 7daysAgoLastYear)<\/li><li>sundayLastWeekLastYear<\/li><li>mondayLastWeekLastYear<\/li><li>fridayLastWeekLastYear<\/li><li>saturdayLastWeekLastYear<\/li><li>firstDayThisMonthLastYear<\/li><li>lastDayThisMonthLastYear<\/li><li>firstDayLastMonthLastYear<\/li><li>lastDayLastMonthLastYear<\/li><li>firstDayThisMonth<strong>X<\/strong>yearsAgo (X is a positive integer)<\/li><li>lastDayThisMonth<strong>X<\/strong>yearsAgo (X is a positive integer)<\/li><li>firstDayLastMonth<strong>X<\/strong>yearsAgo (X is a positive integer)<\/li><li>lastDayLastMonth<strong>X<\/strong>yearsAgo (X is a positive integer)<\/li><li>firstDayLastYear<\/li><li>lastDayLastYear<\/li><li>firstDay<strong>X<\/strong>yearsAgo (X is a positive integer)<\/li><li>lastDay<strong>X<\/strong>yearsAgo (X is a positive integer)<\/li><\/ul><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-7d007b4980af8a00a52f9e9c2cedd401 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-783bcf19279271d23343949a87dd552e fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"performance-max-reports\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-f954c2f132cf60bf184aa3dd5068058f fw-col-xs-12 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-fb17b0a56192b384f488e8418f76349d\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tPerformance Max reports\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-5db3990f2d79474bdb31ec6d41235a63\" class=\"sh-text-block\">\r\n\t<p>Although all available data for Performance Max campaigns can be retrieved in the standard reports, finding the specific data you need can be challenging and, in some cases, may involve multiple steps and some spreadsheet skills.<br \/>For this reason, we have created some predefined PMax reports that you might find useful.<\/p><p>To access the PMax reports, navigate to the add-on menu and select \"Extensions\" &gt; \"Google Ads\u2122 reporting by Adformatic\" &gt; \"Performance Max reports\".<\/p><p>At the moment there are 3 PMax reports available:<\/p><ul><li>PMax allocation<\/li><li>PMax search category label<\/li><li>PMax product performance<\/li><\/ul><p><strong>PMax allocation<\/strong>: This report estimates the cost, conversion, and conversions value distribution for Performance Max campaigns by combining various reports, as Google does not provide this data directly. Shopping data is derived from the 'asset_group_product_group_view' report. Video costs are calculated by multiplying the cost per view with the number of views, and conversions and conversions value are based on interactions with 'Video' assets. Display data is based on interactions with 'Marketing' assets. 'Search\/other' includes all other costs, conversions and conversions value.<\/p><p><strong>PMax search category label<\/strong>: This report displays the performance of all search category labels (keywords) across all Performance Max campaigns. Adjust the lookback period to fetch data for a longer or shorter duration.<\/p><p><strong>PMax product performance<\/strong>: This report will show product performance data from all Performance Max campaigns. Adjust the lookback period to fetch data for a longer or shorter duration.<\/p><p>These reports will provide you with the raw data, which is easy to analyze and simple to connect to a Looker Studio Dashboard.<\/p><p>It is advisable to run these reports in a separate spreadsheet. Some reports may require longer processing time and generate numerous rows. If an account is too large, consider dividing the PMax reports across several spreadsheets.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-c25d2a78b1978066e5c5c61e616143d1 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-990fb06afccfb4609fcabae352a045e4 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"alerts\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-e9ed36434e9a570f1adc89a4241dd269 fw-col-xs-12 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-d160e5b90699b672db88673fbcde7512\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tGoogle Ads alerts\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-a1bf9f6de2471dae365e61277199c28c\" class=\"sh-text-block\">\r\n\t<p>This add-on provides a collection of pre-defined, but customizable, Google Ads alerts. To access them, navigate to the add-on menu and select \"Extensions\" &gt; \"Google Ads\u2122 reporting by Adformatic\" &gt; \"Alerts\". A sidebar will open to guide you through the setup process.<\/p><p>These alerts are currently available:<\/p><ol><li><strong>Monthly budget alert:<\/strong> Checks this months spend until yesterday against the budget available until yesteday. A budget state is calculated and an alert is sent if the difference becomes too great. You can set the tresholds yourself.<\/li><li><strong>No conversions alert:<\/strong> Checks how many days ago the last conversion (included in the conversions column) occured. An alert is sent if the number of days is above the threshold.<\/li><li><strong>No Impressions Alert:<\/strong> Checks how many hours ago the last impression occurred. An alert is sent if the number of hours exceeds the threshold.<\/li><li><strong>Account performance alert:<\/strong> Checks yesterdays account performance for clicks, cost and conversions. It compares yesterdays performance with the average performance on the same weekday in the previous weeks. An alert is sent if the deviation is above the threshold.<\/li><\/ol><p>Configure the schedule to run checks every morning and get email notifications for any detected issues. You can easily set the alerts for multiple accounts.<\/p><p>Since alerts and reports share the same schedule, it's advisable to use a separate spreadsheet for setting up alerts. This way they can both run on their own schedule.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-73f5fb2d1bfd441f41f9cdb47f01edf1 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-ad59a55694262c1ae17196b677fe3ffd fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"audit\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-75b682cc38bdbadc051d94ff326c494a fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-636bb765ffe6ad2c9f9ab48eb5b75564\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tGoogle Ads audit\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-a74263aa1604b2cd0ea8ea71276707aa fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-12142575bd4a1dcb6dd0f9dd6d56d619\" class=\"sh-text-block\">\r\n\t<p>This Google Sheets add-on assists with auditing Google Ads accounts. It enables you to quickly scan any of your Google Ads accounts for common mistakes and performance opportunities.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n\r\n<div class=\"sh-column sh-column-6548c71a72f4c4dcc4cbd68fdbdfebaa fw-col-xs-12 fw-col-sm-6\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<div>\n<div class=\"video-container\" style=\"padding-top:0px;\" align=\"left\"><iframe src=\"https:\/\/www.youtube.com\/embed\/QlFm40klYEA?rel=0&amp;modestbranding=1&amp;autohide=1\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<div align=\"left\"><\/div>\n<\/div><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-e4b2d522bf46adb761aaa40b8c4c7247 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-f6c69f0e82eba8fd3e991a56b2d5de72 fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-d82f174625172d749acb9664afcd2e82\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tHealth check\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-300689ab56535248501bb33ff206faf6\" class=\"sh-text-block\">\r\n\t<p>The health check currently offers these checks:<\/p><ol><li>Campaigns without ad groups<\/li><li>Ad groups without responsive search ads<\/li><li>Number of ads under limit<\/li><li>Ad groups without keywords<\/li><li>Ad groups without targeting<\/li><li>Keywords with BMM<\/li><li>Disapproved extensions<\/li><li>Disapproved ads ( sorted by disapproval reason)<\/li><li>Extensions under limit<\/li><\/ol><p>The add-on performs the checks and writes the results to a Google Sheet.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n\r\n<div class=\"sh-column sh-column-b5fd710889d6fa3139a357da36d4c5c3 fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-64df07eacd3c4b788883d9a4f4e69a52\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tPerformance opportunities\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-daa28348de9d8e846cbb4a1f50040351\" class=\"sh-text-block\">\r\n\t<p>The performance opportunities currently offer these checks:<\/p><ol><li>Negative search terms<\/li><li>Positive search terms<\/li><li>Negative Shopping products<\/li><li>Campaigns limited by budget<\/li><li>Lost conversions<\/li><\/ol><p>The add-on performs the checks and writes the results to a Google Sheet.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-39781875cd8ba060fc2e503a03ccc61f fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-71e8a6ed80fa8e5e962853e35ea09967 fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-451b07b67052db87486d5a63f9c3097e\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h3 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tSummary\t\t\t<\/h3>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-e54ab3ab781fd39ece546e5da7a11ebb fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-861b31cc11053cd5ebf7c1a63c8d9667\" class=\"sh-text-block\">\r\n\t<p>You can easily create a summary of the Health check and performance check results. This creates a new sheet which lists the results of all executed checks. The summary shows the number of results found per check and includes a link to the checks sheet.<\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n\r\n<div class=\"sh-column sh-column-c1c589b441b4744eb5294de20d5356b3 fw-col-xs-12 fw-col-sm-6 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"single-image-1333ceabb0b16114edbd70102971a9de\" class=\"sh-single-image  \">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\t\t\t<div class=\"sh-image-lazy-loading\" style=\"max-width: 868px;\">\r\n\t\t\r\n\t\t\t<div class=\"sh-single-image-container sh-single-image-container-lazy\">\r\n\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"ratio-container\" style=\"padding-top: 63.364055299539%;\">\r\n\t\t\t\t\t\t\t\t\t<div class=\"ratio-content\">\r\n\t\t\t\t\t\t\t\t\t\t<img class=\"sh-image-url lazy\" data-src=\"https:\/\/adformatic.com\/wp-content\/uploads\/google-ads-audit-summary.png\" alt=\"google-ads-audit-summary\" \/>\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\r\n\t\t\t\t\t<\/div>\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-e9fa4b96a2daf8081b7caf63c87fdaa6 fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-1facad11bf048b2cad0953f2764967c9 fw-col-xs-12 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-a9bf0b71e3809fba7ba3ebcfb33787ab\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tTerms\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\r\n<div id=\"text-block-1f40c1ee21890840524a46763554942b\" class=\"sh-text-block\">\r\n\t<p>For more information please visit our <a href=\"https:\/\/adformatic.com\/en\/terms-and-conditions\/\">terms and conditions<\/a> and <a href=\"https:\/\/adformatic.com\/en\/privacy\/\">privacy policy.<\/a><\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n\r\n<section class=\"sh-section sh-section-5138ad50271b1c5050654b7d7bb8628c fw-main-row sh-section-visibility-everywhere\">\r\n\t\r\n\t\r\n\t<div class=\"sh-section-container container\">\r\n\t\t<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-deaab644134f9185d08f5c165aba91fa fw-col-xs-12\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t<div class=\"sh-output-html\">\r\n\t<span id=\"contact\"><\/span><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-9a21413ad3246c6d9b0e603dd0b5e1c1 fw-col-xs-12 sh-column-mobile-padding\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div class=\"sh-heading  \" id=\"heading-30493d646c962b082f6155a91f901973\">\r\n\t<div class=\"sh-element-margin\">\r\n\r\n\t\t\r\n\t\t\t<h2 class=\"sh-heading-content size-default text-left\">\r\n\t\t\t\tQuestions and feature requests\t\t\t<\/h2>\r\n\r\n\t\t\r\n\t<\/div>\r\n<\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n<div class=\"fw-row\">\n\t\r\n<div class=\"sh-column sh-column-127c06ad5e41fa242552394787f49cab fw-col-xs-12 fw-col-sm-6 dark-form\" >\r\n\r\n\t\r\n\t<div class=\"sh-column-wrapper\">\r\n\t\t\r\n<div id=\"text-block-bc47a0f021e99ab03729d2667e822c7f\" class=\"sh-text-block\">\r\n\t<p>If you have a question or a feature request. Please contact us.<\/p><p><noscript class=\"ninja-forms-noscript-message\">\n\tNotice: JavaScript is required for this content.<\/noscript>\n<div id=\"nf-form-9-cont\" class=\"nf-form-cont\" aria-live=\"polite\" aria-labelledby=\"nf-form-title-9\" aria-describedby=\"nf-form-errors-9\" role=\"form\">\n\n    <div class=\"nf-loading-spinner\"><\/div>\n\n<\/div>\n        <!-- That data is being printed as a workaround to page builders reordering the order of the scripts loaded-->\n        <script>var formDisplay=1;var nfForms=nfForms||[];var form=[];form.id='9';form.settings={\"objectType\":\"Form Setting\",\"editActive\":true,\"title\":\"Support\",\"created_at\":\"2019-08-23 11:41:34\",\"default_label_pos\":\"above\",\"show_title\":\"0\",\"clear_complete\":\"1\",\"hide_complete\":\"1\",\"logged_in\":\"\",\"key\":\"\",\"conditions\":[],\"wrapper_class\":\"\",\"element_class\":\"\",\"add_submit\":\"1\",\"not_logged_in_msg\":\"\",\"sub_limit_number\":\"\",\"sub_limit_msg\":\"\",\"calculations\":[],\"formContentData\":[\"name_1563891814361\",\"email_address_1639238883085\",\"message_1563891864044\",\"send_1563891884697\"],\"container_styles_background-color\":\"\",\"container_styles_border\":\"\",\"container_styles_border-style\":\"\",\"container_styles_border-color\":\"\",\"container_styles_color\":\"\",\"container_styles_height\":\"\",\"container_styles_width\":\"\",\"container_styles_font-size\":\"\",\"container_styles_margin\":\"\",\"container_styles_padding\":\"\",\"container_styles_display\":\"\",\"container_styles_float\":\"\",\"container_styles_show_advanced_css\":\"0\",\"container_styles_advanced\":\"\",\"title_styles_background-color\":\"\",\"title_styles_border\":\"\",\"title_styles_border-style\":\"\",\"title_styles_border-color\":\"\",\"title_styles_color\":\"\",\"title_styles_height\":\"\",\"title_styles_width\":\"\",\"title_styles_font-size\":\"\",\"title_styles_margin\":\"\",\"title_styles_padding\":\"\",\"title_styles_display\":\"\",\"title_styles_float\":\"\",\"title_styles_show_advanced_css\":\"0\",\"title_styles_advanced\":\"\",\"row_styles_background-color\":\"\",\"row_styles_border\":\"\",\"row_styles_border-style\":\"\",\"row_styles_border-color\":\"\",\"row_styles_color\":\"\",\"row_styles_height\":\"\",\"row_styles_width\":\"\",\"row_styles_font-size\":\"\",\"row_styles_margin\":\"\",\"row_styles_padding\":\"\",\"row_styles_display\":\"\",\"row_styles_show_advanced_css\":\"0\",\"row_styles_advanced\":\"\",\"row-odd_styles_background-color\":\"\",\"row-odd_styles_border\":\"\",\"row-odd_styles_border-style\":\"\",\"row-odd_styles_border-color\":\"\",\"row-odd_styles_color\":\"\",\"row-odd_styles_height\":\"\",\"row-odd_styles_width\":\"\",\"row-odd_styles_font-size\":\"\",\"row-odd_styles_margin\":\"\",\"row-odd_styles_padding\":\"\",\"row-odd_styles_display\":\"\",\"row-odd_styles_show_advanced_css\":\"0\",\"row-odd_styles_advanced\":\"\",\"success-msg_styles_background-color\":\"\",\"success-msg_styles_border\":\"\",\"success-msg_styles_border-style\":\"\",\"success-msg_styles_border-color\":\"\",\"success-msg_styles_color\":\"\",\"success-msg_styles_height\":\"\",\"success-msg_styles_width\":\"\",\"success-msg_styles_font-size\":\"\",\"success-msg_styles_margin\":\"\",\"success-msg_styles_padding\":\"\",\"success-msg_styles_display\":\"\",\"success-msg_styles_show_advanced_css\":\"0\",\"success-msg_styles_advanced\":\"\",\"error_msg_styles_background-color\":\"\",\"error_msg_styles_border\":\"\",\"error_msg_styles_border-style\":\"\",\"error_msg_styles_border-color\":\"\",\"error_msg_styles_color\":\"\",\"error_msg_styles_height\":\"\",\"error_msg_styles_width\":\"\",\"error_msg_styles_font-size\":\"\",\"error_msg_styles_margin\":\"\",\"error_msg_styles_padding\":\"\",\"error_msg_styles_display\":\"\",\"error_msg_styles_show_advanced_css\":\"0\",\"error_msg_styles_advanced\":\"\",\"changeEmailErrorMsg\":\"Vul hier een geldig e-mail adres is\",\"confirmFieldErrorMsg\":\"Deze velden moeten gelijk zijn\",\"fieldNumberNumMinError\":\"Number Min Error\",\"fieldNumberNumMaxError\":\"Number Max Error\",\"fieldNumberIncrementBy\":\"Please increment by \",\"formErrorsCorrectErrors\":\"Corrigeer de velden waar nodig\",\"validateRequiredField\":\"This field is required\",\"honeypotHoneypotError\":\"Honeypot Error\",\"fieldsMarkedRequired\":\"Fields with a * are required\",\"currency\":\"EUR\",\"unique_field_error\":\"A form with this value has already been submitted.\",\"drawerDisabled\":false,\"allow_public_link\":\"0\",\"embed_form\":\"\",\"changeDateErrorMsg\":\"Please enter a valid date!\",\"repeatable_fieldsets\":\"\",\"ninjaForms\":\"Ninja Forms\",\"fieldTextareaRTEInsertLink\":\"Insert Link\",\"fieldTextareaRTEInsertMedia\":\"Insert Media\",\"fieldTextareaRTESelectAFile\":\"Select a file\",\"formHoneypot\":\"If you are a human seeing this field, please leave it empty.\",\"fileUploadOldCodeFileUploadInProgress\":\"File Upload in Progress.\",\"fileUploadOldCodeFileUpload\":\"FILE UPLOAD\",\"currencySymbol\":\"&euro;\",\"thousands_sep\":\",\",\"decimal_point\":\".\",\"siteLocale\":\"en_US\",\"dateFormat\":\"d\\\/m\\\/Y\",\"startOfWeek\":\"1\",\"of\":\"of\",\"previousMonth\":\"Previous Month\",\"nextMonth\":\"Next Month\",\"months\":[\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\"],\"monthsShort\":[\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov\",\"Dec\"],\"weekdays\":[\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"],\"weekdaysShort\":[\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\"],\"weekdaysMin\":[\"Su\",\"Mo\",\"Tu\",\"We\",\"Th\",\"Fr\",\"Sa\"],\"recaptchaConsentMissing\":\"reCaptcha validation couldn&#039;t load.\",\"recaptchaMissingCookie\":\"reCaptcha v3 validation couldn&#039;t load the cookie needed to submit the form.\",\"recaptchaConsentEvent\":\"Accept reCaptcha cookies before sending the form.\",\"currency_symbol\":\"&euro;\",\"beforeForm\":\"\",\"beforeFields\":\"\",\"afterFields\":\"\",\"afterForm\":\"\"};form.fields=[{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":1,\"idAttribute\":\"id\",\"label\":\"Name\",\"key\":\"name_1563891814361\",\"type\":\"textbox\",\"created_at\":\"2016-08-24 16:39:20\",\"label_pos\":\"above\",\"required\":1,\"input_limit_type\":\"characters\",\"input_limit_msg\":\"Character(s) left\",\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"cellcid\":\"c3277\",\"field_label\":\"Name\",\"field_key\":\"name_1563891814361\",\"default\":\"\",\"placeholder\":\"\",\"container_class\":\"\",\"element_class\":\"\",\"input_limit\":\"\",\"manual_key\":\"\",\"admin_label\":\"\",\"help_text\":\"\",\"mask\":\"\",\"custom_mask\":\"\",\"custom_name_attribute\":\"\",\"personally_identifiable\":\"\",\"value\":\"\",\"drawerDisabled\":\"\",\"id\":45,\"beforeField\":\"\",\"afterField\":\"\",\"parentType\":\"textbox\",\"element_templates\":[\"textbox\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap\"},{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":2,\"idAttribute\":\"id\",\"label\":\"Email address\",\"key\":\"email_address_1639238883085\",\"type\":\"email\",\"created_at\":\"2016-08-24 16:39:20\",\"label_pos\":\"above\",\"required\":1,\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"cellcid\":\"c3281\",\"custom_name_attribute\":\"email\",\"personally_identifiable\":1,\"field_label\":\"E-mail address\",\"field_key\":\"e-mail_address_1563891858757\",\"default\":\"\",\"placeholder\":\"\",\"container_class\":\"\",\"element_class\":\"\",\"admin_label\":\"\",\"help_text\":\"\",\"value\":\"\",\"drawerDisabled\":false,\"id\":46,\"beforeField\":\"\",\"afterField\":\"\",\"parentType\":\"email\",\"element_templates\":[\"email\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap\"},{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":5,\"idAttribute\":\"id\",\"label\":\"Message\",\"key\":\"message_1563891864044\",\"type\":\"textarea\",\"created_at\":\"2016-08-24 16:39:20\",\"label_pos\":\"above\",\"required\":1,\"input_limit_type\":\"characters\",\"input_limit_msg\":\"Character(s) left\",\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"cellcid\":\"c3284\",\"drawerDisabled\":false,\"field_label\":\"Message\",\"field_key\":\"message_1563891864044\",\"default\":\"\",\"placeholder\":\"\",\"container_class\":\"\",\"element_class\":\"\",\"input_limit\":\"\",\"manual_key\":\"\",\"admin_label\":\"\",\"help_text\":\"\",\"textarea_rte\":\"\",\"disable_rte_mobile\":\"\",\"textarea_media\":\"\",\"value\":\"\",\"id\":47,\"beforeField\":\"\",\"afterField\":\"\",\"parentType\":\"textarea\",\"element_templates\":[\"textarea\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap\"},{\"objectType\":\"Field\",\"objectDomain\":\"fields\",\"editActive\":false,\"order\":6,\"idAttribute\":\"id\",\"label\":\"Send\",\"key\":\"send_1563891884697\",\"type\":\"submit\",\"created_at\":\"2016-08-24 16:39:20\",\"processing_label\":\"SENDING\",\"element_class\":\"sh-button sh-button-xlarge \",\"wrap_styles_show_advanced_css\":0,\"label_styles_show_advanced_css\":0,\"element_styles_show_advanced_css\":0,\"submit_element_hover_styles_show_advanced_css\":0,\"cellcid\":\"c3287\",\"drawerDisabled\":false,\"field_label\":\"Send\",\"field_key\":\"send_1563891884697\",\"container_class\":\"\",\"id\":48,\"beforeField\":\"\",\"afterField\":\"\",\"value\":\"\",\"label_pos\":\"above\",\"parentType\":\"textbox\",\"element_templates\":[\"submit\",\"button\",\"input\"],\"old_classname\":\"\",\"wrap_template\":\"wrap-no-label\"}];nfForms.push(form);<\/script>\n        <\/p><\/div>\r\n\t<\/div>\r\n\r\n\r\n\t\t\r\n\r\n<\/div>\r\n<\/div>\n\n\t<\/div>\r\n<\/section>\r\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Ads add-on for Google Sheets Download Google Ads data to Google Sheets. GET THE ADD-ON This Google Sheets add-on helps you view and edit Google Ads data more easily&#8230;<\/p>\n","protected":false},"author":1,"featured_media":8806,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-7524","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Ads add-on for Google Sheets - Adformatic<\/title>\n<meta name=\"description\" content=\"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Ads add-on for Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Adformatic\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-11T09:00:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adformatic.com\/wp-content\/uploads\/Google-Ads-add-on-banner-20230406.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Google Ads add-on for Google Sheets\" \/>\n<meta name=\"twitter:description\" content=\"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/\",\"url\":\"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/\",\"name\":\"Google Ads add-on for Google Sheets - Adformatic\",\"isPartOf\":{\"@id\":\"https:\/\/adformatic.com\/en\/#website\"},\"datePublished\":\"2021-10-13T12:23:14+00:00\",\"dateModified\":\"2025-09-11T09:00:13+00:00\",\"description\":\"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.\",\"breadcrumb\":{\"@id\":\"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/adformatic.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Ads add-on for Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/adformatic.com\/en\/#website\",\"url\":\"https:\/\/adformatic.com\/en\/\",\"name\":\"Adformatic\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/adformatic.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/adformatic.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/adformatic.com\/en\/#organization\",\"name\":\"Adformatic\",\"url\":\"https:\/\/adformatic.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png\",\"contentUrl\":\"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png\",\"width\":128,\"height\":128,\"caption\":\"Adformatic\"},\"image\":{\"@id\":\"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Ads add-on for Google Sheets - Adformatic","description":"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.","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:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"Google Ads add-on for Google Sheets","og_description":"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.","og_url":"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/","og_site_name":"Adformatic","article_modified_time":"2025-09-11T09:00:13+00:00","og_image":[{"width":1200,"height":627,"url":"https:\/\/adformatic.com\/wp-content\/uploads\/Google-Ads-add-on-banner-20230406.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_title":"Google Ads add-on for Google Sheets","twitter_description":"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.","twitter_misc":{"Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/","url":"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/","name":"Google Ads add-on for Google Sheets - Adformatic","isPartOf":{"@id":"https:\/\/adformatic.com\/en\/#website"},"datePublished":"2021-10-13T12:23:14+00:00","dateModified":"2025-09-11T09:00:13+00:00","description":"Download Google Ads data to Google Sheets. Easily configure, edit and schedule your Google Ads reports.","breadcrumb":{"@id":"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adformatic.com\/en\/google-ads-add-on-for-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/adformatic.com\/en\/"},{"@type":"ListItem","position":2,"name":"Google Ads add-on for Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/adformatic.com\/en\/#website","url":"https:\/\/adformatic.com\/en\/","name":"Adformatic","description":"","publisher":{"@id":"https:\/\/adformatic.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adformatic.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/adformatic.com\/en\/#organization","name":"Adformatic","url":"https:\/\/adformatic.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png","contentUrl":"https:\/\/adformatic.com\/wp-content\/uploads\/favicon.png","width":128,"height":128,"caption":"Adformatic"},"image":{"@id":"https:\/\/adformatic.com\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/7524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/comments?post=7524"}],"version-history":[{"count":18,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/7524\/revisions"}],"predecessor-version":[{"id":9869,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/7524\/revisions\/9869"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/media\/8806"}],"wp:attachment":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/media?parent=7524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}