← Back to essays

Boring Learnings About Building 2 CRM's for 2 Companies in 3 Months

How to Design the CRM

  1. CRM Strategy Design — ICP, Workflows, Lifecycle, Pipelines
  2. Customising properties within objects
  3. Automation & Pipeline Stages
  4. Marketing Assets Setup
  5. UTM Tracking System
  6. Campaign Object System
  7. Data, Reporting & Dashboards

A CRM Basically Works Like This

1. CRM Strategy Design

Before setting up the CRM, it's a good idea to map out the actual marketing/sales/operations processes associated with the CRM. Basically, all the rest of the steps.

Most important things would be:

2. Customising Properties within Objects

You have a bunch of objects which are equivalent to different sheets in an Airtable or a Google Sheet. Then, within each object you have a list of attributes which are equivalent to the columns within each of the objects. Then, you put data in each of these attributes and you have that be the actual data for each of the customers.

So, the first thing to define for any CRM is what objects do you want to have. For a website business, you might have: deals, contacts, leads, clients, support-tickets. But, for an energy installation business, you might also add meter, battery, site, finance partner & partner. This is the base that then determines how you set up the rest of your system.

An interesting point here is to never use free text. Instead, always use boolean or dropdown text. This allows for better tracking & better analytics reporting because you can see which statistics are related to which dropdowns.

The goal of objects is to fill as much relevant data as possible so that people can understand the client profile, collect data around sales timelines, close %, different % of touch-points. All objects are relational meaning that one deal is linked to their contact, company, meter, asset finance partner etc. This allows you to map different data from different objects against one another.

3. Workflow Stages

You create pipelines to manage companies going through the pipeline. Sales reps typically do this manually and will move people through different stages e.g. to qualify as a lead, to sign the deal, energy installation onboarding & customer support tickets. A big part of sales reps day is just updating the CRM, ensuring deals are in the right stages, ensuring contacts have the right data & enrolling contacts in sequences to then fulfil your daily activities.

To move candidates across the pipeline, you generally have two options:

(1) Have exit criteria & automation workflows running in the background. Here, you also create automatic tasks in the background for reps to check in on deals & make appropriate actions from that.

(2) Manually moving deals across the pipeline.

Option 1 is generally more attractive.

To collect this data, you typically try to collect as much from the initial lead-capture. You run a landing page & collect data. However, these days clay.com, clearbit are the best tools to achieve this! With clay, you can run an automated sequence every-day, or you can have a webhook every time a new contact is created. From there, you use various agents to research and fill in the data for all the relevant fields that you need to fill in. This saves sales reps time, ensures the data is clean & can be used effectively. You also use dropdown over free text because it allows you to filter by leads. You also collect data by making it mandatory when moving between stages.

From here, you generally have workflows to automate all the necessary steps to try and take as much as possible. So, you have automations when a person enters a sequence to enrol them in a potential sequence, update their record, add them to a certain list, have agents scrape certain data. Though, most of them revolve around email sequences where previously you had to send basically the same email. Now, you can have settings where "If contact becomes qualified lead" then enter them in email nurture sequence.

You have different workflows which basically consist of various automations that work on an if/then basis for all potential leads/contacts. So, for leads + deals + sites + install ops + billing, certain actions like data being missing, delays in pipeline progression, if stage progresses then create object.

Typical sequences include: cold outbound, warm-lead from ads + white-paper + lead magnet, no-show to discovery, no-show to close-call, post proposal-meeting, logging back into the software, haven't signed contract for a long time, onboarding, customer education throughout product experience.

4. Marketing Assets Setup

HubSpot & CRMs typically have both marketing & sales functionality.

The marketing section is comprised of campaigns & assets. Each campaign has a tonne of assets from which it can view analytics for. The purpose of a campaign is to aggregate all the data for a particular geography, time period, product, service etc

For example, if Cable Energy was to push an initial marketing campaign comprised of 2 email marketing campaigns, SMS campaign, Meta ads, Google PPC, Social Content for a launch on August 15th. Then, they would be able to track all of them in one spot.

Generally, the most common assets used are:

5. UTM Tracking System

Generally, people track attribution via UTM codes i.e. in every CTA on each ad, landing page, email template, content post, you embed a tracking URL called UTM_code = PPC, UTM_code = campaign34 & that allows you to track sessions for that particular campaign.

For example, in an email marketing campaign, you'll have UTM codes in every CTA button & different ones at different points on the page. You'll also have different UTM tracking codes on different landing pages.

6. Dashboard & Reporting

Finally, the purpose of the CRM is that it allows you to track all the metrics associated with sales in an easy way. This allows managers to assess KPIs that they're working towards like and optimise against them.

For example, some key volume stats are number of leads generated → number of discovery calls → number of close calls → number of offers presented → contracts signed → payments made. All those touch-points are potential leakages & you can conversion-rate optimise every part of that funnel. The CRM allows you to do that. Also, can track things like what % of leads came from where, CAC, LTV, time to install.

To control the CRM, you'll have different people managing different parts of the pipeline. For example, sales reps will manage the pipeline flow, customer support the onboarding flow, SDRs the leads.