Thanks to all the MozConners who attended Marshall’s session on Big Data.
Here’s the link to the SEO DASHBOARD he mentioned in his deck, and here’s a quick primer on how to use the dashboard.
1) The “Summary” tab is where all the charts live.
2) The “Data for Charts” tab references the raw data that lives in the “Organic Traffic” and “Total Traffic” section, ie Daily Organic Visits, Total Visits and PVs, Mobile Visits etc. Obviously you can change these to be whatever key metrics you need to track for your business. The data in the “Organic Traffic” and “Total Traffic” sections were originally updated using SuperMetrics Data Grabber, which was a tool referenced in Marshall’s deck. It’s not necessary to use SuperMetrics Data Grabber for this spreadsheet, as you can always manually download the metrics you need directly from Google Analytics (or Omniture) but it does make reporting much, much easier and more powerful by pulling the data you need right into Excel, without the fuss of downloads and copying and pasting from CSVs.
3) In the “Summary” tab, we’ve set it up so that the charts auto-update based on the dates as defined in rows 1 – 10. For Cell B2, set to “=Today()-7” to allow charts to auto-update with last week’s data. You can customize this as needed for daily or monthly reports.
4) As the data expands, in “Data for Charts” you need to expand the date range. Each date range has a named range associated with it, so you’ll just have to expand the definition of the named range at some point to account for the extra rows.
5) The YoY and WoW cells have conditional formats associated with them, so they turn Green or Red if there are significant increases or decreases in weekly or yearly data.
If you liked what Marshall had to say, please remember to say so on the speaker survey!