Social Media Data Analysis for Hypothetical Coffee Brand- Great Grounds
This project analyzed two Twitter posts by a mock brand, Great Grounds, to determine what drives social engagement. Despite lower visibility, the funnier, image-and-hashtag-rich Tweet outperformed its simpler counterpart in engagement. The insights formed the basis for a strategy pivot toward humor and visual content.
Project Type
Digital Marketing Project: Data Analysis
Date
October 2024

Project Overview
This was a hands-on data analytics activity using real-world-style social media data for a fictional coffee brand, Great Grounds. The task focused on analyzing and interpreting Twitter post performance to derive insights that could help shape future digital marketing strategies.
What Sparked This?
As part of my Google digital marketing course, I was given access to a dataset simulating a live brand campaign coinciding with Daylight Savings. The aim was to use social media metrics to evaluate campaign success and develop actionable content strategy recommendations, a critical skill in performance-driven digital marketing.
Dataset Details
The dataset was a spreadsheet featuring two Twitter posts with the following metrics:
-
Post text
-
Asset (image/visual)
-
Timestamp
-
Impressions
-
Engagements (likes, replies, reposts, clicks)
-
Hashtag and detail expand clicks

What I Explored & Analyzed
Key questions I explored:
-
What made one post outperform the other in engagement?
-
Does the time of posting outweigh the creativity of content?
-
What content elements drive user interactions?
Comparison of Posts
-
Tweet 1 had nearly twice the impressions of Tweet 2.
-
Tweet 2, however, had 6x the engagements, aligning better with the campaign’s objective.
Content & Creative Strategy
-
Tweet 1 lacked visual or hashtag elements.
-
Tweet 2 used humorous, relatable text, hashtags (#DaylightSavings #CoffeeTime), and an image—resulting in significantly higher interaction.
Timing & Visibility
-
Tweet 1 posted at 8:03 AM, when more users were active.
-
Tweet 2 went live at 1:59 AM, resulting in fewer impressions but higher engagement—showcasing the power of creative content over timing alone.


Key Takeaways
-
How to read and interpret engagement metrics beyond vanity impressions.
-
The importance of contextual creativity and content formatting in social media performance.
-
How small changes (hashtags, images, tone) drastically alter campaign outcomes.