{"id":3114,"date":"2019-11-28T10:02:33","date_gmt":"2019-11-28T09:02:33","guid":{"rendered":"https:\/\/adformatic.com\/?page_id=3114"},"modified":"2025-06-11T17:01:26","modified_gmt":"2025-06-11T15:01:26","slug":"reporting-for-google-analytics-4","status":"publish","type":"page","link":"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/","title":{"rendered":"Google Analytics 4 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-f15fa6926532404663fb0792d76672a5\" class=\"sh-text-block\">\r\n\t<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Google Analytics 4 (GA4) add-on for Google Sheets<\/span><\/h1><\/div>\r\n\r\n<div id=\"text-block-f2232bca6a8d17218d79b86b6f975d7b\" class=\"sh-text-block\">\r\n\t<p style=\"text-align: center;\"><span style=\"font-size: 18px; color: #ffffff;\">Easily configure your reports and download Google Analytics 4 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\/deltas_for_google_analytics\/126881055683\" 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<div class=\"sh-output-html\">\r\n\t<span id=\"video-tutorial\"><\/span><\/div>\r\n\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 Analytics 4 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-96f853b93844eddb333baba779f0e79c 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 style=\"max-width: 600px;\">\n<div class=\"video-container\" align=\"left\"><iframe src=\"https:\/\/www.youtube.com\/embed\/nLGDQFFxej8?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\r\n<div class=\"sh-column sh-column-988b432093ff13aad23f16327f5beed8 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<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 run and update automatically\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\tCompare two periods and sort by the delta of the metrics\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\tEasily create reports with data from multiple Google Analytics 4 properties\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\/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-c1b1abda81853ed6a83771eeccd5a955 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-1dbf30e234abd69c09c2270a6cdaefc1 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-ff7b5af4977202ccdbd10e7f1e903dfc\" class=\"sh-text-block\">\r\n\t<p><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><br \/><span style=\"color: #40414d;\">Awesome and fast plugin when you want to extract data from GA4 tot Google Spreadsheet! Easy to use but also great support when you have questions.<\/span><br \/><span style=\"color: #40414d;\"><strong>Willem Bijenhof<\/strong>, Valantic<\/span><\/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-82da9a14ed9570890d8e0f1a23a5ee37 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-ac6ab4842347b71970144bf97fd85f99\" class=\"sh-text-block\">\r\n\t<p><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><i class=\"fa fa-star\"><\/i><br \/><span style=\"color: #40414d;\">Great add-on \ud83d\udc4c\ud83c\udffb Works great, super fast and is very affordable. They took a lot of time to answer questions that I had. Really great product.<\/span><br \/><span style=\"color: #40414d;\"><strong>Leon Korteweg<\/strong>, freelance<\/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\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\tGet your subscription\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 Analytics 4 add-on for Google Sheets for free for 14 days. If you wish to continue using the add-on after the free trial period, please subscribe. Each subscription includes:<\/p><\/div>\r\n\r\n<ul class=\"sh-list sh-list-style1\" id=\"list-73640ec234f6e683ad73daa8ed60b2a2\">\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\tUnlimited GA4 properties\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\tUnlimited reports (Google&#039;s quotas and Sheets limits apply.)\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\tUp to hourly automated refreshes\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\tEmail support\t\t<\/li>\r\n\t<\/ul>\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\/reporting-for-google-analytics-4\" 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\tSUBSCRIBE\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=\"#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 Reporting for Google Analytics 4 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 > Add-ons > Get add-ons<\/li><li>Find the \u201cReporting for Google Analytics 4\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 Analytics 4 data. Click on \"Allow\".<\/li><li>The add-on is now installed. The \"Reporting for Google Analytics 4\" 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 GA4 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-on's sidebar. To use the sidebar, select \"Extensions\" &gt; \"Reporting for Google Analytics 4\" &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 Analytics 4 account and property information.<\/li><li>Selecting dimensions and metrics. Including custom metrics, dimensions, events and conversions.<\/li><li>Apply simple metric filters.<\/li><li>Apply simple dimension 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 \u201cConfiguration GA4 reports\u201d (if this sheet does not already exist, it will be created).<\/p><p>You can go through these steps again to add another 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 GA4 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-f0343b18e7b59170cffed884cff29635 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-e36ae02e16e290f5df378f808d84c1eb 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-28a1c10d7ed77ca77ac6ecda0d524731 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-aa85276c209109198b2be45ad9540246\">\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 GA4 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-823d9423f53101c1746cdd28b1d54721\" class=\"sh-text-block\">\r\n\t<p>There are two ways to delete 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; \"Reporting for Google Analytics 4\" &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; \"Reporting for Google Analytics 4\" &gt; \"Schedule Reports\".<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=\"single-image-2427c12e7b5393acb66af447b71ac0ae\" 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: 711px;\">\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\t\t\t\t\t\t<a href=\"\/\/adformatic.com\/wp-content\/uploads\/Google-Analytics-4-set-schedule-5.png\" rel=\"lightbox\">\r\n\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: 39.803094233474%;\">\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-Analytics-4-set-schedule-5.png\" alt=\"Google Analytics 4 - set schedule\" \/>\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\t\t<\/a>\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\r\n<div id=\"text-block-da55bb269e84fd9efae510934a18520b\" 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-0a939bbca5fed8e678243dfe3fcde115 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-9396ac6a4846aa2314ab22cf4f34cbd2 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-7e9aca2693a998ab2a2c73ec8b076fa7\">\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\tQuotas\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-3e040980678f72eb0bd39894e92bc210\" class=\"sh-text-block\">\r\n\t<p>This Google Sheets add-on uses the Google Analytics data API. The use of this API is limited by Google. Here you can see which quotas apply: <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/quotas\">https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/quotas<\/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-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\tProperty 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 Analytics 4 property. You can use the sidebar to find out the id. You can also find the ID in the Google Analytics 4 UI (in the admin section or the url).\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\tProperty 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 Analytics 4 property. The property name is filled in by the sidebar. If you enter a report configuration directly to the sheet and leave the property 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 Analytics 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 Analytics 4 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 Analytics 4 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 Analytics 4 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\tMetrics\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\tA list of metrics for the report. Metrics can be specified in two ways:\r\n<ul>\r\n<li>As a list of comma or new-line separated metric ids. For example: newUsers, sessions.<\/li>\r\n<li>As a JSON value in the format specified in the <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/Metric\" target=\"_blank\" >documentation for the Google Analytics 4 data API<\/a>.<\/li>\r\n<\/ul>\r\n<br>\r\nIn most scenarios, a list of metric ids will suffice. JSON allows you to create a mathematical expression for derived metrics. For example, the number of events per user is eventCount\/totalUsers.\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\tDimensions\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\tA list of dimensions for the report. Dimensions can be specified in two ways:\r\n<ul>\r\n<li>As a list of comma or new-line separated dimension ids. For example: country, landingPage.<\/li>\r\n<li>As a JSON value in the format specified in the <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/Dimension\" target=\"_blank\" >documentation for the Google Analytics 4 data API<\/a>.<\/li>\r\n<\/ul>\r\n<br>\r\nIn most scenarios, a list of dimensions ids will suffice. JSON allows you to create a dimensionExpression. One dimension can then be the result of an expression of several dimensions. For example dimension \"country, city\": concatenate(country, \", \", city).\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\tMetric filters\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\tFilters can be used to limit the data in the report. Metric filters can be specified in two ways:\r\n<ul>\r\n<li>As a filter expression in JSON as specified in the <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/FilterExpression\" target=\"_blank\"> documentation for the Google Analytics 4 data API<\/a>.<\/li>\r\n<li>As a simpler text expression. <a href=\"#filter-as-text-expression\">View the explanation<\/a>.<\/li>\r\n<\/ul>\r\n<br>\r\nWhile the text expression is easier to read, JSON can be more flexible in complex scenarios.\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\tDimension filters\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\tFilters can be used to limit the data in the report. Dimension filters can be specified in two ways:\r\n<ul>\r\n<li>As a filter expression in JSON as specified in the <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/FilterExpression\" target=\"_blank\"> documentation for the Google Analytics 4 data API<\/a>.<\/li>\r\n<li>As a simpler text expression. <a href=\"#filter-as-text-expression\">View the explanation<\/a>.<\/li\r\n<\/ul>\r\n<br>\r\nWhile the text expression is easier to read, JSON can be more flexible in complex scenarios.\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\tOrder by\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 determines how the rows are sorted in the report. By default, the reports are sorted by the first metric descending. But you can adjust this in two ways:\r\n<ul>\r\n<li>The Order by expression as JSON as described in the <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/OrderBy\" target=\" _blank\">documentation for the Google Analytics 4 data API<\/a>.<\/li>\r\n<li>It is also possible to enter the rules with a simpler text expression. <a href=\"#order-by-as-text-expression\">View the explanation<\/a>.<\/li>\r\n<\/ul>\r\n<br>\r\n\r\nWhile the text expression is easier to read, JSON can be more flexible in complex scenarios.\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\tComparisons\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\tComparisons enable you to compare subsets of your data in one report. \r\nThe comparison column is automatically added to the report. \r\nComparisons can be specified in two ways:\r\n<ul>\r\n<li>As a comparison in JSON as specified in the <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/rest\/v1beta\/Comparison\" target=\"_blank\"> documentation for the Google Analytics 4 data API<\/a>.<\/li>\r\n<li>As a simpler text expression. <a href=\"#filter-as-text-expression\">View the explanation<\/a>.<\/li\r\n<\/ul>\r\n<br>\r\nWhile the text expression is easier to read, JSON can be more flexible in complex scenarios. The sidebar allows you to easily select comparisons created in the Google Analytics 4 web interface.\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\tCurrency code\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\tA currency code in ISO 4217 format, such as \"USD\", \"EUR\", \"JPY\". If the field is empty, the report uses the default currency of the Google Analytics 4 property.\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\tInclude empty rows\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 the value here is FALSE or not specified, then only rows are included where at least one of the metrics has a value above 0. If the value is TRUE, these rows are displayed.\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\tDelta order\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\tWhen two periods are compared, the report is sorted by the delta of the first metric. By default, the sorting is \"descending\", but you can change this to \"ascending\" by entering \"ascending\" here. This only works when the \"Order by\" field is empty, otherwise the expression in the \"Order by\" field is applied to the dimensions or the metrics of the first date range.\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\tDelta threshold\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\tEnter a numeric value to limit the rows displayed based on a minimum or maximum value of the delta (the difference between the periods for the first metric). When the report is ordered descending, only rows with a delta equal to or greater than the threshold are shown. When the report is ordered ascending only rows with a delta less than or equal to the threshold 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\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\tSeparator\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\tHere you can define the separator that is used with the metrics filters, dimension filters and order by text expressions. The separator is only needed if the value is entered using a text expression. When the value is entered as JSON, the separator is not needed.\r\n\r\nA separator is used to properly interpret the text expression for the metric filter, dimension filters and order by. By default, this separator is two underscores (__). When two underscores occur (one after the other) in one of the fields or in the value, this can lead to conflicts. In this case, you can set a different separator (for example: _**_).\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\tSpreadsheet URL\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 is written to the current spreadsheet by default. Enter the URL of a different Google Sheets spreadsheet to write the report to that spreadsheet. You can give this add-on access to the other spreadsheet by sharing the spreadsheet with \"ga4-add-on@adformatic-tools.iam.gserviceaccount.com\" (This service account needs editor access to be able to write to the spreadsheet.)\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\tShow quotas\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 used and remaining quotas are not shown in the header of the report. Set this value to \"TRUE\" to display the quotas. More information about Google's quotas: https:\/\/developers.google.com\/analytics\/devguides\/reporting\/data\/v1\/quotas\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\tUpdate mode\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\tThere are three update modes available:<br>\r\n<ol>\r\n<li><strong>OVERWRITE<\/strong>: This is the default mode, the report data overwrites any previous report data.<\/li>\r\n<li><strong>APPEND<\/strong>: Set this field to \"APPEND\" if you wish to append the new data to the existing report data. If one of the following date dimensions is included in the report: \"date\", \"isoYearIsoWeek\", \"yearWeek\", \"yearMonth\", \"year\", rows with the same value for this dimension will be overwritten by the new report data. This allows you to, for example, set a report to run daily and add data from the last three days, ensuring you always have the most recent data. (Note: Google Analytics 4 may require more than 24 hours to process all data.) This mode may require more processing time, so consider limiting the number of reports per spreadsheet.<\/li>\r\n<li><strong>APPEND_SIMPLE<\/strong>: This mode appends the data from the new report below the existing data in the sheet. It's efficient and quick but does not overwrite data with matching dates.<\/li>\r\n<\/ol>\r\n<br>\r\nNote: When \"APPEND\" or \"APPEND_SIMPLE\" is used, the total values are disabled. Furthermore, appending data is not possible when comparing two date ranges.\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-1b006a6e4f50cf10208b1b2fec1c75cd 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-478dab1e16a2ba150a691592dce8d7df 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=\"filter-as-text-expression\"><\/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-4a922d123102162b041159e0f28d0f86 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-f2d800c9892740ef5b186c8b4f75d121\">\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\tWrite a filter expression as text expression\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-524a87ef1844dafb210a0868ae4ea851\" class=\"sh-text-block\">\r\n\t<p>A filter expression can limit the number of rows based on the values of the metrics or the values of the dimensions in the report.<\/p><\/div>\r\n\r\n<div id=\"text-block-3edf57018a00e4b9584bf5f2e90bf3d5\" class=\"sh-text-block\">\r\n\t<h3>Metric filters as text expression<\/h3><p>A metric filter filters based on the value of the metrics.<br \/>A metric filter expression always consists of three parts:<\/p><ul><li>A metric (e.g. sessions)<\/li><li>An operator (e.g. greater than (&gt;))<\/li><li>A value (e.g. 30)<\/li><\/ul><p>An example of a filter is: <\/p><div class=\"codeExamples\">sessions__&gt;__30<\/div><p>This filter ensures that only rows with more than 30 sessions are included. Rows with 30 sessions or less are not included in the report.<\/p><p><strong>Metric operators<\/strong><br \/>The following operators are available for metric filters:<\/p><ul><li>Greater than: &gt;<\/li><li>Less than: &lt;<\/li><li>Greater than or equal to: &gt;=<\/li><li>Less than or equal to: &lt;=<\/li><li>Equal to: =<\/li><\/ul><\/div>\r\n\r\n<div id=\"text-block-94fa77c1b7f6c1647e52a0c6c48ccc59\" class=\"sh-text-block\">\r\n\t<h3>Dimension filters as text expression<\/h3><p>A dimension filter filters based on the value of the dimensions. A dimension filter expression always consists of three parts:<\/p><ul><li>A dimension (e.g. sessions)<\/li><li>An operator (e.g. contains)<\/li><li>A value (e.g. \u201cgoogle\u201d)<\/li><\/ul><p>An example of a filter is:<\/p><div class=\"codeExamples\">sessionSource__contains__google<\/div><p>This filter ensures that only rows where the sessionSource contains \"google\" are included. Rows where the sessionSource does not contain \u201cgoogle\u201d are not included in the report.<\/p><div class=\"codeExamples\">country__IN__belgium,netherlands,france<\/div><p>This filter ensures that only rows where the country is either \"belgium\", \"netherlands\" or \"france\" are included. <\/p><p><strong>Dimension operators<\/strong><\/p><p>The following operators are available for dimension filters:<\/p><ul><li>CONTAINS<\/li><li>BEGINS_WITH<\/li><li>ENDS_WITH<\/li><li>EXACT<\/li><li>FULL_REGEXP<\/li><li>PARTIAL_REGEXP<\/li><li>IN<\/li><\/ul><\/div>\r\n\r\n<div id=\"text-block-fb1eab61343735e034f1998ad99efffc\" class=\"sh-text-block\">\r\n\t<h3>Comparisons as text expression<\/h3><p>A comparison can be written in two ways:<\/p><ul><li>The comparison ID, to reference a comparison created in the Google Analytics 4 web interface.<\/li><li>As a dimension filter.<\/li><\/ul><p>An example of two comparisons created in the web interface is:<\/p><div class=\"codeExamples\">comparisons\/paidTraffic, comparisons\/organicTraffic<\/div><p>Including this comparison will add the comparison column to the report. The report will contain rows for \"comparisons\/paidTraffic\" and for \"comparisons\/organicTraffic\" if data is available.<\/p><p>An example of a comparison based on a dimension filter:<\/p><div class=\"codeExamples\">country__EXACT__netherlands<\/div><p>Including this comparison will add the comparison column to the report. The report will contain rows where the dimension filter condition is met. In this case, where the country is \"netherlands.\"<\/p><p>It is possible to give the comparisons a name. The comparisons created in the web interface will already have a name; comparisons based on a filter will have a default name. To give the comparison a name, start the comparison by adding a name between square brackets. This is an example:<\/p><div class=\"codeExamples\">[Netherlands] country__EXACT__netherlands, [Custom paid traffic] comparisons\/12312312<\/div><\/div>\r\n\r\n<div id=\"text-block-3fddcf84f71d08a1442c54b91aab87fb\" class=\"sh-text-block\">\r\n\t<h3>Include or exclude<\/h3><p>By default, a filter will ensure that a report only contains data that meets the condition. It is also possible to exclude this data.<\/p><p>For example, an expression to exclude data looks like this:<\/p><div class=\"codeExamples\">NOT__sessions__&gt;__30<\/div><p>This filter ensures that the report only contains rows with 30 sessions or less.<\/p><div><\/div><div class=\"codeExamples\">NOT__sessionSource__contains__google<\/div><p>This filter ensures that the report only contains rows where \"google\" does not appear in the sessionSource.<\/p><\/div>\r\n\r\n<div id=\"text-block-08315af1e00572f8d67a513aae373f7d\" class=\"sh-text-block\">\r\n\t<h3>Separator<\/h3><p>The Google Analytics Data API (for Google Analytics 4) only accepts filters in the form of JSON. This Google Sheets add-on can interpret a string of text and convert it to JSON. In Google Analytics 4 it is possible to define custom metrics, custom dimensions, events and conversions. There are no naming restrictions for custom dimensions and metrics, and there are few restrictions for event names and conversions either.<\/p><p>In order to be able to interpret the text string properly, a separator is used. By default, this separator is two underscores (__). When two underscores occur (one after the other) in one of the fields or in the value, this can lead to conflicts. In this case, you can set a different separator (for example: _**_).<\/p><p>With a custom separator, the previously mentioned example would look like this:<\/p><div class=\"codeExamples\">sessions_**_&gt;_**_30<\/div><\/div>\r\n\r\n<div id=\"text-block-e9d73431daa0fb07954fadfea34cc758\" class=\"sh-text-block\">\r\n\t<h3>Combine filter expressions<\/h3><p>Filter expressions can be combined with each other. This can be done in two ways:<\/p><ul><li>AND: In this case both filter expressions must be TRUE (before and after pairing with AND).<\/li><li>OR: In this case only one of the two conditions mest be TRUE<\/li><\/ul><p>Examples of a combined filter expression are:<\/p><div class=\"codeExamples\"><p>sessions__&gt;__30__AND__newUsers__&gt;__20<\/p><\/div><div class=\"codeExamples\">sessions__&gt;__30__OR__purchaseRevenue__&gt;__0<\/div><p>A hyphen is always preceded and followed by a separator.<\/p><p>Filters for dimensions and metrics cannot be combined in one expression. The filters for dimensions and metrics must be specified separately.<\/p><\/div>\r\n\r\n<div id=\"text-block-5971cf0d21a075c9e6a6bc7d78ea128d\" class=\"sh-text-block\">\r\n\t<h3>Set priority<\/h3><p>If you want to combine more than two filter expressions, it may be necessary to prioritize them in order to group the correct expressions together. This can be done by adding parentheses. The expressions in parentheses are executed first.<\/p><p>Examples of prioritization with parentheses:<\/p><div class=\"codeExamples\">sessions__&gt;__30__OR__(newUsers__&gt;__20__AND__sessions__&gt;__20)<\/div><div class=\"codeExamples\">eventName__EXACT__Lead__AND__(country__EXACT__Germany__OR__country__EXACT__France__OR__country__EXACT__Belgium)<\/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-1ec461e6e525ee549c9ad7de55c1a83f 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-7b6e8612dd983fd47d8800d01e2fa68b 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=\"order-by-as-text-expression\"><\/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-be457b045344be605f64421398b68e02 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-db1d750800e435538ece5c4ff96ae496\">\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\tOrder by as text expression\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-b09f79ff2c9f8376ab1298e6c8546f46\" class=\"sh-text-block\">\r\n\t<p>With an order by text expression you can determine how a report is sorted.<\/p><p>An order by expression always consists of two parts:<\/p><ul><li>The name of a metric or dimension<\/li><li>The direction, there are two options for this:<ul><li>desc (descending)<\/li><li>asc (ascending)<\/li><\/ul><\/li><\/ul><p>An example of an order by expression is:<\/p><div class=\"codeExamples\">newUsers__asc<\/div><p>This rule sorts the report in ascending order by the newUsers metric.<\/p><p>A separator is used between the name of the dimension or metric and the direction. By default, this separator is two underscores (__). When this separator conflicts with your dimensions or metrics, you can adjust the separator. This can be done in the spreadsheet in the row \u201cSeparator\u201d.<\/p><p>Order by rules can also be combined with each other. This can be done by separating the expressions with a comma.<br \/>An example of a combined expression is:<\/p><div class=\"codeExamples\">newUsers__desc, city__asc<\/div><p>This rule sorts the report descending by the newUsers metric and ascending by city.<br \/>Dimensions are sorted alphabetically and are case insensitive. When this is undesirable, enter the order by rules as JSON.<\/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-afff1582d4e9491259050875ce0a4f0e 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 id=\"text-block-1f40c1ee21890840524a46763554942b\" class=\"sh-text-block\">\r\n\t<h3>Terms<\/h3><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-b2dde59d4430433bb498b0628e60d109 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 fw-col-sm-9 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-c11eae869c5aeb72d8556d6b60b8710b\">\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 Analytics 4 (GA4) add-on for Google Sheets Easily configure your reports and download Google Analytics 4 data to Google Sheets. GET THE ADD-ON This Google Sheets add-on helps you&#8230;<\/p>\n","protected":false},"author":1,"featured_media":8456,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3114","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 Analytics 4 add-on for Google Sheets - Adformatic<\/title>\n<meta name=\"description\" content=\"Easily configure your reports and download Google Analytics 4 data to Google Sheets.\" \/>\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\/reporting-for-google-analytics-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Analytics 4 add-on for Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Easily configure your reports and download Google Analytics 4 data to Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Adformatic\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:01:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adformatic.com\/wp-content\/uploads\/Google-Analytics-4-add-on-for-Google-Sheets-1200x627-1.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 Analytics 4 add-on for Google Sheets\" \/>\n<meta name=\"twitter:description\" content=\"Easily configure your reports and download Google Analytics 4 data to Google Sheets.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/adformatic.com\/wp-content\/uploads\/Discover-changes-in-your-data-faster-1200x627-1.png\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/\",\"url\":\"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/\",\"name\":\"Google Analytics 4 add-on for Google Sheets - Adformatic\",\"isPartOf\":{\"@id\":\"https:\/\/adformatic.com\/en\/#website\"},\"datePublished\":\"2019-11-28T09:02:33+00:00\",\"dateModified\":\"2025-06-11T15:01:26+00:00\",\"description\":\"Easily configure your reports and download Google Analytics 4 data to Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/adformatic.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Analytics 4 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 Analytics 4 add-on for Google Sheets - Adformatic","description":"Easily configure your reports and download Google Analytics 4 data to Google Sheets.","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\/reporting-for-google-analytics-4\/","og_locale":"en_US","og_type":"article","og_title":"Google Analytics 4 add-on for Google Sheets","og_description":"Easily configure your reports and download Google Analytics 4 data to Google Sheets.","og_url":"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/","og_site_name":"Adformatic","article_modified_time":"2025-06-11T15:01:26+00:00","og_image":[{"width":1200,"height":627,"url":"https:\/\/adformatic.com\/wp-content\/uploads\/Google-Analytics-4-add-on-for-Google-Sheets-1200x627-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_title":"Google Analytics 4 add-on for Google Sheets","twitter_description":"Easily configure your reports and download Google Analytics 4 data to Google Sheets.","twitter_image":"https:\/\/adformatic.com\/wp-content\/uploads\/Discover-changes-in-your-data-faster-1200x627-1.png","twitter_misc":{"Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/","url":"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/","name":"Google Analytics 4 add-on for Google Sheets - Adformatic","isPartOf":{"@id":"https:\/\/adformatic.com\/en\/#website"},"datePublished":"2019-11-28T09:02:33+00:00","dateModified":"2025-06-11T15:01:26+00:00","description":"Easily configure your reports and download Google Analytics 4 data to Google Sheets.","breadcrumb":{"@id":"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adformatic.com\/en\/reporting-for-google-analytics-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/adformatic.com\/en\/"},{"@type":"ListItem","position":2,"name":"Google Analytics 4 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\/3114","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=3114"}],"version-history":[{"count":58,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/3114\/revisions"}],"predecessor-version":[{"id":9821,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/pages\/3114\/revisions\/9821"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/media\/8456"}],"wp:attachment":[{"href":"https:\/\/adformatic.com\/en\/wp-json\/wp\/v2\/media?parent=3114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}