KaraboSishuba/creator-audit-Project

End-to-end data audit and Power BI dashboard examining wastage in agency markup and ROAS improvement in South African creator economy. # creator-audit-Project End-to-end data audit and Power BI dashboard examining wastage in agency markup and ROAS improvement in South African creator economy. # 1. Project Overview & Business Case This project is built on the core business hypothesis that South African independent beauty, cosmetics, and hair care brands waste about 30 percent to 40 percent of their budget in paying intermediaries. Traditional intermediaries tend to make true creator performance numbers invisible through vanity metrics, which makes it hard for brands to measure real business outcomes. The data analysis presented below analyzes a structured synthetic dataset that contrasts agency-managed marketing campaigns against direct-to-creator marketing campaigns through the use of escrow infrastructure. Quantitative analysis reveals that eliminating margins from traditional intermediaries doubles ROAS. # 2. Dataset Architecture (dataset.csv) This project employs an analysis dataset using relationships that have 50 campaigns’ data and 33 numerical dimensions that relate to the South African beauty industry and creator economy. Identifiers & Categorization: campaign_id, campaign_name, brand_name, model_type (Traditional Agency vs. Direct Platform), agency_name, escrow_provider. • Creator & Niche Dimensions: creator_id, creator_handle, creator_tier (Nano, Micro, Macro), niche (Curly Hair Maintenance, Beauty & Makeup, Skincare), province (Gauteng, Western Cape, KwaZulu-Natal, Eastern Cape), platform (Instagram, TikTok). • Financial Metrics (ZAR): brand_total_budget_zar, creator_payout_zar, intermediary_fee_pct, intermediary_markup_amount_zar, avg_basket_size_zar, attributed_revenue_zar. • Performance & Efficiency Analytics: impressions, clicks, click_through_rate_pct, conversions, conversion_rate_pct, true_cpa_zar, roas_multiplier. # 3.Dashboard and Vizzes 1. Executive Markup Leakage Card: KPI cards highlighting Average Agency Markup Waste (R) and ROAS Multiplier Uplift (+100%). 2. Geographi …