BigCommerce customer groups in a live spreadsheet

Add the Customer groups table to a sheet as a data source named customer_groups and its 3 columns become names your formulas, pivot tables and charts use. Sheets reads it from your BigCommerce store each time the sheet opens or refreshes.

Formulas on this table

=list.customer_groups(name)

Every name, once. Spills the distinct name values down the column: the row labels for the formula above.

=data.customer_groups.count(name, name, "<>")

Rows with a name. Counts the rows whose Name is not empty.

Columns

Column	In formulas	Type
Name	`name`	Text
Default	`default`	Yes / no
ID	`id`	Text

Other customers tables

Customers9 columns Buyers (from orders)11 columns

Your customer groups, live

Orders, refunds, products, customers and coupons become live tables inside your BigCommerce control panel. Sales reports and dashboards stay current without exporting a CSV.