Kit
Stats for your Kit (formerly ConvertKit) broadcasts: recipients, opens, clicks, unsubscribes.
The Kit (formerly ConvertKit) connector brings your account's broadcast stats into the sheet: one row per sent broadcast, with recipients, opens, clicks and unsubscribes.
The connection does not use a Google login: you enter a Kit v4 API Key, created from Settings > Developer > API Keys > Add a new key. Keys from the old v3 API do not work. The connection name is your Kit account name, read automatically.
Only already-sent broadcasts are included (status "completed"): drafts, scheduled, sending or cancelled broadcasts do not appear. Automated sequences (welcome emails, funnels) are not broadcasts and are not included.
Available metrics
| Metric | Period | Aggregation | Note |
|---|---|---|---|
| Recipients | broadcast | sum | Number of subscribers the broadcast was sent to. |
| Emails Opened | broadcast | sum | Number of recipients who opened the broadcast. |
| Open Rate (%) | broadcast | ratio | Emails opened / Recipients x 100, calculated from Kit's counts; recalculated on the sums in the totals row. |
| Click Rate (%) | broadcast | ratio | The click rate provided by Kit for each broadcast. In the totals row it is the recipient-weighted average, not a plain average of the rows. |
| Total Clicks | broadcast | sum | Total number of clicks, including repeated clicks by the same person: for this reason it should not be compared directly with the click rate, which counts people. |
| Unsubscribes | broadcast | sum | |
| Unsubscribe Rate (%) | broadcast | ratio | Unsubscribes / Recipients x 100; recalculated on the sums in the totals row. |
Available dimensions
| Dimension | Note |
|---|---|
| Date (Sent) | Broadcast send date, in the sheet timezone. One row per broadcast: this is not a daily series. |
| Sent At | Full send date and time, in the sheet timezone. |
| Created At | Broadcast creation date and time. |
| Broadcast ID | |
| Subject | |
| Preview Text | Empty if the broadcast has none. |
| Internal Description | The broadcast's internal note, only visible to you in Kit. Empty if not set. |
| Published on Creator Profile | "true"/"false": the broadcast is also published as a post on your Kit profile. |
| Published At | Publication date and time recorded by Kit. Kit fills it in even for broadcasts not published on the profile, usually a few seconds after sending: to know whether a broadcast is public on the profile use the "Published on Creator Profile" dimension. |
| Open Tracking Disabled | "true" if open tracking was disabled for that broadcast: opens and open rate then stay at 0 without being a real value. |
| Click Tracking Disabled | "true" if click tracking was disabled for that broadcast: clicks then stay at 0 without being a real value. |
Known limits
- Non-Pro plans: max 300 broadcasts per reportOn Kit plans other than Pro the stats are read one broadcast at a time, within the limit of 120 requests per minute: to stay within Google Sheets execution time the connector includes at most the 300 most recent broadcasts in the period, and flags it in the sheet with a warning. On Pro plans this limit does not apply.
- 5-year historyKit only returns stats for broadcasts from the last 5 years; those sent more than 3 years ago are no longer updated and show their values as of that point. Broadcasts older than 5 years cannot be retrieved through the API.
- Sent broadcasts only, no sequencesThe report includes only broadcasts with status "completed". Automated sequences, per-link click detail and per-subscriber detail are not included in this version.
- A v4 API Key is requiredKeys from the old ConvertKit v3 API do not work: the connection rejects them with an explicit message. Generate a new one from Settings > Developer > API Keys.
Execution notes
The report period filters broadcasts by send date, in the sheet timezone.
The connector first tries to read the stats of all broadcasts in a single request; Kit allows this only on Pro plans and returns an error otherwise, in which case the connector automatically switches to reading them one broadcast at a time, in groups, respecting Kit's limit (120 requests per minute). In this second case, with many broadcasts in the period, a run can take a few minutes.
Open rate and unsubscribe rate are calculated on recipients from the counts provided by Kit; click rate is the one provided by Kit for each broadcast. All rates range from 0 to 100 and in the totals row they are recalculated across all broadcasts (weighted by recipients), not as an average of the per-row percentages.