If you want to deep dive into your data, you would probably want to analyze your campaign activities.
This is the most enriched data in lemlist.
Every single email sent, opened, clicked, URL clicked, etc. is an activity. And they are all timestamped.
Lemlist does not provide a way to export them.
Lembot does 😎
When creating a bot, you will be asked what type of data you want to export : reports or activitites.
Follow the steps to finish creating bot:
Few seconds later, all your campaign activities are exported in your gsheet.
See 👇
If you only care about the first occurence of an event, check out the column isFirst
.
The column sequenceStep
tells you the step when the event occured.
Watch out, index starts at 0. Meaning that
0
means "step 1"1
means "step 2"If your prospect clicks on link in your email, an activity of type emailsClicked
is created and the clicked URL is available in the column extra.location
.
Here is the list of all the lemlist event types available in the export
Feel free if you have any questions,
Cheers,
François