The Marketing ROI Calculator – The Simple & Proven Formula for Calculating True Marketing Cost, Value and ROI

Put Your Marketing Team & Your Marketers on Notice! Your company will start using this proven formula to measure true marketing ROI !!

Introducing…The Marketing ROI Calculator – The Simple & Proven Formula for Calculating True Marketing Cost, Value and ROI !!

  1. Having trouble figuring out the value of your marketing efforts?

  2. Need a proven formula to calculate true marketing ROI?

  3. Want to continue marketing efforts that work and provide net income and abandon those efforts that are a net loss?

  4. Seeking to implement an improved world-class and six sigma marketing process to increase your marketing effectiveness while decreasing your marketing costs?

If you answered “yes” to any one of these questions, read the rest of this blog that delivers the true marketing ROI formula to help develop measured ROI driven marketing!

{Note: this is just one of many formulas variants I have developed for calculating marketing ROI and the actual one to implement will depend on the type of marketing you are performing}. 
The Marketing ROI Dilemma

The Marketing ROI Dilemma

Before we get into the main marketing ROI formula, I want to point out a relevant quote and sentiment from John Wanamaker who was an American merchant, civic and political figure, considered by some to be a pioneer in advertising and marketing. To that end and related to this topic, John Wanamaker once had a famous quote to illustrate his frustration with the inability to determine if his marketing and advertising spend was truly effective and if it was producing the expected ROI. This famous quote is as follows:

John Wanamaker & His Famous Marketing & Advertising Quote

John Wanamaker & His Famous Marketing & Advertising Quote

X

The following blog content is focused on introducing the proven formula, in use by some advanced marketing companies across the US, for calculating marketing and campaign ROI designed to drive sales orders. The marketing ROI formula will be broken down in sections and then by individual fields. We will cover how the formula is used, what internal six-sigma marketing processes need to be put in place to support the population of this formula and how each field is calculated or derived.

Introducing the Tried and True Full Marketing ROI Formula:

Complete Marketing ROI Formula

Complete Marketing ROI Formula

This formula consists of a pre-launch campaign section illustrated in yellow above and a post-launch campaign section for the entry/update of actual campaign post-launch effectiveness and ROI.

Let’s now review each section in detail as follows: Pre-Launch ROI formula section:

Campaign Pre-Launch Marketing ROI Formula

Campaign Pre-Launch Marketing ROI Formula

x

The first column of the pre-launch marketing ROI formula (“Campaign Number”) should be a uniquely identifiable campaign number or code being updated from your marketing automation system and the 2nd column (“Campaign Description”) should be the main goal of the marketing campaign (Customer: acquisition, retention, up-sell, cross-sell, branding or awareness, urgent business alert of crisis communication, etc.).

The 3rd column of the pre-launch marketing ROI formula (“Campaign Quantity”) is the campaign quantity being delivered to your customer audience (i.e. number of e-mails being delivered, mail, texts, etc.)

Campaign Quantity

Marketing Campaign Quantity

The 4th column of the pre-launch marketing ROI formula (“Materials and Labor Cost”) is critical to the ROI formula and will likely require a few marketing process changes, as well as IT system changes. A true six-sigma structured process marketing environment will require your company to track all labor hours and materials cost associated with the planning, development and launching of any and all campaigns. This requires that you create a work breakdown structure (WBS) to appropriately track hours and materials associated with each campaign you conduct. By doing this you will finally have the fully loaded cost for each campaign such as creative hours spent, strategy planning time, cost of materials (for direct mail, outsourced text or e-mail, etc.). The cost shown is the per-unit cost to send the campaign or 34 cents for each delivered campaign item.

Marketing Materials & Labor Cost

Marketing Materials & Labor Cost

The 5th column of the pre-launch marketing ROI formula (“Total Mktg. Cost”) is merely the unit cost expanded out to the total cost of the campaign (10,000 x. 34). If your delivered item is a single unit campaign quantity like web landing page, your campaign cost simply becomes the total labor hours used to develop this page and you can skip both columns 3 & 5.

Total Marketing Cost

Total Marketing Cost

x

The 6th and last column of the pre-launch marketing ROI formula (“Plan Campaign Dates”) is the expected campaign execution dates that the orders (shown in the post campaign section) will be tracked against this particular campaign.

