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.
If you only care about the first occurence of an event, check out the column
sequenceStep tells you the step when the event occured.
Watch out, index starts at 0. Meaning that
0means "step 1"
1means "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
Here is the list of all the lemlist event types available in the export
Feel free if you have any questions,