gitirx

with clean_ads as (
  select 
    *,
    row_number() over (partition by ad_id, date order by timestamp desc) as row_id
  from `neksu-496015.homework.marketing_data_session`
),

monthly_metrics as (
  select 
    date_trunc(date, month) as campaign_month,

gitirx

with clean_ads as (
  select 
    *,
    row_number() over (partition by ad_id, date order by timestamp desc) as row_id
  from `neksu-496015.homework.marketing_data_session`
),

max_metrics as (
  select 
    source,