Marketing Attribution

x fct trans order 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 first fulfillment id unique identifier for a shopify fulfillment at a specific point in time first fulfillment oms fulfillment id unique key generated by shopify that identifies a fulfillment first fulfillment shipment status represent the status of the shipment first fulfillment status the status of the fulfillment first fulfillment tracking company the name of the tracking company first fulfillment tracking numbers a list of tracking numbers provided by the tracking company first fulfillment tracking urls the urls of tracking pages for the fulfillment last transaction amount the amount of money included in the transaction last transaction error code the error code explaining why the transaction failed last transaction gateway the name of the gateway the transaction was issued through last transaction id unique identifier for a shopify transaction at a specific point in time last transaction is failed whether or not the transaction / payment has failed last transaction is successful whether or not the transaction / payment has succeeded last transaction is test whether this is a test transaction or not last transaction kind the type of transaction last transaction message additional information provided the payment provider about the transaction last transaction oms transaction id unique key generated by shopify that identifies a transaction last transaction status the status of the transaction location id unique identifier for a shopify location at a specific point in time location is active whether the location is active or not location is online whether or not this location represents an online location location is physical whether or not this location represents a physical location location name the name of a location location oms location id unique key generated by shopify that identifies a location order admin url contains the full url directing to the admin dashboard of shopify for that given order order app id the id of the app from shopify that created the order order app name app name associated with the app id this field will be generated if the hub configuration is enabled and the value has been set order applied discount codes the discount 'codes' applied or a given order order applied discount codes count the total number of applied discount code for a given order order cancel reason the reason as to why the order was cancelled order cart website locale when available, this is the shopify international site activated prior to cart creation order completed order rank by user allows to rank customer carts by completion date in other words, this will rank the customer's completed order from 1 to x (x being the most recent order that was completed) order completed subscription order rank by user allows to rank customer subscription orders by completion date order contains first subscription order a boolean value to indicate whether an order contains the first subscription order or not an order may contain a mix of first and recurring subscriptions order created order rank by user allows to rank customer carts by creation date in other words, this will rank the customer's creation order from 1 to x (x being the last order that was created) an order can be created but never completed order created subscription order rank by user allows to rank customer subscription orders by creation date order customer lifetime month number of months between the current order's creation date and the user's first order creation date first orders have a value of 1 order customer lifetime week number of weeks between the current order's creation date and the user's first order creation date first orders always have a value of 1 order filtered order whether or not this order will be flagged by custom filter order financial state the status of transaction associated with the order order fulfillment state the summarized status of the 'shipment/fulfillment' associated with the order order has discount whether or not the order has had a discount applied to it order has order tag whether or not the order has an order tag applied to it order id unique identifier generated by chord for an order order included fulfillment codes aggregated array of fulfillment codes, represented as a string order included fulfillment methods aggregated array of fulfillment methods, represented as a string order included payment gateways this is the rolled up successful payment gateway for an order successful payments are included if they are sale or capture transactions order included source subscription ids string list of included source subscription ids per order subscription information received from tenant enabled platforms including recharge and shopify plus order included subscription ids string list of included subscription ids per order subscription information received from tenant enabled platforms including recharge and shopify plus order is admin whether or not the order was created by an admin order is cancelled whether or not the order was cancelled if `cancelled at` is non null then we consider the order has being cancelled order is completed whether or not the order was completed an order is considered completed if it has a closed at timestamp and has been fully fulfilled closed at is generated for orders in shopify that are automatically archived if this feature is not enabled, the last updated closed fulfillment date is used as the completed at date order is first completed order whether the order was the customer's first completed order or not order is first order whether the order was the customer's first order or not order is first subscription completed order whether the order was the customer's first completed subscription order or not order is first subscription order whether the order was the customer's first subscription order or not order is part of subscription boolean flag to indicate whether the order was a part of a subscription plan or not order is test whether this is a test order or not order item id unique identifier generated by chord for an order order item is first product type order whether this order contains the first product type basket for the user order item is last product type order whether this order contains the last, most recent, product type basket for the user order item is repeat product type order whether this order contains a repeat product type basket for the user order item product basket count the count of products for a given order product basket the titles of products for a given orderarray converted to a string order item product purchased quantity the total number of product purchased for a given order order item rank product type order rank orders with the same product type basket per user order item unique product basket count the count of unique products for a given order unique product basket the unique titles of products for a given order array converted to a string order item unique product type the unique line item product types for a given order order item unique variant basket count the count of unique skus for a given order unique variant basket the unique skus of variants for a given order array converted to a string order item variant basket count the count of variants for a given order variant basket the skus of variants for a given order array converted to a string order item variant purchased quantity the total number of variants purchased for a given order order name unique name generated by shopify that is displayed to the customer (e g order number of non reactivated subscriptions number of non reactivated subscriptions per order reactivation is a customer who returned after having canceled the first subscription order number of reactivated subscriptions number of reactivated subscriptions per order reactivation is a customer who returned after having canceled the first subscription order oms order id unique key generated by shopify that identifies an order order tags the order tags applied to a given order, in alphabetical order order tags count the total number of order tags for a given order order processing method how the payment was processed order segment anonymous id when available, this is where we store segment's anonymous id at the time of checkout order source name where did the order get created from 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 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 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 order cancelled at (universal) reflects when the order was cancelled in shopify universal time zone order completed at (central) the timestamp when this order became completed cental time zone order completed at (eastern) the timestamp when this order became completed eastern time zone order completed at (mountain) the timestamp when this order became completed mountain time zone order completed at (pacific) the timestamp when this order became completed pacific time zone order completed at (universal) the timestamp when this order became completed universal time zone order created at (central) reflects when the entity was first created in shopify cental time zone order created at (eastern) reflects when the entity was first created in shopify eastern time zone order created at (mountain) reflects when the entity was first created in shopify mountain time zone order created at (pacific) reflects when the entity was first created in shopify pacific time zone order created at (universal) reflects when the entity was first created in shopify universal time zone order last fulfillment at (universal) the maximum timestamp for the last update order fulfillment universal time zone order updated at (universal) reflects when the entity was last updated in shopify universal time zone 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 additional tax total when taxes are not included in the subtotal, this is total tax added to the order average fulfillment tax total total tax applied to the order's fulfillment fee 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 line item tax total total tax applied to the line items of the 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 non reactivated subscription unit total sum of unit price for non reactivated subscriptions per order reactivation is a customer who returned after having canceled the first subscription average payment capture total sum of successful capture transactions average payment total sum of all sales transaction with gateway of type 'shopify payments' average product basket count the count of products for a given order average product purchased quantity the total number of product purchased for a given order average promo total the total discounts applied to the price of the order in the location's currency average reactivated subscription unit total sum of unit price for reactivated subscriptions per order reactivation is a customer who returned after having canceled the first subscription average refund total sum of all the transactions that are of kind 'refund' applied to the order average tax total the sum of all the taxes applied to the order in the location's currency average total price the sum of all line item prices, discounts, shipping, taxes, and tips in the average transaction total sum of all sale transactions for the order average variant basket count the count of variants for a given order average variant purchased quantity the total number of variants purchased for a given order additional tax total when taxes are not included in the subtotal, this is total tax added to the order fulfillment tax total total tax applied to the order's fulfillment fee 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 line item tax total total tax applied to the line items of the 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` non reactivated subscription unit total sum of unit price for non reactivated subscriptions per order reactivation is a customer who returned after having canceled the first subscription payment capture total sum of successful capture transactions 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 product basket count the count of products for a given order product purchased quantity the total number of product purchased for a given order promo total the total discounts applied to the price of the order in the location's currency reactivated subscription unit total sum of unit price for reactivated subscriptions per order reactivation is a customer who returned after having canceled the first subscription refund total sum of all the transactions that are of kind 'refund' applied to the order 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 variant basket count the count of variants for a given order variant purchased quantity the total number of variants purchased for a given order x fct acc anonymous name description 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 current user address 1 the first line of the street address current user address 2 the optional second line of the address current user address city the city of the address current user address country the country of the address current user address name the full name of the customer, based on firstname and lastname current user address state the region of the address, such as the province, state, or district current user address zip the postal code of the address current 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 current 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 current 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 current user email the email associated with the user current 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 current 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 ] current user ip ip address associated with the user current 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 ] current user last segment anonymous id this column is not documented current user segment user id the unique id of the user current 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 ] current 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 first page browser locale locale of browser first page date day num of year the number representing the day of the year first page date id unique key that uniquify a date first page date month num of year the month number of the year first page device the device on which the event was sent from first 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', first page event table name the properly formatted name of the table of the event first page event text the name of the event first page event text id the slug of the event name, mapping to the page or track event table first 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 first page id unique key generated by segment for each tracking or page event first page oms id unique key generated by our models that uniquifies an oms first 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 first 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 ) first page query the query string portion of the url of the page first page referrer the referrer of the page the referrer is the webpage that sends visitors to the site using a link in first page title the title/name of the page first page url the url of the page first 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 first page segment user id the unique id of the user first page store id unique key generated by our models that uniquifies a store first page tenant id unique key generated by chord that uniquifies a tenant first 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 first page user id unique key generated by chord to identify the user first page utm campaign the campaign name represented by the utm tags first page utm content the campaign content represented by the utm tags first page utm medium the campaign medium represented by the utm tags first page utm source the campaign source represented by the utm tags first page utm term the campaign term represented by the utm tags first page website locale locale of website this will either be collected from the url or from the drop down link on the store first session activity count total count of activities, pave views and tracked events within the session first 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 first 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' first session attribution first page url has gclid indicates if the first page event of the session has a google click id first session attribution first page url has utm indicates if the first page event of the session has any utm information first session attribution has referrer indicates if the first page event of the session has a referrer host first session attribution medium the campaign medium represented by the utm tags for the first page event of the session first session attribution source the campaign source represented by the utm tags for the first page event of the session first session attribution sub channel sub channel is a granular level of attribution first 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 first session completed order ids array of order ids associated to the session id, as collected by order completed or checkout completed front end events first session completed order numbers array of order numbers associated to the session id, as collected by order completed or checkout completed front end events first session days since last session end the days between the last session's end and the start of this session first session device the device on which the event was sent from first 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', first session duration in seconds total seconds between start and end activities within the session first 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 first session has order completion flag for sessions with an order completed or checkout completed front end events first session id unique id for the session first session number session number per anonymous id first 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 first 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 last page browser locale locale of browser last page date day num of year the number representing the day of the year last page date id unique key that uniquify a date last page date month num of year the month number of the year last page device the device on which the event was sent from last 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 page event table name the properly formatted name of the table of the event last page event text the name of the event last page event text id the slug of the event name, mapping to the page or track event table last 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 page id unique key generated by segment for each tracking or page event last page oms id unique key generated by our models that uniquifies an oms last 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 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 page query the query string portion of the url of the page last page referrer the referrer of the page the referrer is the webpage that sends visitors to the site using a link in last page title the title/name of the page last page url the url of the page last 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 page segment user id the unique id of the user last page store id unique key generated by our models that uniquifies a store last page tenant id unique key generated by chord that uniquifies a tenant last 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 page user id unique key generated by chord to identify the user last page utm campaign the campaign name represented by the utm tags last page utm content the campaign content represented by the utm tags last page utm medium the campaign medium represented by the utm tags last page utm source the campaign source represented by the utm tags last page utm term the campaign term represented by the utm tags last 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 current user created at (universal) the timestamp when the user was created universal time zone current user first seen at (universal) the first time the user was seen on the site, identified as either anonymous id or user id universal time zone first page ts (universal) the timestamp calculated by segment correcting clock skew universal time zone first session end ts (universal) last activity timestamp for a session universal time zone first session last session end ts (universal) the timestamp of the previous session's end per blended user id, if this is not the user's first session universal time zone first session last session start ts (universal) the timestamp of the previous session's start per blended user id, if this is not the user's first session universal time zone first session start ts (central) first activity timestamp for a session cental time zone first session start ts (eastern) first activity timestamp for a session eastern time zone first session start ts (mountain) first activity timestamp for a session mountain time zone first session start ts (pacific) first activity timestamp for a session pacific time zone first session start ts (universal) first activity timestamp for a session universal time zone last page ts (universal) the timestamp calculated by segment correcting clock skew universal time zone user anonymous last seen ts (central) the last timestamp the anonymous id was registered, seen, on the site cental time zone user anonymous last seen ts (eastern) the last timestamp the anonymous id was registered, seen, on the site eastern time zone user anonymous last seen ts (mountain) the last timestamp the anonymous id was registered, seen, on the site mountain time zone user anonymous last seen ts (pacific) the last timestamp the anonymous id was registered, seen, on the site pacific time zone user anonymous last seen ts (universal) the last timestamp the anonymous id was registered, seen, on the site universal time zone