Hi @dneo,
I wanted to jump in to help out, as some of the information you received above isn’t entirely correct. Klaviyo DOES use a pure last-touch attribution model, and the last message that a person opened/clicked will be the one attributed to the conversion, as long as the conversion falls within the window you set. Let’s look at an example:
You have a conversion window of 5 days.
Day 1: Customer receives a campaign email and a flow email.
Day 2: Customer opens campaign email.
Day 3: Customer opens flow email.
Day 5: Customer makes a purchase.
This conversion will be attributed to the flow email, as that was the last email opened before the purchase was made.
While we’re not as familiar with Fivetran’s conversion model, and how it’s different from Klaviyo, I’d recommend checking to ensure that the attribution windows you set in Klaviyo match those in Fivetran’s model. That may be where the issue is coming from.
Let me know if I can answer any additional questions. Happy to help.
-Byrne