Web and Social Media Analysis in Practice

What can you do with Un-Sampled Google Analytics Data?

Categories: business intelligence, Dashboard, Data Mining, database, download, Web Analytics|Tags: |

Download un-sampled google analytics data and store it in a personal or corporate database.  This gives you a full range of options for best-in-class tools that convert raw data into business intelligence. Microsoft, Tableau, Qliktech, IBM, SAP, and many other business intelligence tools. You probably have your favourites, or tools that [...]

It takes just ten minutes to setup a personal database using free MYSQL

Categories: business intelligence, Dashboard, Data Mining, database, download|Tags: |

The install (including downloads) will probably take 10 minutes.  It pertains to software that's freely downloaded as of March 10, 2017.  Start by clicking this link and following it’s instructions. Accept all the defaults. https://www.python.org/ftp/python/3.4.0/python-3.4.0.amd64.msi Next, click this link and accept any prompts for Developer or any other default. https://cdn.mysql.com//Downloads/MySQLInstaller/mysql-installer-community- [...]

How To Avoid Google Data Sampling — For Free

Categories: database, download, Excel, Google Analytics|Tags: , |

Has your analytics run aground because you've started seeing Google Data Sampling appear? GOOGLE DATA SAMPLING - WHAT IS IT? When a web site experiences more than 500,000 sessions that covers the same time range as what you’re querying, then GA ignores some of your data. Google refers to this [...]

Dimensional Aggregation and Rollup Made Easy

Categories: Bing, business intelligence, database, download, Excel, Google Analytics, PIWIK, Scripting|Tags: , |

To get the answers we want, sometimes it's desirable to rolled up or aggregate a overly detailed dimension. This can apply to any data source including Google Analytics, PIWIK, Facebook, Instagram, Twitter, YouTube, SQL Queries and more. To demonstrate the value of rolling up detailed dimensions, a good example would [...]

Unlocking Cohorts in Web and Social Media Analytics

Categories: business intelligence, Dashboard, Data Mining, Google Analytics, PIWIK, Uncategorized|

You don’t need to be Houdini to escape the limitations of your Analytics Service. You just need NEXT Analytics Free or PRO Excel Addin. Although this works equally well for PIWIK , consider this example using Google Analytics. NEXT Analytics can create a cohort much more powerful than Google [...]