American Student Assistance Aggregates Social Media Campaign Results through Fivetran and Snowflake
Archetype implements Fivetran and Snowflake to automate American Student Assistance’s Social Media Campaign Results
American Student Assistance is a nonprofit organization that helps kids discover their educational and career opportunities. They were looking to automate the time spent evaluating social media campaign results across multiple channels.
Approach
1
Research
Archetype spent the time to assess the existing pre-built connectors and accurately scope out the level of effort to stage each connector.
2
Talk it out
Archetype held multiple discovery and requirements sessions to capture the metrics and reporting requirements and later facilitated dashboard design sessions that provided layout options.
3
Execute
Archetype created a work plan that allowed multiple new sources to be staged, validated, and ready for reporting. The work plan included a combined emphasis on client resources, helping to publish the final dashboard which gives ownership and knowledge into the deliverable.
Problem
American Student Assistance was spending excess time and resources manually downloading, compiling, and evaluating data in excel from each of their social media platforms including, Snapchat, TikTok, Facebook, Instagram, Google Analytics, and Google Ads. ASA was looking to assess the data across all platforms more quickly and efficiently.
Solution
Archetype facilitated dashboard design sessions, and ultimately executed an integration using Fivetran into the Snowflake data warehouse. This solution combined the marketing metrics related to social media campaign spend and utilization.
Result
American Student Assistance was able to automate data from all their social media channels, reducing their time spent downloading and combining data using manual steps. Their marketing team can now focus more on analyzing the social media campaign ROI (such as, clicks, impressions, and conversion rates) across multiple channels, as opposed to spending their time compiling data.
