AI Agent for Social Analytics

I’m expanding my suite of AI-powered agents and need one dedicated to analysing data and creating reports. Its sole focus will be my website metrics and, more importantly, the social-media signals that reveal engagement levels and audience growth.

The agent should automatically pull raw figures from sources such as Google Analytics, Facebook, Instagram, X/Twitter and YouTube, tidy them, then turn the numbers into easy-to-read visuals and concise written insights. Think daily or weekly runs, a quick comparison with previous periods, and a highlight reel of what changed and why.

Feel free to work in Python with pandas, scikit-learn, LangChain or a similar stack, so long as the final solution can live on my VPS inside a container.

Deliverables
• Fully commented source code and environment file
• Step-by-step setup guide
• One sample report covering the last 30 days of data
• Brief doc on how to plug in new data sources

Acceptance criteria
• End-to-end automation—no manual steps after deployment
• Reach, impressions, engagement rate and follower-growth numbers align with native dashboards within ±2 %
• Report generation stays under five minutes for a 30-day window

If you have past work on social-media analytics bots or marketing dashboards, a quick link or screenshot would be great. Looking forward to seeing how you can turn raw website and social data into clear, actionable reports.