Hi!
We're looking to build a beastmode that meets two requirements to then print a result. For example if a video generated more than $1K in total revenue and more than $100 during month-12, then "repost". See current beastmode below:
Background: The dataset tracks the lifespan of revenue per video title, in a 12-month period. Revenue is trended where if we posted a video in May 2022 and we're able to track how much that video generated the first month, including day 1 through day 30, the second month would include revenue from day 31 through day 60, etc.
Current beastmode:
CASE
WHEN
(MONTH(date
) = MONTH(NOW()) AND YEAR(date
) = YEAR(NOW()) AND sum(revenue
) = 0) THEN 'Repost'
WHEN
(MONTH(date
) = MONTH(NOW()) AND YEAR(date
) = YEAR(NOW()) AND sum( revenue
) < 100) THEN 'Takedown or Repost'
WHEN
(MONTH(date
) = MONTH(NOW()) AND YEAR(date
) = YEAR(NOW()) AND sum(revenue
) < 100 AND sum(revenue
) <1000) THEN 'Takedown'
ELSE 'Other'
END
Thank you!