+2Hello everyone,
Reaching out to the collective intelligence with a question. I have been asked if there is a way to keep track of newly created contacts and if they ever make it to the estimate stage, if that estimate is won, and if a job is completed for them. Essentially we would like to see what percentage of contacts become customers.
I will admit I’m fairly new to Aspire, but is there any way to go about doing this?
There isn’t an elegant at-a-glance way that I’m familiar with to track from contact creation all the way through the sales process.
We deactivate the prospect contact and, if created, the property immediately if the lead doesn’t qualify for whatever reason, or if we lose the bid and we feel like there aren’t further opportunities to quote work. Can always reactivate later if necessary. If you treat the active/unactive similarly, here’s a couple lists which could help a bit.
Active Prospects with No Property (and thus no quote being worked on)
Contacts → Active, type=Prospect, Property Count=0. Sorted by newest (created date) to the top. Grouped by sales person. It helps to have the “Notes” field in the display so depending on your sales SOPs you can see on the list view if sales has made notes such as set meetings, dates contacted, etc.
You can modify Property count filter to be > 0 for basically the opposite of this list to help focus into what client properties to look at with below list.
Prospect Properties with Quotes Being Worked on
Properties → (1) Active, (2)status=Prospect, (3) Active Opportunities > 0, also sorted by newest (created date) to the top. Group by salesperson. This will display all properties that are set to prospect type which have an opportunity on them which is any status other than won or lost, so in theory being actively worked on by sales. Downside of this is your sales/admin staff need to be vigilant about changing the property status from prospect to customer once a sale is made. To help catch any that would fall through when this happens you can also add (4) In Process Opportunities > 0 which will show any Won opps which are not completed yet. so 1 and 2 and (3 or 4) in the conditional box at the top of the filter menu. I always have created date in the display of basically every property/contact list, but it’s essential for this one.
This one can help you follow up with sales if there is a prospect property that’s old (that’s a variable that highly depends on your business… idk a month or two?), which still has active opportunities that aren’t won or lost yet. Sometimes in the heat of the season you just forget to mark something as lost while you are moving fast onto the next one, or is there a legit reason why it’s sitting at delivered or bidding with no movement for a while?
This got longer than I expected… lol. I’d love to hear how other people do it.
+2I really appreciate the insight! Thank you so much. I’ll have to give this a try. I was a bit afraid I would have to manually look each customer up, which seemed extremely daunting.
+2If you don’t want to do it manually long term, either the API or Data Pipeline would give you access to the data needed to report on this. Nothing is available through Sales Pivot or anywhere I can see in Aspire.
Rough method.
Get contacts created in last 30 days that are Customer or Prospect.
Get PropertyID List from PropertyContacts for each ContactID where the PrimaryContact is true.
Get Opportunities for each PropertyID. It will return status, amount Active/Replaced.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
