How do I add Product information as a constraint associated with Opportunities?

[Tadia_Charles1]

I'm new to Marekto and would like to send an email message to all Contacts associated with Opportunities for specific Products.  This would be by product family, product line, or product category or using a custom field. I'm sure that I must be able to do this, I just can't find it.

Thanks,

Tadia

[Floyd_Alvares2]

Hi Tadia,

You would need to specify where does this "product family, product line, or product category or using a custom field" information reside? Does it reside on the Opportunity object OR does it reside on the Contact object?

To pull in the information for contacts that have an opportunity, you will need to run a filter "Has Opportunity" and the fields on the opportunity would be under constraints, plus you can add additional filters based on the Lead/Contact record.

Please let us know where your fields reside and we might be able to provide you a better explanation.

Thanks

Floyd

[SanfordWhiteman]

Opportunity Product (OpportunityLineItem) is a junction object that links Oppties with Products.  (As such the Product itself is a lookup into Products, not a flat field on the Opportunity Product record.)

[Tadia_Charles1]

Hi Floyd,

Product is a related list associated with the Opportunity object.

The fields that I would use are on the Product object. So I was hoping for a Constraint that would be something like Has Opportunity with Product Family xyz.

Thanks,

Tadia

Sent from my iPhone

[SanfordWhiteman]

Not possible, as explained above.

[SanfordWhiteman]

This constraint isn't available in Marketo as the object isn't synced.  You'd have to flatten the related Products into a field on the Opportunity instead. Recommended format: a pipe-delimited field with additional pipes (|) at beginning and end, since Marketo is doing a free-text search and you don't want to have mismatches.