<aside> 🍎 General, Elegant, Efficient —— Designed and Developed by Apple (Foster Guo)

Basically, it’s a framework designed to assist content teams in retrieving data independently, without relying on data analysts or engineers.

It’s an end-to-end solution for content teams seeking to analyze data daily, or even hourly, by leveraging their strong business knowledge and applying complex strategies—all without needing any technical expertise.

This article is mainly about two problems for that purpose:

1. Flexibility: How to make this platform as flexible as possible that users could leverage their imagination and business knowledge.
2. Performance: How to make this platform as efficient as possible that users could get the results and iterate their strategies quickly.

</aside>

Train of thought

<aside> 📌 Apple said, let there be a platform implements strategy recall, and there was strategy recall platform.

</aside>

Origin

Background

Content platforms like TikTok, Twitter, and Facebook often encounter several challenges:

• Find risk content behind complex connection between entities.
• Calculate the total number of specific content.
• Locate users who follow specific patterns.
• ···

Challenge Evolution

Consider the strategies from businesses go more and more complex and as a content mid platform you have to apply these strategies to all of the products.

1. TikTok’s post’s title, hit ‘word1’ ··· a word.
2. TikTok’s post’s title, hit ‘word1’, ‘word2’ ··· a simple word list.
3. TikTok’s post’s title, hit ‘word1&word2’, ‘word3～word4’ ··· a complex word list.
4. TikTok’s post’s title hit word list1 & post_time ≥ 2024-01-01 & post_city in (city1, city2, city3) ··· a filtered strategy.
5. TikTok’s post’s filtered_strategy1 & comment’s filtered_strategy2 ··· a strategy.
6. TikTok’s post’s filtered_strategy1 & comment’s filtered_strategy2 & reply’s filtered_strategy3 ··· a more complex strategy.