We built a comprehensive social media analytics and growth tracking system for PureGlow Skincare — replacing vanity metrics with revenue-connected intelligence that identified their highest-ROI content types, optimized posting strategy, and grew social-attributed revenue by 182%
Social Media Audit, KPI Framework Development, Cross-Platform Analytics Setup, Growth Tracking Dashboard, Competitor Benchmarking System, Content Performance Intelligence, ROI Attribution Model, Automated Reporting
Tools & Platforms Used
Sprout Social, Google Analytics 4, Google Looker Studio, Meta Business Suite, Instagram Insights, TikTok Analytics, YouTube Studio, Pinterest Analytics, Iconosquare, Brandwatch, Rival IQ, Google Sheets, Airtable, Zapier, Make (Integromat), ChatGPT API (OpenAI), Slack, Notion, Shopify (data source), WordPress
Project Year
2025
The Overview
PureGlow Skincare is a D2C beauty brand selling clean, cruelty-free skincare products through their Shopify store and marketplace presence. With active accounts on Instagram (48K followers), TikTok (22K), Facebook (18K), YouTube (8K), and Pinterest (12K), they were posting consistently — 4-5 times daily across platforms — but had zero visibility into what was actually working.
The social media manager tracked “likes and followers” in a basic spreadsheet updated monthly. That was the extent of their analytics. Nobody could answer fundamental questions: “Which platform actually drives sales?” “What content type generates the most revenue?” “Is our Instagram growing or stagnating?” “Should we invest more in TikTok or YouTube?” “What’s our actual ROI from social media?”
They were creating content in the dark — no data-driven decisions, no performance benchmarks, no competitor comparison, and no connection between social media activity and business revenue. High-effort content pieces that took hours to produce might generate zero sales, while a quick behind-the-scenes Story might drive thousands in revenue — but nobody could see the difference.
We built a complete social media analytics and growth tracking ecosystem that connects every platform’s data into unified dashboards, tracks content performance at the individual post level, attributes revenue to specific social activities, benchmarks against competitors, and delivers actionable intelligence that transforms social media from a “hope it works” activity into a measurable, optimizable revenue channel.
The Challenge
Vanity Metrics Obsession: The team celebrated follower count and likes while ignoring metrics that actually matter — engagement rate, reach rate, save rate, share rate, click-through rate, and most importantly, revenue attribution. A post with 2,000 likes and zero website clicks was celebrated equally to one with 200 likes and 40 purchases.
5 Platforms, Zero Unified View: Each platform had its own native analytics — Instagram Insights, TikTok Analytics, YouTube Studio, Facebook Insights, Pinterest Analytics — but data lived in 5 separate dashboards that couldn’t be compared, correlated, or aggregated. Getting a “total social media performance” view required manually checking each platform individually.
No Content Performance Intelligence: PureGlow published 140+ pieces of content monthly across platforms but had no system to identify:
Which content types perform best (carousel vs. Reel vs. static vs. Story)
Which topics resonate (ingredient education vs. routine tutorials vs. product launches vs. UGC)
Which posting times drive highest engagement
Which content drives website traffic vs. saves vs. shares
Which content actually generates purchases
No Revenue Attribution: Social media was treated as a “brand awareness” cost center because nobody could connect social activity to sales. The CEO questioned the ROI of a 3-person social team regularly. In reality, social was likely driving significant revenue — but without attribution, it was invisible and indefensible.
Competitor Blindness: PureGlow had no systematic process for tracking competitor social performance. They had no idea if their engagement rates were industry-leading or lagging, if competitors were growing faster, or what content strategies were working for similar brands.
No Growth Trajectory Tracking: Follower count was checked casually once a month. There was no tracking of growth rate, growth velocity, follower quality, audience demographics shifts, unfollower patterns, or growth by source (organic vs. paid vs. viral).
Manual, Incomplete Reporting: The monthly social media “report” was a Google Doc with screenshots of follower counts and top-liked posts. It took 4 hours to compile, contained no actionable insights, and was delivered 2 weeks after month-end.
Our Approach & Strategy
Phase 1: Social Media Audit & KPI Framework (Week 1)
Content Type Performance Analysis (Instagram Deep-Dive):
Content Type
Volume (12 months)
Avg Engagement Rate
Avg Saves
Avg Shares
Avg Website Clicks
Revenue Attributed
Static Product Photos
380 posts
1.2%
18
4
8
Unknown
Carousel (Educational)
82 posts
3.8%
86
32
28
Unknown
Reels (Tutorial)
64 videos
4.6%
124
68
42
Unknown
Reels (Trending Audio)
48 videos
5.2%
42
94
12
Unknown
Stories
420+
2.1% (reply rate)
N/A
N/A
34 avg/day
Unknown
UGC Reposts
34 posts
3.2%
44
28
22
Unknown
Product Launch Posts
28 posts
2.4%
36
18
64
Unknown
Key Finding: Educational carousels and tutorial Reels dramatically outperformed static product photos (3-4× engagement) — yet 49% of content was static product shots. The team was overproducing their worst-performing format.
KPI Framework (Metrics That Actually Matter):
KPI Category
Metrics
Why It Matters
Growth
Follower growth rate (%), net new followers/week, growth velocity trend, follower quality score
Are we growing, and is growth accelerating or decelerating?
Videos — views, engagement, FYP reach, profile visits, link clicks
API → Looker Studio
Facebook
Sprout Social + Meta Business Suite
Posts — reach, engagement, clicks, video views
API → Looker Studio
YouTube
YouTube Studio API + Sprout Social
Videos — views, watch time, CTR, subscribers gained, traffic sources
API → Looker Studio
Pinterest
Pinterest Analytics API + Sprout Social
Pins — impressions, saves, clicks, closeups
API → Looker Studio
All Platforms → Website
GA4 + UTM tracking
Social referral traffic, behavior flow, conversions
GA4 → Looker Studio
Website → Revenue
Shopify + GA4
Purchase attribution from social referral
Shopify → GA4 → Looker Studio
UTM Tracking System (Every Link Tagged):
textUTM STRUCTURE FOR SOCIAL MEDIA
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
LINK IN BIO:
?utm_source=instagram&utm_medium=social&utm_campaign=link-in-bio&utm_content=main-bio-link
STORY LINK:
?utm_source=instagram&utm_medium=social&utm_campaign=story-swipeup&utm_content=[post-topic]-2026
REEL CTA:
?utm_source=instagram&utm_medium=social&utm_campaign=reel-cta&utm_content=[reel-topic]-2026
TIKTOK BIO:
?utm_source=tiktok&utm_medium=social&utm_campaign=link-in-bio&utm_content=main-bio-link
PINTEREST PIN:
?utm_source=pinterest&utm_medium=social&utm_campaign=pin&utm_content=[pin-title]-[board]
FACEBOOK POST:
?utm_source=facebook&utm_medium=social&utm_campaign=organic-post&utm_content=[topic]-2026
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
[/protected]
Built a UTM generator tool in Google Sheets — social team selects platform, campaign type, and content topic from dropdowns → auto-generates tagged URL. No more guessing or inconsistent tracking.
Social-to-Revenue Attribution Model:
textREVENUE ATTRIBUTION FLOW
━━━━━━━━━━━━━━━━━━━━━━━━
LEVEL 1: DIRECT ATTRIBUTION (Last-Click)
→ User clicks UTM-tagged link in social → lands on Shopify
→ Purchases within session → Revenue credited to that social post
→ Tracked in: GA4 + Shopify attribution
LEVEL 2: ASSISTED ATTRIBUTION (Multi-Touch)
→ User sees Instagram Reel (Day 1) → Visits website from
bio link (Day 3) → Returns via Google search (Day 6)
→ Purchases
→ Social credited as "assisted conversion" with weighted attribution
→ Tracked in: GA4 multi-channel funnel report
LEVEL 3: INFLUENCED ATTRIBUTION (View-Through)
→ Correlate social posting activity with overall revenue trends
→ Did revenue spike when certain content went live?
→ Weekly correlation analysis: social engagement ↔ revenue
→ Tracked in: Custom Looker Studio correlation widget
RESULT: Three levels of attribution showing social's FULL
revenue impact — not just last-click (which undervalues social)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Competitor Tracking System (Rival IQ + Brandwatch):
Identified 6 direct competitors to track continuously:
Competitor
Instagram
TikTok
Why Track
Competitor A (Market Leader)
186K
94K
Content strategy benchmark, aspiration target
Competitor B (Direct Rival)
52K
28K
Closest competitor, market share battle
Competitor C (Fast Grower)
34K
68K
TikTok-first strategy worth studying
Competitor D (Premium Brand)
42K
12K
Brand positioning reference
Competitor E (Indie Darling)
28K
44K
Community-building approach to learn from
Competitor F (International)
120K
56K
Global best practices to adapt locally
Competitive Benchmarking Dashboard:
Metric
PureGlow
Industry Avg
Top Competitor
Gap
IG Engagement Rate
1.8%
3.5%
5.2%
-3.4% (major gap)
IG Growth Rate/Month
+1.2%
+2.8%
+4.6%
-3.4% (falling behind)
TikTok Avg Views
4,200
12,000
48,000
Need viral content strategy
Content Mix (Video %)
28%
55%
72%
Underweight on video
Posting Frequency (IG)
2.1/day
1.5/day
1.8/day
Posting MORE but performing LESS
Saves per Post (IG)
18 avg
45 avg
124 avg
Save-worthy content deficit
UGC as % of Content
4%
18%
32%
Massive UGC opportunity
Key Insight: PureGlow was posting MORE frequently than competitors but getting LESS engagement — indicating a quality problem, not a quantity problem. The data showed they should post 30% less but make each piece significantly more valuable.
Content Intelligence Framework:
Built an Airtable Content Performance Database tracking every post across all platforms:
Challenge: PureGlow Skincare was active on 5 social platforms, publishing 140+ posts monthly, but tracking only vanity metrics (likes and followers) in a manual spreadsheet. No revenue attribution, no content performance scoring, no competitor benchmarking, no unified dashboard, and no way to answer “is social media actually making us money?” The team overproduced low-performing static product photos while underinvesting in high-engagement formats.
Solution: We built a complete social media analytics ecosystem — unified 5-platform tracking via Sprout Social, a value-based KPI framework replacing vanity metrics, a 100-point content performance scoring system, 3-level revenue attribution connecting social to Shopify sales, continuous competitor benchmarking against 6 brands, 4 real-time Looker Studio dashboards, automated reporting, intelligent alerts, and monthly AI strategy briefings.
Result: Social-attributed revenue grew 182% ($8,200 to $23,100/month) while actually publishing 32% fewer posts (quality over quantity). Instagram engagement rate jumped from 1.8% to 4.1%. Content production shifted to data-proven formats. Pinterest revealed as highest revenue-per-follower platform ($0.34). Social ROI proven at 4.2× return. Every strategic decision now backed by data, not gut feeling.
Are You Measuring Social Media Success by Likes — or by Revenue?
We build social media analytics systems that go beyond vanity metrics — tracking what actually matters, connecting social activity to real revenue, benchmarking against competitors, and delivering actionable intelligence that transforms your social media from guesswork into a measurable growth engine.
