tags: cofacts, meeting note GA: UA-98468513-3 —

20230426 會議記錄

:::info

:potable_water: Release pipeline

:star: Released to production

:globe_with_meridians: Site

:rocket: Staging

:robot_face: rumors-line-bot

Testing checklist

https://lin.ee/1QUzEX4nI

⛔️ Release Blockers
未竟項目

:eye: Under review

https://github.com/cofacts/rumors-line-bot/pull/346

CCPRIP

[Comm] Crowd-source transcript

https://g0v.hackmd.io/@cofacts/rd/%2FOhGIQzoxR5eF6audQuS_FQ [name=nonumpa]

整理 code 先發 PR,UI 可以之後再慢慢改

[Document] 開發時用到登入相關的東西 https://github.com/cofacts/rumors-site/issues/242

[Comm] AI transcript

https://g0v.hackmd.io/@cofacts/rd/%2Fwkx286lmTDaFUpgRhnUawQ

[Comm] Article group / co-occurrence

LINE bot tech detail: input batching https://g0v.hackmd.io/f_Ze19PhQuqx_fzOAOkohQ#Technical-detail

GA4 <> UA

承 3/1 時的比較 https://g0v.hackmd.io/zVyuEX5RS5uONLnucsxiYA#GA4-ltgt-UA-%E5%B7%AE%E7%95%B0

LIFF

Both UA (ViewArticle events) and GA4 (view_item events) have exactly the same trigger.

以下以 article 2q2xw134jyblq 為例。

UA:

https://lookerstudio.google.com/u/0/reporting/18J8jZYumsoaCPBk9bdRd97GKvi_W5v-r/page/p_44cex908mc?params=%7B%22df320%22:%22include%25EE%2580%25800%25EE%2580%2580IN%25EE%2580%25802q2xw134jyblq%22%7D

SQL:

SELECT event_date, count(distinct user_id) as user_count, count(*) as event_count
FROM `<table>.events_*`, UNNEST(items) as items
WHERE stream_id = '<LIFF stream ID>' AND event_name = 'view_item' AND items.item_id='2q2xw134jyblq'
GROUP BY event_date
ORDER BY event_date ASC

Result: https://docs.google.com/spreadsheets/d/18jX_N5shuJHibWHJlH9YXfB9Mo-th8d7SdZVFbIQpBI/edit#gid=741917313

Website

以下以 article 11kmpkou7le3c 為例。

UA uses “page path level 2” of the pageview event to represent article ID.

GA uses dataLoaded event in detail pages instead, which is fired from React.JS code.

UA:

https://lookerstudio.google.com/u/0/reporting/18J8jZYumsoaCPBk9bdRd97GKvi_W5v-r/page/orBY?params=%7B%22df239%22:%22include%25EE%2580%25800%25EE%2580%2580IN%25EE%2580%2580%252F11kmpkou7le3c%22%7D

SQL:

SELECT event_date, count(distinct user_id) as user_count, count(*) as event_count
FROM `<table>.events_*`, UNNEST(items) as items
WHERE stream_id = '<LIFF stream ID>' AND event_name = 'view_item' AND items.item_id='11kmpkou7le3c'
GROUP BY event_date
ORDER BY event_date ASC

Result: https://docs.google.com/spreadsheets/d/18jX_N5shuJHibWHJlH9YXfB9Mo-th8d7SdZVFbIQpBI/edit#gid=741917313

TODO

https://g0v.hackmd.io/cJFFXVzgT4OFT6bBLtulGg#-rumors-line-bot