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.
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.
