Conversions

x fct trans activities name definition activity event text the name of the event activity event text id the slug of the event name, mapping to the page or track event table activity id the unique identifier of an activities (i e track or page event) activity page path the page path part of the url a page path is the part of url that comes after the hostname (domain) and before the query parameters, url fragment, or port (e g `/pages/contact us/` for `https //chord co/pages/contact us/?ref=internal banner` ) activity page query the query string portion of the url of the page activity page title the title/name of the page activity page url the url of the page activity session activity count total count of activities, pave views and tracked events within the session activity session attribution channel the attribution channel for the first page event of the session sessions with an attribution of 'unknown' indicates that there is no attributable data for that session activity session attribution channel paid or organic indicates if the session's first page attribution is paid or organic attribution is considered organic if the attribution channel is 'direct', 'other', 'organic search', 'organic social', 'email', or 'sms' activity session attribution first page url has gclid indicates if the first page event of the session has a google click id activity session attribution first page url has utm indicates if the first page event of the session has any utm information activity session attribution has referrer indicates if the first page event of the session has a referrer host activity session attribution medium the campaign medium represented by the utm tags for the first page event of the session activity session attribution source the campaign source represented by the utm tags for the first page event of the session activity session attribution sub channel sub channel is a granular level of attribution activity session completed oms order ids array of oms order ids associated to the session id, as collected by order completed or checkout completed front end events activity session completed order ids array of order ids associated to the session id, as collected by order completed or checkout completed front end events activity session completed order numbers array of order numbers associated to the session id, as collected by order completed or checkout completed front end events activity session days since last session end the days between the last session's end and the start of this session activity session device the device on which the event was sent from activity session device category the device category of the device on which the event was sent from there are multiple supported values for this column such as 'iphone', activity session duration in seconds total seconds between start and end activities within the session activity session duration in seconds tiers total seconds between start and end activities within the session, aggregated into tiers 0 9s, 10 29s, 30 59s, and 60s or more activity session has order completion flag for sessions with an order completed or checkout completed front end events activity session id unique id for the session activity session number session number per anonymous id activity session unique completed order count count of unique order ids associated to the session id, as collected by order completed or checkout completed front end events activity session unique completed order number count count of unique order numbers associated to the session id, as collected by order completed or checkout completed front end events activity utm campaign the campaign name represented by the utm tags activity utm content the campaign content represented by the utm tags activity utm medium the campaign medium represented by the utm tags activity utm source the campaign source represented by the utm tags activity utm term the campaign term represented by the utm tags activity website locale locale of website this will either be collected from the url or from the drop down link on the store anonymous completed oms order ids array of oms order ids associated to the anonymous id, as collected by order completed or checkout completed front end events, over time anonymous completed order ids array of order ids associated to the anonymous id, as collected by order completed or checkout completed front end events, over time anonymous completed order numbers array of order numbers associated to the anonymous id, as collected by order completed or checkout completed front end events, over time anonymous current blended user id unique id derived from the user id and the anonymous id whenever a customer has a user id, the user anonymous id will be constant for anonymous current user id the current user id associated with the anonymous id this unique user id is created by segment's identify call a user id can be associated to many anonymous ids anonymous id unique id created by chord for each anonymous visitor per store anonymous segment anonymous id id created by segment for each anonymous visitor this id gets created as soon as a customer's browser loads the analytics javascript widget the anonymous id remains unchanged through the entire browsing session from a single device depending on configuration, two stores connected stores may have the same anonymous id anonymous unique user ids array of user ids mapped to an anonymous id date day num of year the number representing the day of the year date id unique key that uniquify a date date month num of year the month number of the year last seen page browser locale locale of browser last seen page device the device on which the event was sent from last seen page device category the device category of the device on which the event was sent from there are multiple supported values for this column such as 'iphone', last seen page event table name the properly formatted name of the table of the event last seen page event text the name of the event last seen page event text id the slug of the event name, mapping to the page or track event table last seen page gclid the google click id google click id (gclid) is a parameter passed in the url with ad clicks, to identify the campaign and other attributes of the click associated with the ad for ad tracking and campaign attribution last seen page id unique key generated by segment for each tracking or page event last seen page oms id unique key generated by our models that uniquifies an oms last seen page host the host of the event's url for example `https //www store staging assembly dev/mypage` would become `store staging assembly dev` this facilitates grouping events by host last seen page path the page path part of the url a page path is the part of url that comes after the hostname (domain) and before the query parameters, url fragment, or port (e g `/pages/contact us/` for `https //chord co/pages/contact us/?ref=internal banner` ) last seen page query the query string portion of the url of the page last seen page referrer the referrer of the page the referrer is the webpage that sends visitors to the site using a link in last seen page title the title/name of the page last seen page url the url of the page last seen page referrer host the host of the referrer for example `https //www store staging assembly dev/mypage` would become `store staging assembly dev` this facilitates grouping events by host last seen page segment user id the unique id of the user last seen page store id unique key generated by our models that uniquifies a store last seen page tenant id unique key generated by chord that uniquifies a tenant last seen page user agent the user agent of the device making the request a user agent request header is a characteristic string that lets servers and last seen page user id unique key generated by chord to identify the user last seen page utm campaign the campaign name represented by the utm tags last seen page utm content the campaign content represented by the utm tags last seen page utm medium the campaign medium represented by the utm tags last seen page utm source the campaign source represented by the utm tags last seen page utm term the campaign term represented by the utm tags last seen page website locale locale of website this will either be collected from the url or from the drop down link on the store session landing page browser locale locale of browser session landing page device the device on which the event was sent from session landing page device category the device category of the device on which the event was sent from there are multiple supported values for this column such as 'iphone', session landing page event table name the properly formatted name of the table of the event session landing page event text the name of the event session landing page event text id the slug of the event name, mapping to the page or track event table session landing page gclid the google click id google click id (gclid) is a parameter passed in the url with ad clicks, to identify the campaign and other attributes of the click associated with the ad for ad tracking and campaign attribution session landing page id unique key generated by segment for each tracking or page event session landing page oms id unique key generated by our models that uniquifies an oms session landing page host the host of the event's url for example `https //www store staging assembly dev/mypage` would become `store staging assembly dev` this facilitates grouping events by host session landing page path the page path part of the url a page path is the part of url that comes after the hostname (domain) and before the query parameters, url fragment, or port (e g `/pages/contact us/` for `https //chord co/pages/contact us/?ref=internal banner` ) session landing page query the query string portion of the url of the page session landing page referrer the referrer of the page the referrer is the webpage that sends visitors to the site using a link in session landing page title the title/name of the page session landing page url the url of the page session landing page referrer host the host of the referrer for example `https //www store staging assembly dev/mypage` would become `store staging assembly dev` this facilitates grouping events by host session landing page segment user id the unique id of the user session landing page store id unique key generated by our models that uniquifies a store session landing page tenant id unique key generated by chord that uniquifies a tenant session landing page user agent the user agent of the device making the request a user agent request header is a characteristic string that lets servers and session landing page user id unique key generated by chord to identify the user session landing page utm campaign the campaign name represented by the utm tags session landing page utm content the campaign content represented by the utm tags session landing page utm medium the campaign medium represented by the utm tags session landing page utm source the campaign source represented by the utm tags session landing page utm term the campaign term represented by the utm tags session landing page website locale locale of website this will either be collected from the url or from the drop down link on the store store id unique key generated by our models that uniquifies a store store name the name of the store store oms admin url the admin url of that oms store oms id unique key generated by chord that uniquifies an oms store oms store id unique key generated by our models that uniquifies a store store oms type the type of the oms store id unique key generated by our models that uniquifies a store store tenant id unique key generated by chord that uniquifies a tenant store url the storefront url of of the store user address 1 the first line of the street address user address 2 the optional second line of the address user address city the city of the address user address country the country of the address user address name the full name of the customer, based on firstname and lastname user address state the region of the address, such as the province, state, or district user address zip the postal code of the address user completed oms order ids array of oms order ids associated to the user id, as collected by order completed or checkout completed front end events, over time user completed order ids array of order ids associated to the user id, as collected by order completed or checkout completed front end events, over time user completed order numbers array of order numbers associated to the user id, as collected by order completed or checkout completed front end events, over time user email the email associated with the user user id unique id per user it is equal to either 1) a identified user id as identified by segment in the identify call, or 2) an anonynous id user identified user id unique id per identified user (see segment's documentation on user id)\[https //segment com/docs/connections/spec/identify/#user id] user ip ip address associated with the user user last anonymous id last seen anonymous id per user an anonymous id is a unique id per anonymous visitor (see segment's documentation on anonymous id)\[https //segment com/docs/connections/spec/identify/#anonymous id] user last segment anonymous id user segment user id the unique id of the user user unique anonymous ids array of all seen anonymous ids per user an anonymous id is a unique id per anonymous visitor (see segment's documentation on anonymous id)\[https //segment com/docs/connections/spec/identify/#anonymous id] user unique completed order count count of unique order ids associated to the user id, as collected by order completed or checkout completed front end events, over time x fct trans sales name description affiliate email email address of the affiliate affiliate id unique key generated by chord to identify a unique affiliate affiliate name full name of the user affiliate seen emails list of email addresses seen affiliate user id unique key generated by chord to identify a unique user billing address address1 the street address of the customer billing address address2 the optional second address of the customer billing address alternative phone the customer's alternative phone number billing address city the city where the address is billing address company a company name billing address country abbr billing address country name full name of the country billing address firstname first name of the customer billing address id unique key generated by chord to identify a unique address billing address lastname last name of the customer billing address oms address id unique key generated by solidus that identifies an address billing address phone the customer's phone number billing address state abbr billing address state name full name of the state billing address zipcode the postal code order adjustment types list of distinct adjustment reasons for adjustments made to the order order admin url the admin url of pointing to the order order applied discount codes list of promotion codes applied to the order order applied discount codes count count of promotion codes applied to the order order applied discount ids list of promotion ids applied to the order order applied discount names list of promotion names applied to the order order applied discount names count count of promotion names applied to the order order cart url url of the cart which contains the order order channel the channel from which the order is created order completed order rank by subscription allows to rank completed orders by completion date for a subscription order completed order rank by user allows to rank completed orders by completion date for a user order contains refund whether or not the order contains refund adjustments or refunds that are processed outside of the chord oms adjustment systems (for example via rmas or cancellations) order contains replacement whether or not the order contains replacement adjustments or shipped replacement items (following an rma authorization) order contains return whether or not the order contains returns (authorized rmas) order contains rma refund whether or not the order contains rma refunds (refunds issued after an rma was requested and authorized) order contains rma store credits this column is not documented order currency the currency for this order order customer lifetime month number of months between the current order's completion date and the user's first order completion date first orders have a value of 1 order customer lifetime week number of weeks between the current order's completion date and the user's first order completion date first orders always have a value of 1 order email the email address of the customer that made the order order financial state the current payment state of the order order fulfillment ids array of unique keys generated by chord to identify the unique shipments for an order order fulfillment numbers the unique identifier for this shipment order fulfillment state the current shipment state of the order order has discount whether or not the order has promotions applied to it order has order tags whether or not that order has tags order hours from order to first fulfillment number of hours between order completion and first order shipment; how long it takes a company to get the initial product out to a customer order hours from order to last fulfillment number of hours between order completion and last order shipment order id unique key generated by chord to identify a unique order order is canceled whether or not the order is canceled the order is considered canceled when the canceled at date is not null order is completed whether or not that order is completed the order is considered completed when the completed at date is not null this means that the order does not necessarily have a state = complete , since states can change after the order completion (for example in the case of a refund) order is first completed order whether or not that order was the first completed order for a user order is first order whether or not that order was the first order for a user order is first subscription completed order whether or not that order was the first completed order for a subscription order is first subscription order whether or not that order was the first order for a subscription order is fulfilled whether or not that order has shipped order is part of subscription whether or not that order is part of a subscription order is pre paid purchase whether the order the orderincludes the purchase of a pre payment; this could be a gift subscription, pre pay subscription, or gift card order is pre paid redemption whether the order included the redemption of a pre payment; this could be the redemption of a gift subscription, pre pay subscription, or gift card order is referred by affiliate whether or not the user is referred by an affiliate order is referred by referrer whether or not the user is referred by a referrer order is replacement true when the order is a replacement order order is suspicious referral conversion wether this represents a suspicous referral conversions or not order item id unique key generated by chord to identify a unique order order item line items quantity sum of line items quantities per order order item product basket list of product names per in the order order item product basket count number of products in the order order product basket the titles of products for a given order array converted to a string order item total line item unit quantity sum of line item units in the order order item total line items quantity sum of line items quantities per order order item unique product basket list of unique product names per in the order order item unique product basket count number of unique products in the order order unique product basket the list of unique products for a given order array converted to a string order item unique unit basket list of unique units in the order order item unique unit basket count count of unique units in the order order unit basket the list of units for a given order array converted to a string order item unique variant basket list of unique variant names per in the order order item unique variant basket count number of unique variants in the order order unique variant basket the list of unique variants for a given order array converted to a string order item unit basket list of all units in the order order item unit basket count count of all units in the order order unique unit basket the list of unique units for a given order array converted to a string order item variant basket list of variant names per in the order order item variant basket count number of variants in the order order variant basket the titles of variants for a given order array converted to a string order number human readable unique key generated by solidus that identifies an order it begins with a set of tenant store defined letters and ends in a nine digit number (for example, chord 123456789) this number is shown to the users in various places these combinations are unique for a given store order oms order id unique key generated by solidus that identifies an order order rank by user allows to rank completed orders by completion date for a user order tags list of tags associated to the order order tags count number of tags associated to the order order referral conversion suspicious reasons a list of reasons explaining why the referral conversion is suspicious order referrer user email the email address of the customer identified with the referral order special instructions any special shipping instructions that have been specified by the customer during checkout order state the current state of the order order store id unique key generated by our models that uniquifies a store order store name the name of the store order store oms admin url the admin url of that oms order store oms id unique key generated by chord that uniquifies an oms order store oms store id unique key generated by our models that uniquifies a store order store oms type the type of the oms order store id unique key generated by our models that uniquifies a store order store tenant id unique key generated by chord that uniquifies a tenant order store url the storefront url of of the store order subscription customer lifetime month number of months between the current order's completion date and the user's first subscription order completion date first orders have a value of 1 order subscription customer lifetime week number of weeks between the current order's completion date and the user's first subscription order completion date first orders always have a value of 1 order user referral code unique key generated by solidus that represents the user's referral code order website locale locale of website this will either be collected from the url or from the drop down link on the store referral conversion rank by referrer allows to rank a referral conversion by referrer referral id unique key generated by chord to identify a unique referral identifier referral is converted wether this represents a converted referral or not referral is first conversion whether or not the referral was the referrer's first converted referral referral is first non suspicious conversion whether or not the referral was the referrer's first non suspicious converted referral referral is suspicious wether this represents a suspicous referral conversions or not referral non suspicious conversion rank by referrer allows ranking of non suspicious referral conversion by the referrer referral oms referral conversion id unique key generated by solidus that identifies a referral conversion referral suspicious reasons a list of reasons explaining why the referral conversion is suspicious referrer currency the currency for this referral identifier referrer email the email address of the customer identified with the referral referrer id unique key generated by chord to identify a unique referral identifier referrer oms referral identifier id unique key generated by solidus that identifies a referral identifier referrer user referral code unique key generated by solidus that represents the user's referral code shipping address address1 the street address of the customer shipping address address2 the optional second address of the customer shipping address alternative phone the customer's alternative phone number shipping address city the city where the address is shipping address company a company name shipping address country abbr shipping address country name full name of the country shipping address firstname first name of the customer shipping address id unique key generated by chord to identify a unique address shipping address lastname last name of the customer shipping address oms address id unique key generated by solidus that identifies an address shipping address phone the customer's phone number shipping address state abbr shipping address state name full name of the state shipping address zipcode the postal code subscription completed oms order ids list of completed oms order ids by a subscription subscription completed order count total amount of orders completed by a subscription subscription completed order ids list of completed order ids by a subscription subscription first order unique product basket array of unique product names ordered in the first order per subscription subscription first order unique variant basket array of unique skus ordered in the first order per subscription subscription has subscription tags whether or not the subscription has tags subscription id unique key generated by solidus that identifies a subscription subscription interval in days the number of days in the subscription interval subscription is auto redeemed whether the pre paid subscription will be auto redeemed or if an action is required by the recepient subscription is gift whether or not the pre paid subscription is a gift subscription is recurring whether the pre paid subscription is recurring subscription last order unique product basket array of unique product names ordered in the latest order per subscription subscription last order unique variant basket array of unique skus ordered in the latest order per subscription subscription oms pre paid subscription id id generated by chordoms to identify a unique pre paid subscription subscription oms subscription id unique key generated by solidus that identifies a subscription subscription pre paid subscription id chord generated unique id for the pre pay subscription subscription state the current state of the subscription, enhanced with values for `paused` if the subscription is active and paused subscription tags the list of tags associated with a subscription subscription tags count the number of tags associated with a subscription subscription unique product basket array of unique product names ever ordered per subscription subscription unique variant basket array of unique skus ever ordered per subscription user completed oms order ids list of completed oms order ids by a user user completed order ids list of completed order ids by a user user credit category basket array of credit categories (gift card, reimbursement, referral credits, prepaid subscription, gma) issued per user user email email address of the user user first completed oms order id oms order id of the first order completed by a user user first completed order id unique order id of the first order completed by a user user first order unique ordered products unique products ordered by the user in their first completed order user first order unique ordered skus unique skus ordered by the user in their first completed order user has ordered a la carte whether or not the user has had at least one order that is not part of a subscription user has promo applied in first order whether or not the user has a promo applied to their first completed order user has subscription in first order whether or not the user's first order is linked to a subscription user id unique key generated by chord to identify a unique 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 user is customer whether or not the user is a customer user is new customer whether or not the user is a new customer user is not customer whether or not the user is not a customer user is returning customer whether or not the user is a returning customer user is subscriber whether or not the user has completed at least one subscription order user login the login email address of the user user name full name of the user user number of completed a la carte orders total amount of orders completed by a user that are a la carte user number of completed subscription orders total amount of orders completed by a user that was part of a subscription user number of orders with promos the count of completed orders with a promo applied user number of subscriptions total amount of subscriptions linked to a user user oms user id unique key generated by solidus that identifies a user user phone phone number of the user user total completed order count total amount of orders completed by a user user unique ordered products unique products ordered by the user across all orders user unique ordered skus unique skus ordered by the user across all orders billing address created at (universal) timestamp at which the address row was created universal time zone billing address updated at (universal) timestamp at which the address row was last updated universal time zone order approved at (universal) reflects when the entity was approved in solidus universal time zone order canceled at (universal) reflects when the order was cancelled universal time zone order completed at (central) reflects when the entity was moved to the completed state cental time zone order completed at (eastern) reflects when the entity was moved to the completed state eastern time zone order completed at (mountain) reflects when the entity was moved to the completed state mountain time zone order completed at (pacific) reflects when the entity was moved to the completed state pacific time zone order completed at (universal) reflects when the entity was moved to the completed state universal time zone order created at (central) reflects when the entity was first created in solidus cental time zone order created at (eastern) reflects when the entity was first created in solidus eastern time zone order created at (mountain) reflects when the entity was first created in solidus mountain time zone order created at (pacific) reflects when the entity was first created in solidus pacific time zone order created at (universal) reflects when the entity was first created in solidus universal time zone order first fulfillment fulfilled at (universal) timestamp at which the first shipment for that order was shipped universal time zone order last adjustment refund at (universal) timestamp of the last return adjustment for an order universal time zone order last adjustment replacement at (universal) timestamp of the last replacement adjustment for an order universal time zone order last fulfillment fulfilled at (universal) timestamp at which the last shipment for that order was shipped universal time zone order updated at (universal) reflects when the entity was last updated in solidus universal time zone referral converted at (universal) reflects when the referral entity was first converted in solidus universal time zone referral created at (universal) reflects when the entity was first created in solidus universal time zone referral updated at (universal) reflects when the entity was last updated in solidus universal time zone referrer created at (universal) reflects when the entity was first created in solidus universal time zone referrer updated at (universal) reflects when the entity was last updated in solidus universal time zone shipping address created at (universal) timestamp at which the address row was created universal time zone shipping address updated at (universal) timestamp at which the address row was last updated universal time zone subscription actionable date (universal) the date of the next subscription installment this date is updated after each successful installment subscriptions in an inactive state will be null universal time zone subscription created at (universal) reflects when the entity was first created in solidus universal time zone subscription first order completed at (universal) the timestamp of the subscription's first completed order universal time zone subscription last order completed at (universal) the timestamp of the subscription's last completed order universal time zone subscription updated at (universal) reflects when the entity was last updated in solidus universal time zone user created at (universal) timestamp at which the users row was created universal time zone user date of birth (universal) date of birth of the user universal time zone user deleted at (universal) timestamp at which the user's account was deleted universal time zone user first order completed at (universal) the timestamp of the user's first completed order 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 last order completed at (universal) the timestamp of the user's last completed order universal time zone user last sign in at (universal) the last sign in timestamp for the user universal time zone user updated at (universal) timestamp at which the users row was last updated universal time zone average additional tax total total additional taxes for an order average adjustment fulfillment tax total total adjustment shipment taxes for an order average adjustment fulfillment total total shipment adjustments applied to an order average adjustment other charges total total of included additional adjustment charges paid for an order average adjustment other credits total total of credits issued for an order average adjustment refund total total of return dollars for an order average adjustment replacement total total of replacement dollars for an order average adjustment rma refund total total of refund dollards associated to an order that was returned via the rma functionality of the chord oms average adjustment tax total total adjustment taxes an order average adjustment total total of adjustment applied for an order as on the order average applied gift card total total of gift card dollars that were used as a payment method in the order average commission total commission for an order average fulfillment total total shipment for an order average gross revenue gross amount of revenue generated by the order including items and shipments totals gross revenue = total included tax total + shipment total purchased gift card total pre payment subscription purchase amount average included tax total total included taxes for an order average item total total price for the order before adjustments average net revenue net revenue generated by the order's items after promotions net revenue = total included tax total + shipment total + adjustment total additional tax total purchased gift card total pre payment subscription purchase amount average pre paid purchase total average pre paid redemption total average promo total promotions applied to an order average purchased gift card total total of gift card dollars that were purchased in the order average reimbursement credit total the amount of store credits owed back in an order average tax total total taxes for an order average total price total to be paid by the customer for an order average transaction total total paid by the customer for a completed order additional tax total total additional taxes for an order adjustment fulfillment tax total total adjustment shipment taxes for an order adjustment fulfillment total total shipment adjustments applied to an order adjustment other charges total total of included additional adjustment charges paid for an order adjustment other credits total total of credits issued for an order adjustment refund total total of return dollars for an order adjustment replacement total total of replacement dollars for an order adjustment rma refund total total of refund dollards associated to an order that was returned via the rma functionality of the chord oms adjustment tax total total adjustment taxes an order adjustment total total of adjustment applied for an order as on the order applied gift card total total of gift card dollars that were used as a payment method in the order commission total commission for an order fulfillment total total shipment for an order gross revenue gross amount of revenue generated by the order including items and shipments totals gross revenue = total included tax total + shipment total purchased gift card total pre payment subscription purchase amount included tax total total included taxes for an order item total total price for the order before adjustments net revenue net revenue generated by the order's items after promotions net revenue = total included tax total + shipment total + adjustment total additional tax total purchased gift card total pre payment subscription purchase amount pre paid purchase total pre paid redemption total total price total to be paid by the customer for an order promo total promotions applied to an order purchased gift card total total of gift card dollars that were purchased in the order reimbursement credit total the amount of store credits owed back in an order tax total total taxes for an order transaction total total paid by the customer for a completed order