WITH
funnelTrack_RawEvents AS (
    SELECT
        dt AS EventDate,
        uid,
        MAX(action = 'feed_opened_full') AS geo_widget_added,
        MAX(action = 'geo_widget_clicked') AS geo_widget_clicked
    FROM
        stat.funnelTrack
    --    JOIN exp_users USING(uid)
    WHERE dt >= '2024-08-10'
  AND appVersion >= 2007831
  AND region in ('global', 'ru')
  AND (deviceType = 1 AND appVersion % 2 = 1)
        AND dt < today()
        AND action IN ('feed_opened_full', 'geo_widget_clicked')
    GROUP BY
        EventDate, uid
),
users AS (
    SELECT
        uid,
        min(EventDate) AS EventDate
    FROM
        funnelTrack_RawEvents
    WHERE
        geo_widget_added = 1
    GROUP BY
        uid
)
SELECT
    dateDiff('day', e1.EventDate, cm.EventDate) AS day_,
    -- uniqExact(e1.uid) AS users,
    sum(cm.geo_widget_clicked) AS clicked,
    ROUND(sum((cm.geo_widget_clicked AND cm1.geo_widget_clicked) ? 1 : 0) / clicked, 2)  AS RT_widget_clicked,
    sum(cm.geo_widget_added) AS added
FROM
    funnelTrack_RawEvents cm
LEFT JOIN
    funnelTrack_RawEvents cm1
    ON cm.uid = cm1.uid AND cm.EventDate = cm1.EventDate + INTERVAL 1 DAY
JOIN
    users e1 ON cm.uid = e1.uid
WHERE
    e1.EventDate <= cm.EventDate
GROUP BY
    1
ORDER BY
    day_
LIMIT 90;