Unlocking Cohorts in Web and Social Media Analytics

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’ [...]

Manage your Google Analytics Filters in Excel

Spam referrals are a problem for everyone.  You use hundreds of filters across hundreds of views to give you a better view of your business. Changing each one of your hundreds of filters to remove spam could take you all day to accomplish!  With a little bit of setup, NEXT Analytics can help you manage [...]

Analyze how Referrals are driving your Goal Completions

Analyze how Referrals are driving your Goal Completions If you’ve been active in promoting your web site, you will have accrued a number of external sources who drive traffic to your web site. These could be A-List bloggers, industry analysts, critics and fans, and members of your partner or affiliate network. Reaching out to these [...]

Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet

How effective is your Adwords spend? Get a complete 12 month overview of everything that happened relating to Adwords. This easily customizable Dashboard runs inside Excel and is free for users of NEXT Analytics. Just download it, and one click later, you'll know how well your pay per click campaigns are doing. Download it Download [...]

Monthly Trend of Ecommerce Metrics (a Customizable Dashboard)

All of the metrics relating to Ecommerce, conveniently in one screen. Shows the trend of values for every metric over a 12 month period. Get the spreadsheet here:google-analytics-ecommerce-metrics Click the Refresh Data button on the ribbon bar. Your own data will show. Customize It Open the worksheet named “_actions”. Change the year and month to [...]

Download Google Analytics to your Computer

Power Queries Do you need to build reports that are outside the scope of the free reports offered by Google? Multiple Account Multi-View Multi-segment Powerful ways to use goals, events, multi-channel funnels Up to ten dimensions and seven metrics -- downloaded in one query Re-usable queries over many accounts and views Big data, Efficient Refresh [...]