Source: marketing_etl_dashboard.pbix · Page 1 of 4 · 14 visuals · Data: marketing_ga4_merged_with_kpis · Slicers: Date · Country · Brand Name
7 cards3 slicers3 line charts1 bar chart

Marketing Performance Overview — Dec 2023 · May 2024

Brand Name
Country
Month
Monthly Trend — Dec 2023 – May 2024
Total Ad Spend
Ad spend
Profit
Profit
ROAS — monthly avg
ROAS
Total Sales by Country
Country
Marketing ETL · Google Ads API + GA4 · Python · RandomForest · PuLP · Claude API github.com/ozlemtonbul/ads-ml-budget-intelligence
Source: marketing_etl_dashboard.pbix · Page 2 of 4 · 12 visuals · Data: product_country_performance · Slicers: Brand Name · Country
2 slicers3 col charts1 scatter5 bar charts

Brand-Level Marketing Insights

Brand Name
Country
Sales · Profit · ROAS by Brand
Total Sales by Brand
Sales
Profit by Brand
Profit
Avg ROAS by Brand
ROAS
Spend vs Profit · CPA
Spend vs Profit — Bubble = Orders
Scatter
Avg CPA by Brand
CPA
Country Breakdown
Sales by Country
C1
Orders by Country
C2
Profit by Country
C3
Brand × Country — Performance Table
Marketing ETL · Google Ads API + GA4 · Python · RandomForest · PuLP · Claude API github.com/ozlemtonbul/ads-ml-budget-intelligence
Source: marketing_etl_dashboard.pbix · Page 3 of 4 · 10 visuals · Data: what_if_budget_simulation · Slicer: Scenario · PuLP linear optimizer
1 slicer3 cards3 col charts3 stacked bars

Scenario Simulation — What-If Analysis

Select Scenario — Click to Update All Visuals
−19% budget
$9.1M
Total sales → $53.4M
Total profit → $44.3M
ROAS → 5.89×
Baseline — 0%
$11.3M
Total sales → $66.7M
Total profit → $55.4M
ROAS → 5.89×
+19% budget
$13.6M
Total sales → $80.1M
Total profit → $66.5M
ROAS → 5.89×
Sales · Profit · ROAS by Scenario
Total Sales
S1
Total Profit
S2
ROAS
S3
100% Composition — Stacked
% Sales Share
S4
% Profit Share
S5
Spend vs Return Ratio
S6
Marketing ETL · Google Ads API + GA4 · Python · RandomForest · PuLP · Claude API github.com/ozlemtonbul/ads-ml-budget-intelligence
Source: marketing_etl_dashboard.pbix · Page 4 of 4 · 10 visuals · Data: lp_budget_recommendations · Slicers: Brand Name · Country
2 slicers3 cards5 bar charts1 table

Product & Region Performance + KPI Diagnostics

Brand Name
Country
Budget Recommendations — LP Model
Recommended LP Budget by Brand
LP
ROAS by Brand
ROAS
Revenue · Predicted ROAS · Profit
Revenue by Brand
Rev
Predicted ROAS — RandomForest
PR
Profit by Brand
Prof
KPI Diagnostics — Brand × Country
Marketing ETL · Google Ads API + GA4 · Python · RandomForest · PuLP · Claude API github.com/ozlemtonbul/ads-ml-budget-intelligence