IFOPA – Social Media Automation & Management

Overview

Built and automated a social media management system for the International FOP Association, streamlining content creation, scheduling, publishing, and analytics. By integrating Make and Airtable, I optimized workflows, enabling the organization to exceed its fundraising goals and deliver on a year-long social media strategy.

Challenges & Solutions

The IFOPA team faced inefficiencies in manually managing multiple social media platforms, leading to missed engagement and fundraising opportunities.

I automated content creation, scheduling, and analytics using Make and Airtable, centralizing all social media operations. This increased efficiency and freed up the team to focus more on strategic, year-long campaigns.

Client

The International FOP Association (IFOPA), based out of Kansas City, Missouri, is a nonprofit dedicated to finding a cure for Fibrodysplasia Ossificans Progressiva (FOP), an ultra-rare bone disease.

Key Contributions

Developed and executed a comprehensive year-long social media strategy, coordinating key campaigns.

Built an automated system to manage social media content from creation to publishing.

Integrated social media platforms with Make and Airtable, centralizing analytics and performance tracking.

Delivered comprehensive reports with detailed performance analytics, optimizing social media strategies in real-time.

Helped exceed fundraising goals through optimized campaign execution.

Tools Used

Make – Automated social media workflows and content scheduling.

Airtable – Managed content creation, analytics, and campaign tracking in one streamlined system.

Google Drive – Collaborated using Sheets, Docs, and Slides for data analysis and content organization.

Premiere Pro – Edited video content for social media campaigns.

Additional tools used include Canva, Linktree, Photoshop, and Asana for design, link management, and team collaboration.

Main Features of the Social Media Tool

Team collaboration on content creation with tags and campaigns.

Automated scheduling and publishing across multiple platforms, including video posts from Google Drive.

Centralized tracking for all comments and analytics across social media.

Comprehensive People table to track individuals engaging with newsletters and posts, providing a full profile and activity history.

Unified dashboard for tracking post performance, email analytics, and link clicks.

Ad performance tracking with an algorithm that scores and evaluates campaign success.

Data visualization and reporting interfaces for real-time insights and analytics.

Impact

By automating social media processes, manual efforts were reduced, allowing the IFOPA team to focus on long-term campaign strategies. The streamlined system increased engagement and drove greater impact, ultimately surpassing fundraising goals.