• http://www.volumeseo.com/ Keller Tiemann

    Great Excel tip. I used to work as a tax consultant and would go out of my way to learn Excel tips and tricks to improve my work. Happy to stumble on this for my SEO clients!

  • http://www.annielytics.com/ Annie Cushing

    Happy to help, Keller!

  • http://www.websiteoptimizers.com/ Tom Bowen

    So cool. Like you Annie, I was a bit intimidated going into areas of Excel I haven’t used before. The video makes it so easy. Can’t wait to give my customers more!

  • http://www.annielytics.com/ Annie Cushing

    Awesome to hear, Tom! Sometimes I wish I could be a fly on the wall to see how marketers take these ideas, pivot on them, and create super sexy data.

  • Mikael Thuneberg

    You can easily automate this even further with our GA functions for Excel: http://supermetrics.com/interactive_chart.gif. Get the Excel file here: https://dl.dropboxusercontent.com/u/8653266/interactive-chart.xlsm. Get a token from analyticsfunctions.com, paste it to the Raw Data sheet, and you’re good to go. Need to have Windows Excel with macros enabled.

  • danleibson

    For people using Excel 2010 or Excel 2007 this is how you add the developer tab to the ribbon:

    http://www.addintools.com/documents/excel/how-to-add-developer-tab.html

  • http://www.annielytics.com/ Annie Cushing

    I’ll check it out. Thanks.

  • http://www.annielytics.com/ Annie Cushing

    Thanks, Dan.