In this “How to”, we will use Data Explorer UI to export a spreadsheet (CSV) containing page traffic data. This information is collected by AB Tasty, but not directly available in a raw format in the app. With Data Explorer, you can use these pageviews events to measure anything you want.
To learn more about Data Explorer, refer to this article.
1. Defining the expected end result
You 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 pageview metrics:
- The number of pageview
- The number of unique visitor for a specific page
2. Defining the breakdown of the previously defined metrics
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 page url: it will allow us to get every metric defined previously for each page of your website.
You may also use “Page title”, “Page Path” or even some specific parts of page path like “Page Path Level 1” to get a different breakdown according to your specific needs.
3. Defining the campaigns and visitors concerned
By default, all campaigns and all visitors are included in your query. You can specify which campaign interests you and/or which population thanks to the filters. For our example:
- We will observe data for all users, there is no need to filter on a specific campaign neither on a specific kind of user, session or hit.
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.