Whether it is the hyper-personalized contextual engagement approach, increasingly higher marketing ROI\/ROMI, higher influence on pipeline generation\/acceleration, or the increasingly better demand waterfall efficiencies,<\/span><\/span><\/p>\n<\/div>\n <\/p>\n marketing analytics capabilities span across the areas of marketing execution and the key strategies.<\/span><\/span><\/p>\n <\/span><\/p><\/blockquote>\n<\/div>\n<\/div>\n With the ability to leverage data and analytics in real-time across the life cycle of all marketing campaigns irrespective of the channel and the source, all these <\/span>data-driven strategies are transforming marketing into a revenue-generating function.<\/span><\/strong> CEOs\/finance\/sales leaders are all in this exciting transition led by the forward-looking marketing leaders.<\/span><\/span><\/p>\n<\/div>\n While the B2B marketing analytics and the associated KPIs span across the funnel from awareness to demand generation to pipeline acceleration, <\/span>Marketing ROI<\/span><\/a>, there is one set of metrics that is top of the mind across marketing teams especially the ones with more matured analytics competencies.<\/span><\/span><\/p>\n<\/div>\n <\/p>\n Cohort based demand waterfall conversions<\/span><\/strong> are the set of forward-looking metrics and leading indicators that go beyond just tracking the engagement volumes across the funnel to providing the insights into the quality of these engagements across the different stages of the funnel.<\/span><\/span><\/p>\n <\/span><\/p><\/blockquote>\n<\/div>\n<\/div>\n Demand Waterfall conversions generally track 5 KPIs<\/span><\/strong> with some degrees of variations depending on the demand funnel definitions within an organization:<\/span><\/span><\/p>\n<\/div>\n Leads to MQLs (Marketing Qualified Leads)<\/span><\/span><\/p>\n<\/li>\n MQLs to SALs (Sales Accepted Leads)<\/span><\/span><\/p>\n<\/li>\n SALs to SQLs (Sales Qualified Leads)<\/span><\/span><\/p>\n<\/li>\n SQLs to SQOs (Sales Qualified Opportunities)<\/span><\/span><\/p>\n<\/li>\n SQOs to Deals<\/span><\/span><\/p>\n<\/li>\n<\/ol>\n<\/div>\n These 5 KPIs along with the ability to slice the data for these KPIs across the dimensions like regions, campaigns, tactics, account segments, etc. provide valuable insights into the efficiencies across the funnel and the time\/effort it takes to move the prospects through the funnel. <\/span>Some of the key questions from the marketing leaders that are answered through this framework include:<\/span><\/strong><\/span><\/p>\n<\/div>\n How many engagements it takes to generate MQLs that are accepted by SDRs?<\/span><\/span><\/p>\n<\/li>\n How many MQLs are needed to generate a new opportunity?<\/span><\/span><\/p>\n<\/li>\n How long it takes an MQL to convert to an opportunity?<\/span><\/span><\/p>\n<\/li>\n What is our win rate for all marketing engagements?<\/span><\/span><\/p>\n<\/li>\n How lead aging affects our ability to meet our funnel goals?<\/span><\/span><\/p>\n<\/li>\n What marketing tactics have the ability to move the pipeline in the shortest time?<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<\/div>\n A very important thing to note here is that these insights are derived from an organization\u2019s data (as opposed to some irrelevant benchmarks, generalizations from research companies) and are critical for optimizing the marketing mix and accelerating the customer journey. Every company is unique in terms of what it offers, how it operates, how the go-to-market strategy is.<\/span><\/span><\/p>\n<\/div>\n <\/p>\n When you can use your own company\u2019s data for the most relevant insights, the generalizations are irrelevant.<\/span><\/span><\/p>\n <\/span><\/p><\/blockquote>\n<\/div>\n<\/div>\n Based on my experience of implementing cohort-based conversion models across <\/span>more than 30 B2B marketing analytics organizations, here is the framework that I have been following:<\/span><\/strong> To begin with, a set of leads are identified based on \u201cLead\/Contact Created\u201d date and their progression through the funnel is followed through the different stages of the funnel. All the dimensions needed to slice and dice the funnel data are included in this initial data set.<\/span><\/span><\/p>\n<\/div>\n 1. Lead to MQL conversion:<\/span><\/strong> All leads\/contacts (Individuals) created in a given time frame are identified. Individual \u201cCreated Date\u201d is used as the primary date dimension to track the conversions. Apart from the time dimension, various other dimensions like region, account segment, lead source are added to this first data set. To identify \u201cHow many of these leads have converted to MQLs\u201d, MQL date stamps and flags are critical for this analysis so the CRM and Marketing Automation systems should have the workflows to stamp these fields. I look for each of the \u201cPeople ID\u201d and see if that People ID has been through the MQL stage of the funnel. If this condition is true, I set a flag to identify if that lead has been converted to MQL. The total of all \u201cPeople IDs\u201d gives the total leads created in a given time frame and of those \u201cPeople IDs\u201d wherever the MQL flag is set, the total of those are counted as MQLs. The division of these 2 metrics gives the \u201cLead to MQL\u201d conversion number. With all the dimensions that I have on \u201cPeople IDs\u201d, I can find conversions by different slices like region, segment, trials, paid-ads, etc.<\/span><\/span><\/p>\n<\/div>\n 2. MQL to SAL conversion:<\/span><\/strong> SAL phase of the funnel tracks the acceptance of leads by the SDR teams. The acceptance of a lead is usually tracked in the CRM by a combination of \u201cIndividual Status\u201d change, date stamping the acceptance or\/and the logging of sales activities on the individuals (MQLs in this case) by the SDR teams either manually or by the sales engagement platforms like Outreach, Salesloft. I look at each of the \u201cPeople IDs\u201d and see if that People ID has been through the SAL stage of the funnel. If this condition is true, I set a flag to identify if that lead has been converted to SAL. Of the MQLs identified in step 1, all those \u201cPeople IDs\u201d where the SAL flag is set, the total of those are counted as SALs. The division of these 2 metrics gives the \u201cMQL to SAL\u201d conversion number.<\/span><\/span><\/p>\n<\/div>\n 3. SAL to SQL conversion:<\/span><\/strong> this is the most tricky of the cohort conversion metrics because we have to transcend from \u201cPeople\u201d objects in Salesforce.com (SFDC) to \u201cOpportunity\u201d object and account for \u201cmany-to-many\u201d relationships between MQLs and their influence at generating opportunities.<\/span><\/span><\/p>\n<\/div>\n <\/p>\n In B2B marketing, one opportunity can be influenced by more than 1 individual, and at the same time, one individual can influence more than 1 opportunity in a given time frame.<\/span><\/span><\/p>\n <\/span><\/p><\/blockquote>\n<\/div>\n<\/div>\n The joys of \u201cmarketing influence on the pipeline\u201d keep the world of data analytics exciting!<\/span><\/span><\/p>\n<\/div>\n This part of the framework gets even more exciting (both from the insights it provides and the data analytics tricks \u2013 the good old windows and ranking functions in SQL) because I leverage attribution data here to account for the \u201cmany-to-many\u201d scenarios. The key question I am trying to answer for marketing here is \u2013<\/span><\/span><\/p>\n<\/div>\n <\/p>\n how many engaged leads and marketing engagements it takes to create a new opportunity?<\/span><\/span><\/p>\n <\/span><\/p><\/blockquote>\n<\/div>\n<\/div>\n Whether it is the custom attribution algorithm, out of the box algorithm from SFDC, or via popular tools like LeanData, Bizible, FullCircle, when done right, any attribution approach would provide the insights into the relationship between individuals and the opportunities they are influencing. <\/span>I<\/span><\/strong> <\/span>have been using the \u201cMulti-Touch (MT)\u201d and \u201cFirst-Touch (FT)\u201d attribution algorithms in my conversion framework.<\/span><\/strong> The \u201cFT\u201d approach gives the opportunity influencing credit to only those marketing engagement<\/span><\/span><\/p>\n<\/div>\n s (and in-turn the leads\/contacts) that end up being the first touch on the opportunities. The MT attribution model gives a fractional share of each opportunity to the lead\/contact depending on the number of marketing touches that are involved.<\/span><\/span><\/p>\n<\/div>\n Now, for the SAL to SQL conversion, I first have to identify all the opportunities that have been created and find the individuals on those opportunities. The marketing attribution data gives this relationship and helps with identifying the \u201cPeople IDs\u201d (SALs in this case) that are associated with the opportunities. With these details, I identify all those People IDs that have influenced the opportunity creation. I already have calculated (from above) all the People IDs that have been flagged as SALs. With these 2 counts, I can find out how many of these SALs have influenced the opportunity creation and thus, the SAL to SQL conversion.<\/span><\/span><\/p>\n<\/div>\n 4. SQL to SQO Conversion:<\/span><\/strong> for SQL to SQO cohort conversion, the framework involves identifying the SQLs that have gone beyond the pre-qualification stage. The primary difference between SQL and SQO is when an opportunity moves to a qualified stage. For some organizations that signals opportunity creation by SDRs and for some, it signals an opportunity acceptance by the AEs. For all such opportunities that qualify as SQOs, a flag is set to mark the opportunities that in turn is divided by the total SALs (from above) to get to SQL to SQO conversion rate.<\/span><\/span><\/p>\n<\/div>\n 5. SQO to Won Conversion:<\/span><\/strong> the logic for SQO to Won conversion follows the same approach as is used for the SQL to SQO conversion. The only difference is that for identifying the won opportunities, I take the SQOs and find how many of these SQOs have been won. From there, I count these opportunities and divide them by the count of SQOs that were identified in the previous step to get the conversion rate or in this case, qualified opportunity to win rate.<\/span><\/span><\/p>\n<\/div>\n Once the logic build for all these KPIs is completed, multiple rounds of data validation and unit testing (taking sample leads and opportunities and tracking their journey through the funnel) are undertaken to confirm that all calculations are working as intended. I then <\/span>design the visualizations<\/span><\/a> (in popular BI tools like Tableau, Looker, Periscope, DOMO, PowerBI) to<\/span><\/span><\/p>\n<\/div>\n\n
\n
<\/wow-image><\/div>\n<\/div>\n<\/figure>\n<\/div>\n<\/div>\n<\/div>\n
<\/wow-image><\/div>\n<\/div>\n<\/figure>\n<\/div>\n<\/div>\n<\/div>\n