Solve Business Problems
with Predictive Analytics

Category Archives: Excel

How to Quickly Uncover Leads in Google Analytics Data

If you are running Google Analytics, then inside your data you already have a list of leads visiting your site. Who’s going to complain about getting a quick list of sales leads interested in what you have to offer? The following video describes how to get these leads; we’ve also provided an excel [...]

  • Share/Bookmark

Using The “Linest” Function in Excel For Faster Twitter Potential Reach Analysis

Last time we looked at a way to put together an analysis for the potential reach of a tweet; today we’ll look at a method of using the ‘linest’ function in excel to make the analysis faster. When you go to Twellow to look up the users that would be interested in your business, [...]

  • Share/Bookmark

A Complex Pricing Model Made Easy by Excel (part 2)

We are now ready, having performed a historical analysis in part 1 of this post, to create a useful system for pricing. Depending on how comfortable you are with statistics and mathematical operations with standard deviations, you may or may not understand why the excel formulas are set up the way that they are. [...]

  • Share/Bookmark

A Complex Pricing Model Made Easy by Excel (part 1)

Pricing is perhaps one of the hardest aspects of marketing to get right. And even though it’s impossible to keep control over and measure all of the variables involved, using analytics can help you track and predict enough of those variables so you can set the price where it needs to be. Here, [...]

Related Posts with Thumbnails
  • Share/Bookmark