Analytics
4.5K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

Exporting multiple datasets in custom report to single excel

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi! I have generated a custom report with multiple datasets but when i export to excel, only the first dataset is contained. How do i get an export of all my datasets into one excel, with one dataset per worksheet?

1 Expert replyverified_user

Exporting multiple datasets in custom report to single excel

Top Contributor
# 2
Top Contributor

Analytics Edge has a free Excel add-in that can get your data for you.

Mike Sullivan, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

Exporting multiple datasets in custom report to single excel

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks but shouldn't i just be able to export both datasets at once if i have set up my custom report to have both?

Exporting multiple datasets in custom report to single excel

Top Contributor
# 4
Top Contributor

What do you mean by "custom report"?  I am assuming that means a Google Analytics custom report, which usually only handles a single data set at once.....

Mike Sullivan, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

Exporting multiple datasets in custom report to single excel

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Yes, you can add 2+ datasets in a single custom report. I would have thought they would both export when you exported the full report, but is that not the  case?