How To Use The Google Analytics API In Plain English

The data is exported into Excel in a range with headers that’s perfect for pivot tables and charts. (Excel 2011 for Mac still doesn’t support pivot charts. Too much lame, too little time.) You can also create regular, static charts from the data, too, if you’re on a Mac, but it’s better to create even static charts from a pivot table because you can easily change the headings in pivot tables. If you’re using Excellent Analytics for monthly reports, once you hit the first of the new month, you can update each data set by just clicking on the header, choosing Update Query, and clicking Execute. If you’ve built pivot tables and/or charts, you can choose Refresh All (under Data > Connections), and all of your tables and charts should update to match the new month’s data. It’s pretty slick. With the exception of dividing all rate values by 100, I don’t touch any of the raw data...

Full article: http://searchengineland.com/how-to-use-the-google-analyti...

Tweets

@jordiobdotcom » 30 Dec '12, 9am
Olé con este plugin Excellent Analytics para Excel (PC). Cómo me va a facilitar la vida [link] vía @sengineland
@JohnRowa » 28 Dec '12, 4pm
“@SEERInteractive: How To Make Google Analytics Talk To Excel, In Plain English [link]” <-- So helpful, @AnnieCushing! U rock!
@Sonja_Stein » 28 Dec '12, 2pm
Wow! #impressed - How To Make Google Analytics Talk To Excel, In Plain English [link] via @AnnieCushing
@vishalbiyer » 26 Dec '12, 1pm
@AnnieCushing Hi Annie I need your help on Excellent Analytics [link] Pls see my comment. Thanks, Vishal
@vishalbiyer » 26 Dec '12, 1pm
@alzahler Hi I need your help on Excellent Analytics [link] Please see my comments Thanks, Vishal
@vishalbiyer » 25 Dec '12, 5pm
@AnnieCushing Hi Annie I need your help on Excellent Analytics [link] Please see my comment Vishal
@vishalbiyer » 25 Dec '12, 7am
@AnnieCushing Hi Annie, I have a query on EA - [link]
@gameroom1 » 25 Dec '12, 3am
RT @KvSeoServices: How To Use The Google Analytics API In Plain English: I’m spoiled now. I rarely go into the Google Analytics (GA... [link]
@seotweetz » 14 Dec '12, 3pm
RT @RebelDekadance: How To Make #GoogleAnalytics Talk To Excel, In Plain English [link] via @sengineland #seo
@seotweetz » 14 Dec '12, 12pm
RT @egiethoorn: How To Make #GoogleAnalytics Talk To Excel, In Plain English [link] via @sengineland #seo
@MatthewLothian » 13 Dec '12, 6am
RT @autumn01: How To Use The Google Analytics API In Plain English [link]
@deanpeters » 08 Dec '12, 2pm
for all #Analytics peeps: How To Make Google Analytics Talk To Excel, In Plain English - [link]
@ximoberna » 07 Dec '12, 6pm
RT @smallbiztrends: How To Use The Google Analytics API In Plain English by @AnnieCushing [link] RT @sengineland #fb
@joyrenee » 07 Dec '12, 5pm
RT @smallbiztrends: How To Use The Google Analytics API In Plain English by @AnnieCushing [link] RT @sengineland
@fetchprofits » 07 Dec '12, 8am
Here's a cool tip | How To Make Google Analytics Talk To Excel, In Plain English [link] via @sengineland
@thompsonpaul » 06 Dec '12, 7pm
Additional resource:- @anniecushing's article on pulling GA API data into Excel - automated dashboards [link] #seochat
@HubInteraction_ » 05 Dec '12, 8pm
RT @dposada: How To Make Google Analytics Talk To Excel, In Plain English [link] vía @sengineland
@RiseUpUK » 05 Dec '12, 3pm
RT @1stwebdeveloper: How To Make Google Analytics Talk To Excel by @AnnieCushing [link]
@nateknox » 05 Dec '12, 3pm
PC-only is stupid... How To Make Google Analytics Talk To Excel, In Plain English [link]
@MyEskan » 05 Dec '12, 2pm
RT @portentint: How To Use The Google Analytics API In Plain English [link] @anniecushing kickin' ass and taking names in analytics
@allengerritsen » 05 Dec '12, 12am
More #data talk. Here's a great post that outlines simply how to get the most out of your Google Analytics: [link]
@pedrodasilvauk » 04 Dec '12, 7pm
#HowTo Make Google Analytics Talk To Excel [link] , In Plain English
@FogelRivka » 04 Dec '12, 6pm
Best. Excel plugins for Google Analytics [link] by @AnnieCushing at @sengineland
@mackfogelson » 04 Dec '12, 5pm
Miss @anniecushing never ceases to amaze me. Embrace her technical prowess with How to Make GA Talk to Excel--> [link]
@MarkBRefined » 04 Dec '12, 4pm
RT @fighto: How To Make Google Analytics Talk To Excel, In Plain English [link] via @ScottKellam
@fighto » 04 Dec '12, 4pm
How To Make Google Analytics Talk To Excel, In Plain English [link] via @ScottKellam
@leen_machine » 04 Dec '12, 3pm
Nice description RT @googleanalytics: Excel + Analytics better together @AnnieCushing shows you, in plain English, here [link]
@analyticspeak » 04 Dec '12, 2pm
#techie #tuesday: How To Make Google Analytics Talk To Excel, In Plain English [link] ^jc
@wordtracker » 04 Dec '12, 12pm
RT @ihowie: How To Make Google Analytics Talk To Excel, In Plain English [link] via @sengineland
@KarstenWerner » 04 Dec '12, 8am
Excel + Analytics ...better together. @AnnieCushing shows you how, in plain English, here: [link] #data #journalism
@LamiaHSM » 04 Dec '12, 7am
Wish I'd seen this earlier! How To Make Google Analytics Talk To Excel, In Plain English [link] via @sengineland
@InverseLogix » 04 Dec '12, 7am
How to Export Google Analytics Data to Excel via the API [link] [link]
@seotweetz » 04 Dec '12, 12am
RT @RonSansone: Aaand bookmarked!! RT @nick_eubanks: Helpful tips from @anniecushing > How To Make Google Analytics Talk To Excel [link] #SEO
@RonSansone » 04 Dec '12, 12am
Aaand bookmarked!! RT @nick_eubanks: Helpful tips from @anniecushing > How To Make Google Analytics Talk To Excel [link] #SEO
@nick_eubanks » 04 Dec '12, 12am
Super helpful tips from @anniecushing >> How To Make Google Analytics Talk To Excel, In Plain English [link] via @sengineland
@trendiamx » 03 Dec '12, 11pm
How To Make Google Analytics Talk To Excel, In Plain English [link] @Trendiamx #ArquitecturadeMarca #Marketingdigital
@fencelinebakery » 03 Dec '12, 11pm
"Excel + Analytics ...better together.shows you how, in plain English, here: [link]" @kylelitz6 @Chuckwood_21
@TeishaCollins » 03 Dec '12, 11pm
How To Make Google Analytics Talk To Excel, In Plain English [link] via @sengineland #GoogleAnalytics #SearchMarketing
@fabo_nl » 03 Dec '12, 11pm
RT @AdwordsRobot: How To Make Google Analytics Talk To Excel, In Plain English [link] [link]
@YossiflowersLis » 03 Dec '12, 11pm
How To Make Google Analytics Talk To Excel, In Plain English [link] דרך @sengineland
@FedericaGrossi » 03 Dec '12, 10pm
RT @LovesData: How to make Google Analytics & Excel work together [link] #measure
@WeidertGroup » 03 Dec '12, 10pm
How To Make Google Analytics Talk To Excel, In Plain English [link] | Great primer for this important tool.
@naturephotospa » 03 Dec '12, 10pm
RT @Tom__Coleman: How To Make Google Analytics Talk To Excel, In Plain English [link]
@LovesData » 03 Dec '12, 9pm
How to make Google Analytics & Excel work together [link] #measure
@recalibrate » 03 Dec '12, 9pm
.@AnnieCushing is gifting serious knowledge here --> How To Make Google Analytics Talk To Excel, In Plain English [link]
@CharlyAtJenis » 03 Dec '12, 8pm
@ryanatjenis RT @googleanalytics: Excel + Analytics ...better together. @AnnieCushing shows how...here: [link]
@seotweetz » 03 Dec '12, 8pm
RT @451Heat: "How to Make #googleanalytics Talk to Excel" via @sengineland [link] Have you used this PC-only free plug-in to improve #SEO?
@451Heat » 03 Dec '12, 8pm
"How to Make #googleanalytics Talk to Excel" via @sengineland [link] Have you used this PC-only free plug-in to improve #SEO?
@ravidixit101 » 03 Dec '12, 8pm
@googleanalytics: Excel + Analytics better together. @AnnieCushing shows you how, in plain English, here: [link] V interesting
@Logan_gramatr » 03 Dec '12, 8pm
Do you use @GoogleAnalytics? Do you want more freedom through Analytics' #API? @SEngineLand shows you how to save time- [link]