Revolutionizing Brand Safety with Contextual Analysis at Scale

Serves Publishers, DSPs, Agencies and Advertisers as a third-party content-level contextual analysis and brand safety solution​

Challenges​​

  • Current system unable to cope with growing data size (in TBs) and not extensible due to flat structure​
  • Insights could be generated for limited number of days and any extended period resulted in system timeouts​
  • Generating new insights was complex and time consuming​

Solution

  • Snowflake data warehousing enabled generating analytical insights at scale.
  • Transitioned from Athena to Snowflake, utilized Snowflake to deliver new MVPs, while migrating the rest in parallel.
  • Leveraged curated data tables to optimize time-to-market by ensuring data readiness.
  • Curtailed learning curve by reusing Apache Airflow to sync data between S3 and Snowflake.
  • Tech Stack:
    • Pipelines: Apache Spark, Apache Airflow, AWS (Athena,S3, Redis, ECS) 
    • Reporting: Google Looker, Docker
    • API: Python

IMPACT​ GENERATED​

  • 86% Boost New explore (Snowflake): < 8 seconds as compared to old explore
    (Athena Query): > 60 seconds​
  • Scalable ​Transitioning from Athena to Snowflake enabled generating insights for a larger date range that previously resulted in timeouts with Athena​
  • Extensible Curated tables enabling versatile usage across dimensions, supporting internal and customer-facing insights
  • Seamless transition Ensured seamless transition with minimal disruption to ongoing operations

Getting from a challenge to its solution starts with one click

Gain expertise from Zimetrics global network of experts and find practical solutions to your challenges.

To find out more about us, email
biz@zimetrics.com or complete the form below.