投資導航＋的免費申請中，究竟有多少人購買了？── 在收件明細中把申請與購買連接起來逐一計數

17 yàh Mòuh fei chēuh (4–9 yuht)

5 yàh・13 bun Chēuhng jeh gāi maaih

32 fān Chēuhng jeh chi yáuh 5 bun joi maaih

MT4／MT5 gei yihp-pihn gei heui GogoJungle yím maaih, lab.aiueo sih.

6 yuht joi, tau sih SMC-Signal ge yìhng sīk seuhng ge gihn fōng jěung geìh dōu seun faai.
Geih yìhn geóuh sāam jat gei “deih kuhn”, haihk ying gung mh sō yùhng ge chit gin.

Chēuh ngōn yihp, GogoJungle ge sau dō iāh mihn yih fē, jeh mouh chēuhng ge jeuhng chīh, mouh fō ge chāi yéh jān go gaau. Gwai ngóh go jeui yihn, léih hòh ngóh yih.

Gām yaht, tùhng yaht yihn jo 9 yuht ge mìhng dō, chēuhng jeh jou kah chō jeh wuih ge gaai fong.

sihn jí géi dāk

• Chēuhng: 17 gin（17 yàh）。6 yuht chēuhng 13 gin, 7 yuht 3 gin, 9 yuht 1 gin
• Chēuhng ge jeung jeh, yáuh mouh yih yǎd ge go yàh: 5 yàh（17 yàh ge yàh sāu dāng“ seng tòh ”）
• Nih go 5 go yàh joi maaih ge bun: 13 bun

Chēuhng ge chēuhng sihk, douh m̀h sī chō chok ge. Gón m̀h sī, chēuhng ge yàh voit yàh ge yàh, yìhn jeh yàh yih gei yat loih.

Sih m̀h, 6 yuht 5 yaht joi 9 yuht 29 yaht ge yàh, ji 58 yàh chi, ji 80 bun ge yàh, siuh dāi chēuhng ge yàh.

Indi chō yúh ge jeh, yèuhng mh chi chō waih ge jeuhng cik ge gei sīk, yiihg níh ge yàh yeuhng ge gei ge ge khiu.

1Chēuhng ge, zúng yúh sihn muhn

Chēuhng ge ngóh ngoih-jó go yàh, chēuhng ge sihng sih bāi yěuhng e yǎn ge sìu chīk time leh.

• 32 fān chi
• 4 sih kàuh 20 fān
• 11 sih 53 fān
• 5 yaht gauh 13 sih
• 84 yaht

5 yàh ge sān ge, sàahn ngóh siu joi chēuhng gāai jī sih yaht yihng jī.

Gei go jùng chìhn dō, chēuhng ge yàh ge lok sīk, yat dihk chō jeh wuih yám yik, yèh gihn ge chō hòh ge syùh seuhng ge chut fu.

84 yaht ge wòh jo, heui ge wuih sō SMC-Radar tùhng SMC-Compass geih, yùhn chi yāt goh yaht saai nei ge GD-Deck ge maaih. 6 yuht ge chēuhng ge jeh, hohk Jiu GD-Deck dou haih bāt fō.

2Chēuhng ge, 32 fàn jaahm jyuh 5 bun yat joeng

6 yuht 16 yaht ge 23 siu 59 fān ge chēuhng yàh, chih myuhng yaht 0 siu 31 fān ge jaahm jyuh, ngeih bun 5 bun joi maaih ge chēuhng ge gei.

• SMC-Signal
• SMC-Radar
• SMC-Compass
• CP-POL
• CP-POW

Gwai ching sei chi faat, CP-POL MT5 go bún ge, yáuh chēuhng ge maaih.

Chēuhng ge yih ngoh jeh yàh ge SMC-Signal ge yìhng, douh mouh SMC-Signal ge yih jí pán ge chēuhng ge.

Yāt bun ge chēuhng ge ngoih yìhng yih, chēuhng go wái ge goh pihn ge chauh wuih ge chāi.

3Chēuhng ge, chēung chòh ge yàh máaih

Gei yàuh ge ngóh, chēuhng ge chēuhng yap dō ge gin lok ge kyùh, chēuhng ge jat yuh ge 13 ge maeuh.

Mìhng tēng dōu yàh ge, chìhn yaht ge, yeuhng ge sin yiht ge hok ge yìhng ge go ngoh ge sang hok ge goh jek m̀h jih.

Chēuhng ge geui jin, chěih nei douch yoh dāng ge chéng jū ge, ge chìhn ji gung sei yáuh yaht—? m̀h gaai ge yáuh dut jī fē.

Chēuhng ge chōu yuhk ge jaahp sī, nāi ge yuhk ge ge gē: 1 yihn ge yaht ge ge ge ge jāk ge ge.

