The advanced editor enables you to track most of the available metrics that Google Ads provides. Follow this short tutorial and unlock more growth for your business.
Note: It is advised to go through this walkthrough of the connector structure before reading this tutorial for better understanding of the customisation process.
You can follow almost every parameter from Google Ads platform, but you need to follow one rule to make it work:
Values in the query need to follow Google API documentation. You can find most of the supported columns here.
Now, let's get to adjusting the template.
Step 1: Decide Which Metric or Dimension to Add
Browse this list of metrics and find the column you would like to export. Let's say you are interested in tracking Average Cost per Click. The API call to download the metric is parameter AverageCpc.
Step 2: Create the Parameter in the Connector Advanced Editor
Go to your connector and enable the Advanced Editor. Then find the fieldssection in the query.
Add the AverageCpc.
Note: Don't forget to add a comma to separate it from the metric in the list before it.
Note #2: Watch out.JSON and its parameters are case-sensitive.
Step 3: Define the Metric
The last step is to add the parameter Time on Page to the dataset as a metric. It is very important as to call a parameter without a definition assigned to it, can lead to an error. To do this, add the new metric to the "transform list".
The Code defines the name of the column
The Source parameter is referring to the source parameter above the transform parameter. JSON will go and check if there is the same source (in this instance "AverageCpc") and if it is, it will populate the column with that data.
After that, you are ready to save the adjustment and test it in the preview. The results in your Excel sheet from your newly customised template should look like this:
You should see a new column in a Data Preview
Note: If you are not sure what to do, you can contact your Roivenue Support. We will be happy to help you.