• Justin Goodman

    Can the next tutorial be on using named ranges to count the range and index only based on values within the dataset so that you dont need to know your min/max and you can add data later knowing that the chart will still work!

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

    I’m not following you, but whatever it is you’re asking, it sounds like you already know how to do it.

  • Sam Mazaheri

    this is gold. scrollable gold.

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

    Love this! :)

  • kasyallen

    You may be a geek when you call excel charts sexy, but I’m proud to be one of those geeks!

    Annie, you’ve really outdone yourself this time; I love how clean this is, and the GA API, I seriously don’t know how many hours I have wasted on reports before this came into my life – love at first sight!

  • kasyallen

    Quick question, I want to take Google & Bing Shopping out of the organic traffic, do you know if there is a way to setup filters so that these are excluded?

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

    Heh. Thanks! That means it’s only downhill from here. :)

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

    This is a great question. I found this answer re: Google, which seems to be the most accurate:

    https://www.en.adwords-community.com/t5/Measure-results/Google-shopping-results-in-google-analytics/td-p/109822/page/2

    Look for eCI’s reply to AdWiser (‎22-04-2013 06:59 AM) and follow the links the Google rep provided.

    As for Bing, I think you would need to use campaign parameters, e.g., utm_source=bing and utm_medium=shopping to distinguish them from regular ads, but I’m not 100% about that.

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

    Great! Glad it hit the mark. Even a broken watch gets the time right twice a day. :)

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

    Then create one?

  • William

    Fabulous tutorial, and nothing wrong in being a perfectionist. One question I have as a very new user to dashboards. I have a set of data that is in weeks and months but as you know there a some months with 5 weeks and some with 4, so is there anyway you can do the scroll bar with this is mind.
    I want to create the scroll bar via weeks but the middle by the month hence my problem.
    Also love your very direct answers to other comments, my kind of girl