In this “How to”, we will use Data Explorer UI to export a spreadsheet (CSV) containing some metrics from a campaign breakdown by multiple dimensions. It allows us to dive deeper than the AB Tasty included reporting while still taking advantage of AB Tasty’s high quality statistical metrics.
To learn more about Data Explorer, refer to this article.
1. Defining the expected end result
We should first define the end results you want to exploit in the CSV output. These columns will be filled with metrics. For this example, let’s say that you are interested in the following metrics:
-
The number of visitors
-
The number of new visitors
-
The number of clicks
-
The conversion rate per user (not per session)
2. Defining the breakdown of the previously defined end results
Then, you must define the breakdown you want to apply. For this example, let’s say that you are interested in the following dimensions:
-
The country of the user
-
The device type (smartphone or desktop?)
3. Defining the campaigns and visitors concerned
By default, all campaigns and all visitors are included in your query. We can specify which campaign interests you and/or which population thanks to the filters. For our example:
-
We will focus on the campaign 491215: By using the campaign filter, you will exclude all hits that were triggered in sessions where the campaign 491215 has not been seen.
-
We will focus on the action tracker called “CTAsubmit”: By filtering hits with “Action tracker name (ea)” is equals to “CTASubmit”, only these hits will be taken into account in the computing of our metrics. Another solution may have been to use “Action tracker name (ea)” as a dimension in order to get results for each tracker in our CSV output.
4. Running the query
You can now run the query. To make sure your query is correct, we recommend you to run the query on a short period (ex: yesterday) to run the test while consuming few data.
Once you’re ok with your query, select the full period you need. You can now download the CSV output and analyze it by yourself in a spreadsheet app or with custom scripts.