Users

x fct trans users name description billing address 1 the street address of the billing address billing address 2 an additional field for the street address of the billing address billing address city the city, town, or village of the billing address billing address company the company associated to this billing address billing address country the name of the country of the billing address billing address country code the two letter code (iso 3166 1 format) for the country of the billing address billing address first name the first name of the person associated to this billing address billing address id unique identifier generated by chord for a billing address billing address last name the last name of the person associated to this billing address billing address latitude the latitude of the billing address billing address longitude the longitude of the billing address billing address name the full name of the person associated to this billing address billing address oms billing address id unique key generated by shopify that identifies a billing address billing address phone the phone number associated to this billing address billing address province the name of the region (province, state, prefecture, …) of the billing address billing address province code the two letter abbreviation of the region of the billing address billing address zip the postal code of the billing address shipping address 1 the street address of the shipping address shipping address 2 an additional field for the street address of the shipping address shipping address city the city, town, or village of the shipping address shipping address company the company associated to this shipping address shipping address country the name of the country of the shipping address shipping address country code the two letter code (iso 3166 1 format) for the country of the shipping address shipping address first name the first name of the person associated to this shipping address shipping address id unique identifier generated by chord for a shipping address shipping address last name the last name of the person associated to this shipping address shipping address latitude the latitude of the shipping address shipping address longitude the longitude of the shipping address shipping address name the full name of the person associated to this shipping address shipping address oms shipping address id unique key generated by shopify that identifies a shipping address shipping address phone the phone number associated to this shipping address shipping address province the name of the region (province, state, prefecture, ) of the shipping address shipping address province code the two letter abbreviation of the region of the shipping address shipping address zip the postal code of the shipping address user completed oms order ids list of all completed oms order ids for a user user completed order names list of all completed order names for a user user email the email of the customer user first completed oms order id order id from the oms for the first completed order user first completed order name order name for the first completed order user first name the first name of the customer user first name last initial the first name and last name initials of the customer this appends the value of `first name` and the first character of `last name` together user first order unique ordered products list of unique products purchased by the user in their first completed order user first order unique ordered skus list of unique variant skus purchased by the user in their first completed order user first subscription ids array of first subscription ids purchased by the user the user may have more than one subscription created at the same time, resulting in more than one subscription counted as first user full name the full name of the customer this appends the value of `first name` and `last name` together user has ordered a la carte whether or not the user has had at least one order that is not a part of a subscription user has promo applied in first order whether the first completed order has a promo applied or not user has reactivation subscription whether or not the user has at least one subscription created after the first subscription is cancelled user has subscription in first order whether or not the user's first order is linked to a subscription user has verified email whether the customer has verified their email address user id unique identifier generated by chord to identify the user user is active subscriber whether or not the user has an active subscription with at least one completed subscription order an active subscription is one that is not cancelled or paused subscribers may have completed subscription orders on inactive subscriptions, but will not be considered active if their current subscription has no completed orders user is customer whether the user has completed at least one order or not user is new customer whether the user has completed one order or not user is not customer whether the user has no completed orders or not user is returning customer whether the user has completed more than one order or not user is subscriber whether or not the user has completed at least one subscription order user last name the last name of the customer user last subscription ids array of last subscription ids purchased by a user the user may have more than one subscription created at the same time, resulting in more than one subscription counted as last user number of cancelled subscriptions total number of subscriptions the user has cancelled user number of completed a la carte orders total number of orders completed by a user that are a la carte user number of completed orders total count of completed orders by the user user number of completed subscription orders total number of orders completed by a user that are part of a subscription user number of created subscription orders total number of orders created by a user that are part of a subscription user number of orders with promos count of completed orders with a promo applied user number of reactivated subscriptions total number of subscriptions for a user that are reactivations these subscriptions may be active, inactive, or concurrent user number of subscriptions total number of subscriptions linked to a user these subscriptions may be active, inactive, or concurrent user oms user id unique identifier generated by the oms to identify the user user phone the phone number of the customer user unique ordered product type list of unique product types purchased by the user across all completed orders user unique ordered products list of unique products purchased by the user across all completed orders user unique ordered skus list of unique variant skus purchased by the user across all completed orders user first completed order completed at (universal) timestamp for the first order completed universal time zone user first completed order created at (universal) timestamp for the first completed order created universal time zone user first order created at (universal) timestamp of the first created order for the user universal time zone user first subscription created at (universal) timestamp of when the first subscription was created per user universal time zone user first subscription order completed at (universal) the timestamp of the user's first completed subscription order, regardless of subsequent subscriptions universal time zone user first subscription order created at (universal) the timestamp of the user's first completed subscription order, regardless of subsequent subscriptions universal time zone user last completed order completed at (universal) timestamp for the most recent order completed universal time zone user last completed order created at (universal) timestamp for the most recent completed order created universal time zone average a la carte gross revenue sum of gross revenue generated by all completed a la carte orders for a user average a la carte net revenue sum of net revenue generated by all completed a la carte orders for a user average additional tax total when taxes are not included in the subtotal, this is total tax added to the order average first order gross revenue gross revenue of the first completed order average first order net revenue net revenue of the first completed order average fulfillment total the sum of all shipping prices in the location's currency average gross revenue gross revenue of the order calculated as `item total` + `fulfillment total` average included tax total when taxes are included in the subtotal, this is the total tax included in the order average item total the sum of all line item prices in the location's currency average last order gross revenue gross revenue of the most recent completed order average last order net revenue net revenue of the most recent completed order average manual transaction total sum of all sales transaction with gateway of type 'manual' average net revenue net revenue of the order calculated as `item total` + `fulfillment total` `promo total` `refund total` average order gross revenue the average order gross revenue of completed orders per user average order net revenue the average order net revenue of completed orders per user average order transaction total the average transaction total of completed orders per user average payment total sum of all sales transaction with gateway of type 'shopify payments' average promo total the total discounts applied to the price of the order in the location's currency average refund total sum of all the transactions that are of kind 'refund' applied to the order average subscription gross revenue sum of gross revenue generated by all completed subscription orders for a user average subscription net revenue sum of net revenue generated by all completed subscription orders for a user average tax total the sum of all the taxes applied to the order in the location's currency average total ordered quantity the total quantity of variant skus purchased the user average total price the sum of all line item prices, discounts, shipping, taxes, and tips in the average total unique ordered products the count of unique products purchased the user average transaction total sum of all sale transactions for the order a la carte gross revenue sum of gross revenue generated by all completed a la carte orders for a user a la carte net revenue sum of net revenue generated by all completed a la carte orders for a user additional tax total when taxes are not included in the subtotal, this is total tax added to the order first order gross revenue gross revenue of the first completed order first order net revenue net revenue of the first completed order fulfillment total the sum of all shipping prices in the location's currency gross revenue gross revenue of the order calculated as `item total` + `fulfillment total` included tax total when taxes are included in the subtotal, this is the total tax included in the order item total the sum of all line item prices in the location's currency last order gross revenue gross revenue of the most recent completed order last order net revenue net revenue of the most recent completed order manual transaction total sum of all sales transaction with gateway of type 'manual' net revenue net revenue of the order calculated as `item total` + `fulfillment total` `promo total` `refund total` total ordered quantity the total quantity of variant skus purchased the user payment total sum of all sales transaction with gateway of type 'shopify payments' total price the sum of all line item prices, discounts, shipping, taxes, and tips in the promo total the total discounts applied to the price of the order in the location's currency refund total sum of all the transactions that are of kind 'refund' applied to the order subscription gross revenue sum of gross revenue generated by all completed subscription orders for a user subscription net revenue sum of net revenue generated by all completed subscription orders for a user tax total the sum of all the taxes applied to the order in the location's currency transaction total sum of all sale transactions for the order total unique ordered products the count of unique products purchased the user