Whenever I get a request for a new dashboard I try to use dashboard filters where possible instead of over-filtering the underlying reports. The reason? It's easier to re-use or clone the reports and dashboard in future. I love dashboard filters and very often find myself filtering on picklists like Opportunity Stage or Account Type. … Continue reading Dashboard date filters: the best feature you’re not using yet…
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 🔋
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 ⭐⭐⭐⭐
I debated posting this time saving tip for fear of being laughed out of the Salesforce community...maybe this one is too obvious, maybe it's just me that missed it?! Then I read #WTHWednesday – The Accidentals’ Salesforce Fails (Take 1) and saw several face-palm scenarios I thought no one else experienced. So, if I missed this … Continue reading Time saving tips: There’s a search bar in the App Launcher 🤦♀️
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? 👀 📆
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 📆
Ah standard report types....how we love your default columns. We absolutely do not spend an age removing the default columns every time we create a new report (hint: we do). The Lightning report builder has a really nifty solution for this! You can use the 'Remove All Columns' button. It does what it says on … Continue reading Time saving tips: Remove all report columns with a single click using the Lightning report builder!
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…🚩
The problem GDPR + users that don't check contact preferences, does not a happy prospect make (and could have some pretty serious consequences). Salesforce natively provide us with the standard fields 'Do Not Call' and 'Email Opt Out' but if your org is anything like mine, these fields tend to end up at the bottom … Continue reading Contact preferences your users can’t ignore!
The problem When a customer gets in touch with an issue, the first thing your service department do is view the account record to check the SLA. The SLA information is right down the bottom of the page so users are asking for a quicker way to identify VIP customers, in this case, those with … Continue reading Highlight your VIP customers based on SLA