CeraVe Bluesky Social Media Analysis

This analysis examines recent Bluesky posts mentioning CeraVe to understand social media engagement and common topics of discussion.

Collect the Data

library(atrrr)
library(dplyr)
library(stringr)
library(ggplot2)
library(knitr)

# Collect posts
cerave_posts <- search_post(
  q = "CeraVe",
  limit = 150,
  sort = "latest"
)

# Create clean dataset
cerave_clean <- cerave_posts %>%
  transmute(
    Post = text,
    Author = author_handle,
    Likes = like_count,
    Reposts = repost_count,
    Replies = reply_count,
    Engagement = like_count + repost_count + reply_count
  ) %>%
  filter(!is.na(Post)) %>%
  distinct(Post, .keep_all = TRUE)

# Save CSV
write.csv(
  cerave_clean,
  "CeraVe_Bluesky_Posts.csv",
  row.names = FALSE
)

cat("Total CeraVe posts analyzed:", nrow(cerave_clean))
## Total CeraVe posts analyzed: 163

Top Posts by Engagement

The following graph shows the five CeraVe posts that received the most engagement.

Common Topics

This graph shows how frequently selected skincare-related words appeared in the CeraVe posts.

Top 5 Posts

Top 5 CeraVe Posts by Engagement
Author Likes Reposts Replies Engagement
2ndaryprotocol.bsky.social 16 2 0 18
stillantspants.bsky.social 7 0 10 17
jenlucpiquant.bsky.social 10 1 0 11
magnolia2010.bsky.social 8 0 0 8
jerkwheatery.bsky.social 5 0 3 8

Summary

The Bluesky data provides a snapshot of how users are discussing CeraVe online. Engagement levels help identify which posts attracted the most attention, while the keyword analysis highlights common skincare topics associated with the brand.