How this worksFive minutes to read. Ask Philip at Gecko IT if anything here is unclear.

What Retention is for

A list of our own customers worth getting in touch with, the reason, and a place to note what happened. The people and cars come from Gemini. Nothing here changes Gemini.

  1. Target · pick a group of customers, for example Kuga owners who bought two to three years ago.
  2. Reach them · ring them from a call list, text them, send letters, or email the few who have an address.
  3. Today's calls · work through the list, ring, and log what happened.
  4. Results · see how many were contacted, booked and sold for each campaign.

Who is on the lists

Everyone is in one of four groups, by when they last did business with us:

  • Active · bought here in the last five years, serviced or in our workshop in the last two, or MOT still current. About 2,600 people. Target starts with just these.
  • Gone cold · last dealt with us two to five years ago. Worth a "we have missed you".
  • Long gone · over five years ago.
  • No history · on file, but no sale or workshop job with us.

Pick a group with the Customers chips on Target, or on the Customers tab to browse them.

  • Trade buyers, other garages and Gemini's own internal accounts are left out.
  • Anyone marked do not contact never appears anywhere.
  • Someone contacted in the last 30 days about the same thing drops off until next month.
  • Someone who said not interested stays off that list for four months.

Trade buyers

A sale counts as trade if Gemini's Sale Type says Trade, or the buyer's account is a trade account. The Trade buyers page lists every trade account: how many cars they have bought, when they last bought and what they spent, for one salesperson or everyone. "Gone quiet" means nothing bought for over two years. Motability, insurers, finance companies and Daron's own accounts are neither retail nor trade, so they are left out of both. Trade buyers follow the same contact rules as everyone else for now, and few have given permission for calls or emails in Gemini.

Target · building a group

Tap chips to narrow the group. Each chip shows how many people you would get. The group is written out in words at the top so there is no doubt what you chose. Clear all starts again.

  • Retail or trade · starts on Retail. Pick Trade for sales to trade buyers, and Sold by to see one person's. Trade shows one line per car sold.
  • Customers · Active, Gone cold, Long gone or No history. Active is on to start with.
  • Car · the family, so Fiesta covers every Fiesta model.
  • Bought from us · counted back from today. "2 to 3 years ago" is the sweet spot for a change of car.
  • Finance · who the car is financed with. Cash means no finance recorded.
  • Last in our workshop · when we last serviced or MOT'd the car.
  • Coming up · MOT or service due soon. Groups built on this count as reminders, see the rules below.
  • Reach by · only people we are allowed to phone, text, email or post to.
  • Leave out · ticked by default, so nobody gets pestered.

Tap a box at the top (In this group, Can phone, Can text, Can post, Can email) to list just those people underneath. Tap it again to see everyone.

Then reach them.

  • Start calling · saves the group and puts everyone who can be phoned on Today's calls, for you or for whoever you choose.
  • Pick a template · texts and emails start from a ready-made message: changing car, finance ending, buying their car, test drives, MOT and service due, workshop, winter and summer checks, thank you, sorry I missed you, and we've missed you. Names, car and dates fill in for each person, and you can change any of it before it goes.
  • Send texts · one text each from the Daron number. Check the message and the cost first; about 4p a text, double if it is over 160 characters. Replies come back into the hub.
  • Download addresses · a spreadsheet for a Word mail merge. Letter text gives you a letter to start from. Each person gets a "Letter sent" on their history.
  • Draft emails · from the template you pick, one at a time to check, sent from your own Outlook. Few customers have an email address on file.
  • Save as campaign · keeps the group so Results can track it. Give it a name you will recognise.

Today's calls

  • One card per person with every reason to ring them, soonest first. Tap the number to dial on a mobile.
  • Log outcome after every call, even "no answer". It keeps the list honest and feeds Results. Type a quick note as you go; it shows on their history.
  • Each card has a line of history: when they were last in our workshop, how many visits, and how many cars they bought from us.
  • Set a call-back date and the person comes round again on that day under Call-backs due.
  • Text replies at the top are customers texting back. Replies to your own texts come first, marked "reply to your text", and you get an email about them. The browser tab shows how many are waiting, for example (2). Open the card, deal with it, then Mark handled.
  • If someone asks not to be contacted, choose Do not contact again. They disappear from everything, including after the next import.

Customers

  • Search by name, registration, postcode, phone, email, town or Gemini account number.
  • Tap a name for a quick look, or Open for their full page. Both show everything we have done with them, newest first: every car they bought, every workshop job, every call, text, reply and letter. Tap a car to see just that car, or the registration for the car's own page (owners over time and every job on it).
  • Spent with us counts the cars they bought, their workshop visits and what they spent on retail workshop jobs.
  • Permissions can be changed on the card. If a customer tells you they are happy to be texted, tick Marketing texts there and then.
  • Record a TPS check after checking a number against the Telephone Preference Service.

The rules, in plain English

These are the UK rules on marketing calls, texts and emails. The hub applies them for you, so you only need the gist.

WhatAllowed when
Reminder about their own car · MOT due, service dueAlways, by any channel, unless they are marked do not contact.
Marketing call · finance ending, change of car, seasonal offerPhone permission is on and the number has been checked against TPS in the last 28 days. A number on the TPS register may not be called for marketing.
Marketing textText permission is on. Every marketing text ends "Reply STOP to opt out", and STOP switches the permission off by itself.
LetterMailshot permission is on.
Marketing emailEmail permission is on. Each email offers a way to say no.
Anything at allNever, if they are marked do not contact, or Gemini has them as deceased.

Permissions come from Gemini's Exclude flags and are updated at each import. Anything you change on a customer card here is kept.

Keeping the data fresh

  • Once a month, run the three saved queries in Gemini's Data Export (Hub - Customers, Hub - Vehicles, Hub - Sales), export each to CSV and load them on the Import from Gemini tab, in that order.
  • Re-loading updates what changed and adds new people. Nothing is deleted and your notes, permissions and contacts are kept.
  • Keep the CSV files on the office PC or Daron's SharePoint. Do not email them.

Common questions

  • Someone is missing. They may be in another group (try the Customers chips on Target), or Gemini may list them as a company or trade account. Search for them under Customers and check the card.
  • No one has an email. Right, few do in Gemini. Texts and calls are the main channels. Ask for an email when you speak to people and add it to the card.
  • Why is Can email so low in Target? It only counts people with an address and email permission.
  • Finance coming to an end is empty. Gemini does not hold the end dates. Use "Car is about three years old" instead; it shows who is on finance.
  • Send texts says not set up. The text service has not been connected yet. Use Download texts in the meantime.