You can follow and export almost every metric and dimension that Google provides using our connectors.
There are few rules to follow when adjusting Google Analytics templates:
Values in the query need to follow Google API documentation. You can find most of the supported values on this page.
ROIVENUE provides two kinds of Google Analytics Templates:
Campaigns Daily is for "performance" metrics like sessions, clicks, hits, etc.
Transaction Daily is for lists of transactions with metrics like transaction tax, etc.
It is advised to change transaction-related metrics in the Transaction template and Campaign-related metrics in the Campaigns daily template.
Adjusting the template isn't as hard as it sounds. It requires only three steps:
Browse the supported metrics and find the new column you would like to export. Let's say you want to download Time on Page (per user) from Google Analytics. The API call to download that metric is ga:timeOnPage. It is a performance metric, so it's best if you use the Campaign's Daily Template.
Go to your connector and enable the Advanced Editor. Then find the metrics and dimensions section in the query.
Add ga:timeOnPage, to the metrics section.
The last step is to add the parameter Time on Page to the data set as a metric. It can't be called unless a definition is assigned to it. To do this, add the new metric to the "transform list".
The Code defines the name of the column
The Datatype is what type of data are you storing in the cells. Long is a value, that tells the JSON to store integers in it.
The ConceptType is saying if the field is metric or dimension.
The SemanticType tells you how and in which format should the field be threated.
The source parameter is referring to the source parameter from the second part of the query. The connector checks if the value in the source field refers to the same field from the second part and if yes, it populates the column with that data.
After that, you are ready to save the adjustment and test it in the Preview section of your connector. The results in your Excel sheet from your newly customised template should look like this: