4 Steps to ‘Close the Loop’

  |  September 13, 2012   |  Comments

Tying marketing activity to revenue can seem daunting – especially for B2B companies. Learn how to use closed-loop insights to deeply optimize programs based on what’s really driving revenue and thereby see a strong ROI on this project.

Has this happened to you… You suggest integrating your web analytics, CRM, and marketing automation sources together. Your IT team promises to have it ready “in a few years.”

You grind your teeth because you know you need to optimize digital marketing programs based on what’s really driving revenue rather just “front-end” metrics like visitors or registrations.

There’s obviously no one-size-fits-all approach or tool to close the loop – you have to look closely at your company’s particular situation and requirements. But, to de-mystify this project, let’s go through four common steps.

1. Define Requirements & KPIs

Define the goals, stakeholders, and team to get the work done. This will include your marketing, sales, IT, and web dev teams and likely a third-party vendor. You’ll also identify the source systems: a CRM such as Salesforce.com, a web analytics system such as SiteCatalyst or Google Analytics, and perhaps a call center or other line-of-business technology.

  • Determine reporting requirements, goals, KPI
  • Identify source systems and data stores (CRM & Web Analytics at a minimum)
  • Mock up reporting, dashboard, and presentation layout

2. Design & Build Data Model

Build a data model to house all the data behind the KPIs you just defined. You’ll define the key data fields and keys and the transformations that need to occur from the source systems into your target system.

  • Identify key data fields and transformations
  • Identify target datastore and data model
  • Create field-to-target mapping

closed-loop-marketing

3. Develop ETL Integrations

Now you actually build the programs and scripts to move data from the source systems into the target systems. You’ll also build various scripts and programs to transform, and calculate data, and build your KPIs in the target system. IT requirements will come into play here because you’re dealing with systems across the enterprise.

  • Write scripts to extract / de-dupe / load to target
  • Write scripts to check and validate data

4. Build & Distribute Dashboards

This is where it all comes together with reporting (and ongoing analysis). You’ll build dashboards and analyze reporting that ties front-end marketing activity with actual revenue.

  • Develop report server
  • Build dashboard presentations
  • (Naturally, at this point you’ll be doing on-going ad hoc analysis as well)

Bottom Line

The work to close the loop isn’t trivial, but it doesn’t have to be a boil the ocean, seven figure exercise either. With the right partner and/or internal team, you should be able to execute this project in three months for under $100,000. As the simple drawing above shows, you’ll be able to use closed-loop insights to deeply optimize programs based on what’s really driving revenue and thereby see a strong ROI on this project.

Tags:

ClickZ Live Toronto On the heels of a fantastic event in New York City, ClickZ Live is taking the fun and learning to Toronto, June 23-25. With over 15 years' experience delivering industry-leading events, ClickZ Live offers an action-packed, educationally-focused agenda covering all aspects of digital marketing. Register today!

ClickZ Live San Francisco Want to learn more? Join us at ClickZ Live San Francisco, Aug 10-12!
Educating marketers for over 15 years, ClickZ Live brings together industry thought leaders from the largest brands and agencies to deliver the most advanced, educational digital marketing agenda. Register today and save $500!

ABOUT THE AUTHOR

Richard Roberts

Rich has over 20 years of experience in planning, building, and managing cutting-edge integrated marketing for some of the smartest companies in the world. His career balances senior agency roles and senior client-side roles. On the agency side, while at BusinessOnline and Grey Interactive he works with world-class brands including HP, NetApp, Dell, Honeywell, and Workday. On the client side, he has been a CMO or VP marketing for big online brands such as CNET and ZipRealty and for start-ups like Zing, Callwave, and SendMe Mobile. This gives him the unique ability to deeply understand his clients' needs and to ensure that the agency delivers on meeting these needs.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Marketing newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

Gartner Magic Quadrant for Digital Commerce

Gartner Magic Quadrant for Digital Commerce
This Magic Quadrant examines leading digital commerce platforms that enable organizations to build digital commerce sites. These commerce platforms facilitate purchasing transactions over the Web, and support the creation and continuing development of an online relationship with a consumer.

Paid Search in the Mobile Era

Paid Search in the Mobile Era
Google reports that paid search ads are currently driving 40+ million calls per month. Cost per click is increasing, paid search budgets are growing, and mobile continues to dominate. It's time to revamp old search strategies, reimagine stale best practices, and add new layers data to your analytics.

WEBINARS

Resources

Jobs

    • GREAT Campaign Project Coordinator
      GREAT Campaign Project Coordinator (British Consulate-General, New York) - New YorkThe GREAT Britain Campaign is seeking an energetic and creative...
    • Paid Search Senior Account Manager
      Paid Search Senior Account Manager (Hanapin Marketing) - BloomingtonHanapin Marketing is hiring a strategic Paid Search Senior Account Manager...
    • Paid Search Account Manager
      Paid Search Account Manager (Hanapin Marketing) - BloomingtonHanapin Marketing is hiring an experienced Paid Search Account Manager to...