Skip to main content

A personal dashboard keeping my (Salesforce) house in order

I've put a 'penalty box' on my reps' dynamic dashboard. This section of their dashboard calls out items that they own that require attention. Their penalty box includes issues such as
  • open opportunities with a close date in the past
  • forecasted opportunities with no quote issued
  • open opportunities that include inactive SKUs
  • MQLs that haven't been addressed after some period of time
  • stale opportunities (untouched in, say, 30 days)
  • early-stage opportunities with near-term close dates
These are intended to keep the reps honest and help them keep their pipeline clean.

But I have my own Salesforce hygiene issues to keep up with. So I've created my own dashboard to keep these front and center. I can't necessarily fix all the issues today (who gets those leads when the territory is vacant?), but I want to fix what I can, and then keep sight of others needing attention.

My personal cleanup dashboard includes the following:
  • Open opportunities owned by an inactive user.
    • When a rep leaves, we'll typically review their open opps. Some may be immediately disqualified (marked closed-lost). Some may get reassigned. But others may sit until we hire a backfill. This dashboard component keeps visibility on those 'in-limbo' deals.
  • Products on committed opportunities that haven't been set up in our ERP.
    • We have a lot more SKUs in Salesforce than we've pushed over to our ERP. The reps need them in Salesforce to quote (or even to reference prices and descriptions), but we'll only push them to the ERP as needed. This table shows me the SKUs that we're likely to sell soon, so I'll get them set up in the ERP to prepare.
  • Closed-won opportunities lacking a NetSuite Sales Order
    • When an opportunity is won, we create the order in NetSuite and record it in Salesforce. Opportunities that are won but don't have a sales order number indicate a process failure, and this element calls them out for me.
  • Former or new customers
    • We change a Status field on the Account record to Customer when we have an active contract. So I have one report showing accounts that have no active contract but are tagged as customers. ('Active' is based on the contract start and end dates on closed-won opportunities.) And a separate report calls out the opposite situation, where there IS an active contract but the account isn't shown as a customer. These are Account attributes that I can correct immediately. I also then track the changes for quarter-end reporting of customers added and lost.
  • Leads with improper owners
    • We let our marketing automation tool handle most of the lead routing. But sometimes that system doesn't get updated promptly when we have turnover. And sometimes there are other problems such that routing rules don't get applied. So I have a report on my cleanup dashboard to identify leads that are assigned to someone who shouldn't own leads. Usually, I can reassign them (one-by-one, or mass transfers). And then I often go back to address root causes with Marketing.



  • New accounts created
    • We allow reps to create their own accounts. You know the saying, "Trust but verify."? By listing all the new accounts created in the past week, I get a chance to review them all. Among my checks: ensure it's not a duplicate account; check that the website is accurate; consider whether there's a parent account; confirm the territory and the proper owner. For us, the website is of special interest as that's a key field for our data enrichment tool that brings in info such as industry, revenue, company description, fiscal year end, and number of employees.
For a number of these issues, I had previously created reports and set up subscriptions. Then I'd get an email alert when appropriate. Now I've ditched the emails and put all these alerts in one place. It's a single dashboard, scheduled to refresh every morning.

Comments

Post a Comment

Popular posts from this blog

Salesforce Pipeline Reporting - part 1 of 3

In a dozen (plus) years working with Salesforce, I've never been entirely happy with the built in reporting of my opportunity pipeline. I can export details, or a printed (formatted) view, but I lose the interactivity. I can use a dashboard, which is better now in Lightning in that I can see a lot more fields in a table component. But flexible views require filtered dashboards, and just maintaining the filter values (if they go down to a rep level) can be onerous. Plus applying (or removing) a filter tests my (very limited) patience. So I've typically exported the report details into Excel, and there created a workbook that includes (1) summary info, (2) scrollable deal lists with hyperlinks back to the opportunity records in Salesforce and (3) filters that let me instantly switch views, say among teams, reps, opportunity types, or fiscal periods. My process around this involved LOTS of VBA and LOTS of formulas. Lately, I've (finally) gotten turned on to slicers in Exc
Post a Comment
Read more

Salesforce reporting: XL-Connector and VBA

In an earlier post , I mentioned a tool I'm using to import Salesforce data - via SOQL or existing reports - into Excel. This post is more about using that tool, XL-Connector from Xappex . Here, I'll walk through the (simple) process of importing and refreshing a report, and I'll provide a simple VBA macro to automate the refresh. In a future post, I'll expand on that macro to show a friendly view of my opportunity pipeline and a single-page view of how each of my sales reps are doing against a series of KPIs. Importing a report is simple enough. From the XL-Connector tab, select Log In and enter your credentials. I'm using the old id and password (as opposed to SSO), so I provide that along with my 'token'.  (Don't remember your token? Log in to Salesforce via your browser, click on your photo, select Settings, then 'reset my security token'.) Once you're logged in the lock turns green. Back in Excel, on the XL-Connector tab, select
Post a Comment
Read more

Using Excel with Salesforce: One tool, two tips

Obviously, Salesforce has strong built-in reporting tools. And I'm a big fan of the dashboards, especially filtered dashboards and dynamic dashboards. WAY better than the old approach of creating a unique set of reports and a corresponding dashboard for every conceivable view. Still, I often want to pull my Salesforce data into Excel. This might be for further manipulation / processing, aggregating data that doesn't live in Salesforce, or distribution to non-Salesforce users (hey, those licenses are expensive!). Reporting Tool - XL-Connector: I'm using a new (to me) tool when I have to repeatedly pull Salesforce data into Excel: XL-Connector  (fka Enabler 4 Excel) from Xappex. There's a lot you can do with XL-Connector. My primary use is just to extract data from Salesforce, and this can be done in two ways: reports or SOQL queries. The great part is that once you've captured data into an Excel file, refreshing the data is trivial. I've stored my credential
Post a Comment
Read more