How to calculate the ROI of your Facebook Marketing Campaigns

In order to calculate the ROI for your Facebook marketing campaigns, follow the steps below:

Step-1: Login to your Google Analytics account and then navigate to your main GA view.

Step-2: Navigate to ‘Acquisition’ > ‘All Traffic’ > ‘Source / Medium’ report:

Step-3: Change the data range of the ‘Source/Medium’ report to the last one month.

Step-4: Filter out all the Facebook and Instagram referrers by using the following regular expression in the advanced reporting filter: facebook|instagram

Step-4: Note down the direct sales (last click sales) from Facebook:

So, Direct Sales from Facebook: $25,545.92

Step-5: Navigate to ‘Conversions’ > ‘Multi Channel Funnels’ > ‘Assisted Conversions’ report:

Step-6: Click on the ‘Source’ tab:

Step-7: Filter out all the Facebook and Instagram referrers by using the regular expression facebook|instagram in the advanced reporting filter and then note down the ‘Assisted Conversion Value’ metric:

So, Assisted Sales from Facebook: $10,857.89

Report on the assisted conversion value because Facebook does not always directly close a sale.

Sometimes it may only assisted a sale which is then closed by other marketing channels.

It is important to note that the assisted conversion value for Facebook, as reported by Google Analytics does not take Facebook view through conversions into account.

There are no impression assisted conversions reported for Facebook by GA.

You see only click assisted conversions.

view-through conversion is the conversion attributed to the last Facebook ad a person saw (but not clicked) before completing a conversion on your website.

Step-8: Navigate to your Facebook Ad manager account and set the date range to the last one month.

Step-9: Note down the total amount spent from all FB campaigns in the last one month:

So the Facebook Ad Spend in the last one month: $26,081.98

Step-10Within the Facebook Ad Manager, click on Columns > Customize Columns:

Step-11: Click on ‘Comparing Windows’ link:

Step-12: Select ‘1 day view’ attribution window (provided you are heavily involved in multi-channel marketing) and then click on the ‘Apply’ button:

Select the ‘1-day view’ attribution window because it is the narrowest window you can get among all available ‘view through attribution windows’ in Facebook. 

The wider you make your attribution window, the more credit Facebook is likely to take, for all the conversions that occurred on your website.

For more details read: Wide and narrow attribution windows and their impact on conversion attribution

Note: If all you do in terms of online marketing is Facebook, then select the ’28 days view’ attribution window.

Step-13: Note down the total website purchases conversion value for ‘1 day view’ attribution:

So, the sales through the view through conversion (based on ‘1 day view’ attribution window) is: $193,478.37

Report on Facebook view-through conversion sales because they are not reported by Google Analytics.

Google Analytics can not report on ‘view-through conversions’, as they do not result in a visit that can be attributed to Facebook.  

All such visits are either reported as direct traffic or branded organic search traffic or traffic from some other marketing channel.

Remember that the Facebook advertising is also creating a ‘demand’ for your product/service.

And this demand can result in lot more direct and branded organic search traffic and sales on your website.

The only way to measure such impact is to take ‘view through conversions’ into account while calculating ROI.

We can not discount them completely and assume they do not exist and have zero impact on sales and other conversions.

It is important to note that the assisted conversion value for Facebook, as reported by Google Analytics does not take Facebook view-through conversions into account.

Google Analytics does not report on impression assisted conversions (conversions assisted by Facebook ad impressions) for Facebook.

It only takes Facebook click assisted conversions (Conversions assisted by Facebook ad clicks) into account, where people clicked on one of your Facebook ads in their conversion path.

Facebook calculates view-through conversions for different attribution windows like ‘1 day view’, ‘7 day view’ and ’28 days view’.

Wider the attribution window, the more conversions Facebook will claim.

1 day view’ attribution window is the narrowest window you can get among all available ‘view through attribution windows’ in Facebook.

