Data Dictionary

Overview

Represents the total amount invested in marketing and advertising across all channels within a specific period. It’s a critical input for measuring marketing efficiency and calculating ROI.

Formula

Insights and Actions

• Track how marketing funds are being allocated and spent.
• Identify which platforms deliver the highest return on spend.
• Compare ad spend with metrics like sales and conversions.
• Detect overspending or underutilization in campaigns.
• Use historical spend trends to plan future marketing budgets.

Detailed Breakdown

• Ad Spend Spend_amount

Suggested Dimensions

Related Metrics

Example Use

Query

SELECT SUM(spends.amount) AS ad_spend FROM spends WHERE spends_date BETWEEN :start AND :end;