Loading...

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 report
    On 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 history
    Kit 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 sequences
    The 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 required
    Keys 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.