Hi Steve,
I would love to be able to have some kind of dashboard with better metrics, tracking sales efficiency that goes beyond the current features in Activities.
To illustrate, here is a example of the project that I am currently working on, and the setup I customized to get the data I need.
I have a sales campaign targeting potential advertisers for our new travel guide. The goal is to maximize sales. To achieve it, I want to make sure that all prospects who fit the target profile are contacted and an offer is presented to them. Also I want to make sure that my sales staff (full time and part-time) has an optimum allocation of their time, in order to contact the maximum number of prospects in the time available.
Step 1) I’ve customized “Company” form by removing unnecessary fields and added the custom fields “current sales status” (not contacted, in discussion, won, lost) and “Company type”
Step 2) I’ve created a special Tag for this sales campaign and used it on all companies in Solve that fit the target profile. The ones not in Solve I’ve added in the system.
Step 3) In order to track the results of this campaign I select the campaign tag and export the list into Excel. From there, using filters, I pull out data for this campaign like:
- How many prospects are being contacted daily; total, broken down by sales person, company type
- What is the % of won/lost by sales person, by company type
The problems I have:
- each time I want an update I need to export and filter in Excel
- “Related to” field is not exported, and I use a lot of part-time sales agents. I assigned all such Companies to one person on my staff, who than uses “Related to” field to add sales agent responsible for that company
I consider this a improvised fix, that fact I can do it attests to the great flexibility of Solve360. Fortunately I have one product type so I can customize “companies” form to get the data I need.
But I think it would make more sense if I could do this through “revenue opportunities” . I know I can customize this form, but I can’t filter it by customized fields (i.e.product / campaign) nor can I get calculation of the tracking data I need.
It sure would be great if I could.
I hope this helps.