One Report Multiple Properties

[Lee Denny]

Hello,

 

I've got a property for each of our sites - about 40 in total.

 

I want a summary report that shows me audience data for a given data range for all of these properties in one spreadsheet.

 

I've added the google-analytics-spreadsheet-add-on to my google spreadsheet but I can't see how to add data for more than one property into one sheet.

 

Can anyone point me in the right direction?

 

Cheers,

 

Lee

[Ryan Praskievicz]

Hi Lee,

To pull data from additional profiles just add the view (profile) ids along with the rest of the query info in the adjacent columns. See the screen shot below.

Best,

Ryan

[Lee Denny]

Ryan,

Many thanks for this - its done the job.

 

Cheers,

 

Lee