How do you pull CoPilot analytics into your scorecard?

Hi Ben,



I have some experience building out this type of Scorecard measure. We recently tested out an 'Email Engagement' measure to track if customers were engaging with our CoPilot emails.



These rules were based on the Email Logs (MDA) Object, which is where CoPilot Analytics pull from. An example set up of this would look like:

• 'Setup Rule' filter was Email Logs 'Triggered Date' = Last 30 days (so only looking at the past month of emails). 
  
• 'Setup Action' was (1) If Open Count = 0, Scorecard = red, (2) if Open Count is between 1 and 50, Scorecard = yellow, (3) if Open Count is 50+, Scorecard = green
  

You should base your Scorecard thresholds on whatever Open Count gradient makes sense for your customers, of course.



On the Email Logs MDA object you have a lot of cool options! You can look at Open Count, Click Count, you can filter by Email Batch, Triggered Date, User Name, Template Name, and more.



Hope this helps!

Ethan

In addition to the [i]threshold-based mechanism Ethan explained above, there are two more ways to get the score you need:

• Assign the sum of email opens (or whatever engagement metric you pull and aggregate into your rule) directly to the Scorecard measure, and then select the option to auto-scale between 0 and 100.

                  

• Another way to implement this is via Smart Signs. You'd have to first build a rule that aggregates the email activity to the account level, on a weekly or monthly basis, and then writes it to our Usage Data object in Salesforce. Once the various engagement trends are available this way, you can create a Smart Sign measure that automatically assigns an engagement score, based on the engagement metrics selected (and whether more is good or bad). Smart Signs also have the ability to normalize these engagement metrics using the count of users/licenses, for example, so that the score reflects engagement per user within each Account. 

Hope this helps!



Thanks,

Manu