![]() This field is filled by the add-on, so you can easily when a report was last updated.Īlthough 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.įor this reason, we have created some predefined PMax reports that you might find useful. If TRUE, the report in the corresponding column is not executed. Set the value to "TRUE" to hide this report header. Leave this field blank to not send the report.īy default, extra information and the totals are shown above the report. The report is only sent if the report contains at least 1 row of data. The email addresses to which this report should be sent. If this parameter is left empty, all rows are shown. The maximum number of rows for the report. You can use the Google Ads API documentation or the Google Ads Query Builder to add the sorting directly to the sheet. You can use the sidebar to add the sorting, or add the sorting directly in the configuration sheet. This is the 'ORDER BY' part of the GAQL query send to the Google Ads API. The sort option allows you to determine in which order the rows are returned. You can use the Google Ads API documentation or the Google Ads Query Builder to add the filters directly to the sheet. You can use the sidebar to add the filters, or add the filters directly in the configuration sheet. This is the 'WHERE' part of the GAQL query send to the Google Ads API. The filters allows you to limit the data returned from Google Ads. You can also use the Google Ads API documentation or the Google Ads Query Builder to get the right column names. You can use the sidebar to select the columns, or enter the columns directly in the configuration sheet. This is the 'SELECT' part of the GAQL query send to the Google Ads API. The columns are all the fields, segments and metrics for your report. You can choose any report type listed here: This is the 'FROM' part of the GAQL query send to the Google Ads API. This is the end date of the date range you want to compare your Google Ads data with. You can specify a specific date formatted as YYYY-MM-DD or as a relative date. ![]() This is the start date of the date range you want to compare your Google Ads data with. ![]() View all possible options for relative dates You can specify a specific end date formatted as YYYY-MM-DD or as a relative date. The end date for retrieving Google Ads data. For example, the following expression returns the last day of the previous month: =EOMONTH(TODAY(), -1) You can also use the date functions of Google Sheets to specify this value programmatically. View all possible options for relative dates. XdaysAgo (X is a positive integer, for example 7daysAgo).You can specify a specific start date formatted as YYYY-MM-DD or as a relative date. The start date for retrieving Google Ads data. it will be fetched on the first run of the report. If you enter a report configuration directly to the sheet and leave the account name empty. The account name is filled in by the sidebar. Please enter the id in this format: XXX-XXX-XXXX. You can also find the ID in the Google Ads UI. ![]() You can use the sidebar to find out the id. This can be a Google Ads account or manager account. ![]() The ID of the Google Ads account you are logged in with. The report name is also the name of the sheet to which the data is written. If the name is not unique, a sequence number is automatically added to make it unique. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |