Subscriber Churn Analytics Demo with dbt Snowpark Python models

Disclaimer: This code is experimental.

Please use dbt v1.3 and above.

PPT: https://docs.google.com/presentation/d/1IJSeE96bze7DECuDYqsTVv6FaOcNcJ5tTiCWKEku_QQ/edit#slide=id.g158d486fe9e_2_12

• What is the Problem We Are Addressing?

  • Over-the-top services or OTT is a category of media solutions that are in the form of apps that are distributed via mobile, tablet or TV (e.g., Netflix). The lines that traditionally separated players in the media segment are rapidly blurring. Streaming services (OTT most prominently), TV companies, and social networks are now competing over the same audiences. Radio stations, podcast companies, and streaming services are competing to provide radio and podcast content.
  • As consumers get overwhelmed by the number of options, they will look to purge their subscriptions. Increased competition means media companies have to focus on content, user experience and loyalty, to create a more direct and lasting relationship with consumers.

• What Does this Demo Aim to Solve?

  Based on customer subscription pattern, determine customer churn.

  This demo is aimed at building dbt python models with Snowflake.