PROJECTS


  • Outdated and Error Prone Circulation Budgeting and Forecasting: Marketing staff spent too much time manually preparing models at the expense of marketing priorities.
  • Solution: Streamlined customer acquisition and retention marketing models and reporting. Created enhanced efficient marketing budgeting and forecasting process. Introduced new and improved renewal rate forecasting techniques.
  • Inadequate Management Reporting: Financial reports didn’t give the publisher all the information when he needed it and in the way he needed it to manage the business.
  • Solution: Created executive dashboard and reports showcasing financial, subscription acquisition, retention, retail sales and digital results. Tools used: Advance Excel, Cognos TM1, Tableau.
  • Newsstand Channel: Management was uncertain about the value added by our newsstand operation and was coming under pressure to kill the channel.
  • Solution: Created long term newsstand customer value model that showed significant number of newsstand buyers subsequently buy subscriptions and other CR products.
  • Special Interest Publication Portfolio: Management had no ways of knowing the profitability of individual Newsstand Special Interest Publications and so could not prioritize.
  • Solution: Built P&L models to determine the profitability of each Special Interest Publication. This enabled management to fine-tune its portfolio of SIP’s. It also enabled the newsstand and editorial staff to know and manage their budgets.
  • Inefficient Marketing processes: Marketing financial functions were inefficient, time consuming and error prone.
  • Solution: Enhanced business operations working closely with the acquisition and retention teams to streamline premium inventory, postage, mail analysis etc.
  • Getting Feedback from Readers was inefficient and only produced negative feedback: Management needed to know positive as well as negative reaction to the magazine and requested a feedback loop.
  • Solution: Lead project to create a feedback loop using IBM SPSS modeler text mining tools.
  • Digital App and Replica Sales Declining: CR magazine’s digital App was designed for just the Apple IPAD and could not run on any other mobile device, including iPhones and Android phones and tablets, or desktop. This limited digital replica revenue especially as IPAD sales and market share declined against the new technologies. Moreover, the magazine was being published as PDF replicas on other platforms which was considered a poor user experience and therefore held back sales.
  • Solution: Initiated conversion of IPAD App and PDF digital replicas to responsive design. This would enable anyone to buy and read CR content on any device. This would open up millions of new digital subscribers and readers to CR magazine.