Browse this list of metrics and find the column you would like to export. Let's say you are interested in following frequency. The API call to download the metric is, simply enough, "frequency".
Step 2: Create the Parameter in the Connector Advanced Editor
Go to your connector and enable the Advanced Editor. Then find the parameterssection in the query.
Add the frequency metric.
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 it 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".
TheCode 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 "frequency") and if it is, it will populate the column with those data.
After that, you are ready to save the adjustment and test it in the preview. In your newly customised template the results in your Excel sheet should look like this.
You should see a new column in a Data Preview
Note: If you are not sure what to do, contact your Client Success Manager. We will be happy to help you.