Windows Task Scheduler will run applications that do not need human interaction. Nothing needs to be clicked, there is no text to be entered. It’s perfect for when you want the data to be downloaded before you arrive at work. It can also be used to refresh data without using Excel on your computer. [...]
Step 1 – start the relationship between Google Drive and your installation of NEXT Analytics Step 2 – Tell Google that you give permission for your installation of NEXT Analytics for it to access your Google Drive Step 3 – Click the upload button. You will be prompted for one or more Excel [...]
During May 2017, Google released a new version of their Adwords interface. You can browse the reports that are now available, as well as the data columns that you can download using the Custom Query option. Data can be used in Excel, Google Data Studio, Power BI, and many other query and reporting tools. [...]
After you have purchased Analytics 360, it is very convenient to continue with the interactive dashboards. But sometimes your requests result in sampling conditions (greater than 500,000) sessions. Click the button that appears on your ribbon bar (in Windows), and you can get more detail which query is being sampled. At that point, you need to [...]
How can you Improve upon Google Analytics Data Studio? Automate Custom Data Processing before you upload into GDS! Report on multiple views and segments on the same report. Stop Google Data Sampling (in most cases) Enhanced multi-period reporting dimension normalization, on-the-fly calculations, iterative filters, and pivoting, and How does it work? After downloading and processing [...]
This blog describes an easy and free technique to avoid Google Analytics Data Sampling without having to pay for Google Analytics 360 (aka Premium). If you have Premium, it might save you from the two step process described here. Sampled data is wrong data. There's a lot at stake, if you are publishing wrong data! [...]
Main Reason to do Multi-View Analysis It's very common to hit the maximum number of goals that a View supports. Web analysts will create additional Views as new Goals are introduced. They do this because they don't want to delete or re-use old goals because they are still historically relevant. Many people therefore would like [...]