Closed Won Attribution (Minutes) - Sample Dashboard for LIGHTNING

  • Updated

The Closed Won Attribution (Minutes) dashboard for Lightning is one of several out-of-the-box attribution dashboards.

Closed_Won_Attribution_Minutes_bid_dashboard.png

Important: In order to use this dashboard effectively, make sure the Demandbase API is configured and running properly in Salesforce.

There is a lot of information in this dashboard. Let's break it down by section in order to understand what it is telling us:

  • Total Revenue Won
    Total_Revenue_Won.png
    This dollar value is pulled directly from the opportunity object's amount field in Salesforce. This is the source of truth for the universe of opportunity amount won in the current and previous fiscal year timeframe. We want the Attribution data to match this total.

  • Closed Won Attribution by Sales and Marketing Engagement
    Closed_Won_Attribution_by_Sales_and_Marketing_Engagement.png
    Knowing the total opportunity-won universe, we want to know what percentage was influenced by Demandbase activities as tracked by Attribution. This chart will show you:

    --The overall opportunity-won universe tracked by Attribution ($16M in this example)
    --The overall amount influenced by Marketing vs. Sales Engagement

    You can also see another view of this data to the right:
    Closed_Won_Attribution_by_Sales_Marekting_screen_2.png

  • Closed Won Attribution Activities by Month
    Closed_Won_Attribution_Activities_Month.png
    This report component breaks down the total amount influenced by Demandbase activity types over time (pulled from the Demandbase activity record). This allows you to see top-performing activity types but helps also validate if your attribution criteria should be altered (for example, if you see activities like canceled events being captured here, you may want to exclude that in your attribution criteria). Out of the box, we use the Minutes Model for this chart and all other attribution based charts on this dashboard.
  • Average number of Touches and Average number of Minutes (Sales + Marketing)
    Touches_and_Minutes.png
    The Average # of Touches component displays the average number of Demandbase activities recorded for each opportunity on average before it is closed won. The Average # of Minutes component displays the average number of minutes recorded prior to a closed won opportunity. Out of the box, we pay attention to all matched leads to the account, contacts under the account, and anonymous activity matched to the account.
  • Average number of People Touched (Sales + Marketing)
    Avg_Number_People_Touched.png
    The Average # of People Touched component displays the average number of unique people tied to Demandbase activities at the point an opportunity moves to closed won.

    These are not contact roles attached to the opportunity. These are unique people with Demandbase activities that fall within the Demandbase Activity Influence Time frame. Attribution determines unique people first by matching SFDC ID's and then by using a fuzzy matching process if there is no SFDC ID present on the activity record. Anonymous activity is ignored from this calculation.

  • Velocity: First Touch to Closed Won
    Velocity_FT_to_Closed_Won.png
    When viewing this component, think of it as a way to see how long on average it is taking from the first recorded Demandbase activity touch to the date an opportunity moves to closed won. The Demandbase Activity Influence Timeframe has a big impact on this number. Out of the box, we use a time frame of 365 days.

  • Closed Won Attribution by UTM Source
    Closed_Won_Attribution_UTM_Source.png
    You can see the top performing UTM (Urchin Tracking Module) sources in this chart. UTM parameters are URL parameters used by marketers to track the effectiveness of online marketing campaigns across traffic sources and publishing media. The Closed Won Attribution by UTM source is based on the UTM parameters being captured through the Demandbase web tracking script (Understanding the Demandbase Tag). This allows the ability to tie the UTM source parameters to revenue attribution weighted by the engagement minutes model.

    There is also a similar view for UTM Medium:
    Closed_Won_Attribution_UTM_Medium.png

    And another similar view for UTM Campaign:
    Closed_Won_Attribution_UTM_Campaign.png

There are many ways to customize this dashboard. Please feel free to filter, change the date ranges, remove components, or even change the attribution model as needed.

See Customize Dashboards with Custom Journey Stages and Change the Attribution Model Displayed in Dashboards to create your own.

 

 

Was this article helpful?

0 out of 0 found this helpful