Categories: Power BI / Practice Datasets
Tags:

This Paid Digital Marketing Campaigns Performance Analysis dashboard provides a comprehensive view of marketing campaign performance across different advertising channels. The dashboard visualizes key metrics, trends, and insights to help optimize ad spending and maximize ROI.

Get the dataset here : https://github.com/slidescope/data/blob/master/Marketing_Dashboard.xlsx

Key Features & Insights:

πŸ“Œ Summary Metrics:

  • Sum of Ad Spend: 358K €
  • Average Conversion Rate: 42.76%
  • Total Conversions: 9,460
  • Total Revenue: 0.47M €

πŸ“Œ Visualizations & Analysis:

  1. Revenue & Ad Spend Trends:
    • A time-series analysis showing fluctuations in revenue and ad spend from January to March 2024.
  2. Conversion Rate & Performance:
    • Tracks the average conversion rate and the total number of conversions daily.
  3. Revenue by Channel:
    • A breakdown of total revenue generated by each advertising channel:
      • Instagram Ads (27.07%)
      • LinkedIn Ads (23.74%)
      • Google Ads (24.09%)
      • Facebook Ads (25.1%)
  4. Leads by Month & Channel:
    • Displays the number of leads generated each month categorized by platform (Facebook, Google, Instagram, LinkedIn).

πŸ“Œ Interactivity & Filters:

  • Channel Selection: Allows users to filter data by ad platforms.
  • Date Range Filter: Enables analysis within a specific time period (01-01-2024 to 27-03-2024).

Use Case & Benefits:

βœ… Helps marketing teams track ad performance and budget efficiency.
βœ… Enables data-driven decision-making for optimizing digital marketing strategies.
βœ… Identifies high-performing ad channels and areas for improvement.

This Power BI dashboard provides a powerful, interactive way to analyze and enhance digital marketing campaigns. πŸš€