Apr 20, 2022
In Self Help Forum
This way you work towards a unique customer record, also known as a 'Mobile Phone Number global customer ID' (this is also known as "stitching or linking").Below is an Entity Relationship Diagram tMobile Phone Number hat illustrates the relationship between customers and unknown users in an example implementation. This is a simplified view. Entity Relationship Diagram The 3 most important steps for a simple identity resolution, based on SQL in your data warehouse: 1.Mobile Phone Number Identify match keys You identify match keys to determine which fields and columns you will use. This determines which people, or other parts of the company, are the same within Mobile Phone Number and between sources. A typical example of a match key is an email address and a surname. Aggregate customer records The second step is to Mobile Phone Number create a source lookup table that contains all customer records from the source tables. 3. Match and assign a unique customer ID As a final step, you take records that have the same match keys Mobile Phone Number and that together generate a unique customer identifier for this group of customer Mobile Phone Number records. We call this a customer ID. Any customer ID you generate can be used to link customer sources Mobile Phone Number together as part of a data strategy. I describe what this looks like in practice in an article on Frankwatching Mobile Phone Number about first-party data strategy in the headline “Using first-party data in a CDP”. As you add more resources, you can make them go through the same process by setting the appropriate Mobile Phone Number rules and priorities for the resource. Creating master data models for a central customer view To create your first customer view, you solved your first problem, which has to dMobile Phone Number o with establishing the customer's identity, with identity resolution. You can then set up the data pipelines or ETL.