The weighted sort feature helps to quickly find data that is of statistical significance, so that exceptional cases do not get interpreted as major factors. See how to do this with Google Analytics and also when to use Excel for additional metrics.
[Instructor] We're going to explore Weighted Sort…as an alternative option with Excel.…I'll talk you through the reasons…why it might be needed.…First let's produce a report.…In the left column, expand the Behavioral tab,…and then also expand the side content…and you can select Landing Pages.…In theory of course you could select any other metric.…What we see here standard, and the report shows us data…sorted by landing page, and it will be the landing page…with the most visits.…
If we're interested in Bounce Rates,…we'll just go and click on that metric…and you'll see that the page is sorted…by the hightest bound rate.…If you click on the same metric again…the inverse will apply since it…now shows as the lowest count of the same metric.…The challenge however, is when we start…to look a metrics like Average Session Duration.…If we click on it, you'll see that…the pages with the highest session duration…will appear, but we have insignificant numbers…within the sessions column.…
We've got pages with one or two sessions…
Note: This course picks up where Google Analytics Essential Training leaves off. If you have questions about how Google Analytics works straight out of the box, see that course for more information.
This course is part of a Learning Path approved by the American Marketing Association.
Gain the skills you need to become an AMA Professional Certified Marketer (PCM) in Digital Marketing by using the industry-leading courses and resources in the Learning Path. Take the AMA certification exam to show that you have what it takes to lead the digital transformation.
- Measuring the performance of search engines over time through segmentation
- Doing more with analytics
- Understanding user intent
- Setting up site search
- Using content grouping
- Building customized team reports
- Setting up operational dashboards
- Fault reporting with segmentation
- Conversion rate analysis
- Creating a custom attribution model