By connecting external data in the Rule Engine you can upload any data (like conversion type or phone calls) from any source (like a CRM or any 3rd party tool), and use it to apply changes in your Google Ads account. 

You can use metrics that are not available in Google Ads to change bids or change the status of your keywords.

How it works

The Rule Engine will give you the option of linking an external Google spreadsheet to a specific recipe. While building the recipe you can access the data columns from the spreadsheet and use them in rules. 

Setting up the Spreadsheet

To begin, you'll need to generate the data (e.g., conversion types) you'd like to use for bidding and put it on a Google spreadsheet. You can download our sample data spreadsheet to get a better idea.

Spreadsheet Configuration

To make sure the spreadsheet is accessible, it should have the correct sharing settings. The sharing settings should be set to Anyone with the link or be shared with the email rule-engine@optmyzr-automation.iam.gserviceaccount.com

There are mandatory columns you need to add to the spreadsheet. These columns depend on the level you will apply changes:

  • Changes at Keyword level: include Keyword ID and Ad Group ID (or Ad Group Name and Campaign Name)
  • Changes at Ad Group level: include Ad Group ID or (Ad Group Name and Campaign Name)
  • Changes at Product Level: include Product Group ID and Ad Group ID (or Ad Group Name and Campaign Name)

There shouldn't be duplicate IDs (at ad group and keyword/product group level) in the spreadsheet. The mandatory columns are required to enable the rule engine to match the data in the spreadsheet with the correct entity in Google Ads.

Installing Spreadsheet in the Rule Engine

After linking the spreadsheet, the system will pull all the columns and provide you an option to classify them as number or text. Specify the details and proceed to the next step (setting up the rules). 

It is important to classify each field correctly because it will define the operations you can perform on them. For example, if a numerical field is wrongly classified as a text field, it can't be used in a formula.

To understand how to use the Rule Engine to create custom recipes, watch this short video or read the help article.

Did this answer your question?