Several reports in one sheet/tab

265 views
Skip to first unread message

quentinhu...@gmail.com

unread,
Feb 26, 2018, 8:45:30 PM2/26/18
to google-analytics-spreadsheet-add-on


Hi everyone, 

I'm a new user of this GA add-on and I have not so much experience in GA in general. So I am looking for some help with the issue describe below.

I have created 3 reports to run weekly but I have quickly noticed that each report generates a new tab in the spreadsheet. And I cannot afford to have 3 new tabs per week in the spreadsheet... At least 1 new tab per week would be acceptable. 

So that is my question : Is it possible to combine my three reports (Cf. screenshot below) in only one tab ? 



Philip Walton

unread,
Feb 27, 2018, 3:51:54 PM2/27/18
to quentinhu...@gmail.com, google-analytics-spreadsheet-add-on
A new sheet is only created the first time a report is run. Subsequent run will update the data in the same sheet.


--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/adeb080f-9f40-47fc-a981-14dff1b033a6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

quentinhu...@gmail.com

unread,
Feb 27, 2018, 8:22:26 PM2/27/18
to google-analytics-spreadsheet-add-on
Hi Philip, 

Thank you for your answer. 

Actually the report names are going to change every week precisely because I want to keep every reports in order to generate an automatic dashboard from these extractions. So I cannot erase the previous data... 

Knowing that, do you know if my request is feasible ? If not, I read in another conversation that it's possible to indicate a cell where we want to create the new report. Do you know where we have to indicate this cell ? It could solve my problem is I can indicate 3 cells in the same sheet.

Thank you, 

On Wednesday, 28 February 2018 04:51:54 UTC+8, Philip Walton wrote:
A new sheet is only created the first time a report is run. Subsequent run will update the data in the same sheet.


On Mon, Feb 26, 2018 at 5:45 PM <quentinhu...@gmail.com> wrote:


Hi everyone, 

I'm a new user of this GA add-on and I have not so much experience in GA in general. So I am looking for some help with the issue describe below.

I have created 3 reports to run weekly but I have quickly noticed that each report generates a new tab in the spreadsheet. And I cannot afford to have 3 new tabs per week in the spreadsheet... At least 1 new tab per week would be acceptable. 

So that is my question : Is it possible to combine my three reports (Cf. screenshot below) in only one tab ? 



--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

Philip Walton

unread,
Feb 28, 2018, 12:36:57 PM2/28/18
to quentinhu...@gmail.com, google-analytics-spreadsheet-add-on
This isn't feasible. Each report is always going to be in it's own sheet.

You can then combine sheets however you like.


On Tue, Feb 27, 2018 at 5:22 PM <quentinhu...@gmail.com> wrote:
Hi Philip, 

Thank you for your answer. 

Actually the report names are going to change every week precisely because I want to keep every reports in order to generate an automatic dashboard from these extractions. So I cannot erase the previous data... 

Knowing that, do you know if my request is feasible ? If not, I read in another conversation that it's possible to indicate a cell where we want to create the new report. Do you know where we have to indicate this cell ? It could solve my problem is I can indicate 3 cells in the same sheet.

Thank you, 

On Wednesday, 28 February 2018 04:51:54 UTC+8, Philip Walton wrote:
A new sheet is only created the first time a report is run. Subsequent run will update the data in the same sheet.


On Mon, Feb 26, 2018 at 5:45 PM <quentinhu...@gmail.com> wrote:


Hi everyone, 

I'm a new user of this GA add-on and I have not so much experience in GA in general. So I am looking for some help with the issue describe below.

I have created 3 reports to run weekly but I have quickly noticed that each report generates a new tab in the spreadsheet. And I cannot afford to have 3 new tabs per week in the spreadsheet... At least 1 new tab per week would be acceptable. 

So that is my question : Is it possible to combine my three reports (Cf. screenshot below) in only one tab ? 



--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/8d5aaa6d-5652-45d8-9b43-6da99ab32d00%40googlegroups.com.

quentinhu...@gmail.com

unread,
Feb 28, 2018, 8:01:21 PM2/28/18
to google-analytics-spreadsheet-add-on
Ok, thank you


On Thursday, 1 March 2018 01:36:57 UTC+8, Philip Walton wrote:
This isn't feasible. Each report is always going to be in it's own sheet.

You can then combine sheets however you like.


On Tue, Feb 27, 2018 at 5:22 PM <quentinhu...@gmail.com> wrote:
Hi Philip, 

Thank you for your answer. 

Actually the report names are going to change every week precisely because I want to keep every reports in order to generate an automatic dashboard from these extractions. So I cannot erase the previous data... 

Knowing that, do you know if my request is feasible ? If not, I read in another conversation that it's possible to indicate a cell where we want to create the new report. Do you know where we have to indicate this cell ? It could solve my problem is I can indicate 3 cells in the same sheet.

Thank you, 

On Wednesday, 28 February 2018 04:51:54 UTC+8, Philip Walton wrote:
A new sheet is only created the first time a report is run. Subsequent run will update the data in the same sheet.


On Mon, Feb 26, 2018 at 5:45 PM <quentinhu...@gmail.com> wrote:


Hi everyone, 

I'm a new user of this GA add-on and I have not so much experience in GA in general. So I am looking for some help with the issue describe below.

I have created 3 reports to run weekly but I have quickly noticed that each report generates a new tab in the spreadsheet. And I cannot afford to have 3 new tabs per week in the spreadsheet... At least 1 new tab per week would be acceptable. 

So that is my question : Is it possible to combine my three reports (Cf. screenshot below) in only one tab ? 



--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages