User Post Engagement Tracking
This dataset provides granular, daily engagement metrics for user-generated posts on social media platforms, including views, likes, comments, shares, and more. It supports advanced content recommendation, community management, and trend analysis by capturing contextual details such as content type, promotion status, language, and topic. Ideal for building recommendation systems, monitoring community health, and optimizing content strategies.
Sample rows
preview · 8 of 90 rows · all 16 columns| engagement_idstring | post_content_typestring | engagement_scorefloat | is_promotedboolean | topicstring | post_idstring | user_idstring | post_created_atdatetime | engagement_datedate | views_countinteger | likes_countinteger | comments_countinteger | shares_countinteger | bookmarks_countinteger | reports_countinteger | languagestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ENG-0001 | image | 55.6 | false | travel | POST-001 | USR-01 | 2024-05-22T14:01:23Z | 2024-06-12 | 134 | 42 | 8 | 6 | 9 | 0 | en |
| ENG-0002 | video | 132.7 | true | technology | POST-002 | USR-02 | 2024-05-29T11:46:08Z | 2024-06-12 | 365 | 98 | 21 | 15 | 22 | 1 | en |
| ENG-0003 | text | 31.9 | false | news | POST-003 | USR-03 | 2024-06-01T19:25:53Z | 2024-06-12 | 80 | 24 | 4 | 2 | 7 | 0 | es |
| ENG-0004 | link | 13.7 | false | business | POST-004 | USR-02 | 2024-05-27T09:16:10Z | 2024-06-12 | 44 | 15 | 1 | 0 | 2 | 0 | en |
| ENG-0005 | video | 87.8 | true | sports | POST-005 | USR-04 | 2024-06-03T15:38:41Z | 2024-06-12 | 290 | 66 | 14 | 10 | 18 | 1 | en |
| ENG-0006 | text | 22.6 | false | health | POST-006 | USR-05 | 2024-05-30T20:04:10Z | 2024-06-12 | 61 | 22 | 3 | 1 | 3 | 0 | fr |
| ENG-0007 | image | 38.7 | false | fashion | POST-007 | USR-06 | 2024-06-11T07:19:41Z | 2024-06-12 | 110 | 30 | 5 | 3 | 5 | 0 | en |
| ENG-0008 | video | 70.9 | true | music | POST-008 | USR-07 | 2024-06-10T17:29:17Z | 2024-06-12 | 212 | 60 | 12 | 8 | 11 | 0 | en |
| ENG-0009 | link | 10.4 | false | science | POST-009 | USR-08 | 2024-05-25T13:31:47Z | 2024-06-12 | 39 | 10 | 2 | 1 | 1 | 0 | es |
| ENG-0010 | other | 2.9 | false | culture | POST-010 | USR-09 | 2024-06-02T22:42:51Z | 2024-06-12 | 18 | 3 | 0 | 0 | 0 | 0 | de |
| ENG-0011 | text | 17.7 | false | education | POST-011 | USR-10 | 2024-06-07T10:11:18Z | 2024-06-12 | 45 | 17 | 3 | 2 | 4 | 0 | en |
| ENG-0012 | image | 61.8 | false | food | POST-012 | USR-11 | 2024-06-09T13:55:32Z | 2024-06-12 | 171 | 54 | 9 | 7 | 13 | 0 | fr |
| ENG-0013 | video | 101.1 | true | movies | POST-013 | USR-12 | 2024-06-08T16:33:46Z | 2024-06-12 | 251 | 75 | 17 | 12 | 20 | 2 | en |
| ENG-0014 | link | 24.5 | false | news | POST-014 | USR-13 | 2024-06-01T08:01:29Z | 2024-06-12 | 63 | 21 | 5 | 2 | 4 | 0 | en |
| ENG-0015 | text | 7.3 | false | travel | POST-015 | USR-14 | 2024-05-24T21:32:04Z | 2024-06-12 | 29 | 9 | 1 | 0 | 1 | 0 | fr |
| ENG-0016 | image | 59.2 | false | nature | POST-016 | USR-15 | 2024-05-23T10:18:27Z | 2024-06-12 | 142 | 48 | 10 | 7 | 10 | 1 | en |
| ENG-0017 | video | 115.8 | true | sports | POST-017 | USR-16 | 2024-05-31T18:48:36Z | 2024-06-12 | 319 | 88 | 19 | 13 | 19 | 0 | en |
| ENG-0018 | text | 23.5 | false | business | POST-018 | USR-17 | 2024-06-06T21:14:12Z | 2024-06-12 | 73 | 23 | 3 | 1 | 3 | 0 | es |
| ENG-0019 | image | 68.2 | false | food | POST-019 | USR-18 | 2024-06-04T06:08:03Z | 2024-06-12 | 188 | 55 | 12 | 8 | 12 | 0 | en |
| ENG-0020 | video | 93.6 | true | technology | POST-020 | USR-19 | 2024-06-05T12:03:47Z | 2024-06-12 | 298 | 70 | 16 | 11 | 17 | 1 | en |
What the 90 rows show
from the 90-row sampleVideo (post content type) stands out: 22 of its 23 rows have is_
- 24%is_
promoted = true - 45.0median engagement_
score - 5languages
- 173median views_
count - 37.5median likes_
count - 6median comments_
count
Median 45.0, from 2.9 to 277.5.
- string 6
- integer 6
- float 1
- date 1
- datetime 1
- boolean 1
Columns
16 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
engagement_id | string | Unique identifier for each engagement recordunique | ENG-0001 |
post_id | string | Unique identifier for the user-generated post | POST-001 |
user_id | string | Unique identifier for the user who created the post | USR-01 |
post_content_type | string | Type of content in the post (e.g., text, image, video, link)text · image · video · link · other | image |
language | string | Language code of the post content (e.g., en, es, fr)5 languages · optional | en |
topic | string | Primary topic or category assigned to the post (e.g., sports, news, technology)optional | travel |
| Numbers 7 columns | |||
views_count | integer | Number of times the post was viewed on the engagement date0 or more | 134 |
likes_count | integer | Number of likes received by the post on the engagement date0 or more | 42 |
comments_count | integer | Number of comments received by the post on the engagement date0 or more | 8 |
shares_count | integer | Number of times the post was shared on the engagement date0 or more | 6 |
bookmarks_count | integer | Number of times the post was bookmarked or saved on the engagement date0 or more · optional | 9 |
reports_count | integer | Number of times the post was reported as inappropriate on the engagement date0 or more · optional | 0 |
engagement_score | float | Calculated engagement score for the post on the engagement date (weighted metric)0 or more · optional | 55.6 |
| Dates and times 2 columns | |||
post_created_at | datetime | Timestamp when the post was originally created | 2024-05-22T14:01:23Z |
engagement_date | date | Date on which engagement metrics were recorded | 2024-06-12 |
| True or false 1 column | |||
is_promoted | boolean | Indicates if the post was promoted or boosted on the engagement dateoptional | false |
Use it for
A social media dashboard
The is_
promoted rate, engagement_ score by post_ content_ type and a breakdown of topic. Excel, Power BI or Tableau. Why do 22 of 90 rows have is_
promoted = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Engagements90ENG-000155.6imageENG-0002132.7videoENG-000587.8video
A software demo
Believable engagements with post_
id, user_ id and post_ created_ at to fill a screen in front of a buyer.
blueprint · user-post-engagement-tracking
Behind this dataset
Same schema. As many rows as you need.
These 90 rows came out of a blueprint — 16 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.
- Log post type (text, image, video)
- Capture engagement counts (likes, shares, comments)
- Flag posts with negative sentiment
- Track time to first engagement
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- user-post-engagement-tracking