SayPro Marketing Performance Dashboard Export

Python Code to Export the Dashboard

pythonCopyEditimport pandas as pd

# Campaign performance summary
campaign_performance = pd.DataFrame({
    "Campaign Name": ["Email Blast May", "Google Ads Q2", "Facebook Awareness", "Webinar Promo"],
    "Channel": ["Email", "Search", "Social Media", "Email/Social"],
    "Start Date": ["2025-05-01", "2025-04-15", "2025-04-20", "2025-05-05"],
    "End Date": ["2025-05-10", "2025-05-30", "2025-05-25", "2025-05-12"],
    "Impressions": [5000, 12000, 8000, 4500],
    "Clicks": [800, 1600, 950, 700],
    "CTR (%)": [16.0, 13.3, 11.9, 15.6],
    "Conversions": [120, 250, 90, 110],
    "Conversion Rate (%)": [15.0, 15.6, 9.5, 15.7],
    "Cost (USD)": [200, 900, 350, 250],
    "Cost per Conversion (USD)": [1.67, 3.60, 3.89, 2.27]
})

# Channel performance overview
channel_performance = pd.DataFrame({
    "Channel": ["Email", "Search", "Social Media", "Referral", "Direct"],
    "Visitors": [3000, 5000, 4000, 1200, 1800],
    "Leads Generated": [600, 800, 500, 150, 100],
    "Conversions": [180, 250, 120, 40, 30],
    "Conversion Rate (%)": [6.0, 5.0, 3.0, 3.3, 1.7]
})

# Export to Excel
excel_file = "SayPro_Marketing_Performance_Dashboard.xlsx"
with pd.ExcelWriter(excel_file, engine="xlsxwriter") as writer:
    campaign_performance.to_excel(writer, sheet_name="Campaign Performance", index=False)
    channel_performance.to_excel(writer, sheet_name="Channel Performance", index=False)

print(f"Excel file '{excel_file}' created successfully.")

🛠 What You Need:

• Python installed on your computer
• pandas and xlsxwriter libraries (you can install them with pip install pandas xlsxwriter)