Google analytics core reporting API : 2 000 000 cells limit

[Frederik Vermeire]

Dear Community

Now we have a big client which is using your GA Spreadsheet Add-on.

In their spreadsheet they have more than 60 tabs. Each spreadsheet creates standardly 1000 rows and 26 columns (which makes 26.000 cells). When we make the sum they use 26.000 cells * 60 = 1 560 000 (which is not far away from the 2 000 000 cells limit).

Is there any possibility that when a new tab is created it only creates the rows & columns needed when there is data filled in.

Example in attachment

It would be great that when this tab is created through the report configuration that it only creates 89 lines (instead of 1000) and 2 columns (instead of 26).

Thanks for feedback.

Frederik

Duo.be

[Claudia Guirao]

My suggestion in this case is to export (and translate) all your reports to R + RGA package. There's practically no limitations and it will work faster and better. 

If your are used to work with datasheets it could be difficult at first but will save you a lot of time and "nightmares". 

Hope it helps!

[Frederik Vermeire]

Dear,

Can you give me more information about the R + RGA package (do you have a URL?) so I can explore this feature.

Kind Regards,
Frederik

[Claudia Guirao]

Of course, here's what works for me:

• Software: http://www.r-project.org/
• R environment: www.rstudio.com
• The package: https://github.com/skardhamar/rga and http://skardhamar.github.io/rga/
  

Video from Tatvic, with 3 examples: https://www.youtube.com/watch?v=rvLyCZIEt5A

Claudia