Send a single alert to sales owners who have any record in a program

Michelle_McDona
Level 2

Send a single alert to sales owners who have any record in a program

I'm trying to send an alert to a sales owner if they own a record in any record in a particular program.  The problem is that I only want to send one alert, so if they own 10 records in the program, I only want to send 1 alert. Is there a way to do this?

 

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Send a single alert to sales owners who have any record in a program

You‘d have to use a webhook-compatible service to assist with this. As simple as it seems, Marketo can’t throttle/communicate across lead records like this.
Jay_Jiang
Level 10

Re: Send a single alert to sales owners who have any record in a program

As you're aware, Marketo does things by the records in the database, and isn't able to know what has been done for the sales owners of those records.

 

A manual way of achieving what you need is to use a temporary field and export/import.

 

1. Export your data and open it in excel

2. Sort by sales owner, add an extra column for your temporary field if it's not already in your export

3. For every record except for the first record of each sales owner, set the value of the temporary field to 0

4. For the first record of each sales owner, set the temporary field value to 1

5. Import your data

6. Run a smart campaign to send alert with choices, send alert if temporary field = 1, default choice = do nothing

 

Frustrating as it may be I know