Query stuck at 37%

[nk]

I've been trying to refresh 2 queries for Adwords and Bing, but they are stuck at 37%.

I use similar, almost same query in other files and they are able to refresh without any problems. 

I could create exactly same query in new file and build report in that file again, but when I try refresh them next day, they stuck at 37% again.

Please respond this asap as I don't have any workaround process. 

Thanks,

[Supermetrics Support]

Our logs show no problem with your queries. If this is still occurring, please share the file with in...@supermetrics.com so we can test.

[nk]

I sent email with the file attached. 

Could you investigate this asap? as I can't use that report at the moment...

Thanks,

[Mikael Thuneberg]

The problem seems to be that it takes many minutes for Google to add that much data to a sheet. It takes so long that our add-on starts trying to rerun the query, and then starts adding the data again to the sheet, and then that is slow and it tries again etc. 

We will see what we can do, possibly reporting this to Google so they may try to improve the speed. But to get this working right now, you can simply fetch the data on weekly or monthly level. The problem is that you are fetching it by date, so there's a huge number of rows.

--
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.
Visit this group at https://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/79c6fc8b-6a58-45de-85e8-ed4419ddf467%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[nk]

I changed query to weekly level, but now it stuck at 95%...

In Query management tab it said updated, but in actual sheet query is still refreshing and shows nothing.

(It pulls data but few mins later it's going back to refreshing... even status shows updated)

Ideally I want pull daily data, and weekly is the longest time range that I'd go as monthly is too long to track accounts performance. Please let me know if I can use supermetrics for this report or not..

On Friday, 12 August 2016 18:20:00 UTC+10, Supermetrics Support wrote:

The problem seems to be that it takes many minutes for Google to add that much data to a sheet. It takes so long that our add-on starts trying to rerun the query, and then starts adding the data again to the sheet, and then that is slow and it tries again etc. 

We will see what we can do, possibly reporting this to Google so they may try to improve the speed. But to get this working right now, you can simply fetch the data on weekly or monthly level. The problem is that you are fetching it by date, so there's a huge number of rows.

On 12 August 2016 at 09:40, nk <nob...@jayride.com> wrote:

I sent email with the file attached. 

Could you investigate this asap? as I can't use that report at the moment...

Thanks,

On Thursday, 11 August 2016 16:35:49 UTC+10, Supermetrics Support wrote:

Our logs show no problem with your queries. If this is still occurring, please share the file with in...@supermetrics.com so we can test.

On Thursday, August 11, 2016 at 5:34:48 AM UTC+3, nk wrote:

I've been trying to refresh 2 queries for Adwords and Bing, but they are stuck at 37%.

I use similar, almost same query in other files and they are able to refresh without any problems. 

I could create exactly same query in new file and build report in that file again, but when I try refresh them next day, they stuck at 37% again.

Please respond this asap as I don't have any workaround process. 

Thanks,

--
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 https://groups.google.com/group/automateanalytics.

[nk]

Weekly one was updated successfully, but I had to reduced a row.

Thanks,