|
 
|
| |
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 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.
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.
Software
Guide to data structures and Postcodes
|
|
|
|
Data Cleansing, Enrichment,
Database Management Services
We offer a fast and affordable way to tidy up and
combine your data
-
-
Realigning data fields and migrating databases
across different software
-
Standardising data definitions
across multiple databases for accurate decision making
-
Combining multiple spreadsheets, lists and databases
to give you a single customer view
-
Splitting data into separate fields and correcting title
and other casing
-
Verifying addresses and adding missing towns and Postcodes
(or zip codes)
-
Removing duplicate records, merging spreadsheets,
files, databases... 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 data
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 (see
merging below) external
data (after
segmentation and profiling), or even - in the
case of B2B data - deriving URLs and validating emails.
See
also
animated e-surveys
|
 |
|
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!
Most importantly, when making company-wide (or
group-wide) data-based decisions that rely on disparate
operational or financial data to provide the
intelligence, that 'intelligence' can easily be skewed
if data has not been correctly aligned and meanings
standardised into one single data source.
iii)
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.
|
iv) Identify
and remove duplicate records (B2B / B2C)
We remove duplicate records
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.
Importantly, we ensure there is no loss of important
data!
|
v) Improve address quality (UK,
Ireland, European, USA, Worldwide, e-mail)
We
can take your address data and match against various worldwide
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.
|
vii) 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.
|
viii) Fusing
addition data to fill gaps and merging, de-duplicating
and integrating 'difficult to link' databases, spreadsheets
and lists...
...website interests, order
details, customer data, mailing and lists, surveys,
etc.
We use advanced matching algorithms and special software
to ensure accurate matching when combining files or appending
data for enhancement (SIC codes, Employee, Fleet, 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. We
have extensive experience of this kind of work,
especially systems such as SAP, Siebel, Act, Goldmine,
Maximiser...
|
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. This includes
aggregation and data recoding.
|
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 file-on-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
|
|
|
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
|
|
|