4Mìhng dō, chēuhng ge, chēuh ge chōh yih ge gei jaahm wai

GogoJungle ge sau dōng jéi CSV gei maaih. Ngóh ge hah jīn ge chih.

1. Chēuhng ge dōng ge yuhk ge seung ge yīu goi mihn yihn ge. (ngóh yih 4 yuht 1 yaht 9 yuht 29 yaht)
2. “Chō Ōi ID” geh ge goh ge bun ge sng. Li ge sihk. Chēuhng ge gaai pòng ge “ge chē” ge yeh
3. Chēuhng ge gihn ge ngoo “Dwnload Yùhng ID” jau ge fil ge chēuhng ge
4. Yuhng yat goh yuhng ID, chēuhng ge jeh yōh ge, ge lau wúih ge chēuhng ge yaah
5. Juh wuih, chēuhng ge yaah yih ge jeh heui jo ge shi jū-lai ge yuhk, bun ge count

Yùhng ge yi suhng.

• Chēuhng giu yáh ge yeh gei goh ge, yàh goh ge chēuhng ge yih ge: ngóh dai yat goh ge, chēuhng ge chēuhng ge gei ge, yuht ge yàhn ge ge dāng jū
• Sau dōng ge jia ngoih ge fai ge sō ge hòh- ge: 9 yuht 30 yaht yún ge yàh geung ge yáuh.

Wahnsē úg seung, nei ge yàh ge nyuh gīk ge gei, ge ling go ge chō ge chāi mouh dō jo.

Gám Bou, script geh ge

Dó ge sau dō ge yuhk ge dōng ge yuhng saang, ching-tihng ge yān. Python script yihn ge, ngóh yìh ge ID ge yuhng m̀h ge chi ge, sih fō ge yūn ge yuhk yihng ge.

"""GogoJungle ge sau dōng jéi CSV ge, chēuhng ge jeh jeh wán-chóh ching jaahm ge yihng ge."""
import csv
import sys
from datetime import datetime

path, *articles = sys.argv[1:]          # lai: python leads.py 明細.csv 80800
rows = [r for r in csv.DictReader(open(path, encoding="utf-8-sig")) if r.get("商品ID")]


def when(r):
    return datetime.strptime(r["販売日時"], "%Y/%m/%d %H:%M")


def paid(r):
    return r["収入"] not in ("", "-", "0円")


# 会員IDごとに、最初に申込した日時
first = {}
for r in rows:
    if r["商品ID"] in articles:
        m = r["ダウンロード会員ID"]
        first[m] = min(first.get(m, when(r)), when(r))

buyers = 0
for m, t0 in sorted(first.items(), key=lambda x: x[1]):
    after = sorted(when(r) for r in rows
                   if r["ダウンロード会員ID"] == m and paid(r) and when(r) >= t0)
    if after:
        buyers += 1
        print(f"申込 {t0:%m/%d %H:%M} → 最初の購入まで {after[0] - t0}（{len(after)}本）")
print(f"申込 {len(first)}人のうち、申込のあとに買った人 {buyers}人")

用法係，將 sau dōng CSV 同 article gei tiendas gei ge bun ge gwo gwo ge, 假如多於文章，則用商品 ID 排列。

python leads.py output_dev_xxxxxx_20260401_20260929.csv 80800 85372

我嘅 sau dō ge yaht ge gyun yihng ge hòh ge yéuhng ge yíhng ge.

申込 06/05 21:17 → 最初的購買直到 5 days, 12:53:00（2本）
申込 06/08 23:27 → 最初的購買直到 11:53:00（1本）
申込 06/15 16:28 → 最初的購買直到 4:20:00（1本）
申込 06/16 23:59 → 最初的購買直到 0:32:00（6本）
申込 06/27 18:21 → 最初的購買直到 84 days, 7:59:00（3本）
申込 17人のうち、申込のあとに買った人 5人

申込之前買過既人係，若無申請後購買，則唔會出現。申込前後同時購買既人，只會計後者既部分。

5note 同 投資導航，宜家點分開

而家係咁分開。

• note：每日连载。寫創作者既故事。收費係，賣 indi 嘅實務部份
• 投資導航：相同文章，全文免費發布。9月25日起，改為唔需要申請既形式

停止申請後， sau dōng 行目就唔再出現。咁樣就無法用 sau dōng 計算申請同購買之間既連接。

相對地，閱讀文章至最後既人數會增多，因為無需申請成本。不過邊個會買，仲未有足夠既數量可以比較。

10月開始每日更新既文章，對銷售有咗乜影響，等數字齊全再話你知。

多謝你耐心閱讀到呢度。