SuperMetrics auto-refresh fails when using multiple logins i.e. Login stored in Google Sheet, not in SuperMetrics.

[Matthew Stover]

Hi,

I've found that SuperMetrics fails to automatically refresh for some Google Sheets, not all, when multiple logins are used. 

Example: 

I have 2 clients, client A and client B. Client A has the login 'cli...@gmail.com' for fetching adwords data, client b has 'cli...@gmail.com' for fetching their adwords data. Each has their own, separate Google Sheet created for their reporting i.e. Client A's report is connect to client A account, client B's report is connected to client B account. Both reports are set to refresh daily. If the last AdWords connection which I had selected in SuperMetrics was for Client A, then client B's report will not automatically refresh. vice versa. 

However, I also have another Google Sheet which pulls in data from both Client A and Client B accounts.This dashboard always refreshes, without fail. 

It seems like SuperMetrics does not store logins at the owner account level, but rather the Google Sheet level, which requires manual the user to manually resync reports. Is this an issue which can be overcome?

Thanks,

Matt

[Mikael Thuneberg]

Logins are stored on the account level, not on file level. When you change between accounts, be sure to use "Switch", not "Log out". The latter will delete the authentication information so queries created by that account can no longer be refreshed with its credentials.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at http://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/69113716-53ae-4adc-8ed5-9cc1dffe6651%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Matthew Stover]

I do exactly this - I use the switch function, not log out, yet the problem still exists. 

On Friday, April 24, 2015 at 10:28:31 AM UTC-4, Supermetrics Support wrote:

Logins are stored on the account level, not on file level. When you change between accounts, be sure to use "Switch", not "Log out". The latter will delete the authentication information so queries created by that account can no longer be refreshed with its credentials.

On Friday, April 24, 2015, Matthew Stover <mjsto...@gmail.com> wrote:

Hi,

I've found that SuperMetrics fails to automatically refresh for some Google Sheets, not all, when multiple logins are used. 

Example: 

I have 2 clients, client A and client B. Client A has the login 'cli...@gmail.com' for fetching adwords data, client b has 'cli...@gmail.com' for fetching their adwords data. Each has their own, separate Google Sheet created for their reporting i.e. Client A's report is connect to client A account, client B's report is connected to client B account. Both reports are set to refresh daily. If the last AdWords connection which I had selected in SuperMetrics was for Client A, then client B's report will not automatically refresh. vice versa. 

However, I also have another Google Sheet which pulls in data from both Client A and Client B accounts.This dashboard always refreshes, without fail. 

It seems like SuperMetrics does not store logins at the owner account level, but rather the Google Sheet level, which requires manual the user to manually resync reports. Is this an issue which can be overcome?

Thanks,

Matt

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.

To unsubscribe from this group and stop receiving emails from it, send an email to automateanalytics+unsubscribe@googlegroups.com.

[Supermetrics Support]

We've made some improvements on how you can manage the refresh in a multi-account situation, mainly adding a new "Refresh as user account" parameter to the SupermetricsQueries sheet (launch the add-on sidebar and it will update the sheet with this new parameter on the right). You can use that parameter to specify that a certain account must be used for refreshing a query. See full instructions at http://supermetrics.com/support/supermetrics-for-googledocs/#multiaccount