How did happened? Duplicate contact

Photo says it all … email domain are both exactly same but was edited out for privacy

Both are same person and have same email address but different database id

Is email address the primary key in Mautic → I checked and Email is set Yes on Unique Identifier in custom field settings

It would help if you’d explain how the contacts were created. I saw the same behavior when editing the contacts manually.

I look at both contact history. This contact is one of our staff member. He receives a newsletter that we sent out weekly so when we switched from Sendy (former mailer) to Mautic, we imported all contact over to Mautic via CVS file.

I can see both contact have same history and both was created same day 2 month ago until recently I imported a new CVS for a “Staff only” segment and that when it seem to duplicate the contact into two contact but still same name and email address.

Funny thing is history show “Contact updated” instead it duplicate the two. The only difference between two contact is one have a “staff” tag on it.

I did some testing beforehand to make sure that importing would merge the contact instead of creating a new secondary same contact and it did pass the test that it merged which I wanted in the first place.

Here a screenshot of both contact history … in history comm.cvs is the list I imported to add those who are communication staff

There are only 12 staff on communication team and I checked all contacts history. There was only one that was duplicated. The rest of the contacts in staff CVS was merged successfully.

Hey Bill!
2 quick questions:

  • Is email your unique identifier?
  • Did you create a secondary email field?
    J
  1. Yes, email is set to be unique identifier.

  2. No, I do not have a secondary email field or any custom field on it.

Did you make an import, where the id somehow was pared with mautic id?

When I made an import, I only use first, last, and email. It was only thing I had in Sendy before I switch over to Mautic.

I did not use ID or any other information from Sendy.

What is the event that identified the contact? You see this among events. Check both.

Can you explain how to check event? I will be happy to check it

This is where you see how someone was created. This user was done by a user called API added with api call.

Then you click on the audit log tab for more details:

There a screenshot in my post #3 above that shows the history of each contact. The screenshot is taken from each contact.

It just says contact created and identified. There nothing clickable on that line to open up detail about that event.

Hovering mouse over it does not give me toggle detail tooltip or anything so it’s not clickable.

Do you want access to my Mautic? I can PM you a temporary admin access if you want to take a look at it briefly.

Contact was exported to a CVS file from Sendy then imported into Mautic manually via web browser if that what you were asking about?

Hi, sorry I need to catch up with things, don’t have time now, but let’s see if someone has a tip.
If it won’t get solved by the end of the week, I’ll look into it on friday.

But looking at the adit log tab could give you a clue.
Also: can it be, that someone changed the email of the contact in the system?

Bumping an old issue as I am seeing similar behaviour all of a sudden in Mautic 4.4.1

I have two new contacts created. There lead ID are consecutive: 483 and 484.

For lead id 483 this is the audit log:


In the history of this user I am not seeing any tracking, however they are getting an email sent and changing into different segments and campaigns.

For lead id 484 this is the audit log:


For this user I am seeing a full history of all pages being tracked as well as emails being send.

The emails being sent are from within a campaign and they are market type “marketing”.

The field for email is publicly updatable and is also a unique identifier.
image

The user is being created via the Mautic tracking script and/or via forms in both cases.

@joeyk or anyone else looking for some interesting insights here.
My initial hunch was that a field was being overwritten on a specific user, but I would expect to see the values of email change in the audit log if this was the case, and then the fact that the lead_ids are consecutive also raises a small alarm.

You can of course create duplicate emails via API without problems.
When you EDIT the contact, then the API won’t check if the email already exists, since the ID will be used as UNIQUE FIELD.
You should CREATE the contact every time you want to make change using email as a key.

Maybe it’s done by API? N8N?

Thanks Joey. No it is not being done via API, a contact is created via a form submission in one scenario, at the same time the tracking script will pass through the email as well.
The other scenario is that a user registers has registered through the site mechanism (in this case Auth0) and then the tracking script passes through user details.

Ok.
Is the form a standard mautic embed? Or a post action from a wp plugin?
Also:
Do you have a synch with a crm or other system?
One more:
Do you have multiple keys besides email?

Standard Mautic form.
No other synch with any CRM
No other unique keys
:frowning:

I did see that they could have implemented the tracking script incorrectly as I am seeing 4 hits per anonymous user, also the dup records are created within seconds of each other

Appreciate the questions @joeyk

Yeah there must be a tracking issue. Can you plz check if there are ja errors while tracking? Does the page have proper access to Mautic cookie? Maybe cors error?