|
|
| |
Tech4T offer a specialised set of data
(and database) skills,
bureau services and software to handle all
your data cleansing, manipulation, enrichment and processing needs.
We can work
with
UK, European,
USA and
Worldwide data,
held in most spreadsheet, database and
list formats
We've
been doing this for 20+ years, so have the hard won
expertise to apply to your projects.
And if you
purchase mailing or e-mail lists and wish to remove
cross-list duplicates and suppress records matching your
customer database, then our merge/purge solution is both
fast and cost effective.
The Tech4T process
At Tech4T we tend to look at data differently from most
companies and this is reflected in the methodologies and
technologies we deploy.
We fully appreciate that
when it comes to the data cleaning, enhancement and
analysis of your company-wide data, then the approaches
and tools usually adopted for the more straightforward
direct mail list processing will not cut the mustard.
The risk is simply too high and your critical business
data could be corrupted as a result.
Our focus and
'precision approach' is therefore on helping you first
ensure that your company data is 100% (or as close to
this as possible) fit for purpose.
We
then ensure that
the appropriate analytics, targeting and database
marketing resource is in place to help you grow both
customer value and profitability.
Need prospect lists?
Click here
We also add enhancement
data for profiling including
TRAC
geo-demographic systems.
Need a quote?
To provide a quotation, we
need to understand your objectives plus view a sample of
the data we will be working with. Please give us a call
to discuss this further.
|
Data Cleansing, Enrichment and Database Management
Services |
|
|
|
We
offer a fast and affordable way to tidy up your data -
from realigning data fields, standardising data
definitions across multiple databases for accurate
decision making, splitting mixed fields into
first and last names, correcting title casing, verifying
addresses and adding missing towns and Postcodes (or zip
codes), removing duplicate records, and much more. See
below for some of the ways we
can help you.
We also offer a 121 list production resource
where we use rules, data mining and segmentation to determine
which message to send to which individual, then make
selections and create the
lists that contain the personalisation and codes
to change the variable message and images.
These 'behaviour' triggers vary the content, offer, and
optionally the web
experience, delivered to each prospect by email, direct
mail and through campaign-specific microsites.
|
|
i.
|
Audit and fill gaps in your database
After
standardising your data (we can convert 80+ different formats),
we audit files in terms of field
content, population, value distribution (min, max...),
etc.
Once gaps are identified, we develop strategies to fill
the holes. This may include acquiring and fusing
external data (after
segmentation and profiling),
or even - in the case of B2B data - deriving URLs and
emails, which we ping to validate.
See also
animated e-surveys
|
 |
|
ii. |
Making selections
- Very often you need to do a mail merge or get an email
out to a subset of your database. Typically you've got a
CRM or contact management system, or perhaps are trying
to access data stored on your operations system. You
then find the support or skills you need aren't
available, or that the pieces or information you feel
should create the right list of people produce rather
different results. We can help in several ways.
Checking and correcting your source data, identifying
where interface problems exist, making the selections
for you, even circumventing the issues using leading
edge technologies and utilities.
|
|
iii.
|
Improve address quality (UK, Ireland, European,
USA, Worldwide, e-mail)
- we can take your address data and match against
various address registers and external information to
verify and enhance accuracy. Where department name
and/or additional important comments or delivery
instructions are nested in the address lines, then we
are able to retain this information 'as-is' or
standardise and migrate it to new fields.
|
|
iv.
|
Identify and remove duplicate records (B2B / B2C)
- in a single file or across multiple databases or
lists. Using fuzzy matching
techniques, we consolidate important information from
sets of duplicated records into new 'enriched' master
records before removing unwanted information.
|
|
|
v.
|
Standardise
formats, coding and definition - to
ensure fields align correctly - esp. if data is taken
from spreadsheets, and that product, profile or category codes, values and
descriptions, together with fields such as job title,
function, marketing measures, etc. are uniform -
with any value ranges standardised across all records.
This prevents data misinterpretation, enables more
accurate list selection and helps identify gaps in your
data!
|
|
vi.
|
Data restructure
and enhancement
- improve data format and field
layout; splitting fields containing mixed names or data;
defining gender from first names; correctly casing
Irish, Scottish... surnames - Macdonald > MacDonald
etc.; salutation generation; etc.
|
|
vii.
|
Merge, de-duplicate
and integrate 'difficult to link' databases,
spreadsheets and lists...
website interests, order details, customer data, mailing
lists, email lists, surveys, etc.
|
viii.
|
Database development, enrichment and suppression
We can source and add data to enhance your database.
We can then enrich this by including lifestyle,
demographic, SIC, company profile, industrial
datasets...
...and also provide the
SONAR and Wealth
predictor datasets for consumer profiling.
For suppression, we can use several external datasets
including: NCOA (National change of address), GAS
(Gone-away suppression), Deceased (Mortality), MPS
(Mailing Preference Service), TPS (Telephone Preference
Service), etc.
|
|
 |
|
ix.
|
Create and maintain a fully merged marketing
database
- giving you a single 360° view of your prospects,
members, customers...
|
|
x.
|
Produce mailing files
- managing campaigns, making selections, extracting lists
with codes to vary dynamic content messages, etc.
|
|
xi.
|
Migrate your data
- preparing files to move from one computer system to
another
|
|
xii.
|
Compare database
content across multiple files or snapshots of your data
over time - on a record by record, field
by field basis. This helps you identify records that
have changed so you can more easily understand and
analyse behaviour change or ensure you are using the
right file for your analysis or mailing!
|
|
xiii.
|
Transform your data
- ready for analysis and predictive targeting
|
|
xiv. |
Unwrap/wrap data - when you want to
split information across several records, or bring
multiple fields into one record, then we can undertake
this work for you.
-
Unwrap/Wrap records from a common fileon file
-
Combine/Wrap fields from different records into one
-
Unwrap
single records containing several names or addresses
to create separate records for each name or address
-
Wrap
multiple records containing the data you need into
one record
-
Select
common information to go across all records
-
Take
information from a record and split into other
records
|
|
|
|
|
Pricing - our data improvement and enrichment
services are usually charged on a per project basis, due to the
number of factors that can come into play. We
take
account of your specific objectives, the required deliverables and
timescales,
the quality and state of your data,
the number of files involved and the complexity of the task.
We
tend to
base our quotation on realistic time
estimations or actual time taken, plus any data costs as appropriate.
Often, for data enrichment though, a mix of time and a cost per 1000 (for
the number of records processed) and/or cost per record
suppressed/enhanced, is applied.
Software
Our technical guide to data structures and Postcodes
Back to
data services home page
|
Outline your data shaping needs
- call Tech4T on
01733 890790
or
click here
 Technologies4Targeting Ltd., Geneva House, 3 Park
Road, Peterborough. PE1 2UX. United Kingdom
Tel: +44 (0) 1733 890790 Fax: +44 (0)1733 890799 Web:
www.technologies4targeting.co.uk
Email:
info@tech4t.co.uk
Tech4T
also partner with marketing and IT service providers to deliver
data-driven solutions to their clients
|
|
|
