Analytics
4.7K 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

Google Analytics Sheets Add-on

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi everyone!

 

Right now I am using Google Sheets to convert data from Google Analytics into sheets.

The data I am using is from different companies (different GA-accounts) and many different kind of events, so every company has it's own sheets.

 

At this point I would like to research all data to see which campaigns and companies have been the most succesfull, based on several KPI's. Ideally, I would like to have one sheet with all data in figures and tables.

Is it possible to create 1 sheet with all data from different GA accounts/sheets, so I can easily compare the different accounts and campaigns? Or is there maybe another way to do this?

 

Appreciate your help!

Marked as Best Answer.
Solution
Accepted by topic author Lisa P
November 2016

Google Analytics Sheets Add-on

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

After reviewing the Add-On settings, there is now easy way to combine different reports into one spreadsheet.  My recommendation is to add your report data into one sheet with one column identifying the account then sort by the relevant KPI.  

Google Analytics Sheets Add-on

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for the reply!

This sounds like a good solution to me.