Set the Last Order Amount in a custom field
It'd be great if we could set the amount of the most recent order in a custom field. The Calculate Customer Value feature is great but it would be epic if we could do this!
The problem is that the default affiliate notification emails in Infusionsoft are 1) horrible 2) not customizable. So you use the default notification email to let the affiliate know they just referred a sale it's super boring, doesn't keep them excited, etc.
I was going to setup in campaign builder a custom affiliate sale notification but there's no way to get the order amount or amount of commission earned into the email as a merged field.
My idea was to use the Calculate Customer Value feature to set the amount of the last order in a custom field, then use the Math feature to put the amount of commission earned in another custom field. I could then both of those merge fields in a custom email to the affiliate that would excite them to go get more sales!
Great idea. Thanks for the submission. I could see this being a pretty cool notification to keep affiliates excited.