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