Back to Case Studies

Telestream: Using Google Analytics and R to Forecast Revenue Impact


Telestream sells software that enables Mac users to play Windows Media Files (.wma and .wmv) on their Mac using QuickTime or a web browser. Microsoft notified Telestream that they were removing the link from their website to the product.


Since this link provided traffic to their product, and subsequent revenue, Telestream wanted to quantify the impact of the link removal. They reached out to Blast Analytics & Marketing to devise a forecasting solution that would provide a projection of the estimated loss in monthly revenue from this change.


The first step was to understand if the backend revenue for Flip4Mac matched the revenue reporting numbers in Google Analytics. Once it was confirmed that the Google Analytics data was correct, Blast broke down the revenue for Flip4Mac into two components: revenue from the link, and all other revenue.

Blast then created three possible revenue loss scenarios for the link removal:

  • Best Case Scenario: (25% loss of revenue from the link)
  • Average Case Scenario: (50% loss of revenue from the link)
  • Worst Case Scenario: (100% loss of revenue from the link)

Blast used the statistical package R, which is a programming language and software environment for statistical computing and graphics, to forecast the revenue loss according to the outlined scenarios. By manipulating the Google Analytics data within R, Blast was able to determine the impact the link removal would have upon overall monthly revenue.


The results were presented in two different formats:

  • a presentation handout outlining the possible revenue impact of the link removal, and

  • an R markdown file which would allow Telestream to see the methodology and reproduce the analysis, if necessary.

With a forecasted loss of revenue between 2% and 8%, Blast Analytics & Marketing provided Telestream with recommendations that helped address the forecasted loss of revenue, limiting its impact.

Blast’s combined expertise in the fields of conversion research, web analytics, and SEO, make them extremely useful as an outside resource that can lend multiple perspectives toward improving our website’s performance. I particularly appreciated their efforts in understanding our business and markets rather than just applying cookie cutter solutions.

Chuck Whitlock, Creative Services and Web Development Manager


Telestream Case Study

Interested in Working with Blast?

Request More Information or Call 1 (888) 252-7866

Project Overview


  • Gain an understanding of the impact of a link removal to their sales for a specific product


  • Compared backend sales data with Google Analytics data to ensure accuracy
  • Ascertained how much revenue came from the link that was to be removed and devised three possible revenue loss scenarios
  • Used R with Google Analytics data to forecast revenue loss scenarios


  • Telestream was able to prepare ahead of time for the forecasted loss scenarios
  • A presentation handout outlined the possible revenue impact of the link removal
  • An R markdown file allowed Telestream to reproduce the analysis, if necessary



Talk to an Analytics Expert

Call 1 (888) 252-7866
or contact us below

Request Consultation

Raving Fans Read what our raving fans have to say about our work.

Google Analytics Certified Partner

View All Certifications

Strategy Driven Analytics Consulting Company
Copyright © 1999-2019 Blast Analytics & Marketing

Privacy  |  Privacy Settings  |  Terms  |  Code of Ethics