Planned Campaign Dates

Planned Campaign Dates (that orders will be tracked against)

x

Let’s now review the last section of the marketing ROI formula in detail as follows: Post-Launch ROI formula section:

Campaign Post-Launch Formula

Campaign Post-Launch Formula

The first column is the actual campaign dates that the campaign executed in order to compare it to the planned campaign dates

To obtain the 2nd column of the post-launch marketing ROI formula (“# of Orders”) will require your company to develop the process of direct campaign attribution so that when customers order an item based on a campaign, those customers are incented to provide the campaign code (e.g. in exchange for a small discount) they viewed that drove them to order the item. By making this marketing process change, you have a direct way to track which campaigns drove which orders, by how much, etc. Car rental companies are excellent at this since every coupon is tracked with an encoded code such that they know exactly where the coupon was obtained, what campaign it was associated with, etc.

Number of Orders Associated with Campaign

# of Orders

x

The 3rd column of the post launch marketing ROI formula (“Actual RR %”) is the redemption rate (RR) or simply the number of orders driven by the campaign, divided by the campaign quantity launched (column 3 of the pre-launch form).

Rate of Return for Campaign

Rate of Return

x

The 4th column of the post launch marketing ROI formula (“Avg. Order Sold”) is the average order sold which is populated by your order system and is simply the total value of all orders divided by the number of orders. In this case the total of all orders is equal $2,175 (this becomes the 4th column, “Bookings”) divided by 15 orders = $145 average per order.

Average Order Sold (AOS) $$

Average Order Sold $$

x

The 5th column of the post launch marketing ROI formula (“Bookings $$”) is simply the number of orders multiplied by the average $ per order or, in this case, 15 orders x $145 per average order = $2,175.

Bookings $ from Orders

Bookings $ from Orders

x

The 6th column of the post launch marketing ROI formula is the Average Cost of Goods Sold (“COGS %”). In this case, the company has calculated that, historically, the cost of an average order is approximately 30% of an orders value. Another way to state this is that average margins are 70% and 30% is the cost to produce an order.

Cost of Goods Sold (Avg.) %

Cost of Goods Sold (Avg.) %

x

The 7th column of the post launch marketing ROI formula (“COGS $”) is simply the COGS sold percentage (30%) multiplied by the total bookings $$ value ($2,175 x 30%) = $652.50

Cost of Goods $$

Cost of Goods $$

x

The 8th column of the post launch marketing ROI formula (“Contribution $$”) is where we finally calculate the total ROI of the campaign via this simple 2 step process:

  1. Add the cost of the labor to produce the campaign as calculated in column 5 of the pre-launch formula to the cost to produce the orders that the campaign specifically drove.

  2. Subtract the total value of orders from #1 above.

Using the example shown in the full marketing ROI formula above, we first add the pre-launch materials and labor cost of $3,400 to a Cost Of Goods Sold (COGS) cost of $652.50 = ($3,400 + 652.50) = $4,052.50 We then subtract this total campaign cost from total bookings value of $2,175 = -$1,877.50.

Contribution $$

Contribution $$

The 9th and final column of the post launch marketing ROI formula (“Cost Per Order”) is simply the total number of orders divided by column 7 (“Contribution”) to determine how much each order is benefitting or costing the company when produced. In this case it is a contribution of -$1,877.50 divided by 15 = -$125.17.

Cost Per Order

Cost Per Order

Per the last section, it is important to note that, the greater the number of orders, the more likely the cost will go from a negative contribution to a positive. This occurs because you have generated enough bookings $$ to exceed the cost of the overhead associated with the labor cost to develop and launch the campaign.

Break even for this campaign would be to sell at least 34 orders where the contribution finally turns positive of $51 and the cost per order becomes +$1.50. Selling beyond 34 orders becomes pure profit for the campaign and adds to the bottom line contribution.

This sample below shows the equation using break even orders (“# of Orders”) of 34:

Campaign Break Even Example

Campaign Break Even Example

I have helped numerous companies across the US implement, not only the marketing ROI formula/equation, but an entire world class & six-sigma marketing process that accompanies the ROI formula.   Implementing this six-sigma marketing process includes implementing a marketing and campaign work breakdown structure (WBS), campaign tracking codes, a set of governing marketing performance metrics and benchmarks and much more.

Once this six sigma process architecture is in place, companies are able to implement a full closed loop marketing process and enable full marketing ROI and effectiveness tracking for any/all marketing initiatives and programs as well as the associated marketing campaigns. In addition to those benefits, companies experience an increase their marketing process repeat-ability and predictability as well as automation of numerous manual marketing tasks, leading to decreased marketing costs and decreased marketing cycle time.

Advertisements

The Basic S4 (S**4) Building Blocks to Creating and Implementing an Effective Customer Strategy

4S - Customer Strategy Building Blocks

4S – Customer Strategy Building Blocks

 

The following blog article will succinctly and effectively answer the following questions as related to developing and deploying an effective customer strategy:

  • What are the basic building blocks of an effective customer strategy ecosystem?

  • What is the function of each process in this customer delivery ecosystem?

  • What are the critical questions that must be answered by each function in this ecosystem?

  • How can you develop an effective customer strategy that delivers maximized customer satisfaction simultaneous to maximized profitability?

  • What is the checklist to ensuring your customer strategy and delivery is effective?

The Building Blocks of the Customer Strategy Life Cycle

The Building Blocks of the Customer Strategy Life Cycle

 

Above are the basic building blocks to delivering an effective customer experience.  Each process is designed to work in an ongoing continuous ecosystem (loop) in order to deliver a personalized customer experience that matches the customer’s current and future needs, preferences, etc.

Let’s examine each process and how it supports the overall infrastructure model.

  • Segment – the analogy for the segment process is that the more and differentiated customer knowledge you have, the better you will be able separate customers into unique needs groups in order to deliver a unique experience that they truly value.

  • Separate – Once you have effectively segmented your customers and prospects into unique needs groups, you can then start to separate them in order to deliver differentiated and 1-on-1 treatments that are uniquely valuable to each of those customer segment groups.

  • Satisfy – The next step in the process is to deliver content and programs that deliver value, not only to the needs of the overall segment group, but also delivers value to every customer sub-segment within the overall segment group via program sub-segment delivery structures. This is accomplished by delivering customized 1-to-1 customer programs that effectively leverage the unique customer insights gathered (history, needs, preferences, likes, dislikes, previous pain points, etc.).

  • Stratify – The last step in this foundational process is to develop program that migrate customers from low value segments to ever increasing higher value segments. The goal of this process to increase customer’s overall spend, overall share of wallet with the company and overall loyalty and brand ‘stickiness’ such that migrating to a competitor and defecting becomes increasingly difficult. In addition, the migration of customer to higher value segments should also increase the customer’s brand advocacy ranking such that there is a correlation between higher value customer segments and their likelihood to be more likely brand super-advocates {see blog on this topic titled “Achieving Market Leadership by Effectively Managing Customer Loyalty and Advocacy ” : Achieving Market Leadership by Effectively Managing Customer Loyalty and Advocacy  }

The 4S Customer Capabilities

The 4S Customer Capabilities

 

Critical Questions Answered by Each Process in the Above Customer Delivery Ecosystem:

  • Segment – What specific data elements and insights can we leverage or collect to increase our ability to develop unique customer treatment groups.

  • Separate – Which customer groups does it make sense to develop and deliver differentiated treatment strategies based on profitability models?

  • Satisfy – What are the optimal customer treatment strategies that can simultaneously optimize customer profitability, loyalty, brand advocacy and customer growth objectives?

  • Stratify – How do we deliver a progressive and tiered customer program to differentiate ourselves vs. our competitors and grow our market share?

Summary: You might read many complex articles on what a good customer strategy should be based on, but the above basic foundational building blocks are a simple way to start thinking about your customer ecosystem and what corporate capabilities need to be put in place to deliver effective customer and market success.

Aligning Market Insights & Trends to Customer Strategies & Priorities

Does Your Company Ever Grapple with how to answer the Following Questions related to the market you operate in and your customers?:

  1. What is the size of the potential pool of new customers and which are the best customers to acquire?

  2. Which customers are your most profitable and how do you get other customers to grow and become part of your top ( and most profitable) customer segment group?

  3. What is your current customer share of wallet (SOW) as compared to your competitors and what does driving small incremental increases in your customer SOW do to your overall revenue?

  4. What are the shifting attitudinal and behavior patterns of your customer market and how do you develop a strategy that ‘gets in front of’ these trends?

  5. What are the shifting customer demographics of your marketplace as well as the underlying shift in spending habits

  6. What are the changes in customer preferred marketing channels as well as trends that might impact customer loyalty strategy

Market Insights and Trends Drive Customer Strategy, Programs

Market Insights and Trends Drive Customer Strategy, Programs

 

The above charts illustrate why it is critically important to have clear and accurate insights into your new customer market potential/pool as well as the current customer base and their share of wallet.

The chart above (left side) details the trends for new customers by segment as compared to current customers.

The chart above (right side) illustrates which customers drive the current percentage of revenue in order to understand how customer priorities and strategy should be defined.

Critical Insights: Top Customer, Top Profitable Customers and Customer Share of Wallet vs. Competitors

Critical Insights: Top Customer, Top Profitable Customers and Customer Share of Wallet vs. Competitors

Market Spend Insights Can Be Transformational in term of goal setting

The above graphic illustrates how share of wallet changes drive bottom line revenue as well as converting customers into more loyal top customers.

Customer Attitudinal Trends Insights Are Critical to Customer Strategy

Customer Attitudinal Trends Insights Are Critical to Customer Strategy

Understanding your market & customer behavior insights is crucial to your company’s survival

The above graphic demonstrates a deep understanding in the shifting attitudinal and behavior patterns of the customer market

Customer Market Buying Power Insights are Crucial For Developing a Coherent Customer Strategy

Customer Market Buying Power Insights are Crucial For Developing a Coherent Customer Strategy

The above chart illustrates a company capability to understand shifting demographics as well as the underlining shift in spending habits per demographic group

Understanding Key Customer Behavior & Preferences is a Customer Strategy Imperrative

Understanding Key Customer Behavior & Preferences is a Customer Strategy Imperrative

The above chart illustrates a company capability to understand the changes in marketing channels as well as trends that might impact customer loyalty strategy

Customer Strategy: An Alignment of All Customer & Market Insights to Maximize Market Dominance & Profitability

Customer Strategy: An Alignment of All Customer & Market Insights to Maximize Market Dominance & Profitability

Once Customer and Market Insights are fully embraced, an Effective Customer Strategy can be developed that includes optimizing market channel selection, as well as contact and loyalty strategy program components

Blog Summary: In order to achieve the above insights, your company must develop and deploy the following strategic capabilities and delivery programs:

  1. Market sizing & trend insights

  2. Customer revenue and profitability insights analysis

  3. Customer share of wallet and competitor spend insights delivery capability

  4. Market trend & consumer attitudinal and behavior change longitudinal analysis

  5. 360° customer needs and preference cultivation that enables a personalized customer experience strategy and delivery (i.e. preference portal customer selection of preferred channels, content types, offer types, frequency of content delivery by content type.)

Below is a list of companies where I have helped develop these programs and are considered world-class in these practices:

  • Johnson & Johnson

  • Capital One

  • Amazon

  • American Express

  • Kelloggs

Turn Customer Feedback & Complaints into Market Leadership, Dominance, Max Profitability

slide-1

Turn Customer Insights & Complaints into Market Leadership, Dominance, Max Profitability

Research has shown that customers are willing to donate their time (approx. 5-10 hours per week) to become a company and brand partner to help your company grow and become more successful

slide2

Key Customer Questions to Grow Your Market Share, Profitability

If you don’t ask your customers for insights, they will share them with someone else in the form of negative feedback, complaining, etc. which will erode your perception in the marketplace

slide3

Golden Questions to Win New Customer, Expand Your Business with New Products & Services

Customers are your best source for insights to help grow and improve your business – if you don’t ask, then you are ignoring valuable feedback that your competitors potentially could exploit to your detriment

slide4

Customer Complaints Can Be Turned Into Gold with the Right Approach

Treat Customer Complaints not as annoyances but rather as gifts to the company and brand(s)

slide5

Transform Customer Complaints into Company Expansion Plans and Customers into Brand Advocates

A carefully constructed customer-partner system will simultaneously cultivate great customer business expansion ideas as well as customer advocates and partners (Research has shown that, by enabling customers to provide continuous feedback and insights, customer longer-term loyalty has correspondingly increased)

Change Management Best Practices & World-Class Change Deployment Methodology

 

slide1

Best Practice Change Management Framework

 

Any change initiative should employ a proven & world-class change management implementation framework

slide2

Best Practice Change Management Project Approach & Plan – Define Goals, Obtain Buy-In

Change Management Methodology: Any change initiative should employ a proven & world-class change management implementation framework. Best Practice Steps to Define Change Goals and Obtain Buy-In for the Change

slide4

Best Practice Change Management Project Approach & Plan – Design Change Approach

Change Management Methodology: Best Practice Steps to Designing a Solid Change Approach

slide5

Best Practice Change Management Project Approach & Plan – Develop and Deploy Change

Change Management Methodology: Best Practice Steps to Developing and Deploying Change

slide6

Best Practice Change Management Project Approach & Plan – Deliver Change Results

Change Management Methodology: Best Practice Steps to Delivering Change Results

slide3

Management’s Crucial Role In Supporting Change

Management Must Have Clearly Articulated Roles in Facilitating and Supporting any Change

slide7

Organizational Change Alignment Possible Outcomes

The graphic above depicts the various change outcomes possible. Following a solid change methodology can ensure the optimal state of “total alignment”

slide8

Change Initiative Ranking Analysis Techniques

A best practice change approach includes proven methods and techniques to evaluate potential change initiatives to undertake

slide9

Typical & Critical Change Initiative Roles & Organizational Structure

A world-class change approach includes mapping out change roles and delivering sufficient training and role change orchestration. This approach ensures that aspect of the organization is pulling together in synergy on every level following the implementation of the change.

slide10

Change Management Initiative Resource Plan

A world-class change approach includes mapping out a change implementation organization including the organizational inter-relationships, special committees and groups as well as specific roles and responsibilities.

slide11

The Role of Middle Management in Change Management

A world-class change approach must include middle management inclusion strategies

slide12

Managing & Mitigating Organizational Change Resistance

Careful Considerations must be made to anticipate and mitigate change resistance, including from middle management

slide13

Executive Support for Change Management

A world-class change approach includes planning how executive support will be applied during any change initiative

slide14

Change Management Strategies for Institutionalizing Change

Best practice change methodologies and strategies can mitigate the pitfalls associated with not institutionalizing a change which risks, over time, organizational drift away from the desired change state.

Customer Emotions that Drive Buying Behavior

Find out why most companies miss the mark in terms of focusing on generating positive customer emotions

slide1

Solutions to Problems AND Good Customer Emotions Need to Exist for Long-Term Loyalty

Good products and services are only part of the equation in terms of generating customer repeat business, loyalty, long-term retention

slide2

Some Customers Will Work to Destroy Your Business While Others Are Willing Partners in Helping You Grow, Be More Successful

Some customers will actually work to kill your company and brand(s), namely dissenters and defectors, while others will work tirelessly to bolster your sales, reputation, customer acquisition efforts, etc.

slide3

Guidelines for Generating Positive Customer Emotions and Relations

It is essential that all of your customer facing team members are representing the company and brand well, and that they adhere to your stated customer principles

slide4

Sample Steps to Developing an Environment Where Customers Are Motivated to Buy from Your Company

Your customer facing team members need to develop a customer interaction playbook that is consistent with your brand and customer mantra

slide5

Alignment of the customer delivery ‘value chain’ is Crucial

Every aspect of your customer delivery ‘value chain’ needs to be synchronized to deliver a highly consistent and high quality (emotional) experience as rated by your customers

slide6

A Chief Customer Officer’s (CCO) role is to Advocate for the Customer within the CxO suite

** Refer to previous blog article on the 5 R’s of customer loyalty – https://goo.gl/L4IA3q

If you rate customer satisfaction and loyalty as a high company priority, then they must be represented by a Chief Customer Officer (CCO) that will truly advocate for customers and set the customer standards that drive positive customer emotions

Summary:  The following points summarize the content of this blog as follows:

  • In order to develop customer loyalty you must have both great products and services as well as the ability to generate positive customer emotions (customer delight, feeling connected to the company)

  • Segments of your customer base will work to destroy your attempt at market success while others are your partners in helping your company become even more successful.

  • In order to drive positive customer emotions and convert your customers into advocates and super-advocates, you must develop an internal customer relations playbook (develop customer vision, code of customer interaction conduct, etc.)

  • Every aspect of your customer delivery ‘value chain’ needs to be in-synch in order to deliver an end-to-end superb and fulfilling customer experience

  • Every company should have the equivalent of a Chief Customer Officer (CCO) in order to set the customer vision and standards and be the ultimate advocate for all of your customers.

Win a Customer for Life by Employing the 5 R’s of Customer Loyalty

 

slide1

The 5 “R’s” of Customer Loyalty

slide2

Ensure Your Company is 5 “R” Customer Compliant

Following the 5 R’s of Customer Loyalty Will Enable Your Company to Attract and Keep Customers for Life

 

slide3

Ensure Your Company is Customer R-Reliable

 

slide4n

Top Steps to Ensuring Your Company is R-Reliable

The First “R” of Customer Loyalty Is Setting High Quality Customer Standards (External) and Goals (Internal) and then Delivering on that Customer Promise for Each and Every Customer Interaction as well as the overall & long-term customer relationship

 

slide5

Example of How a Company Demonstrates Customer R-Reliability

 

 

slide6

Example of How a Company Demonstrates Customer R-Reliability (continued)

 

 

slide7

Ensure Your Company is Customer R-Responsive

 

slide8

Top Steps for Your Company to Become Customer R-Responsive

 

The 2nd “R” of Customer Loyalty Is Ensuring That Customer’s Expectations Are Met: Needs, Concerns, Quality, Cycle Time Expectations, etc.

 

Example of How a Company Demonstrates Customer R-Responsiveness

Example of How a Company Demonstrates Customer R-Responsiveness

 

slide10

Example of How a Company Demonstrates Customer R-Responsiveness (continued)

 

slide11

Ensure Your Company is Customer R-Recognizable

 

slide12

Top Steps for Your Company to Become Customer R-Recognizable

The 3rd “R” of Customer Loyalty Is Ensuring That Your Brand and Company has Distinctive and Positive Characteristics such that it drives positive emotions (driving repeat business, customer referrals, word-of-mouth adverting, etc. 

 

slide13

Example of How a Company Becomes Customer R-Recognizable

 

slide14

Example of How a Company Becomes Customer R-Recognizable (continued)

 

slide15

Ensure Your Company is R-Relationship Oriented

 

slide16n

Top Steps for Your Company to Become Customer R-Relationship Oriented

The 4th “R” of Customer Loyalty Is Ensuring That Your Brand and Company develops a high quality and mutually beneficial relationship with your customers based on mutual respect, customer insights, an ongoing and open dialogue and a model that encourages a partnership between your brand & company and your customers 

 

slide17

Example of How a Company Demonstrates That It Is Customer R-Relationship Oriented

 

slide18

Example of How a Company Demonstrates That It Is Customer R-Relationship Oriented (continued)

 

 

slide19

Ensure Your Company is Customer R-Rewarding

 

slide20

Top Steps for Your Company to Become Customer R-Rewarding

The 5th “R” of Customer Loyalty Is Ensuring That Your Brand and Company rewards mutually beneficial customer behavior (greater share of wallet, spend, brand partnership activities, etc.) such that it drives further and longer-term customer loyalty.

 

slide21

Example of How a Company Demonstrates Customer R-Rewarding

 

slide22

Example of How a Company Demonstrates Customer R-Rewarding (continued)

 

slide23

Is Your Company Ready to Take the 5 “R” Pledge?

SUMMARY: If you take the pledge above to adhere to the 5 R’s of customer loyalty, you will enhance your ability to attract and retain customers for life. Key to this is developing the capabilities to be best in class for each “R” and ensuring that you are (cost effectively) maintaining a major qualitative advantage in each customer R vs. your competitors.

%d bloggers like this: