Again thank you so much Eddie it's great learning a lot. I'll email you if I get stuck again, but this has been really helpful looking at the analytics. You're a wealth of information, sure appreciate it.

Case Study: Engineering a Global Social Media Ecosystem for Philip Kim From "Spreadsheet Stagnation" to a High-Velocity, Volunteer-Led Digital Engine Client Overview

https://youtu.be/bUqqy5Wj900?si=rGojzu_BKKch1wjl

Case Study: Social Media Strategy and Volunteer Team Coordination for Multi-Platform Nonprofit Organization

Content Planning and Analytics Consultation for International Nonprofit Managing Six Volunteer Administrators Across Eight Social Platforms Through Scheduling Strategy Comparison, Real-Time Analytics Interpretation, and Sustainable Content Frequency Framework

Client Overview

<aside> 📸

Project Snapshot

Client: Philip Kim

Organization: Community Arts Foundation (CAF) – an international nonprofit with significant volunteer network

Geographic Base: Los Angeles, California (with international audience reach)

Organizational Structure: Six volunteer administrators managing distinct social media accounts across multiple platforms

Current Platforms: TikTok, Instagram, Twitter, Blue Sky, Weibo, Red Book, YouTube, WeChat; plus website news and events section

Current Pain Point: Organization had developed a basic Excel spreadsheet tracking when content should post across platforms and which volunteers were responsible for each channel, but lacked strategic planning framework. Content was being created and posted reactively rather than being planned in advance, built up toward events, executed during events, and leveraged afterward. With numerous events happening continuously, the social media approach felt overwhelming and inefficient—each event received only single post rather than integrated multi-week campaign strategy.

Desired Outcome: Establish systematic approach to planning social media content two weeks in advance per event, build content calendars that span pre-event promotion through day-of coverage to post-event follow-up, create sustainable framework for coordinating six volunteer administrators across multiple platforms without requiring new software tools if possible, develop understanding of which content types and posting times actually drove engagement and reach for their specific audience

Current Resources: Google Workspace with Google Calendar, Google Chat, Google Drive, and Google Tasks already integrated across the organization; existing volunteer team familiar with these tools; open to exploring scheduling software but preferring solutions that integrate with existing infrastructure

Technical Knowledge: Nonprofit administrator with data literacy and analytical curiosity—comfortable examining Instagram insights and interpreting engagement patterns, but lacking frameworks for translating analytics into content strategy decisions

</aside>

<aside> ⚠️

The Challenge

</aside>

<aside>

The Challenge

Philip Kim initiated the consultation by positioning what appeared to be a software selection problem but was actually a strategic infrastructure problem. The organization had grown organically, developing multiple social media accounts across eight platforms as different volunteers brought their own platform preferences or as organizational priorities shifted. Rather than having a deliberate multi-channel strategy, they had accumulated channels—each one existing but none of them operating within a coherent framework that connected planning to execution to measurement.

The immediate friction was operational. The Excel spreadsheet tracked which volunteer managed which platform and when content should theoretically post, but the spreadsheet didn't actually drive the posting. Volunteers still needed manual coordination. The volunteer network, while generous with their time, couldn't be expected to maintain perfect synchronization without clear communication and advance warning. Meanwhile, events kept arriving—CAF apparently hosted them continuously—and each event received basic coverage rather than strategic amplification. There was no pre-event buzz building, no multi-post content sequence, no post-event momentum capture. Just posting when the event happened and moving on.

The software question emerged from this operational reality. Philip asked whether there was a scheduling tool that would improve their process, and mentioned they already used Google Workspace as their organizational infrastructure. This seemed like a simple tooling question, but it masked deeper uncertainty about what they actually needed. Did they need a sophisticated scheduler? Did they need to integrate scheduling with Google Calendar? Should they invest in learning new software, or could their existing Google tools be leveraged more effectively?

The analytical challenge was equally pressing. Philip had started examining Instagram insights, discovering patterns that surprised him but didn't yet translate into decision-making. The data showed their audience engaged most heavily at 6 a.m. to 9 a.m. Pacific time (with Sunday morning being the peak slot), with shocking concentration in a specific timezone pattern suggesting either international audience or significant East Coast USA reach. More striking was the engagement distribution: reels generated dramatically more engagement than stories or traditional posts, yet when looking at the account visually, stories appeared more prominent. The insights contradicted intuition, which meant the analytics weren't yet informing strategy—they were just creating confusion.

Beyond the operational and analytical layers lay the frequency question. How often should they post? The volunteer team had limited bandwidth. Posting more frequently meant asking volunteers to commit more time. But less frequent posting meant missing opportunity to reach an international audience operating across multiple time zones. How did they determine the right frequency given their content creation capacity?

</aside>

<aside> 💡

The Solution

</aside>