The problem: In my last post I discussed the importance of identifying your data quality so you can plan how to tackle it. After reading that post someone asked me if I could combine my data quality score with a declarative progress bar instead of stars. The answer is YES and I'd love to show … Continue reading Create A Data Quality Progress Bar 🔋
Tag: Formula
Lead Scoring by Data Quality ⭐⭐⭐⭐
The problem: Bad data plagues us all. In all seriousness, if you don't have bad data then we need to talk so you can tell me your secrets... Poor data quality has many consequences, here are just a few: ❌ Poor user adoption ❌ Lack of executive buy in ❌ Unreliable reports and dashboards ❌ Slower on-boarding of … Continue reading Lead Scoring by Data Quality ⭐⭐⭐⭐
MAX your roll-ups! Are you keeping an eye on your lapsed customers? 👀 📆
The Problem: Wouldn't it be great if you could easily see the date of your last won opportunity directly on the account record page, instead of sifting through your opportunities? Even better, if you could identify an account as a current or past customer at a glance. I don't know about your business, but in … Continue reading MAX your roll-ups! Are you keeping an eye on your lapsed customers? 👀 📆
MIN for the win! Date stamp when an account became a customer 📆
The Problem: I recently wanted to date stamp when an account became a customer. For my purposes this date was the 'Close Date' of the very first won opportunity. My first instinct was to reach for Process Builder (I love it!), but I had a niggling feeling I was over-complicating things and there was a … Continue reading MIN for the win! Date stamp when an account became a customer 📆
🚩Warning! Unhappy customer ahead…🚩
The problem Let's start with a little story... Winn Ing - EMEA Sales Team Member "In the past 12 months I sold some widgets to ABC Technology. The sale went well and I'm pretty sure they like me 😃 I venture that I could probably sell them some more widgets. I get on the phone, … Continue reading 🚩Warning! Unhappy customer ahead…🚩
Create a Declarative Progress Bar
Use Case: Alastair Hill works as a Salesforce System Administrator at Universal Containers and has been asked to provide a visual progress bar to enable users to see, at a glance, the status of support tasks' completeness. These bars need to be presented on record pages, list views and reports and should represent, graphically, … Continue reading Create a Declarative Progress Bar
The Everyday Admin 