![]() Secondary Pivot Metric – Goal Conversions.This report will provide great data if you are looking to test your website in different environments, or to understand if there is a technical issue in a certain browser and operating system combination. Second Pivot metric – Completed Transaction.Adding a Goal Completion Metric will provide even further insights. This Pivot Table will break down sessions by each channel for both new and returning visitors showing data on which channels are reaching new audiences or encouraging users to return. Go to Acquisition – All Traffic – Channels then pivot by Source. You can compare sources that are sending a number of traffic types including organic and paid, organic and referral, display and referral, etc. This Pivot Table will overview each channel by the source sending traffic to your website. You can access this report by going to Behavior – Landing pages, then select pivot table view and pivot by Medium. This pivot table will give a clean data overview of sessions to each landing page sent by the different advertising mediums you are using in your marketing strategy. Here are some of my favorite pivot tables. It contains goal conversion rate, goal completions, and other conversion data.ĮCommerce – If you have eCommerce enabled, this category of metrics includes transactions, revenue, average order value, etc. Goals – This category will be split by the number of goals you have set-up in your view. Site Usage – This category includes metrics like sessions, % of new sessions, bounce rate, and pages per session. Summary – This category is selected by default and contains all metrics covered by the other categories. Once you select your metric category the metrics will be available from the drop down menu of the pivot metrics, as shown above. You can select the metrics you need at the very top of your report overview. There are four different categories of pivot metrics that you can select in your Google Analytics Pivot Table. A second one can be added by selecting it in the options next to the primary Pivot Metric. It will be the second column of the Pivot Table.Īdding a secondary pivot metric – By default, a Pivot Table will have only one metric. It is added in the same way, by clicking on the Secondary Dimension option. It can be changed in the drop down menu on the top left side of the pivot table.Īdding a secondary dimension – As in the default Data Table view, a secondary dimension can be added to a Pivot Table. ![]() Pivot Metrics – This is the primary metric that appeared in the report that was initially selected. ![]() It appears at the top row of the pivot table. Pivot by Dimension – This is a secondary dimension by which the report is pivoted. It is the first component of the pivot table. Primary Dimension – This is the primary dimension of the report that was initially selected. While this is similar to simply including a second dimension, a pivot table presents the data in a much easier to understand format. The pivot table will include the original report with an option to pivot the data by a secondary dimension. Google Analytics also includes an option to visualize the report in a Pivot Table. These options are available next to the option to filter your data. In addition to data table (the default setting), visualization options in Google analytics include Percentage, Performance and Comparison. I’ll show you how to modify pivot table options, structure and format to better analyze and understand website performance. In this post I’ll discuss how to take advantage of Pivot Tables. This setting can be changed to present data in another visual format. By default, Google Analytics loads reports in the data table view.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |