12 Steps to Setting Up Your Marketing Attribution in Marketo

March 2, 2015 RingLead Inc

Marketing attribution is a frequently discussed topic among marketing automation professionals and vendors. Yet it is a challenge to achieve an attribution system that takes into account touches, offers, and sources. Here’s is a roadmap of best practices to help you get closer to your goal of understanding the how and why of your sales funnel.

Keep in mind that this is a checklist. Getting to a closed loop attribution system takes time, so do not expect to get through all 12 steps in one day, or even in one month.

marketo attribution - laptop look from above

Step 1: Determine What You Want to Report On

In this crucial first step, you will work with your leadership to mockup reports. What are the strategic metrics for your funnel, and what are the tactical metrics?

While a tool like Marketo can collect a ton of data on lead behavior, reporting on all of that may be pointless, leading to vanity metrics and reports with no decision insights.

Strategic Metrics are what is important to the business.

  • Revenue
  • Subscribers
  • Churn Rate
  • Conversion rates in the funnel

Tactical Metrics are sometimes “
vanity metrics” but often serve to show you how well your marketing activities work. The key though is to tie back tactics to the strategy. If your content program is generating 25% CTR and a 12% on page conversion, that’s great, but how many are signing up for a trial? What’s the churn on that Offer or Channel? See more in this post.

The nice thing is Marketo (and other tools) can provide all of this data if setup correctly.

Once you have report mockups, then you can work backward to understand how to build the reports and what data you need to collect.

Step 2: Setup the Offer-Channel Attribution Lists

I highly recommend the
Offer-Channel Attribution Method, which provides a framework for the type of data to collect from each lead.

Here is a quick run down of how this system works.

  • Offer – the content or event that the lead was interested in. This would be viewed as:
    • Whitepapers
      • 2014-Holiday-Whitepaper
  • Channel – where and how the lead found out about the content. This would be viewed as:
    • Telemarketing
      • Agency A

When you consider your list of Offers and Channels, it is a good idea to think of all the possibilities, including voice and offline.

This entire system can be operated using the next steps. But for now, all you want to do is identify all of the Offers you make and all of the Channels you plan to use. Then create a spreadsheet that lists all the values you can have.

An example would be:

Channel Type Channel Name (free text) Offer Type Offer Name (free text)
PPC Adwords Whitepaper Definitive-guide-to-nurturing
Newsletter Tech Target Ebook 20-steps-to-marketing-guru
Banner-Ad Yahoo! Webinar ann-handley-webinar-Jan-30-2014
Social-Ad LinkedIn Video ann-handley-video-Jan-30-2014
List-Rental the-economist-011 Demo free-demo-offer
blog blog-post-title

Your Type fields will be picklists while your Names, or campaigns, should use dashes so they can be used in URL parameters. (It is possible to map a code to a name later if you want).

Step 3: Choose an Attribution Model for B2B Marketing

There are three major attribution systems, each with pros and cons.

First Touch is the easiest method to implement. In fact, you probably already have this out of the box with your CRM. First Touch says that the most important touch is the original acquisition of the Lead. All of your costs and revenue will be attributed to the first program the lead responds to. Sometimes First Touch is called “Original.” While easy, First Touch over represents the acquiring program instead of all of the other efforts you make.

A first touch system (FT), however, places all credit with the acquiring program. It is simple and easy to report on, yet ignores all of the nurturing efforts you make. If you are focused on acquisition for any reason – choice, e-commerce, one-off transactions – then this works well for you.

Last Touch is the opposite of First Touch. This system says to give all of the cost and revenue credit to the most recent, or last, campaign the lead responded to. Similar to First Touch (FT), Last Touch (LT) over represents the latest campaign to touch the Lead.

And LT has similar pros and cons to FT. Your system will be unable to tell you much about the acquisition method, but a lot about that last moment before the win. While that is helpful information, it is likely a lot of effort went into that lead before the last touch.

Multi-Touch attribution (MT) is the marketer’s goal. In this system, all touches are counted for cost and revenue. Multi-touch, however, requires further setup because you can weight the LT or FT differently than other touches. Marketo’s Revenue Cycle Explorer, for instance, automatically distributes revenue equally across the Programs that touch the Opportunity. Other reporting tools allow you to weight touches equally or placing emphasis on the First or Last touch, giving less weight to the middle touches. Each weighting option has challenges and I don’t necessarily recommend one or another. In most situations, equal weighting or a FT weighting provides appropriate insight into ROI.

As your understanding of attribution modeling improves, you will start to ask questions that can be resolved with more detailed modeling. The MT model we discussed above is a version of Avinash Kaushik’s Across Digital Channels models:

  • Online to Store (O2S)
  • Across Multiple Screens/Devices (AMS)
  • Across Digital Channels (ADC)

