I see that with the Google Search Console and Moz connectors it is possible to append new data to the bottom row of a column by using the proper query settings.
Is this also possible with the Google Analytics connector?
My use case is that I need a column with all past data run once a month.
Hi Jouni, thanks for the prompt reply.
Perhaps with some spreadsheet trickery this is possible?
For instance, the Supermetrics query range could perhaps be dynamically generated so as to be moved to the first empty row of a column?
I wouldn't know how to edit the Supermetrics Query parameters in the SupermetricsQueries tab, but I'm sure you do!
For example, the range address looks like this:
Which I can't make sense of...
Would appreciate your support in figuring out how to move the query range to the first empty row!
Thanks very much :)
we have gone through many ideas on making it work, but as of now the only option is if you have an external database that can be set to pull data from your Google Sheet with a certain day/time interval and set it to follow after your Supermetrics refresh has gotten the new data.
Changing the parameters in the query is not possible for this case.