A customer spreadsheet is a database with no rules, no history and one person allowed to edit it.
Early accessCustomer Database Software in Shropshire
Customer Database Software for businesses across Shropshire. CubeCRM supports Shrewsbury, Telford and Oswestry with setup, data import and UK-based support. Talk to us on 01234 672 617.
- Part of CubeCRM
- Shropshire
- 01234 672 617
We work with businesses right across Shropshire, and the pattern is a familiar one: customers held in a few inboxes, a spreadsheet and the memory of whoever last spoke to them.
Getting customer database right is usually the part of that people want to fix first.
Almost every business starts with its customers in a spreadsheet, and for a while that is fine. Then the spreadsheet grows columns nobody understands, several copies appear, somebody sorts one column and not the others, and the question "which customers bought from us last year but not this year?" becomes an afternoon of work. CubeCRM turns that spreadsheet into a proper customer database: one record per customer with rules about what must be filled in, duplicates prevented, every change recorded, and the history of every conversation, quote and case attached. Segments and lists can be built from anything on the record in seconds, and the data stays in step with your accounts package.
- 1
Record per customer, duplicates prevented
- Any
Field can drive a segment or list
- Every
Change recorded, with who and when
What it does
Inside customer database software
The parts of CubeCRM that make up customer database. Everything here sits on the same customer record, so nothing needs re-keying between them.
From spreadsheet to database
Your existing columns mapped to proper fields during import, with required fields, picklists and validation so the data stays clean from then on.
One record per customer
Duplicates merged on import and prevented afterwards, so the same customer is not in the list three times with three phone numbers.
Custom fields as standard
Add the fields your business needs - sector, size, account tier, equipment installed, renewal month - without paying for a higher edition.
Segments in seconds
Build lists from any combination of fields and history - "customers in the Midlands with no contact in six months" - and save them for next time.
Every change recorded
An audit trail of who changed what and when, so an overwritten phone number can be traced and put back.
In step with the accounts
Customer details and invoiced revenue shared with Xero, Sage or QuickBooks, so the database and the ledger agree.
In practice
Problems this actually solves
Typical situations, anonymised. What businesses tell us before they change anything, and what changes afterwards.
- Case 1
The spreadsheet only one person could edit
Before
A trade supplier’s customer list was a large spreadsheet maintained by the office manager. Others had read-only copies, which were always slightly out of date, and her holidays meant a fortnight of changes waiting.
With CubeCRM
The spreadsheet became a CubeCRM database the whole team can update, with required fields and an audit trail. The office manager now reviews the data rather than being its only editor.
- Case 2
Lapsed customers nobody could list
Before
A wholesaler wanted to contact customers who had ordered the previous year but not this year. Producing the list meant cross-referencing the spreadsheet with an export from the accounts package.
With CubeCRM
With invoiced revenue synced from the accounts package, the lapsed-customer list is a saved segment that updates itself. A monthly call campaign now works through it.
- Case 3
Columns nobody understood
Before
A service company’s customer spreadsheet had grown to over sixty columns, several with names like "Status 2" and "Old ref". Nobody was sure which were still used.
With CubeCRM
Import was an opportunity to agree what each field meant. The useful twenty became proper fields with picklists, the rest were archived, and the data became trustworthy again.
The features behind it
See the parts doing the work
Each one has its own page showing how it works. And if the business later needs orders and stock, CubeCRM grows into CubeERP on the same records.
Contact records
One shared record per customer: every company, site, contact and role, with every email, call, quote and case on the same timeline.
See how it worksSegments & campaigns
Build lists from anything on the customer record, sync them to Mailchimp, and track which campaigns turn into enquiries and won work.
See how it works
Local coverage
Customer database across Shropshire
Our Shropshire coverage includes Shrewsbury, Telford, Oswestry, Ludlow, Market Drayton and Bridgnorth, and the SY1, SY2, SY3, SY4 and SY5 postcode districts. If you are in Shropshire and not on that list, we almost certainly still cover you - ask.
95miles from our Olney office
Discovery and training can be done at your office - watching how enquiries really arrive and how the team really sells tells us more than any questionnaire.
Postcode districts
- SY1
- SY2
- SY3
- SY4
- SY5
- SY6
- SY7
- SY8
- SY9
- SY10
- SY11
- SY12
- SY13
- SY14
- TF1
- TF2
- TF3
- TF4
- TF5
- TF6
- TF7
- TF8
- TF9
- TF10
- TF11
- TF12
- TF13
Areas we cover
Shrewsbury, Telford, Oswestry, Ludlow, Market Drayton, Bridgnorth, Whitchurch and Church Stretton.
Customer database elsewhere in Shropshire
How it happens
What getting started involves
The same process wherever you are, and for Shropshire discovery and training can be done in person.
- 1
Discovery
A short, structured session on how enquiries arrive, how you quote, and where customer information lives now - the inboxes, the spreadsheet, the old CRM and the notebook in the car. We come back with what works as standard and what needs configuring.
- 2
Setup
Pipeline stages, fields, quote templates, email connection, teams and permissions set up to match how you sell - not a demo account with your logo dropped on it.
- 3
Data import
Contacts, companies, open opportunities and quote history brought across from spreadsheets, inboxes or your previous CRM, with duplicates merged. You check it against what you had before anybody switches over.
- 4
Training & rollout
Short, role-based training so the sales team learns the pipeline and the office learns enquiries and cases - in person where it helps. Guides and screen recordings left behind for new starters.
- 5
Ongoing support
UK support from the people who built the platform, with a named contact, agreed response times, and a product roadmap you can influence.
You might call it something else
If you searched for any of these, this is the page you wanted.
- Customer database system
- Customer records software
- Client database
- Customer list software
- Single customer view
Questions
The things people ask first
We map your columns to CubeCRM fields during setup, clean and de-duplicate the data, and import it. You check the result against the spreadsheet before switching over.
Yes. Custom fields, including picklists, dates, numbers and checkboxes, are part of the standard product. Setup is a good time to decide which columns are still worth keeping.
Yes, at any time, in full and in open formats. Saved lists can also be exported to a spreadsheet when you need one.
Yes - it is a full CRM, with enquiries, pipeline, quotes, email sync and service cases on the same records. But plenty of businesses start by using it as a better customer database and add the rest later.
Related
Other things we can put right
Also available in Shropshire.
Contact Management Software
Every customer, supplier and prospect contact in one shared, searchable place - with companies, roles, history and consent attached.
Small Business CRM
A CRM a small team can set up in weeks and actually keep up to date - contacts, enquiries, quotes and follow-ups without the enterprise baggage.
Cloud CRM Software
An online CRM hosted in UK data centres - nothing to install, nothing to back up, and the same customer record on every desk and every phone.
CRM Software
Contacts, enquiries, pipeline, quotes, follow-ups and service in one shared customer record - built in the UK for growing businesses.
Working in Shropshire?
Customer database for your Shropshire business
Tell us what your current system does badly. We will tell you whether CubeCRM fixes it, and what it would take.