Abandon Cart emails - P2

We do them through P2 as well.  We have two flows of abandoned cart emails. 
1. If user is logged in, cart is saved and retrieved.  We do a check that they haven't made a purchase within 12 hours.  If no purchase, we send an abandoned cart email that retrieves web content from the performance setup.  That web content is usually a friendly title, description, web product URL link, and a product image.
2. We also use the out of the box abandoned cart recipe which is more generic.  User hits the cart page(usuallly you need to visit this page coming from a seat selector page). User doesn't hit the checkout/confirmation page within 12 hours.  If that condition is met, we send a basic, 'hey you left something in your cart, we have no idea what it was, but head back to our site because tickets are selling fast.

The automation does a check to make sure a user can't get both abandoned cart emails. 

As you might imagine, version 1 does better from a conversion standpoint, but sends much less in volume than version 2.  Version 2 does good, sends to more people, but the conversion rate is not as high.

That sounds about what I am imagining Michael Moore

For email 1, are you using a stored Proc to get your data?

Hi, yes that is correct. 

would you be willing to share?

Hi Jen,

Can you send me a private email?  While I had helped set the criteria we wanted for the SQL view, (not a stored procedure), I didn't write it, so I'd probably want to put you in touch privately with the folks that did do the writing. 

Thanks
Mike

Hi Jen,

Can you send me a private email?  While I had helped set the criteria we wanted for the SQL view, (not a stored procedure), I didn't write it, so I'd probably want to put you in touch privately with the folks that did do the writing. 

Thanks
Mike