SW Manager 功能說明SW Manager features
Google Offline Conversions:把轉換回傳給 Google AdsGoogle Offline Conversions: sending conversions back to Google Ads
每天早上把轉換整理成 Google 的 offline conversion 格式,寫進一份 Google Sheet,Google Ads 再從 Sheet 讀進去。Every morning the day's conversions are written into a Google Sheet in Google's offline-conversion format, and Google Ads reads them from there.
為什麼要回傳給 Google:大部分廣告點擊不會在網頁上直接成交,真正有價值的是之後的通話。把這些通話(用 GCLID 對應到原本的點擊)回傳給 Google,Google 就能往會帶來真實 lead 的點擊去最佳化,而不只是看表單填寫。Why send them back: most ad clicks never close on the website — the value shows up later, in a call. Sending those calls back (matched to the original click by GCLID) lets Google optimise toward clicks that produce real leads, rather than toward form fills.
三個分頁Three tabs
- Overview —— 目前的設定和每天的檔案。Overview — the live configuration and the daily files.
- GCLID coverage —— 新進的 contact 有沒有帶 click ID。GCLID coverage — whether new contacts arrive with a click ID.
- Settings —— 修改設定(三個步驟)。Settings — change the configuration (three steps).
還沒設定過的帳號只會看到設定精靈,不會有三個分頁。帳號沒有任何 conversion 時,會顯示「沒有可以匯出的 conversion」。An account that has never been configured sees only the setup wizard, not the three tabs. With no conversions defined at all it says there is nothing to export.
Overview — 目前生效的設定Overview — the live configuration
| 項目Field | 意思Meaning |
|---|---|
| 狀態標籤Status tag | Active — generating daily / Inactive(關掉了,或沒有勾選 conversion)/ Not connected(Sheet 還沒連好)。Active — generating daily / Inactive (switched off, or nothing selected) / Not connected (no sheet linked yet). |
| Committed | 第一次存檔的日期,之後再改設定也不會變。The date of the first save; later edits do not move it. |
| Conversions sent | 勾選了幾個 conversion。How many conversions are selected. |
| Rolling window | 往回 N 天(1–90),包含今天,而且是累積的 —— 每次都送整段時間的資料。N days back (1–90), including today, and cumulative — every file carries the whole span. |
| Runs | 每天 06:00 太平洋時間自動跑。每個帳號會再隨機延後 0–30 分鐘。如果到 07:30 還沒開始,那天的排程就跳過。Daily at 06:00 Pacific, plus a random 0–30 minute offset per account. If it has not started by 07:30, that day is skipped. |
Edit configuration 會跳到 Settings 第 1 步。Edit configuration jumps to Settings step 1.
Publish nowPublish now
立刻產生一份新檔案,並整份覆蓋 Sheet。沒有確認視窗 —— 按下去之後每 3 秒檢查一次,最多等 120 秒,結果顯示在按鈕旁邊。沒有次數限制,但同一個帳號同時只能跑一個,撞到的話會標成 Skipped。沒有連結 Sheet 時會出錯:「no connected Google Sheet」。Generates a file immediately and overwrites the whole sheet. No confirmation — it then polls every 3 seconds for up to 120 seconds and reports beside the button. There is no rate limit, but only one run per account at a time; a clash is marked Skipped. With no sheet linked it errors with "no connected Google Sheet".
只有開了 flag 的環境看得到這個按鈕(staging、CL1),正式環境不會出現。The button only exists where the flag is on (staging, CL1); it is absent in production.
Daily files — 每日檔案Daily files
每天跑一次留一筆紀錄,同一天跑了不只一次的可以展開來看。One row per run; days with more than one run expand.
| Status | 意思Meaning |
|---|---|
| Delivered | 成功寫進 Sheet。Written to the sheet successfully. |
| Written, not verified | 寫進去了,但回頭檢查沒有通過。Written, but the read-back check did not pass. |
| Failed | 失敗,滑過去可以看原因,例如 CLP 沒有寫入權限。Failed; hover for the reason, e.g. CLP cannot write to the sheet. |
| Skipped | 跳過 —— 沒有勾選 conversion、算出來沒資料、太晚開始、或撞到另一個正在跑的。算出來是空的時候不會覆蓋 Sheet。Skipped — nothing selected, nothing to send, started too late, or another run was in flight. An empty result never overwrites the sheet. |
| In progress | 正在跑。Running. |
Latest 標在最新一筆成功送達的檔案上,不一定是最上面那一列。
With GCLID % = 放進檔案的列數 ÷(放進去的 + 沒有 contact 的 + 沒有 click ID 的),算的是整個時間範圍,不是最近 24 小時。
Download 下載 CSV,檔案保留 90 天,過期後顯示 Expired。Latest marks the most recent successful delivery, which is not necessarily the top row.
With GCLID % = rows included ÷ (included + no contact + no click ID), computed over the whole window, not the last 24 hours.
Download fetches the CSV; files are kept 90 days and then show Expired.
File format — 固定 8 個欄位File format — eight fixed columns
第一列會自動寫入欄位名稱。The header row is written automatically.
- Google Click ID / GBRAID / WBRAID —— 只會填其中一個,優先順序 GCLID → GBRAID → WBRAID,從 contact 的
custom.gclid / gbraid / wbraid讀取。Google Click ID / GBRAID / WBRAID — only one is filled, in that order of preference, read from the contact'scustom.gclid / gbraid / wbraid. - Conversion Name
- Phone —— E.164 格式(+1…)。Ava 的號碼如果不是美加格式,這欄會是空的。Phone — E.164 (+1…). If an Ava number is not US/Canada shaped, this is left blank.
- Conversion Time —— 格式像
2026-08-13 14:05:00-07:00。Conversion Time — e.g.2026-08-13 14:05:00-07:00. - Conversion Value —— 整數。Conversion Value — a whole number.
- Conversion Currency —— USD。金額空白的話,這欄也是空白。Conversion Currency — USD; blank when the value is blank.
沒有 click ID 或沒有 contact 的轉換,不會放進檔案。這就是為什麼要盯 GCLID coverage。Conversions with no click ID, or no contact, are left out of the file. That is why GCLID coverage is monitored.
Sheet 的兩種權限The sheet needs two kinds of access
要兩個條件都成立,Google 才拿得到資料:Google only receives data when both hold:
- CLP write —— 系統用 service account 寫入 Sheet,需要編輯權限。如果權限被拿掉、Sheet 被刪、找不到 Conversions 分頁,排程那次會失敗,連線會被標成 error。CLP 沒有寫入權限就不能繼續,按鈕停用時滑過去會看到原因。CLP write — the system writes via a service account and needs Editor access. If that is revoked, the sheet is deleted, or the Conversions tab is missing, the scheduled run fails and the connection is flagged as an error. Without write access you cannot continue; hover the disabled button for the reason.
- Google read —— 使用者要把 Sheet 用 Viewer 權限分享給 Google Ads 提供的
…@partnercontent.gserviceaccount.com(在 Google Ads 的 Uploads 畫面找得到),然後自己勾確認。Google read — you share the sheet as Viewer with the…@partnercontent.gserviceaccount.comaddress Google Ads gives you (on its Uploads screen), then tick to confirm yourself.
系統沒有去 Google 檢查,只會記下誰在什麼時候確認的,Undo 可以取消。而且沒確認也可以繼續 —— 所以這一項做了沒做,畫面上看不出真假。The system never checks with Google; it only records who confirmed and when, and Undo clears it. And you can continue without confirming — so the screen cannot tell you whether this was really done.
GCLID coverageGCLID coverage
檢查最近 24 小時新進的 contact 有沒有帶 click ID。狀態完全由後端計算,前端只負責顯示。這個表格只是標示,不會發任何通知。Checks whether contacts created in the last 24 hours carry a click ID. The status is computed entirely in the backend; the front end only displays it. The table is indicative only and sends no notifications.
怎樣算有覆蓋:contact 的 custom.gclid、custom.gbraid、custom.wbraid 任一個是非空字串就算。What counts as covered: any of the contact's custom.gclid, custom.gbraid or custom.wbraid being a non-empty string.
放在最外層的 gclid 不算 —— 一定要在 custom 底下。A top-level gclid does not count — it must sit under custom.
什麼是「有足夠的歷史資料」:看 24 小時之前的 7 天,至少 50 個 contact 有 click ID,而且比例 ≥ 20%。"Enough history" means: in the 7 days before the last 24 hours, at least 50 contacts had a click ID, and the share was ≥ 20%.
判斷順序(由上往下,符合就停):Decision order (first match wins):
- 0 個新 contact → No new contactsNo new contacts at all → No new contacts
- 沒有足夠歷史資料,而且有 click ID 的比例 < 1% → Set up GCLID(代表客戶可能根本還沒開始送)Not enough history and under 1% carry a click ID → Set up GCLID (the customer may not be sending them at all)
- 有足夠歷史資料、新 contact ≥ 20、缺少比例 > 10% → Investigate(紅)Enough history, ≥ 20 new contacts, and more than 10% missing → Investigate (red)
- 其他 → OK(綠),或是 Not enough dataOtherwise → OK (green), or Not enough data
邊界值例子(有足夠歷史資料時):20 個缺 2 個(10%)→ OK;20 個缺 3 個(15%)→ Investigate;19 個全缺 → Not enough data。剛好 10% 不算。Boundary examples (with enough history): 20 new, 2 missing (10%) → OK; 20 new, 3 missing (15%) → Investigate; 19 new, all missing → Not enough data. Exactly 10% does not trigger it.
表格欄位:New (24h) 是往回滾動 24 小時內新建立的 contact 數(已刪除的不算);With GCLID 是其中有 click ID 的數量;Missing 是沒有的數量;% missing = Missing ÷ New。Columns: New (24h) counts contacts created in the trailing 24 hours (deleted ones excluded); With GCLID is how many carry one; Missing is the rest; % missing = Missing ÷ New.
Set up GCLID 會開 API 文件的 gclid 段落(/doc/contacts-v2#gclid):要放在 custom.gclid、不送也不會出錯(contact 照樣會建立,只是不能回傳給 Google)、值要原封不動轉送不要截斷。Set up GCLID opens the gclid section of the API docs (/doc/contacts-v2#gclid): put it in custom.gclid; omitting it is not an error (the contact is still created, it just cannot be sent back to Google); pass the value through unchanged, never truncated.
Settings — 三個步驟Settings — three steps
What to send → Deliver → Review & commit。前一步的條件沒有滿足就不能按繼續。從 Overview 按 Edit configuration 進來,一律從第 1 步開始。存檔後從下一次早上的排程開始生效。What to send → Deliver → Review & commit. You cannot move on until the current step is satisfied. Entering via Edit configuration always starts at step 1. A save takes effect at the next morning's run.
第 1 步 — 選要送什麼Step 1 — what to send
第一次設定時,Primary 的 conversion 會預設被勾選。一個都沒勾就不能繼續,提示是「Include at least one conversion — an empty file would clear the sheet Google reads.」Created 和 Last seen 可以幫你分辨哪些 conversion 還在用、哪些已經沒在用。On first setup, primary conversions are pre-selected. You cannot continue with none ticked: "Include at least one conversion — an empty file would clear the sheet Google reads." Created and Last seen help you tell active conversions from stale ones.
這裡的 Last 7 days 用的是瀏覽器所在地的時區,跟 Define 頁(太平洋時間)可能對不起來。The Last 7 days here uses the browser's local time zone, so it can disagree with the Define page, which uses Pacific.
Rolling window:每份檔案往回放幾天的資料。1–90 的整數,預設 90,超出範圍顯示「Enter a whole number between 1 and 90 days.」是累積的 —— 每天的檔案都包含整段時間的資料,包含今天。Rolling window: how many days each file reaches back. A whole number 1–90, default 90; outside that it says "Enter a whole number between 1 and 90 days." It is cumulative — every file carries the whole span, including today.
第 2 步 — DeliverStep 2 — Deliver
CLP 會把每天的檔案寫進這份 Sheet 的「Conversions」分頁。第一次設定時用網址連結一份現有的 Sheet,也可以從範本建一份新的。Change 只是重新打開輸入網址的地方 —— 真的換成另一個網址之前,原本的連線和確認都會保留。換成另一份 Sheet 之後,Google read 的確認會被清掉。CLP writes each daily file into the sheet's "Conversions" tab. On first setup you link an existing sheet by URL, or create one from a template. Change merely reopens the URL field — the existing link and confirmation survive until you actually swap in a different URL. Swapping sheets clears the Google-read confirmation.
Re-check access 會立刻檢查一次:可以寫入就變成 Granted;沒有權限、找不到 Sheet、找不到分頁就變成 error。另外兩種送法(下載檔案、HTTPS)是 Coming soon。Re-check access tests immediately: writable becomes Granted; no permission, missing sheet or missing tab becomes an error. The other two delivery methods (downloadable file, HTTPS) are Coming soon.
第 3 步 — Review & commitStep 3 — Review & commit
預覽只顯示前 3 列。「≈ N rows」是估計的上限,實際列數可能比較少,因為沒有 click ID 的會被拿掉。估計超過 100,000 列會跳警告 —— 還是可以存檔,但之後每天的排程會被跳過。估計是 0 列時顯示「Nothing to send yet」。預覽載入失敗不影響存檔。The preview shows the first 3 rows only. "≈ N rows" is an upper estimate; the real count is usually lower because rows without a click ID are dropped. Above 100,000 estimated rows it warns — you can still save, but the daily run will then be skipped. At zero it reads "Nothing to send yet". A failed preview does not block saving.
按 Save & commit — generate daily 存檔。成功後回到 Overview 並立即生效,下一次早上的排程就會用新的設定。失敗時顯示後端的錯誤訊息,或是「The configuration could not be saved.」後端也會再檢查一次:至少 1 個 conversion、必須是這個帳號的、天數 1–90。Press Save & commit — generate daily. On success you return to Overview and it takes effect at once, from the next morning's run. On failure it shows the backend's message, or "The configuration could not be saved." The backend re-validates too: at least one conversion, belonging to this account, and 1–90 days.
來源:同事提供的 Conversion Tracking 說明(2026-10-06),逐條對照後整理。相關畫面見介面導覽的 Google Offline Conversions 面板;轉換怎麼定義見 Conversions。Source: a colleague's Conversion Tracking write-up (2026-10-06), reorganised point by point. For the screens see the Google Offline Conversions panel in the tour; for defining conversions see Conversions.