Customer tags table
The customer tags table contains data about the customer tags in your store. This table reflects the current state of these tags in Shopify and it contains one row per customer tag.
A customer tag is created every time you add a tag to a customer. For example, you have a tag named Loyalty that you add to your most loyal customers. If you add this tag to two of your customers, John Smith and Jane Doe, then two customer tags are created. Each of these customer tags has their own ID. If you want to find out how many times the Loyalty tag has been added to your customers, then use the title column (do not use the customer_tag_id column)
| Column | Data type | Description |
|---|---|---|
| customer_tag_id | numeric | ID of the customer_tag. This ID is created every time a tag is added to a customer. This is the primary key column for the customers table. |
| customer_id | numeric | ID of the customer that the tag has been added to. This column is a foreign key reference to the customer_id column in the customers table. |
| shop_id | numeric | ID of the store. This column is a foreign key reference to the shop_id column in the shops table. |
| title | varchar | Name of the customer tag. For example, Risky or VIP. |
The following example returns customer tags by average order size