Measure Sessions & E-Commerce Data From Search Engines With Excel (Reporting)
Let’s assume that you need to prepare a basic excel spreadsheet that you need to report on your client in which you will report the sessions, including transactional data (transactions, revenue, ecommerce conversion rate). Sure, you could report it via a Custom Report from Analytics but you are kind of limited in what you report and you cannot the depth of data that you could do using a spreadsheet and a couple of functions/formulas.
This sample report, easily calculates for you the overall number of sessions, revenue, transactions and ecommerce conversion rate from each traffic source and you can know how all these KPIs perform per easy source.
All you need to do is to copy/paste the data from analytics and the spreadsheet will do the rest, either you copy/past 20 landing pages or 20,000.
I created an easy example of sports shoes (landing pages) and provided random figures using RANDBETWEEN for the sake of our example.