← Mikaeel Faraz

CRM automation that tells account managers where to look

Role
Designed and built the automation; maintain it
Users
Account managers and support
Period
Jan 2026 to now
Stack
Zoho CRM, Deluge, Slack API, AWS Lambda
Status
In production

Account managers used to find struggling venues by reading dashboards. I built CRM automation that does the watching: it reads each venue’s numbers, opens a task when something changes enough to matter, gives it to the right person, and closes it when things recover.

Try it: an example run with made-up numbers

  1. Yesterday’s numbers arriveAdoption 34% below this venue’s usual
  2. Is someone already working this venue?No
  3. Is the drop big enough to be worth a call?Yes (34% against a 25% line)
  4. Task for the venue’s account managerOpened with the reason, the owner and a due date.

One task, one owner. Fictional venue, fictional numbers.

Illustration with made-up numbers and a made-up threshold

Why it is harder than it sounds

A naive rule makes things worse. Flag every change and the same venue appears every day, the queue fills with noise, and people stop trusting it. Most of the work is in the controls that keep an automated queue worth reading.

Decisions

  • Ask whether someone is already working a venue before asking whether its numbers changed.
  • A task cannot be closed without a note, so the queue doubles as a record of what was done.
  • Write handover guides as I go, so someone else can maintain it.

Before and after

BeforeAfter
How venues needing attention were foundDashboards and memoryTasks created automatically, with an owner
Duplicate and stale tasksCommonPrevented

This describes internal work at qlub. Names, internal rules and business data are left out on purpose. If you want the detail behind any of it, email mikaeel2013@gmail.com and I will walk you through it.