A content analytics dashboard built in Looker Studio, connected to Google Sheets, tracking views,...A content analytics dashboard built in Looker Studio, connected to Google Sheets, tracking views,...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Ohakam's avatar
Ohakam Bruno
• 19h
A content analytics dashboard built in Looker Studio, connected to Google Sheets, tracking views, engagement, and content-pillar performance at a glance for a short-form video brand.
The problem: raw platform analytics (TikTok, etc.) don't show performance broken down by content category — making it hard to see which content pillars are actually working without manually cross-referencing every post.
The build: at-a-glance scorecards for total views, total followers gained, and total engagement (likes + comments + shares), plus a breakdown of views by individual video and by content pillar (Rare Animals / Family Trees / Ancient History) — surfacing which content categories perform best.
Note: built using sample/demo data for demonstration purposes, not live account data. The dashboard structure, connections, and logic are fully functional and could be connected to real data at any time.
Result: a working, reusable reporting template — the kind of dashboard a content or marketing team would use to make decisions on what to produce more of.
Looker StudioMarketing AnalyticsGoogle Sheets
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started