Hi <@U02KBGF0S05> I can think of following option...
# thirdeye-pinot
m
Hi @Sanjay Aswani I can think of following option: 1. Pre-calculate Top Campaigns: Use Pinot to create a dimension filtering the top 10 campaigns by CPC (e.g., scheduled job or materialized view). 2. ThirdEye Alert with Filter: Configure a ThirdEye alert to trigger only when the "Top 10 CPC Campaigns" dimension is active and the CPC drops/spikes by your threshold (using reference window for comparison). Another option not sure if it is supported in the community edition: You can modify the alert template and update the data fetcher to see if you can modify Pinot SQL to include top compaigns. https://dev.startree.ai/docs/get-started-with-thirdeye/alert-configuration#datafetcher