American Student Assistance Aggregates Social Media Campaign Results through Fivetran and Snowflake

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

Analytic Insights

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.

Get the Details

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.