SOLVED

Re: Sending sales alert to account manager about top ten prospects/contacts

Go to solution
Malcolm_Price1
Level 2

Sending sales alert to account manager about top ten prospects/contacts

Is it possible to send an alert/report of the top 10 active customers/prospects for each Sales account manager.

 

If so where would be the best place to set this up Marketing activities and use smart campaigns or is there another way.

 

We have access to OneInsight (MSI equivalent) but not all account managers have access to this.

 

Any help appreciated!

 

Malc

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Sending sales alert to account manager about top ten prospects/contacts

There's no way, with built-in features only, to do this.

 

We do stuff like this for some clients, but it involves sending scores to a remote db using a webhook and then querying the top N % or other metrics.

 

The easiest way to implement is probably to

  • mirror scoring data to a Google Sheet (via webhook)
  • run each account rep through another 'hook, once per day
    • then you run a VQL query like SELECT [email address column] ORDER BY [score column] LIMIT 10
    • send the rep the result in a Marketo email, a formatted table

View solution in original post

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Sending sales alert to account manager about top ten prospects/contacts

There's no way, with built-in features only, to do this.

 

We do stuff like this for some clients, but it involves sending scores to a remote db using a webhook and then querying the top N % or other metrics.

 

The easiest way to implement is probably to

  • mirror scoring data to a Google Sheet (via webhook)
  • run each account rep through another 'hook, once per day
    • then you run a VQL query like SELECT [email address column] ORDER BY [score column] LIMIT 10
    • send the rep the result in a Marketo email, a formatted table