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 months of hushed rumours, Facebook quietly announced their newest ad format - Facebook Collection - this week. The format is an e-commerce dream: a mobile ad with a feature video or image, with a product carousel underneath it. When the user clicks a product, Facebook launches an instantly loaded ecommerce page, with a user experience similar [...]
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 you already own and are [...]
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 “sampled data”. The elimination of [...]
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 be web site referers. Referers [...]
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 Analytics, even using Google Analytics’ [...]
This is probably the most boring blog post on the planet, but if you need PIWIK data, then you will be very excited to read this article. NEXT Analytics offers free software that downloads data, in addition to a wide variety of other data: Google Analytics, PIWIK data, And it also does social, as [...]
Success has always been about listening to customers. In the old days, product and messaging was done by word of mouth and a personal touch. Nowadays, you can analyze the content of Fan Pages comments and Group Discussions. Social Media Users Are a Gold Mine of Information With social [...]
Wow, did the water protectors ever make a difference in Standing Rock! We mapped out the geo-locations for #NoDAPL on Instagram to show where the posts were coming from across North America, as well as when the largest spikes of interest occurred. As you can see from our gif above, there were major spikes on [...]
People love cars. People love posting about cars on Instagram. Analyzing the Los Angeles Auto Show grams was fun for us because it gave us so much data to work with. Car brands from all over the world touched down in California to show off their brand new vehicles. Porsche, Maserati, Ferrari - the usual [...]