select
  date(from_iso8601_timestamp(dt)) as t,
  count(*)
from mobilewebuiactionstracking
where event.action='click'
and event.name='talkpage.readAsWiki'
group by 1
order by 1

select
  date(from_iso8601_timestamp(dt)) as t,
  count(distinct event.token)
from mobilewebuiactionstracking
where event.action='click'
and event.name='talkpage.readAsWiki'
group by 1
order by 1

select
  if(n>1, '2+ interactions', '1 interaction') as "Interactions",
  count(*) as "Users"
from (
select
  event.token as token,
  count(*) as n
from mobilewebuiactionstracking
where event.action='click'
and event.name='talkpage.readAsWiki'
group by 1
order by 1
) x
group by 1
order by 1

select count(*) as "Talk page visits"
from mobilewebuiactionstracking m1
where event.action='init' and event.name='ns=1'
and (year,month,day) >= (2023,2,1)
and (year,month,day) <= (2023,2,14)

select count(*) as "Taps to expand/collapse a topic"
from mobilewebuiactionstracking m1
where m1.event.action='click' and m1.event.name='talkpage.section'
and (year,month,day) >= (2023,2,1)
and (year,month,day) <= (2023,2,14)
and exists(
  select 1
  from mobilewebuiactionstracking m2
  where m2.event.action='init' and m2.event.name='ns=1'
  and m2.event.pageToken = m1.event.pageToken
  and m2.year = m1.year
  and m2.month = m1.month
  and m2.day = m1.day
)

select count(*) as "Taps to add a new topic"
from mobilewebuiactionstracking m1
where m1.event.action='click' and m1.event.name='talkpage.add-topic'
and (year,month,day) >= (2023,2,1)
and (year,month,day) <= (2023,2,14)
and exists(
  select 1
  from mobilewebuiactionstracking m2
  where m2.event.action='init' and m2.event.name='ns=1'
  and m2.event.pageToken = m1.event.pageToken
  and m2.year = m1.year
  and m2.month = m1.month
  and m2.day = m1.day
)

select count(*) as "Taps to read as wiki page"
from mobilewebuiactionstracking m1
where m1.event.action='click' and m1.event.name='talkpage.readAsWiki'
and (year,month,day) >= (2023,2,1)
and (year,month,day) <= (2023,2,14)
and exists(
  select 1
  from mobilewebuiactionstracking m2
  where m2.event.action='init' and m2.event.name='ns=1'
  and m2.event.pageToken = m1.event.pageToken
  and m2.year = m1.year
  and m2.month = m1.month
  and m2.day = m1.day
)
)