> For the complete documentation index, see [llms.txt](https://docs.chord.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chord.co/model-your-data/dbt-model-reference/salesforce/activities.md). # Activities ### x\_fct\_trans\_activities | Name | Description | | ----------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | 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 | This column is not documented. | | 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. | | Activity Session End Ts (Universal) | Last activity timestamp for a session - Universal Time Zone. | | Activity 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. | | Activity 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. | | Activity Session Start Ts (Central) | First activity timestamp for a session - Cental Time Zone. | | Activity Session Start Ts (Eastern) | First activity timestamp for a session - Eastern Time Zone. | | Activity Session Start Ts (Mountain) | First activity timestamp for a session - Mountain Time Zone. | | Activity Session Start Ts (Pacific) | First activity timestamp for a session - Pacific Time Zone. | | Activity Session Start Ts (Universal) | First activity timestamp for a session - Universal Time Zone. | | Activity Ts (Central) | The timestamp calculated by Segment correcting clock skew - Cental Time Zone. | | Activity Ts (Eastern) | The timestamp calculated by Segment correcting clock skew - Eastern Time Zone. | | Activity Ts (Mountain) | The timestamp calculated by Segment correcting clock skew - Mountain Time Zone. | | Activity Ts (Pacific) | The timestamp calculated by Segment correcting clock skew - Pacific Time Zone. | | Activity Ts (Universal) | The timestamp calculated by Segment correcting clock skew - Universal Time Zone. | | Last Seen Page Ts (Universal) | The timestamp calculated by Segment correcting clock skew - Universal Time Zone. | | Session Landing Page Ts (Universal) | The timestamp calculated by Segment correcting clock skew - Universal Time Zone. | | User Created At (Universal) | The timestamp when the user was created - Universal Time Zone. | | 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. | ### x\_fct\_current\_sales\_\_daily | Name | Description | | ----------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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. | | Ts (Universal) | The truncated UTC date the order was created - Universal Time Zone. | | Average Completed Order Count | The total count of orders created on the UTC date that have been completed. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. | | Average Created Order Count | The total count of orders created on the UTC date. | | Average Gross Sales | The gross sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. | | Average Net Revenue | The net sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. | | Average Placed Gross Revenue | Gross Revenue is the pre-tax, pre-adjusted total line item price (unit price \* quantity) + the fulfillment total. | | Average Placed Net Revenue | Net Revenue is the adjusted line item price (unit price \* quantity - line adjustments) + the adjusted fulfillment (fulfillment total - line adjustments) - order level adjustments - refunds. | | Completed Order Count | The total count of orders created on the UTC date that have been completed. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. | | Created Order Count | The total count of orders created on the UTC date. | | Gross Sales | The gross sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. | | Net Revenue | The net sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. | | Placed Gross Revenue | Gross Revenue is the pre-tax, pre-adjusted total line item price (unit price \* quantity) + the fulfillment total. | | Placed Net Revenue | Net Revenue is the adjusted line item price (unit price \* quantity - line adjustments) + the adjusted fulfillment (fulfillment total - line adjustments) - order level adjustments - refunds. | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.chord.co/model-your-data/dbt-model-reference/salesforce/activities.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.