上次张悬来自发版聊的时候，我们说到一个句式“张悬已经来了，某某某（请大家自觉代入自己心水的艺人的名字，代入“孙燕姿”的还没买到票。）还会远吗？ ”，于是，Linkin Park来了。 (挖，你怎么还能装的这么淡定，Linkin Park的留言区已经有人幸福的快要晕倒了！)好吧，让我们用响彻云霄的掌声激动的欢迎Linkin Park加入豆瓣音乐人的大家庭！

豆瓣音乐人上线10个月以来，一直以非常健康的状态向上生长着，到目前为止已经吸引了近3000个音乐人入驻，平均每天有100首歌上传，“关注”音乐人的豆友超过50万。一直觉得很幸运，尤其当得知Linkin Park也要加入豆瓣音乐人，我们的兴奋不亚于任何一位在Linkin Park音乐人页面留言的豆友。因为本身豆瓣很多同事就是Linkin Park的骨灰级粉丝。阿北一直说：“是豆友把豆瓣变成现在这个样子，我们只是为豆友搭建了一个平台而已。”所以，Linkin Park其实是因为你们而来——所有“关注”Linkin Park，并激动得风中凌乱的留言和发帖的豆友们。而豆瓣的幸运也是因为有你们——所有正在看和将要看到这篇Blog的豆友们。

说时迟那时快，Linkin Park已经以迅雷不及掩耳盗铃之势跃居本周流行音乐人的亚军宝座了，让我们再次以响彻云霄的掌声激动的恭喜他们吧！另外，“关注”以及“推荐”Linkin Park，跟友邻一起分享他们的音乐才是王道，哈哈～ 

Linkin park视频截图，请留意CC说出“dou ban”两个字的中文发音 \(^o^)/~

 

Many of our clients use Excel to manage their ad campaigns, visualize marketing performance, and perform complex data analysis. Most analysts use the Google Analytics Export feature to manually export their report data to CSV files. Then they import the CSV file into Excel. No longer! Now, with the Google Analytics API you can bypass this manual step and export Google Analytics data directly from within Excel! Once you've set it up, there's no need to visit the Analytics reports to view data in Excel.

Thanks to a variety of developers, here are four solutions that can transform you from a reporting monkey to an analysis ninja (as Avinash would say).

• VBA Macros - The simplest solution of them all. Mikael Thuneberg's page explains how to make API requests directly from Excel using VBA Scripts and includes a pre-built Excel worksheet to get you started.
  
  
• The Tatvic Excel Plugin - Another easy-to-use plugin for Windows users that supports both Excel 2003 and Excel 2007. To get started you download the plugin then register to use the tool. Its simple UI helps you build complex queries and get data from Analytics right into your Excel worksheet.
  
  
  Tatvic's Plugin Query Builder
  
  
• Excellent Analytics - Is an open-source initiative by Mark Red and Dropit. This Excel 2007 plugin works on Vista/XP and comes with a query builder to help you create Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin.
  
  
  Excellent Analytic's Query Builder Interface
  
  
• ShufflePoint - Works somewhat differently than the solutions above. ShufflePoint has developed a query language that works with the Google Analytics API to achieve common tasks, such as defining the last 30 days as a date range. One then uses this language to construct an Analytics Data Export API query either by navigating to a URL within Excel, or by using their web-based query builder, then importing this data into Excel. This process allows the ShufflePoint solution to work across most versions of Excel, as well as Powerpoint, and iGoogle gadgets.
  
  
  Shufflepoint's Web Based Query Builder
  

We continue to be impressed by the new solutions developers are bringing to market by leveraging the Google Analytics Platform. If you have developed a useful new tool or integration on top of Google Analytics, drop us an email at analytics-api@google.com. If it's innovative and useful we'll highlight it to our readers on this blog.


Posted by Nick Mihailovski, Google Analytics API Team