-
Goal:
-
Steps: This is the query
with
cte as (
select
date,
agency,
brand,
brand_enable,
ad_account_id,
ai_group,
ai_group_status,
ai_group_type,
platform,
sub_platform,
campaign_id,
story_enabled,
cast(total_spends_usd as decimal) as total_spends_usd
from
retool.spends
where
ai_group_id = 'Null'
)
select
round(SUM(total_spends_usd), 2) as total_spends
from
cte
-
Details:
-
Screenshots: