Categories: Discuss issues related to your accounts, reports and data :

Downloading chart data

Showing 1-3 of 3 messages
Downloading chart data Buzzilinear 1/18/12 9:39 AM
Is there a way without using the API or downloading a plugin to export the data from the graph that shows up when viewing Google Analytics reports?

I have a one-year graph of unique visitors and the graph plots daily numbers. I want to download those daily numbers and compare to other data we have to find a correlation. When I export the data, it just exports the rows by page name with the various metrics. The graph is being plotted behind the scenes so I'm guessing you'd have to delve into the API?
Re: Downloading chart data Marketing Geek 1/18/12 5:02 PM
If you start from Audience>Overview and select from Advanced Segments New Visitors and Returning Visitors, the exported file will have the columns Day, Date Range, Segment and Visit Count


Day date_range segment Visits
12/18/2011 Dec 18, 2011 - Jan 17, 2012 New Visitors 1,341
12/18/2011 Dec 18, 2011 - Jan 17, 2012 Returning Visitors 570
12/19/2011 Dec 18, 2011 - Jan 17, 2012 New Visitors 1,547
12/19/2011 Dec 18, 2011 - Jan 17, 2012 Returning Visitors 656
12/20/2011 Dec 18, 2011 - Jan 17, 2012 New Visitors 1,343
12/20/2011 Dec 18, 2011 - Jan 17, 2012 Returning Visitors 606

Hope this helps!
Marc
Re: Downloading chart data happy2012 5/16/12 9:06 PM
In fact  you can export the data from chart not only from " Audience>Overview" but also other places like "SIte content > Pages"  .When you export the excel you can find the data after the table's data
# ----------------------------------------
# 向日葵(全站)
# Pages
# 20120416-20120516
# ----------------------------------------
Page Pageviews Unique Pageviews Avg. Time on Page Bounce Rate % Exit
wenba.xiangrikui.com/zixun/ 59,256 12,562 0:01:35 44.47% 10.61%
www.xiangrikui.com/kefu/dialog.jsp?pos=top&source=http://wenba.xiangrikui.com/zixun/ 23 20 0:05:57 44.44% 30.43%
wenba.xiangrikui.com/zixun/?lgTrfUlxdc=N7d4JaEZIN 1 1 0:01:33 0.00% 0.00%
59,280 12,583 0:01:35 44.47% 10.62%
Day Pageviews
4/16/12 2,298
4/17/12 2,150
4/18/12 1,950
4/19/12 1,285
4/20/12 1,790
4/21/12 1,059
4/22/12 1,029
4/23/12 2,744
4/24/12 1,070
4/25/12 2,506
4/26/12 2,282
4/27/12 1,316
4/28/12 2,043
4/29/12 1,512
4/30/12 729

So just do  focus on the end of data~
happy