was successfully added to your cart.

How to Get Year on Year Organic Data in 5 Easy Steps

By April 16, 2014Reporting

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…

SEO-chart

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

yoy data

2.     Apply Organic traffic filter/segment or in your case just use the “Non-Paid Search” traffic segment.

organic traffic

3.     Select Month view in analytics

month-range

4.     Export

 You should be presented with visitor data that looks as follows:

 

export

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

how-to-transpose

It should transpose as follows:

transpose

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.)

monthlyimport

You can do this with anything you want YoY data for… traffic, goals, bounce rates.  Whatever tells your client that YOU are awesome….

About Simon

Internet Marketing specialist with over 5 years experience based in the North West.