Customer experience | Sales, Customer Insights,...

Issues in Data Unification of Customer Insights

(0) Share

Report

Posted on by Rehan Bajwa

Hi,

I am currently working on a Customer Insights demo and facing some very strange issue

Match step of Unification process shows 517 Customers where as Customers profiles are for 516 Customers and Profiles are also not showing Measures(Customer Attribute).

The most important Point is that my Data Source has 100K Customer records and it's only showing 416 records as Total records on Match stage of Unification Process.

P.S: Screenshots are attached for reference.

Any help in this regard will be appreciated.

Thanks

All responses (6)

Answers (0)

Fortuna2518 15 on at

Like (0)

Report

RE: Issues in Data Unification of Customer Insights

Thank you so much for posting this.

nox app player
Suggested answer

Shefy Manayil Kareem on at

Like (0)

Report

RE: Issues in Data Unification of Customer Insights

Thank you for reaching out.

We also have an updated experience for match shipping very soon to help with better debuggability.

If you would like us to enable it for you, then please reach out to us at cihelp@microsoft.com with your environment ID.

You can find the environment ID under: System -> About -> Environment ID
Rehan Bajwa 5 on at

Like (0)

Report

RE: Issues in Data Unification of Customer Insights

Thanks for your reply.

I tried by creating a new DataSource with only Accounts entity(without making any change to the file),it worked and showing 100,000 Unique Customers records.

Although In the beginning it only showed 100k at Unification Process where as it showed 516 Customers Profiles for quite some time but after some time it started showing 100k Customer Profiles.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Issues in Data Unification of Customer Insights

Hi Rehan,

Okay, at least this narrows down the list of potential issues.

I had a similar issue with my matching outputs last year.

After trouble-shooting every potential issue I could think of, I found out that there was an error in the way the data was being parsed.

Go into Entities and then export the tables you use in the match process as CSV files.

Then open each file, and after converting to columns, check if the right data is showing up for each column.

My issue previously was that because the data was not being parsed correctly, I had limited data for the fields I was using to match and so only a handful of matches showed up.

Other than that, I have no clue lol!

Halen
Rehan Bajwa 5 on at

Like (0)

Report

RE: Issues in Data Unification of Customer Insights

Hi Halen

Thanks for your reply.

I have already checked this Option, have ran a distinct query as well and it shows 100k records.

Screenshots are attached for reference.

Thanks
Community Member Microsoft Employee on at

Like (1)

Report

RE: Issues in Data Unification of Customer Insights

Hi Rehan,

The most likely scenario based on your description above is that the option for including all customer records in your primary table has not been selected:

By leaving these check boxes blank, Customer Insights will only retain customer profiles that it finds in common between the two tables based on your match rules. Think of it as a type of inner join.

If you have already done this, then I suggest tacking a step back and making sure that all your customer records are being ingested properly.

You can go to the relevant data source, and using the statistics function in Power Query, do a distinct count on the primary key for the table:

This will give you a unique count of your customers so you can determine if its a data ingestion problem or matching problem.

Hope this helps!

Halen