Social Media Marketing Automation - Auto-Generate Analytics Report

 Notes:

• Problem: Gathering analytics manually takes effort.

• Benefit: Generates automated analytics reports from data.

• Adoption: Extend to include AI-powered insights.

Python Code:

import pandas as pd

import matplotlib.pyplot as plt

def generate_report(data_file):

    df = pd.read_csv(data_file)

    

    engagement_rate = df["Likes"].sum() / df["Posts"].sum()

    avg_comments = df["Comments"].mean()

    print(f"Engagement Rate: {engagement_rate:.2f}")

    print(f"Average Comments per Post: {avg_comments:.2f}")

    df.plot(x="Date", y=["Likes", "Comments"], kind="line", title="Engagement Trend")

    plt.show()

if __name__ == "__main__":

    generate_report("social_media_data.csv")