Blended ROAS

Overview

Blended Return on Ad Spend (Blended ROAS) is the ratio of order revenue to the total advertising expenditure, including both channel ad spend and custom ad spend, across all channels.

📘

Blended ROAS = Order Revenue / Blended Ad Spend

The calculation is based on data in the Blended Stats table.

Detailed Breakdown

The formula above is derived from the following components:

Order Revenue = SUM(order_revenue) --> Orders table
Blended Ad Spend = spend + custom_ad_spend

Where:

spend = SUM(spend) --> Ads table
custom_ad_spend = SUM(IF(is_ad_spend, amount, 0)) --> Custom Spend table

Insights and Actions

Blended ROAS is crucial for measuring advertising effectiveness, linking ad spend to revenue. It helps optimize ad campaigns, improve budget allocation, influence pricing decisions, refine audience targeting, and evaluate creative content. Efficiently leveraging Blended ROAS data can guide strategic business decisions:

  • Campaign Optimization: Pinpoint and invest in high-performing ads, discontinuing or adjusting less effective ones.
  • Budget Allocation: Direct marketing budgets toward campaigns with the highest ROAS for better efficiency.
  • Pricing Strategy: Use ROAS insights to tweak pricing for enhanced ad performance and revenue.
  • Audience Targeting: Tailor ad targeting based on which segments yield the best ROAS, maximizing profitability.
  • Creative Evaluation: Assess which ad creatives and messages drive higher ROAS to guide future content creation.

Example Use

Prompt

What was my blended ROAS on April 1, 2024?

Response