SOLVED

Send Many to One Email Using Custom Objects

Go to solution
Mihai_Bejgu
Level 3

Send Many to One Email Using Custom Objects

Hello everyone,


I've been really struggling for a while with a pretty difficult task and I really need some clear advice.

   - I need to send out an email, to several Leads that own multiple Accounts.
   - Each Account has it's own unique values and the account ID should be the secondary unique value (After the email address).

The challenge is to send out 5 (or more emails - depending on how many associated accounts each Lead has) to the same (email address) and each email should contain the Dynamic values that correspond to the Account ID

For this, I have created a custom Object, that I populated, for testing purposes, with several details that are in the attached .png.

In the custom object I defined
     - Link value=Email Address

     - Dedupe value = QBR_IdAccount

     - There needs to be several more values as string (but first I need to figure out how to do this right)

Looking at the "qbrprint.png", how can I send to Mihai Bejgu (only one email address associated), 5 emails individual emails, for each QBR_Id Acount, that will contain it's associated QBR_graphURL?

I've read a lot of documentation on the Custom Objects, Velocity Email Scripts, but couldn't find exactly what I need.


I tried defining the attached "Smart List.png", but it didn't work.


Can you please advise on how to set this up, to work correctly?


Kind regard,
Mihai

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Send Many to One Email Using Custom Objects

Hi Mihai,

How are these custom objects being created in Marketo?

Are these custom object records are 'already populated' in Marketo for all the leads that you need to send emails to?

or

Right now you are just testing for your record but for real workflow, these custom object records are 'yet to be populated' in Marketo from some external system?

If they are yet to be added into Marketo, you can create a smart campaign that listens to 'Record is added to that custom object' event and simply print 'Triggered record" in the email using Velocity Script. Like $TriggerObject.QBR_IdAccount

For example,

<div>

<strong>Your order information:</strong>

##pull information from the Triggering Order and format it in a list

<ul>

<li>Product Ordered: $!{TriggerObject.ProductName}</li>

<li>Product Quantity: $!{TriggerObject.Quanitity}</li>

<li>Shipping Address: $!{TriggerObject.ShippingAddress}</li>

<li>Billing Address: $!{TriggerObject.BillingAddress}</li>

<li>Order Total: $!{TriggerObject.Amount}</li>

</ul>

<p><a href="$!{TriggerObject.OrderURL}">View Your Order Online</a></p>

</div>

http://developers.marketo.com/documentation/velocity-script/marketo-objects/

That way, you can send 1 email to the lead, when the new QBR record is created, with the email containing 'only' that QBR record's information. If a lead has 5 or 15 QBR records, each of them will be added one by one (from the external system) and will get a different email each containing only that QBR record's information.

Does this help? This is how we did similar work a year back. Please feel free to reach out if you have any questions.

This will not work if the QBR data is already in Marketo though.

Rajesh Talele

408 306 8767

View solution in original post

5 REPLIES 5
Courtney_Grimes
Level 10

Re: Send Many to One Email Using Custom Objects

Hi Mihai,

Your problem is inherent to the way Marketo works on two fronts: the first being that you cannot loop a person through a flow step multiple times with different selectors, and the other being that if you're trying to reference multiple objects but only want one object in an email, Marketo's simply going to pick the oldest custom object to pull data from.

Now, there's two solutions to that: the simpler one would be to simply write a Velocity script that checks the lead's email address against the custom object's Email_Address field and outputs all data into one email. I'd also think that for UX purposes your leads would prefer that route.

However, if that's not an option, you're going to need additional fields on your object to count the unique number of objects per email address and then run campaigns that select objects with that count constraint (so you'd have a smart campaign for people who have "first custom object," "second custom object," "third custom object," and so forth. In fact, you could even hybridize the approach so, say, if someone has three or less objects to send individual emails and if they have more than three to concatenate them all into one email.

Justin_Norris1
Level 10 - Champion Alumni

Re: Send Many to One Email Using Custom Objects

I agree with Courtney that you'd save a lot of headache by using a script to output all the QBR data from your custom object into a single email. This is consistent with how custom objects seem designed to be used.

Courtney's work-around for multiple object records and multiple emails would work but is hard to scale if there are an indeterminate number of possible QBR records per email address.

Anonymous
Not applicable

Re: Send Many to One Email Using Custom Objects

Hi Mihai,

How are these custom objects being created in Marketo?

Are these custom object records are 'already populated' in Marketo for all the leads that you need to send emails to?

or

Right now you are just testing for your record but for real workflow, these custom object records are 'yet to be populated' in Marketo from some external system?

If they are yet to be added into Marketo, you can create a smart campaign that listens to 'Record is added to that custom object' event and simply print 'Triggered record" in the email using Velocity Script. Like $TriggerObject.QBR_IdAccount

For example,

<div>

<strong>Your order information:</strong>

##pull information from the Triggering Order and format it in a list

<ul>

<li>Product Ordered: $!{TriggerObject.ProductName}</li>

<li>Product Quantity: $!{TriggerObject.Quanitity}</li>

<li>Shipping Address: $!{TriggerObject.ShippingAddress}</li>

<li>Billing Address: $!{TriggerObject.BillingAddress}</li>

<li>Order Total: $!{TriggerObject.Amount}</li>

</ul>

<p><a href="$!{TriggerObject.OrderURL}">View Your Order Online</a></p>

</div>

http://developers.marketo.com/documentation/velocity-script/marketo-objects/

That way, you can send 1 email to the lead, when the new QBR record is created, with the email containing 'only' that QBR record's information. If a lead has 5 or 15 QBR records, each of them will be added one by one (from the external system) and will get a different email each containing only that QBR record's information.

Does this help? This is how we did similar work a year back. Please feel free to reach out if you have any questions.

This will not work if the QBR data is already in Marketo though.

Rajesh Talele

408 306 8767

View solution in original post

Mihai_Bejgu
Level 3

Re: Send Many to One Email Using Custom Objects

Thank you very much everyone. After one day of testing and addpating (I've had 40 Tokens to insert) I finally did it. Manly following Rajesh's feedback, but not only

My other dilema righ now is: how can I erase the values from the Custom Object, to have them NULL? the "Change data value" option is not working

Kind regards,

Mihai

Anonymous
Not applicable

Re: Send Many to One Email Using Custom Objects

change data value only works for lead fields. Custom objects data changes need to be done with API.