在 Pinterest 实现更快的分析

Introduction

介绍

Pinterest is a visual discovery platform where people can find ideas like recipes, home and style inspiration, and much more. The platform offers its partners shopping capabilities as well as a significant advertising opportunity with 500+ million monthly active users. Advertisers can purchase ads directly on Pinterest or through partnerships with advertising agencies. Due to our huge scale, advertisers get an opportunity to learn about their Pins and their interaction with Pinterest users from the analytical data. This gives advertisers an opportunity to make decisions which will allow their ads to perform better on our platform.

Pinterest是一个视觉发现平台，人们可以在上面找到诸如食谱、家居和时尚灵感等各种创意。该平台为合作伙伴提供购物功能，并为每月活跃用户超过5亿的广告机会。广告商可以直接在Pinterest上购买广告，也可以通过与广告代理机构的合作伙伴关系购买。由于我们的规模庞大，广告商有机会通过分析数据了解他们的Pin以及与Pinterest用户的互动情况。这使广告商有机会做出决策，从而使他们的广告在我们的平台上表现更好。

At Pinterest, real-time insights play a critical role in empowering our advertisers and team members to make data-driven decisions. These decisions impact campaign performance, our experiments’ performance, and our policies such as rules to catch spam. We have been using Druid to store and provide these real-time insights, but as our scale and requirements continue to change, we have been evaluating different storage options. In the end we decided to migrate this data to StarRocks.

在Pinterest，实时洞察在赋予我们的广告商和团队成员进行数据驱动决策方面起着至关重要的作用。这些决策会影响广告活动的表现、我们实验的表现以及我们的策略，如用于捕捉垃圾邮件的规则。我们一直在使用Druid来存储和提供这些实时洞察，但随着我们的规模和需求不断变化，我们一直在评估不同的存储选项。最终，我们决定将这些数据迁移到StarRocks。

In this blog post, we’ll discuss and share our experience of launching our Analytics app on StarRocks. In the past, we have published our thoughts on using Druid and the benefits we have gotten from it. This post highlights ...