‘1 day view’ attribution window means, Facebook attribute all conversions that occurred on your website to the last Facebook ad which a person saw (but not clicked), provided the conversion(s) occurred within 1 day from the last ad impression and no other Facebook ad was clicked in the last 28 days.

Step-14: Calculate the ‘Return on Ad Spend’ from Facebook

Return on Ad Spend from Facebook =

(Direct Sales from Facebook as reported by ‘Google Analytics’ +

Assisted Sales from Facebook as reported by ‘Google Analytics’ +

View Through Conversion Sales from Facebook as reported by ‘Facebook Ad Manager’)  

/

(Total Facebook Ad Spend as reported by ‘Facebook Ad Manager’ + Cost of managing the Facebook marketing campaigns)

= ($25,545.92 + $10,857.89 + $193,478.37) / ($26,081.98 + $3500)

= $229,882.18 / $29,581.98

= 7.77

So for every dollar we spent on Facebook, we got $7.77 back.

That’s how we can calculate the ROI of Facebook marketing campaigns.

NoteIf majority of your website traffic and sales come from Facebook then make sure to use the ‘28 days view’ attribution window (not ‘1 day view’ attribution) for calculating the View through conversion sales from Facebook.

Related Articles

 

Do you know the difference between Digital Analytics and Google Analytics?


99.99% of course creators themselves don’t know the difference between Digital analytics, Google Analytics (GA) and Google Tag Manager (GTM).

So they are teaching GA and GTM in the name of teaching Digital analytics.

They just copy each other. Monkey see, monkey do.

But Digital analytics is not about GA, GTM.

It is about analyzing and interpreting data, setting up goals, strategies and KPIs.

It’s about creating strategic roadmap for your business.


Digital Analytics is the core skill. Google Analytics is just a tool used to implement ‘Digital Analytics’.

You can also implement ‘Digital analytics’ via other tools like ‘adobe analytics’, ‘kissmetrics’ etc.

Using Google Analytics without the good understanding of ‘Digital analytics’ is like driving around in a car, in a big city without understanding the traffic rules and road signs.

You are either likely to end up somewhere other than your destination or you get involved in an accident.


You learn data analysis and interpretation from Digital analytics and not from Google Analytics.

The direction in which your analysis will move, will determine the direction in which your marketing campaigns and eventually your company will move to get the highest possible return on investment.

You get that direction from ‘Digital analytics’ and not from ‘Google Analytics’.


You learn to set up KPIs, strategies and measurement framework for your business from ‘Digital analytics’ and not from ‘Google Analytics’.

So if you are taking a course only on 'Google Analytics’, you are learning to use one of the tools of ‘Digital analytics’. You are not learning the ‘Digital analytics’ itself.

Since any person can learn to use Google Analytics in couple of weeks, you do no get any competitive advantage in the marketplace just by knowing GA.

You need to know lot more than GA in order to work in digital analytics and marketing field.


So what I have done, if you are interested, is I have put together a completely free training that will teach you exactly how I have been able to leverage digital analytics to generate floods of news sales and customers and how you can literally copy what I have done to get similar results.

Here what You'll Learn On This FREE Web Class!


1) The number 1 reason why most marketers and business owners are not able to scale their advertising and maximise sales.

2) Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.

3) The number 1 reason why conversion optimization is not working for your business.

4) How to advertise on any marketing platform for FREE with an unlimited budget.

5) How to learn and master digital analytics in record time.

 
 

My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and Beyond
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

Himanshu Sharma

Digital Marketing Consultant and Founder of Optimizesmart.com

Himanshu helps business owners and marketing professionals in generating more sales and ROI by fixing their website tracking issues, helping them understand their true customers purchase journey and helping them determine the most effective marketing channels for investment.

He has over 12 years experience in digital analytics and digital marketing.

He was nominated for the Digital Analytics Association's Awards for Excellence.

The Digital Analytics Association is a world renowned not-for-profit association which helps organisations overcome the challenges of data acquisition and application.

He is the author of four best-selling books on analytics and conversion optimization:

error: Alert: Content is protected !!