We went from using 14 technologies to a stack of four powerhouses — AWS, Snowflake, Fivetran and MicroStrategy – all managed by a single person.
– Joseph Bates, Head of Analytics, ShareThrough
Download the full report to learn how Sharethrough revolutionized its data warehouse and data analytics by leveraging best-of-breed technologies from Snowflake and its valued partners MicroStrategy and FiveTran.
Sharethrough coordinates native ad placement between brand advertisers and publishers, serving more than three billion native ad impressions every month. Its analytics focus on how well websites perform, how content renders, and how to improve the viewing experience of its ads.
Sharethrough had outgrown the capacity of its data analytics environment, which was custom built using a MySQL product. With no semantic layer, poor performance, and a maxed-out row capacity, getting data for analysis was a complex and manual operation.
With Snowflake as its core data warehouse, Sharethrough pipes in raw website activity data directly without preprocessing. With the addition of Fivetran, Sharethrough easily loads data from four different sources into Snowflake data warehouse and in sync in less than two hours.
Sharethrough streamlined and simplified its analytics pipeline, while making the process more affordable, and making all data more accessible to business users. Queries parked to run over a weekend now take 30 seconds. Reports that ran in 45 minutes now take less than a second – all in an environment managed by a single staff member.
Sharethrough’s technology stack harnesses the power and flexibility of the Snowflake and Fivetran infrastructure while layering the sophisticated analytics of MicroStrategy on top to make complex data more accessible to business users. Sharethrough is considering making the entire solution available to all of its end users — 30,000 or more ad buyers in total.