Lembot found multiple columns with the same name in the final export.
This happens when your campaign has a duplicate custom variables, or when your custom variables includes lemlist report reserved columns such as openedAt
, bouncedAt
, etc...
💡 Lembot does not take responsibility for choosing one variable over another and prefers to fail.
Review your campaign's custom variables in the lemlist app, found the duplicates and clean them.
Fortunately, lembot helps you with that by listing the duplicates directly in the error message, between the square brackets.
Let's take the example where lembot told me it found a duplicate for the column ["notes"]
. If I manually download the report and open the CSV, I can see that I have two columns named notes
. Now I have to open the lemlist app, open the campaign, check its custom variables and delete the notes
I don't need.
You will encounter this error if you use the same variables that lemlist uses in their reports. I'm talking about sentStep
, sentAt
, repliedAt
, bouncedAt
... This happens when you use a lemlist CSV report in order to import your leads when creating a campaign.
In the example below, lembot found duplicates for bouncedAt
, callDoneAt
and so. Indeed, I can see they are in my custom variables.
Cheers,
François.