---
title: How To Calculate Return on Ad Spend (ROAS) in Excel or Sheets
description: This guide breaks it down step-by-step, helping you measure campaign effectiveness and optimize your advertising budget for maximum ROI.
---

[Why do you think? ](https://demandcues.com/resources)

# [How To Calculate Return on Ad Spend (ROAS) in Excel or Sheets](https://demandcues.com/resources/how-to-calculate-return-on-ad-spend-roas-in-excel-or-sheets)

 Written by [Doug Dotts](https://demandcues.com/resources/author/doug-dotts) | Sep 2, 2024 3:31:00 PM

##### Introduction

In the world of online advertising, measuring the effectiveness of your campaigns is crucial. One of the key metrics used for this purpose is Return on Ad Spend (ROAS), which tells you how much revenue you generate for every dollar you spend on advertising. Knowing your ROAS helps you optimize your campaigns, allocate your budget effectively, and ultimately maximize your advertising ROI.

This blog post will guide you through the simple steps of calculating ROAS in both Excel and Google Sheets, using a clear and easy-to-follow approach.

##### **Understanding ROAS**

Before diving into the calculations, let's solidify our understanding of ROAS. ROAS is a ratio that expresses the amount of revenue generated from your advertising campaigns compared to the total cost of those campaigns. It can be calculated using the following formula:

**ROAS = Total Revenue from Ads / Total Ad Spend**

##### **Calculating ROAS in Excel**

##### **Calculating ROAS in Google Sheets**

##### **Optimizing Your ROAS**

Once you have your ROAS figures, analyze them to understand the performance of your advertising campaigns. A higher ROAS indicates that your campaigns are generating more revenue compared to the ad spend. Here are some ways to optimize your ROAS:

Get this formula here  
<https://docs.google.com/spreadsheets/d/1t8PVR9BXy1alsq1ygigD-9hs6ja0-SRT/edit?usp=sharing&ouid=100180107424943908535&rtpof=true&sd=true>

Calculating ROAS in Excel or Sheets is a straightforward process that can provide valuable insights into the effectiveness of your advertising campaigns. By understanding and optimizing your ROAS, you can make better decisions about your advertising budget and ultimately achieve your marketing goals.

[View full post](https://demandcues.com/resources/how-to-calculate-return-on-ad-spend-roas-in-excel-or-sheets)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Doug Dotts"
  },
  "dateModified" : "2024-09-19T15:37:44.591Z",
  "datePublished" : "2024-09-02T15:31:00Z",
  "headline" : "How To Calculate Return on Ad Spend (ROAS) in Excel or Sheets",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1260,
    "url" : "https://www.d3mandable.com/hubfs/Blog%20Banners%20%2844%29-3.png",
    "width" : 2240
  },
  "mainEntityOfPage" : "https://demandcues.com/resources/how-to-calculate-return-on-ad-spend-roas-in-excel-or-sheets",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://www.d3mandable.com/hubfs/2-Nov-26-2024-01-39-03-9335-AM.png",
      "width" : 324.0
    },
    "name" : "Why do you think?"
  }
}
```