Social Media Post Interaction Dataset

This dataset provides detailed records of user interactions with social media posts, including likes, comments, and shares, across multiple platforms and campaigns. It enables in-depth analysis of engagement trends, audience demographics, and campaign effectiveness for social media analytics and marketing optimization.

  • opened 12 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Analyzing engagement rates and trends across platforms and campaigns

Sample rows

preview · 8 of 200 rows · all 14 columns
interaction_idstringinteraction_typestringuser_location_statestringpost_idstringuser_idstringplatformstringinteraction_datetimedatetimecampaign_idstringcomment_textstringuser_location_citystringuser_location_countrystringpost_published_datetimedatetimepost_content_typestringpost_languagestring
X2hC_a1Zcommentblankpost_1001user_501Instagram2024-03-12T14:05:29Zcmp_spring24🌸 Love this look! Where did you get it?ParisFR2024-03-11T09:15:00Zimagefr
9JkL0wPplikeNYpost_1002user_502Facebook2023-12-01T08:21:15ZblankblankNew YorkUS2023-11-30T20:10:00Ztexten
QwT-7EvYshareBEpost_1003user_503Twitter2024-01-19T17:45:00ZblankblankBerlinDE2024-01-19T16:00:00Zlinkde
sT1nA0kBcommentCApost_1004user_504LinkedIn2022-09-05T09:30:00Zcmp_b2bGreat insights on the future of AI in business!San FranciscoUS2022-09-05T06:00:00Zlinken
FvW8g3dSlikeRJpost_1005user_505Instagram2024-02-14T11:11:11ZblankblankRio de JaneiroBR2024-02-14T10:09:00Zimagept
u7GkQw2Lcommentblankpost_1006user_506TikTok2024-04-01T22:45:00Zcmp_tiktokfun😂 This is hilarious!ShanghaiCN2024-04-01T20:00:00Zvideozh
kE5xR9mZlikeblankpost_1007user_507YouTube2023-10-15T18:30:05ZblankblankTokyoJP2023-10-15T14:00:00Zvideoja
gH3vLz8NshareONpost_1008user_508LinkedIn2024-05-20T09:22:00Zcmp_leadgenblankTorontoCA2024-05-18T08:00:00Zlinken

What the 200 rows show

from the 200-row sample
  • 4post content types
  • 6platforms
  • 10post languages
  • 23user location countries
  • 46user location cities
interaction_type200 rows by value
0408077like39%77comment39%46share23%
user_location_state106 rows with a value · 94 left blank
  1. CA13
  2. BE10
  3. ON10
  4. RJ8
  5. NSW8
  6. IL5
  7. NY4
  8. MH4
  9. DL3
  10. CT3
14 columns by typefrom the column list below
  • string 12
  • datetime 2

Columns

14 columns in two groups
blueprint · 14 columns
columntypedescriptionexample
Text 12 columns
interaction_idstringUnique identifier for each post interaction recorduniqueX2hC_a1Z
post_idstringUnique identifier for the social media postpost_1001
user_idstringUnique identifier for the user who interacted with the postuser_501
platformstringSocial media platform where the post was published (e.g., Facebook, Twitter, Instagram)6 valuesInstagram
interaction_typestringType of interaction (like, comment, share)like · comment · sharecomment
campaign_idstringIdentifier for the marketing campaign associated with the post, if applicableoptionalcmp_spring24
comment_textstringText content of the comment, if the interaction is a comment; null otherwiseup to 2,000 · optional😂 This is hilarious!
user_location_citystringCity of the user at the time of interaction, if availableoptionalParis
user_location_statestringState or region of the user at the time of interaction, if availableoptionalNY
user_location_countrystringCountry of the user at the time of interaction, if availableoptionalFR
post_content_typestringType of content in the post (image, video, text, link)image · video · text · link · optionalimage
post_languagestringLanguage code of the post content (e.g., en, es, fr)10 languages · optionalfr
Dates and times 2 columns
interaction_datetimedatetimeTimestamp of when the interaction occurred2024-03-12T14:05:29Z
post_published_datetimedatetimeTimestamp when the original post was published2024-03-11T09:15:00Z

Use it for

  • rows20014 columnsrows by interaction t…77like77comment46share

    A social media dashboard

    A breakdown of user_location_state. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable interactions with post_id, user_id and platform to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 14 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset200 rows14 columns
Yours10,000 rows14 columnsuser_location_city: UK only

blueprint · social-media-post-interaction-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Include post type and author
  • Track interaction counts per post
  • Segment by content category
  • Flag viral posts
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
social-media-post-interaction-dataset

More in Social Media

Browse all
Also in Social MediaTikTok Influencer Engagement MetricsSocial Media Influencer Metrics StreamsSocial Media Hashtag Engagement DataAll 1,947 datasets

What should your data show?

Preview 20 rows free
No signup. No card.