Whenever I run a query (like 4 times now) with Avoid GA Sampling the query runs for about 30 minutes and then error comes up: "Exceeded maximum execution time" and no data reveived.
Can you report the query ("Report an issue with a query") to check why is taking too long?
You can see where in screenshot 1.
Moreover, the "Avoid GA sampling" option always will need more time to load data than a normal execution, so it is very useful to check if the query you want to execute needs to avoid GA sampling or not. For that, use the "Show if GA is sampling data" (screenshot 2) before using "Avoid GA sampling". If the result is UNSAMPLED, then you will not need to use "Avoid GA sampling"
Hi Antonio. Thanks! I'll report the query as shown in your screenshot. I'm aware that it's suppose to take longer but the problem is that it takes so long that the data actually never "appears". I also did go through the exercise to check whether the data is sampled and unfortunately it is for the date range of the data I need.
Thank you for reporting the query and giving us more information. I have checked that, indeed, it needs more time than expected. I'll let you know when we have solved this issue or with new info.
Thank you in advance.