Data Dictionary

Overview

Measures the monetary impact of marketing campaigns.

Formula

Insights and Actions

• Revenue Attribution — Understand total value driven by ads or marketing activities.
• ROI Calculation — Helps determine ROAS, ACOS, and profitability.
• Campaign Prioritization — Focus on campaigns with the highest conversion value.
• Performance Analysis — Evaluate average value per conversion.
• Forecasting — Predict future sales based on current conversion trends.

Detailed Breakdown

• Conversion_value= SUM(conversion_value)

Suggested Dimensions

Related Metrics

Example Use

Query

SELECT ROUND(COALESCE(SUM(conversions_value), 0), 2) AS conversions_value FROM spends WHERE spends_date BETWEEN :start AND :end;