NN
Size: a a a
NN
AK
NN
NN
AK
NN
СБ
ВТ
ВЛ
ВЛ
sessionId, source
max(case when h.eventInfo.eventAction='lead_add' and h.eventInfo.eventCategory='AMOCRM' then 1 else 0 end) as orders
from table
cross join unnest(hits) as h
group by sessionId, source
DZ
sessionId, source
max(case when h.eventInfo.eventAction='lead_add' and h.eventInfo.eventCategory='AMOCRM' then 1 else 0 end) as orders
from table
cross join unnest(hits) as h
group by sessionId, source
ВЛ
ВЛ
NG
x
MC
Д
SK