As an SEO, reporting on organic campaign performance is a must…
Clearly all SEO graphs look the dogs b****cks so they’ll straight away see the value in your presence…
But honestly when starting out a report it can be a bit of a ball ache until you really figure out some efficiencies.
All you want is data that shows you’re a legit SEO… But doing so can take a good chunk of your day just getting the data.
Want to turn a 15 minute task into a 3 minute task? Then read on..
My quick 5 step guide on using Analytics to extract non paid search traffic data over a custom period.
1. Set date range to start of previous year
2. Apply Organic traffic filter/segment or in your case just use the “Non-Paid Search” traffic segment.
3. Select Month view in analytics
4. Export
You should be presented with visitor data that looks as follows:
Treat 0 as 1 so selecting 0-11 = 1 calendar year
By selecting this data you can then transpose it and copy it straight into a report.
5. Transpose data
It should transpose as follows:
Which when pasted into your shiny new report it’ll fill out the YoY data up to the latest full calendar month (or whatever date range you selected.)
You can do this with anything you want YoY data for… traffic, goals, bounce rates. Whatever tells your client that YOU are awesome….