Analytics playbook: 5,600 posts
Mariam Adebanjo published a Power BI dashboard analyzing 5,600 social posts across platforms to reveal regional content strategies, while Phil Kiel recommends sorting top ads by spend and CPMr to spot algorithmic biases—both give juniors concrete analytics approaches to replicate in portfolios. Screenshots of dashboards and annotated ad-sort experiments make strong evidence of data fluency. (x.com, x.com)
The GitHub repository titled Social_Media-Analysis-Dashboard includes image files named page1_platform_performance.png, page2.time_and_regional_analysis.png, page3.hashtag_and_content_strategy_insights.png and a downloadable social media analysis project.pdf. (github.com) Repository activity logs show multiple uploads and recent commits, with the project receiving pushes as recently as five days prior to the latest activity listing. (github.com) Phil Kiel has publicly advocated a CBO-first, content-centric testing framework and, in recent discussions, recommended launching roughly 8–10 distinct creative concepts per month (approximately 40–50 assets) to feed algorithmic allocation. (scalabilityschool.com) Competitive ad-intelligence platforms that let analysts sort ads by spend operate at scale—top-ads.io advertises filtering across a database of about 2.5 million ads—while Chrome extensions can sort Meta’s Ad Library by reach and surface estimated spend and reach figures. (top-ads.io) Industry commentary and agency playbooks have elevated CPMr (cost per mille reach) as a creative-efficiency KPI, with Ambaum describing CPMr as “the new ROAS” and PaidMediaWorld advising CPMr monitoring to spot creative fatigue before ROAS declines. (ambaum.com) Together, the repository’s downloadable visuals and Phil Kiel’s recorded ad-testing frameworks (podcast and YouTube episodes) create reproducible artifacts and stepwise experiments that can be captured as portfolio entries showing data work and paid-social methodology. (github.com)