I can’t tell you which one to use for your situation, just that you will have to weigh the pros and cons and your ability to interpret the reports.

Step 4: Set up Paired Fields

In Step 2, you created a framework for the fields and picklist values required. Each attribution model requires a minimum of fields, just like this:

  • FT: just need
    • First Channel Type
    • First Channel Platform
    • First Offer Type
    • First Offer Name
  • LT will use Most Recent instead of Original
  • MT will use both, pairing the fields:
    • First Channel Type
    • Last Channel Type
    • First Channel Platform
    • Last Channel Platform

paired field - list

To see more about paired fields, download
Jeff Coveney’s Guide to Attribution.

Step 5: Set Up Hidden fields on Your Forms

There are plenty of ways to do this, but here’s how it might look in Marketo.

hidden field - list

Step 6: Set up URL Parameters

I wrote a
brief URL Parameter tutorial last year. Here is another good walkthrough of URL parameters.

Step 7: Create a Spreadsheet to Manage the URL Parameters

Here’s the
spreadsheet I use, feel free to adapt it.

Step 8: Set up a Program in Marketo

This is a Marketo centric issue. And it may be hard for you to manage if you have existing reports based on Programs.

It is possible to use Marketo Programs to collect Offer-Channel data. The most obvious way is to have a program for each Offer-Channel pair. You will end up with dozens of programs this way. I do not recommend this, however, it does work for some people. You might end up with:

offer-channel pair - list

I usually recommend a single Offer Program, with Tags to help identify the Offer content. Inside this Program is a registration flow that listens for the URL channel parameters, then assigns the Lead to a specific Channel SFDC Campaign.

Inside SFDC, you will have a Campaign Hierarchy:

  • Offer Campaign
    • Child Channel 1
    • Child Channel 2

This system requires SFDC Campaign Influence to work. Reporting will be done in SFDC, Tableau, or Full Circle CRM. We can argue about Marketo RCE or other options, but this will get you started.

I also have an Idea to
extend Marketo Programs to manage and report on this process.

Step 9: Set Marketo Campaign to Process Leads to SFDC Campaigns

For the single Program method, you will need a campaign to listen for the Last Touch data and then assign the lead to an appropriate SFDC Campaign. This is just an example of how you might set it up.

from marketo to salesforce - screenshot

Step 10: Set Marketo System to Manage Last Touch to First Touch Data

You will need a workflow to update the First Touch field in case it is empty. While you could just try to overwrite it from the hidden field (and use Field Blocking), this is less risky in my opinion.

Last Touch to First Touch - screenshot

Step 11: Add Data to SFDC Campaign Member Objects

In Step 8, we added records to SFDC Campaigns, creating Campaign Member Objects. In a basic system, we can now
start to report on this cross-object to study campaign influence. In a more complex system, we could add data to the Campaign Member Object to further study attribution and sales funnel.

Step 12: Report with Campaign Member Objects

I have found it hard to do proper reporting, but if you have a great SFDC Admin or data analyst, they can use the Campaign Member Object effectively. In addition, a tool like Full Circle CRM can do this all for you.

This is just a checklist of steps. The work to do this in your system is very detailed.

The Quick Checklist

Here’s a quick checklist of items you need to put together to build a proper attribution system.

  1. Mockups of reports you want to display.
  2. Setup Offer-Channel Attribution Lists.
  3. Choose the Attribution Model to start with.
  4. Setup Paired Fields in Marketo and the CRM.
  5. Setup hidden fields on the forms to work with URL parameters.
  6. Setup URL Parameters to collect data on forms.
  7. Spreadsheet to manage the URLs for each offer-channel combination.
  8. Marketo Program for the Offer.
  9. Marketo Campaign to manage adding leads to the right offer-channel campaign.
  10. Marketo system to manage LT to FT data.
  11. Take it one step further with SFDC Campaign Member Objects.
  12. Reporting tool that brings in SFDC Campaign Member and Influence.

Thank you to the team at
Perkuto for access to a Marketo instance and for working with me to develop this system.

Learn some cool things to do with your new Webhook with the free ebook below.

marketo webooks

This post originally appeared on Marketing Rockstar Guides.

The post 12 Steps to Setting Up Your Marketing Attribution in Marketo appeared first on RingLead.

Previous Article
21 Eye-Opening Statistics About CRM Users
21 Eye-Opening Statistics About CRM Users

Software Advice recently released a report from 304 CRM software users about their current CRM solution. Th...

Next Article
How to Use Text Messaging as Data Quality tool to Sell
How to Use Text Messaging as Data Quality tool to Sell

I am often asked whether it’s appropriate to use text messaging with a customer or a prospect. Times are ch...