|
importing data via API from CDP Customer Data Platform or DMP Data Management Platform , use the ID set in CDP or DMP as the primary key. You can also. 2. Check data quality The next step is to check the quality of the imported data . missing data, suitability no discrepancies, consistency no typos , accuracy no errors, and redundancy no duplicates. This will be done comprehensively based on the following criteria Obtaining data in conjunction with a corporate database will not only improve accuracy compared to matching with a single key such as an email address , but also enrich the data by adding a variety of information .
3. Perform data cleansing We correct data errors found during data quality checks and perform data cleansing . If you can extract potential duplicates in your database that you are unaware of , as well as email undeliverable lists , it will be easier to cleanse India WhatsApp Number Data your data than if you were to do it all by hand. For MAs that cannot add information such as company information or addresses , you can perform data cleansing after enriching the data by linking with a company database . At this time, it is important to decide on rules regarding ``what and how much to unify'' and ``how to unify '' based on how the data will be used after cleansing .

For example, when using it to analyze numerical values such as conversion rates , full-width numbers may not be recognized as numbers , so the rule is to standardize all numbers to half-width . 4. Match data Once data cleansing is complete, we will merge the data . Name consolidation is the integration of dispersed or duplicated data from the same person or company . By integrating data , data from the same person or company is gathered together, eliminating the trouble of searching for data and sending emails to the same
|
|