Social Media Engagement vs. Posting Frequency

Added on: Jun 27, 2025
User Prompt

Generate a scatter chart with post frequency (number of posts per week) on the x-axis and total engagement (sum of likes, shares, and comments) on the y-axis. Plot data from 300 social media accounts across platforms like Facebook, Instagram, and TikTok. Color-code points by content type: videos (blue), images (green), text (orange). Each data point also includes a small icon indicating the platform. For example, an Instagram account that posts 5 times a week, primarily with video content, and receives 15,000 total engagements. Add trend lines for each content type to show the optimal posting frequency for maximum engagement, and a tooltip that reveals the exact number of likes, shares, and comments for each post, along with the top-performing posts' captions and hashtags.