Publishing: Advertising - Sales Analysis

Sales Reps up by Revenue

Click to enlarge

The names in this report are sorted by who is selling the most. Then create a bar graph to reveal which Areas (Zip Codes) the salesperson sold more or less in, compared to last year.



"The response to the product has been very positive. We have been able to bring in a lot of detail data that, until now, was the type of information that was kept out on spreadsheets on a user's desktop. This has added a lot more value to what our users are able to dive into."

Rosanne Smola, Project Leader
Copley Press

Sales Reps down by Lines

Click to enlarge

The left side of this report lists Lines that salespeople sold Last Year to Date, Lines this Year to Date, and the difference between the two. The right side displays a bar graph: each salesperson's customers have two bars representing the Total Number of Lines or Inches they ran last year and what they ran this year, making the largest differences stand out at a glance. You simply click on a salesperson on the left to see his/her customers on the right.



"By analyzing linage, revenue, and ad-count, I'm able to track statistics and promotions and provide managers with the exact detailed information they requested. Access to the data is fast. I can look up data and, in less than a minute, pinpoint the details that I'm looking for."

Michael Kooner, Information Coordinator
Pacific Press

Lines Sold by Salesteam

Click to enlarge

Two tabular graphs list Lines sold Year to Date, Lines sold Last Year to Date, Change in Lines, and the Percentage Change for each sales manager, and salespeople who report to that sales manager. (You just click on each sales manager's name to display the salespeople who report to him/her.)



"Diver will help us perform better analyses of our business in both the Circulation and Advertising arenas by allowing us to data-mine the information from our business systems."

Michael Lillis, Chief Technology Officer
New York Post

Classifieds YTD by Manager

Click to enlarge

This "Split Window" report presents the same data in both a tabular view and a bar graph. Lines Sold and Revenue Year-to-Date are revealed for each sales manager.



"By analyzing linage, revenue, and ad-count, I'm able to track statistics and promotions and provide managers with the exact detailed information they requested. Access to the data is fast. I can look up data and, in less than a minute, pinpoint the details that I'm looking for."

Michael Kooner, Information Coordinator
Pacific Press

Sales Rep's Average Revenue by Account

Click to enlarge

Total Revenue, Number of Accounts and the Average Revenue per Account is shown in this report for each Salesperson by Month. Click on a month listed on the far right to see each month's data.



"We have been searching for an analytical adjunct for our business software and we are looking to partner with DI because they are a company that offers a highly advanced and economical solution. We will soon be able to present our customers with analytical capabilities that can be implemented in a fraction of the time that is available from competitive products."

Mark J. Ganslaw, President and CEO
Data Sciences, Inc.

Profit Margin

Click to enlarge

Profit and Margin for each saleperson is shown in a tabular report. You can view the salespeople by their managers simply by clicking on names in a pull-down menu.



"In the past, our internal reporting has been a collage of reports that left some revenue not accounted for and some revenue double counted. Accountability has increased and our commission calculations have become much tighter since we have used Diver to pull data. Also, turnaround time for revenue reports at the end of the month is much faster."" "

Jennifer LaLonde, Financial Analyst for the Windsor Star
Southam, Inc.