Running a pre vs new customer revenue report

Thank you so much @Dov !

In case anyone else reads this:

I created the segments, exported, reimported into Klaviyo with the custom property:

Customer:
No
First Time
Repeat

Then updated the flows relating to thank you to update these segments so if they join any segment through the welcome  series and haven’t placed an order the profile is updated to:
Customer: No

Thank you page
Customer: First Time

Repeat customer:
Customer: Repeat

Now to filter the original segments through the event page to see how much they’re bringing in. Thanks again so much!

Hi @NJVasic & @Michael,

Thank you both for your replies!

Hi @NJVasic! Good questions - let me jump back for a second to clarify a couple of things. First, you’re totally correct that the revenue from the profiles directly through the segment export would be over all time rather than just during that 30-60 day period. I updated my original reply to reflect that -- my mistake. The purpose of creating and exporting these segments were twofold: 1) to establish the email addresses for both “new” vs “returning” customers within that timeframe which is helpful in its own right (to know who they are). And also for purposes of later sending campaign(s) to these users or putting them through a flow 2) It’s the first required step (followed by export + re-upload) to allow Michael to begin using the filtering function in the reporting tool for “new” vs “returning” users.

While it’s not necessary for the purpose of this thread, I’m curious to better understand where your thinking is going for exporting Historical Lifetime value? 

In terms of the segment definition itself, since Michael mentioned “returning” (rather than repeat) that typically refers to someone who has purchased at least once, but of course you can adjust the segment definition to accommodate the target audience, if the intention was really “repeat” rather than returning updating Placed Order to at least twice would be the right move, as you suggested.

And @Michael, glad to hear you’ve got these profiles updated in Klaviyo with their new custom properties. Let me clarify something from the original reply (also worth noting it’s called out in our documentation under Add Group By: “Note that reports only include events filtered by a profile property starting after that property was created. Even if a property was retroactively applied, if it didn’t exist on profiles at the time the event takes place then it won't appear in the report.”) In other words, we’ll only track events in the reporting tool for events that take place after the property is added. So you’ve got the first part down of getting the filter available in the reporting tool by segmenting, exporting and re-importing these users with the properties. So moving forward, as they log net-new order metrics, you’ll be able to use reporting for profiles with these properties but it won’t apply retroactively for past placed order events.

I hope that information is helpful.