Social Media Analytics Dataset Generator

Generate Realistic Social Media Performance Data in Seconds. Generate relational data for users, posts, engagement, and campaigns.

Advanced Options

Select your options and click "Generate Data".

Data Preview

Preview will appear here...

The Ultimate Social Media Analytics Dataset Generator

How do you prove the value of a tweet or measure the true impact of an Instagram campaign? Answering these questions requires data that goes far beyond simple likes and follower counts. To truly understand engagement, you need a dataset that connects posts, performance metrics, audience demographics, and campaign goals—a resource that’s nearly impossible to find for practice.

That’s why we built the PNRao Social Media Analytics Data Generator.

This powerful tool creates a complete, enterprise-grade social media dataset with a single click. Whether you’re a marketing analyst trying to calculate engagement rates, a student learning about digital communication, or a brand manager building a competitive analysis report, this generator provides the data you need. Stop working with isolated metrics and start analyzing the entire social media ecosystem.

Why This Dataset is a Powerful Learning Tool

Learning social media analytics with abstract numbers can be challenging. This generator provides a realistic context that makes complex concepts easier to grasp.

  • Builds a Narrative: You can step into the role of a Social Media Analyst for the PNRao Company. Your task could be to identify which content format drives the most engagement, analyze audience sentiment around a new product, or determine the most effective platform for your marketing campaigns. This narrative-driven practice helps solidify your understanding.
  • Makes Concepts Concrete: When you see a Post Performance table linked to Social Media Posts and Follower Growth, abstract concepts become tangible. This makes metrics like Engagement Rate, Follower Growth Rate, and Sentiment Score easier to understand because you can see how they are built from the ground up.
  • Encourages Realistic Analysis: The rich context inspires more creative and insightful analysis. You might build a dynamic brand health dashboard in Power BI or create a report in Excel to analyze the performance of different hashtags. This allows you to practice not just the technical skills, but also the art of data storytelling.

Designed for Real-World Social Media Analysis

This dataset isn’t just a random collection of tables. It has been carefully crafted to mirror the data structures you will find in actual social media analytics platforms like Sprout Social or Hootsuite, making it the perfect tool to develop practical, job-ready skills.

  • Reflects Core Social Media Operations: Every brand tracks posts, followers, engagement, and campaigns. The tables in this generator represent the core of what you will encounter professionally. By understanding how these tables relate to each other, you are learning the fundamental blueprint of social media data.
  • Focus on a High-Demand Skillset: Social media analytics is a critical function for any modern business. The skills you build here—calculating engagement rates, analyzing audience demographics, and measuring campaign impact—are directly transferable to the tasks and challenges you will face in a real data analytics or marketing job.
  • Covers a Wide Range of Concepts: The structure of this data is intentionally designed to be a comprehensive playground for learning. With this single resource, you can practice:
    • Excel/Sheets Functions: Use VLOOKUP or XLOOKUP to connect post performance with campaign details, SUMIFS and COUNTIFS to create summary reports, and PivotTables to analyze engagement by platform.
    • Time-Series Analysis: Analyze follower growth or post frequency over time to practice forecasting.
    • Data Cleaning: Use the “messy data” option to practice cleaning and validating social media metrics and user-generated content.
    • Advanced Analysis: The interconnected tables are perfect for practicing relationship-building in Power BI or writing SQL JOIN queries to combine data from multiple sources for a complete analysis.

In short, learning with this dataset ensures you are not just practicing abstract concepts, but preparing yourself with the practical knowledge and experience valued by employers.

Tables Overview

The generator produces a wide array of datasets across different social media functions. Each dataset has a unique structure, as detailed below.

Content & Performance

Table Name Description Columns
Social Media Posts The master list of all posts published across platforms. PostID, PlatformID, PostDate, PostText, PostType, CampaignID
Post Performance Engagement metrics for each individual post. PerformanceID, PostID, Likes, Shares, Comments, Impressions

Audience & Growth

Table Name Description Columns
Follower Growth A monthly snapshot of follower counts by platform. RecordID, Date, PlatformID, Followers
Audience Demographics A summary of audience demographics by platform. DemographicID, PlatformID, AgeGroup, Gender, Country

Campaigns & ROI

Table Name Description Columns
Campaigns Master A list of all social media marketing campaigns. CampaignID, CampaignName, StartDate, EndDate, Budget
Campaign Performance Aggregated performance metrics for each campaign. CampaignPerfID, CampaignID, TotalImpressions, TotalEngagement, TotalSpend, Clicks, Conversions

Listening & Sentiment

Table Name Description Columns
Mentions & Sentiment A log of brand mentions from across the web. MentionID, Date, Platform, MentionText, Sentiment
Influencers A list of influencers and their key metrics. InfluencerID, Name, Platform, Followers, EngagementRate

Master Data

Table Name Description Columns
Platforms Master A master list of social media platforms. PlatformID, PlatformName
Hashtags Master A list of all hashtags used. HashtagID, HashtagText
Post Hashtags A linking table showing which hashtags were used on which posts. PostHashtagID, PostID, HashtagID

How to Use This App

  1. Select a Table to Preview: Use the “Select Table to Preview” dropdown menu to choose the type of data you want to inspect.
  2. Specify the Number of Posts: Enter the desired number of social media posts. This is the main driver; a higher number will generate more related records in all other tables.
  3. Configure Advanced Options (Optional): Click on Advanced Options to expand the menu.
    • Date Range: Select a Start Date and End Date to constrain the generated data to a specific time period.
    • Data Quality: Choose the quality of your dataset (Clean, Slightly Messy, or Very Messy).
  4. Generate the Data: Click the “Generate All Datasets” button. The application will process your request and display a preview of your selected table.
  5. Download Your Data:
    • Preview: To quickly download just the data shown in the preview table, click “Download Preview (CSV)” or “Download Preview (Excel)”.
    • All Related Tables: Click “Download All Tables (Excel)” to download a single Excel file with every table on a separate, clearly named sheet. This is the best option for relational analysis.

How to Use This Data

  • For Data Analysts & BI Professionals:
    • Social Media Dashboards: Use the Post Performance, Follower Growth, and Campaign Performance tables to build an executive-level dashboard in Tableau or Power BI.
    • Engagement Analysis: Calculate engagement rates by platform, content type, or time of day to find what resonates with your audience.
    • Practice SQL: Load the tables into a database and practice writing complex JOIN queries to link posts to their performance metrics and associated campaigns.
  • For Students & Educators:
    • Create realistic case studies for marketing, communications, and data science courses.
    • Use the data as a foundation for assignments on calculating key social media metrics like engagement rate, follower growth rate, and campaign ROI.

Feedback & Suggestions

This tool is built for you. If you have an idea for a new social media table or an improvement, please leave your feedback in the comments section below.