Google Ads - Search Query Reporting

Overview

If not used SQR before and don't have a connected google sheet, follow step 1 in SQR setup documentation. Once step 1 is completed, you can use the rest of the documentation to help set up the node using template variables and your SQR spreadsheet.

This workflow is strictly determined either FETCH or PUSH data, determine what metrics you want to pull, and what date range you want to pull. The sheet contains the rest of the instructions on how to apply filters on fetched data.

Variables

Name	Reference	Type	Required	Default	Options	Description
Account ID	ACCOUNT_ID	Alphanumeric	✅	-	-	Google Ads Account ID
Parent Account ID	PARENT_ACCOUNT_ID	Alphanumeric	✅	-	-	Google Ads Parent Account ID
Google Sheet ID	GOOGLE_SHEET_ID	Alphanumeric	✅	-	-	ID of you SQR google sheet, located between /d/"ID"/edit
Date Range	DATE_RANGE	Select	✅	YESTERDAY	Today: TODAY Yesterday: YESTERDAY Last 7 Days: LAST_7_DAYS Last Business Week: LAST_BUSINESS_WEEK This Month: THIS_MONTH Last Month: LAST_MONTH Last 14 Days: LAST_14_DAYS Last 30 Days: LAST_30_DAYS	Select the Date Range of SQR Data You Want to Pull into Your Spreadsheet.
Metric to Pull	METRICS_TO_PULL	Alphanumeric	✅	Clicks,Impressions,Avg. CPC,Cost	-	Enter the metrics and columns you want to pull into your Spreadsheet. The following options are: Clicks, Impressions, Interactions, Interaction Rate, CTR, Avg. CPC, Cost, Avg. Cost, Cost / Conv., Conversions, Conv. Rate.
Pull Data	PULL_DATA	Alphanumeric	✅	TRUE	-	Fetch SQR data and pull into your spreadsheet. Following options: TRUE, FALSE
Push Changes	PUSH_CHANGES	Alphanumeric	✅	FALSE	-	Push Spreadsheet Add/Negate tab information to Google Ads. Following options: TRUE, FALSE
Data Source	DATASOURCE	Select	✅	Alli Data Library	Alli Data Library Google Ads	Datasource to Pull SQR data from.
Error File Name	ERROR_FILE_NAME	Alphanumeric	✅	-	-	Name of the error file generated when keyword updates error
Error Folder Name	ERROR_FOLDER_NAME	Alphanumeric	➖	-	-	(Optional) Name of the folder where the error file will be downloaded
OAuth Code	OAUTH_AUTHORIZATION_CODE	Alphanumeric	✅	-	-	Authorization tokens needed for Google Ads Access. In order to get credentials for OAuth Code, State, and Response, add credentials using the blue "Use Credentials" button at the top and then click on "add credential group". Then follow the instructions, and save credential group to be easily identifiable. The user adding the credential group must HAVE ACCESS to the google ads account.
OAuth State	OAUTH_STATE	Alphanumeric	✅	-	-
OAuth Response	OAUTH_ACCESS_TOKEN_RESPONSE	Alphanumeric	✅	-	-

YAML

Below is the YAML template

YAML


source:
  template: Google Ads - Search Query Reporting
  inputs:
    ACCOUNT_ID:
    PARENT_ACCOUNT_ID:
    GOOGLE_SHEET_ID:
    DATE_RANGE: YESTERDAY
    METRICS_TO_PULL: Clicks,Impressions,Avg. CPC,Cost
    PULL_DATA: 'TRUE'
    PUSH_CHANGES: 'FALSE'
    DATASOURCE: Alli Data Library
    ERROR_FILE_NAME:
    ERROR_FOLDER_NAME:
    OAUTH_AUTHORIZATION_CODE:
    OAUTH_STATE:
    OAUTH_ACCESS_TOKEN_RESPONSE:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges: []