Mailchimp Integration - EspoCRM getting Emails a few times

[lucakuehne]

Yes, what about this topis? The problem itself is fixed in the newest release, but what about the script to remove the duplicates?

[alasdaircr]

tanya any update on a fix for this?

[lucakuehne]

Filter the campaign log relationship panel showing underneath the Campaign details.

That isn't enough.. I have sent round about 4500 mails in the campaign ^^ But as mentioned before, I saw a few duplicate "sent"-entries.

You can also check the Campaign statistics on the right hand side.
If you see really high open rates (some greater than 100%) you know you are seeing duplicates in the campaign_log_record.

No, the "open" rates are in fact to low.. Maybe because the sent "rate" is way to high.. "Sent" is in EspoCRM about 4 times higher, than sent in reallity..

[alasdaircr]

You can also check the Campaign statistics on the right hand side.

If you see really high open rates (some greater than 100%) you know you are seeing duplicates in the campaign_log_record.

[alasdaircr]

Filter the campaign log relationship panel showing underneath the Campaign details.

[lucakuehne]

No, old data won't be touched. I will try to generate a sql query to clear duplicate emails, if you want

Yes please.. We send about en average 5000 mails per campagin.. Some of them are importet into EspoCRM 7 times.. You can calculate yourself how many duplicates are in our system now.. (Round about 25'000 mails per campaign).

@lucakuehne if you look at your campaign log record for the campaign does that also have duplicate 'Sent' messages ?

I guess you're talking about the campaign log of EspoCRM? It's pretty difficult to check that, beacause I'm not able to search in the campaign log. But within 5 minutes I found a few duplicate sent-messages.

[alasdaircr]

@lucakuehne if you look at your campaign log record for the campaign does that also have duplicate 'Sent' messages ?

[alasdaircr]

Great to see it's not just me who is experiencing this!

[tanya]

No, old data won't be touched. I will try to generate a sql query to clear duplicate emails, if you want

[lucakuehne]

Thank you for your response!
Then I'm waiting for the update of the Advanced Pack..
Out of curiosity: Are the older campaign Mails going to be fixed?

[tanya]

Hello
In a short time we'll release an updated Mailchimp integration Advanced Pack.
Apologize for this inconvenience.

[lucakuehne]

We have a pretty huge problem with the Mailchimp integration.
I activated "fetch sent emails":

But they are getting saved in EspoCRM for 2-6 times, allthought it was sent only once:

That's really anoying. It spams the whole CRM...
Please fix this. We payed for the extension to get a proper solution and not this...

Kind regards
Luca