About Data cleansing of I&D
"Data cleansing" or "data cleaning" is the process of maintaining(integrating) data which are managed separately on various management tools, such as business card management software, CRM, SFA, and MA so that it can be used for sales promotion activities.
Since we, I & D, acts on behalf of marketing measures such as telemarketing and digital marketing, and has MA tools developed in-company, I&D is familiar with the way of making data which produces results in sales promotion activities should be.
I&D have a dedicated consultant for business card data entry for exhibitions, various corporate data maintenance for sales promotion, and data cleansing.Please feel free to contact us, I&D will carefully and politely make proposals in line with your needs.
Data cleansing service will solve those problems.
Preparing for data so that it can be used for digital marketing.
- Integrating the Excel files which are entered the business card by each sales position.
- Solving the problem with data consistency between foreign-affiliated SFA and marketing automation.
- There are some notational fluctuations, such as sales representatives manually entering data and the same company being registered in different notations.
- The companies that don`t know what they should do because no one is familiar with data management.
Reducing unnecessary effort
- Reducing the trouble of deleting and integrating the same person.
- Finishing the identification of the name of prospect`s name as soon as possible.
- Reducing the time of checking multiple lists.
- Giving(making) meaningful company information and quickly extracting for measures.
Keeping costs down
- Improving lead data and carrying out sales promotion activities under efficient extraction conditions to reduce costs.
- Checking the alive monitoring of my e-mail address, address and confirm unnecessary destinations.
Cooperating / Transferring
- （It is necessary to maintain）/ Maintaining a database by linking business card management software and SFA.
- （We are considering to switch） Switching to CRM and SFA, or migration.
What you can do with a data cleansing service.
Integrating Excel and access lead data stored separately in the marketing department and sales department, and SFA customer information to perform redundant processing. In addition, unifying to one company name if it is registered multiple ways with different notations.
|Items||Contents||Merits of implementation|
|Company name cleaning||Unifing legal personality notation
(Unification of notation such as "Co., Ltd.", "Co., Ltd.", "Co., Ltd.")
Confirming /searching of duplication
/reducing of investigation load
|Identifing of company nam||Separating personal name into given and family name|
|Cleaning of Phone number||Corresponding such as change of area code, unification of notation
Collating with the latest phonebook data, updating data
Alive monitoring of telephone number
|Cleaning of address||Changing the address from the old town name or old city name to the new address
Collating with the latest phonebook data, data update
Reducing the cost of unnecessary call / email / DM sending
|Cleaning of Fax number||Changing area code, unification of notation|
|Cleaning of email address||Notation check
(Presence / absence of @, correction of input mistakes of "." And ",", etc.)
Alive monitoring of email address
|Coding work||Code of department / position||
Target segmention / extraction becomes easier
|Matching||Collating with the database owned by the partner company|
|Adding / provisioning of corporate information
||Please contact us for more information.|
|Information survey by Web survey||Obtaining the latest information from corporate websites and reflecting it in the data||Update of aging|
Cases of data cleansing service
[Case 1] Foreign-affiliated medical software sales company
Data preparation was required due to database transfer. The deciding factor was that we could entrust the cleaning of personal data, including department, job title, email address, etc.).
Background / Issues
CRM system transfer is decided. Checking the data inside, it turned out that there was a large amount of old data and redundant data. （It cannot be transferred as it is ...）
To unify the notation of all data and to identify the same person. Regarding to the same person data, comparing old and new data and unifying to new data.
Renewed the old data, format the data and made it usable data!
Approximate: 1.8 million yen / 45,000 cases
Service used: Data cleansing
[Case 2] Call center operating company
What kind of industry does our service sell to? I want to analyze with company data!
Background / Issues
Even though I had personal data of the customer, I couldn`t analyze the customer because I didn`t have the company information of customers ...
Carried out of the entire process from officializing the company to which the individual customer belongs to purchasing company data
Got company data which enabled us to analyze customers!
Approximate: 750,000 yen / 6,200 cases
Services used: Corporate information provision, corporate information survey, data cleansing
Standard price of data cleansing
The outline is as follows. I&D will make a proposal that suits your application, so if you can tell us the item name of the data you want to clean, I&D will calculate a estimate approximately.
* A separate basic charge is to be incurred.
|Data cleansing||Cleansing of company`s name||3 yen ~ @ 1 unit price|
|Cleansing of adress||3 yen ~ @ 1 unit price|
|Cleansing of telephone number||1 yen ~ @ 1 unit price|
|Cleansing of name||3 yen ~ @ 1 unit price|
|Cleansing of email address||2 yen ~ @ 1 unit price|
|Cleansing of Departments or position||4 yen ~ @ 1 unit price|
|Checking the overlapping of list||10yen ~ @ 1 unit price|
|Address correction service||20 yen ~ @ 1 unit price|
|Adding company information||Please contact us for more information.|
|Information survey by Web surve||It depends on the content. please contact us for more information.|
The workflow of Data cleansing
Integrating prospect data scattered throughout the company
・Leads acquired by Online event.
・Business card acquired by a salesperson.
・Own customer`s data
・Inbounds leads, etc.
Cleansing customer information compiled in a database
・Unification of duplicate information
・Correcting of department
・Correcting of based address
・Unification of notation fluctuation, etc
・ Confirming of living data by telemarketing + acquiring of information permission
・Checking the alive monitoring of my e-mail addresses
・Checking the alive monitoring of telephone numbers
[Specific example of data cleansing]
Utilization of cleansed data
Proposal of sales promotion measures utilizing cleansing data
Data that eliminates fluctuations and duplication of characters and is centralized can be used as is for sales promotion activities.
By using Dr. Marketing ® equipped with an automatic cleansing function, it is possible to keep the data clean at any time.
I & D acts on behalf of various marketing measures such as Telemarketing and Digital marketing. I&D will propose effective sales promotion measures that utilize cleansing data.
Matching-Corporate information addition image
Matching with database
Matching your data with your corporate database
Matching your data with the corporate database.
Adding company information
Adding the scale and industry of the company database to your business card and company information
By adding scales and industries, it will be possible to segment by scale and industry, and more targeted sales promotion activities will be possible.
Utilizing from analysis to data
Calculating the market share by industry based on the added company information (matching with the market)
You will be able to calculate the market share of the target companies and figure out which company you should attack now from the numbers.