The client uniquely uses Opportunities in Salesforce to designate Scheduled Appointments. The terms ‘deals’ or ‘opportunities’ and ‘Closed Won’ or ‘Closed Lost’ were very confusing for her and the difference in terminology was causing a disconnect and distrust.
In addition, while the AM liked that she could view all the Appointments scheduled, she wanted a way to easily tell how many fit the filter without having to scroll to the bottom of the page.
Terminology Change: To fix the terminology issue, I used a CASE statement to make some switches in terminology in the report for our deal category field. “closed won” became “Completed” and “closed lost” became “Not Completed”.
Here’s the CASE statement I used:
CASE
WHEN REGEXP_MATCH(category, “open”) THEN “Open”
WHEN REGEXP_MATCH(category, “closed won”) THEN “Completed”
WHEN REGEXP_MATCH(category, “closed lost”) THEN “Not Completed”
END
Overview Number Addition: To add an easy way to the team to see how many appointments fit the filter, I added in a scorecard for the ‘record count’. I made sure that the filters between the scorecard and the chart matched exactly so the number would be consistent.
Note: not relevant for this client, but I would highly recommend doing this for revenue for other clients! Makes reporting way easier.
Edited Nolan’s integrationsFX deal template in Looker to better suit my client’s needs.
This was a huge help in increasing the client’s trust in the data we were reporting on (by matching their terminology) and made the AM’s life way easier with reporting!