Report

Count BigCommerce subscriber growth by source, channel and week

For marketers who want to know which sources bring in new subscribers, by asking their AI assistant for a period.

BigCommerce subscriber growth report

How many BigCommerce subscribers did we add between 1 March and 31 March, and which sources did they come from?

You added 412 subscribers in March, and 38 percent came from checkout. - Top source: Footer signup form, 187 - Next sources: Checkout, 156, and Popup, 69 - Busiest week: 15 March, 121 subscribers - Channels: Storefront, 389, and Wholesale, 23 Want the full weekly table? Emails are left out unless you ask.

BigCommerce

Sample figures. Your results come from your own account.

bigcommerce-get-subscriber

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

Run it on your own BigCommerce data.

Connect BigCommerce, pick your AI tool and paste the prompt.

The problem

Sign-up sources counted by hand in a spreadsheet

Marketing tallies new BigCommerce newsletter sign-ups from exports to see which sources and channels bring people in. Counting by source, channel and week is slow, and the export carries every subscriber email whether needed or not.

Without PopdockAI

Export subscribers for the period
Count them by source and channel in a sheet
Group by week with formulas
Pass around a file full of email addresses

With PopdockAI

Subscribers added in the period are read from BigCommerce
Counts by source, channel and week are worked out
The share linked to an order from checkout is shown
Emails stay out unless you ask, and nothing is changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt

**Objective:** Report subscribers added from `{date-from}` to `{date-to}`.

**Step 1: Pull subscribers**

Call `bigcommerce-get-subscriber` with `date-created.from` and `date-created.to`.

**Step 2: Aggregate**

Count by `source` and by `channel-id`, by week of `date-created`, and the share linked to an `order-id`.

**Step 3: Report**

Headline total, tables by source, channel and week, and the share that came from checkout. Do not list email addresses unless asked.

**Rules & Guidelines:**

* This is a read-only job. Never call any `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tool. Do not suggest that you changed anything.
* Do not print subscriber emails by default.

**Validation:**

* If a read returns no records, say so plainly and stop; do not invent figures.
* If a result hits the maximum records limit, say the figures may be incomplete and name the filter that would narrow it.

Who it's for

One answer, three teams that use it

Email marketers

Know which sources bring subscribers

Counts by source show which forms and placements grow the list.

Which sources brought the most BigCommerce subscribers between 1 August and 31 August?

Marketing managers

Track list growth week by week

Weekly counts show whether a campaign moved sign-ups, ready for a status update.

Show weekly BigCommerce subscriber sign-ups for the last quarter.

Ecommerce managers

See how many sign up at checkout

The share of subscribers linked to an order shows how much checkout adds to the list.

What share of BigCommerce subscribers added in September signed up during checkout?

How it works

What PopdockAI does when you ask

You give a start and end date and your AI assistant counts BigCommerce subscriber growth. Subscriber emails are left out of the report by default.

Ask

You give a start and end date.

Your AI tool

Read

It reads the BigCommerce subscribers created in that period.

bigcommerce-get-subscriber

Count

It counts by source, by channel and by week, and the share linked to an order.

No items found.

Report

It shows a headline total and tables, without email addresses unless asked.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.

get-data

bigcommerce-get-subscriber

Returns subscribers from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.

Read only.Nothing in BigCommerce Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

The outcome

See what drives sign-ups without handling an export

Related use cases

More ways to put this data to work

BigCommerce and Drip customer purchase profile

Ask your AI for a customer's BigCommerce orders alongside their Drip status, tags, lead score and campaigns, matched by email, with nothing changed.

Learn More

BigCommerce and Dynamics GP customer receivables profile

Ask your AI to show a BigCommerce customer's orders beside their Dynamics GP balance and open receivables, and it says when the match was by name.

Learn More

BigCommerce and HubSpot customer 360 by email

Ask your AI for a customer view and it joins BigCommerce orders to the HubSpot contact, deals and tickets by email, without changing either system.

Learn More

BigCommerce and Pipedrive customer brief

Ask your AI for a customer brief and it combines BigCommerce orders and refunds with the Pipedrive person, organization, deals and activities.

Learn More

BigCommerce big spenders with no recent Constant Contact email

Ask your AI which BigCommerce customers with large orders have had no recent Constant Contact send, and it separates not in the list from not emailed.

Learn More

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.