# Google Ads Customization

{% hint style="info" %}
**Note:** It is advised to go through [this walkthrough](https://docs.roivenue.com/roivenue-resources/roivenue-connectors/connectors-overview/json-structure-description) of the connector structure before reading this tutorial for better understanding of the customisation process.
{% endhint %}

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.](https://docs.roivenue.com/roivenue-resources/roivenue-connectors/google-ads-customization/google-ads-supported-columns)

Now, let's get to adjusting the template.

### Step 1: Decide Which Metric or Dimension to Add

Browse [this list of metrics](https://docs.roivenue.com/roivenue-resources/roivenue-connectors/google-ads-customization/google-ads-supported-columns) 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***. 

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MVreDIzJjxeBlwqfPLJ%2F-MVu1BrT3mHR3yqFNGKK%2Faveragecpc.png?alt=media\&token=e4f64f88-7cf5-400b-9cd9-258431612cfb)

### Step 2: Create the Parameter in the Connector Advanced Editor

Go to your connector and enable the [Advanced Editor](https://docs.roivenue.com/roivenue-resources/roivenue-connectors/connectors-overview/advanced-editor). Then find the ***fields*** section in the query.

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MVreDIzJjxeBlwqfPLJ%2F-MVtz9S5Hob9VMG7Czaa%2FAWCT\).png?alt=media\&token=28eb944d-81ae-4254-9736-522b12367d59)

Add the ***AverageCpc***.

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MVreDIzJjxeBlwqfPLJ%2F-MVtzOc4HYx05iLksOAT%2FAWCT2.png?alt=media\&token=c6dbae41-4abe-42b9-8d64-7aeabaa97dd3)

{% hint style="info" %}
**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. 
{% endhint %}

### 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".

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MVGh6l4kLMnfRmfE3PM%2F-MVGuwJ4Vrdg2ZtAaggK%2Faverage%20cpc.png?alt=media\&token=d60c3316-9917-4ce5-b2ce-eeb85e258996)

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](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MW9JSTdQfNPsY_YHAEM%2F-MW9JW7XdbTzdJskbRFZ%2Fdata%20preview%202.png?alt=media\&token=aea6d5f6-be21-45c2-ab84-9d0625d67475)

{% hint style="info" %}
**Note:** If you are not sure what to do, you can contact your Roivenue Support. We will be happy to help you.
{% endhint %}