BigCommerce customers in a live spreadsheet
Add the Customers table to a sheet as a data source named customers and its 9 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.customers(group) Every group, once. Spills the distinct group values down the column: the row labels for the formula above.
=data.customers.count(name, group, "<>") Rows with a group. Counts the rows whose Group is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| Name | name | Text |
e_mail | Text | |
| Company | company | Text |
| Group | group | Text |
| Country | country | Text |
| City | city | Text |
| Accepts marketing e-mails | accepts_marketing_e_mails | Yes / no |
| Registered | registered | Date |
| ID | id | Text |
Other customers tables
Your customers, 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.