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

    I use that tool almost daily but have never been able to get the GA part of it to work.

  • Randy Guzman

    Thanks a lot. It was a great a help to me.

  • http://twitter.com/richcaina Richelle Caina

    Wow.. Thanks Annie. This is really helpful. I am trying to follow your tips about bugs. Truly, it helps lessen my head banging moments.

  • importantlyernest

    Thanks Annie. It looks awesome. I’ve downloaded and your test drive will hopefully save me crashing a few times :-)
    If I DO bang my head, I’ll let you know.

  • treepodia

    Nice article with plethora of tips. Thank you! Does anyone else recommend this way of accessing the metrics?

  • Anshul Gautam

    This is an awesome

  • http://www.engag.io/Abdallah Abdallah Al-Hakim

    this looks extremely useful. Unfortunately, I running mac operating system :( I will need to find a way around it. This is the first time in a long while that I wished I had a windows OS!!

  • AM

    thanks, annie

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

    Thanks! Data Grabber does the same thing but is more finessed and has visualization built in. But it’s a paid tool – costs $300/year.

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

    This is one of the reasons my next laptop will be a PC.

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

    Thanks! Glad it’s helpful for you. :)

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

    Please do! I think I’ve hit most of the bugs, in both EA and the API. But if you run into any or get stuck on anything, I’ll help you get past it. Or die trying. :)

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

    Then my job here is done! Seriously, I wish I would have had this guide when I started!

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

    My pleasure. :)

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

    You’re welcome.

  • http://twitter.com/ampliofy Ampliofy

    Thanks for the mention! You may want to have a look at the next generation of Excellent Analytics: Excellent Analytics Pro. Now, it costs the equivalent of 50 cents a day so it’s not free. But then it comes with mass refresh. It currently has a 90-day free trial, no strings attached. No need to enter credit card details for the trial.

    BTW, a little secret: we’re Mac users ourselves. We use Excellent Analytics with Parallel Desktops or WMWare in OSX.

    One more tip is that EA returns data exactly how it is provided by the API. And this is a good resource to test if your combination of metrics and dimensions is supported by the API (that can seem like a “bug” but isn’t):
    https://developers.google.com/analytics/devguides/reporting/core/dimsmets

    If you run into issues with EA:
    http://excellentanalytics.com/help/

    Annie, feel free to reach out to us.

    Happy analyzing everyone, and liberate your data! :)

  • http://twitter.com/ampliofy Ampliofy

    We’re also considering releasing a 100 % free edition of EA Pro as well, but then without the mass refresh functions (paying 50 cents a day for that is bargain if you really do want it.) Any thoughts on that?

  • http://www.engag.io/Abdallah Abdallah Al-Hakim

    Wow! I think you are the first Mac to PC convert I have heard about. It is annoying that this program is not available through mac. I am not ready for the jump myself :)

  • http://twitter.com/alzahler Alejandro Zahler

    Thanks Annie. I’ve used thoroughly Excellent Analytics, and when used with a lot of data it started to slow my Excel. I switched I’ve to “vba functions” from Mikael Thuneberg. The best solution so far, though not free, but really worth the money.

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

    Oh yeah, I love Data Grabber. We just started playing with it at SEER. I wish they would add the functionality to update the query in the interface though. That’s my only complaint thus far.

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

    Let me think about that … YES, PLEASE. :)

  • Vishal

    Thanks Annie.

    I need your help ! ! !

    I am trying to restrict the data at sub-levels

    Here is an example –

    Country Region Cities Visits

    I want to restrict the data for top 10 cities with Visits for each change at Region

    Please advise how to do this using Excellent Analytics Queries in Excel.

    Thanks

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

    Hey Vishal,

    I can’t understand what you’re trying to do. But Excellent Analytics lets you decide how many results you want (which is where you can get the top 10). Everything else you’re trying to do can be accomplished w/ filters. In the byline at the end of the article is the option to connect w/ me via email. That might be better.

  • Vishal

    Hey Annie, Thanks for your reply

    I can restrict the total results up to 10,000 (0-10,000 in
    base version)

    However, I need to restrict data for top 10 cities with
    visits falling under different regions.

    For example, there are 10 regions – California, New Jersey, New
    York, Illinois, Pennsylvania, Florida, Texas, Massachusetts, Virginia and
    Michigan

    There can be more than 10 records for each regions but I
    need to restrict the records for the top 10.

    The total rows (records) will come to 100 (if all the
    regions have 10 records) even though the max-result is set to 10,000.

    I have 2 Alternative solutions -

    1. I can take the whole data dump and make a pivot then take
    the top 10.

    2. Restrict the data by filtering visits (visits greater
    than 1 or 10) to cut short the maximum results

    But I want to restrict the data thru query itself as I need
    to pull information across many segments and this is currently making my excel file size very heavy and difficult to manage the large data chunks.

    I came across itemsperpage function but not sure how to use
    it within Excellent Analytics query in Excel

    Please let me know if it’s possible in Excellent Analytics
    using queries in Excel

    Thanks,

    Vishal

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

    Hey Vishal,

    For the level of customization you need, you should look at one of the paid options, like Excellent Analytics Pro. They’re very inexpensive and come with technical support. EA wasn’t really intended for the heavy lifting you require.

    Annie

  • Vishal

    Thanks Annie.