Shopping Cart Engagement DMO

Object API Name: ssot__ShoppingCartEngagement__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• EngagementChannelTypeId has a FOREIGNKEY relationship with the Engagement Channel Type DMO Id field.
• EngagementAssetId has a FOREIGNKEY relationship with the SMS Template DMO Id field.
• EngagementAssetId has a FOREIGNKEY relationship with the Email Template DMO Id field.
• MarketJourneyActivityId has a FOREIGNKEY relationship with the Market Journey Activity DMO Id field.
• LeadlId has a FOREIGNKEY relationship with the Lead DMO Id field.
• IndividualId has a FOREIGNKEY relationship with the Individual DMO Id field.
• EngagementPublicationId has a FOREIGNKEY relationship with the SMS Publication DMO Id field.
• EngagementPublicationId has a FOREIGNKEY relationship with the Email Publication DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Bundle Product DMO Id field.
• MarketSegmentId has a FOREIGNKEY relationship with the Market Segment DMO Id field.
• SalesOrderId has a FOREIGNKEY relationship with the Sales Order DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Master Product DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Goods Product DMO Id field.
• ContactPointId has a FOREIGNKEY relationship with the Contact Point Social DMO Id field.
• ContactPointId has a FOREIGNKEY relationship with the Contact Point Phone DMO Id field.
• ContactPointId has a FOREIGNKEY relationship with the Contact Point Email DMO Id field.
• ContactPointId has a FOREIGNKEY relationship with the Contact Point App DMO Id field.
• ContactPointId has a FOREIGNKEY relationship with the Contact Point Address DMO Id field.
• CaseId has a FOREIGNKEY relationship with the Case DMO Id field.
• AccountContactId has a FOREIGNKEY relationship with the Account Contact DMO Id field.
• EngagementAssetId has a FOREIGNKEY relationship with the Device Application Template DMO Id field.
• UtmId has a FOREIGNKEY relationship with the Campaign DMO Id field.

• AccountContactId
• ActionCadenceStepId
• AdjustedTotalProductAmount
• BrowserName
• BrowserRenderEngineName
• BrowserVendorName
• BrowserVersionNumber
• CaseId
• cdp_sys_record_currency
• CheckoutId
• ContactPointId
• CorrelationId
• CreatedDate
• CurrencyId
• DataSourceId
• DataSourceObjectId
• DeviceCountryId
• DeviceIPAddress
• DeviceLatitude
• DeviceLocaleId
• DeviceLongitude
• DeviceModelName
• DevicePostalCode
• DeviceType
• DeviceVendorName
• EngagementAssetId
• EngagementChannelActionId
• EngagementChannelActionStatus
• EngagementChannelId
• EngagementChannelTypeId
• EngagementDateTm
• EngagementEventDirectionId
• EngagementNbr
• EngagementNotesTxt
• EngagementPublicationId
• EngagementTypeId
• EngagementVehicleId
• ExternalRecordId
• ExternalSourceId
• Id
• IndividualId
• InternalEngagementActorId
• InternalOrganizationId
• IsGiftOrder
• IsPageView
• IsRecognizedBrowser
• IsTestSend
• KQ_AccountContactId
• KQ_CaseId
• KQ_ContactPointId
• KQ_EngagementAssetId
• KQ_EngagementChannelTypeId
• KQ_EngagementPublicationId
• KQ_Id
• KQ_IndividualId
• KQ_LeadlId
• KQ_MarketJourneyActivityId
• KQ_MarketSegmentId
• KQ_ProductId
• KQ_SalesOrderId
• KQ_UtmId
• LastModifiedDate
• LeadlId
• LinkURL
• MarketAudienceId
• MarketingEmailListId
• MarketJourneyActivityId
• MarketSegmentId
• Name
• NetOrderAmount
• OSModelName
• OSName
• OSVendor
• OSVersionNumber
• PageId
• PageName
• PagePublicTitleName
• PageURL
• PerslServiceProviderName
• PersonalizationContentId
• PersonalizationId
• PersonalizationRequestId
• ProductBrandName
• ProductCategoryName
• ProductColorName
• ProductDisplayPosition
• ProductDisplayPositionNumber
• ProductId
• ProductImageURL
• ProductPriceAmount
• ProductQuantity
• ProductSKU
• ProductSKUNumber
• ProductStyleName
• ProductViewURL
• PromotionCouponId
• Referrer
• ReferrerURL
• SalesChannelId
• SalesOrderId
• ScreenHeightPixelsQuantity
• ScreenWidthPixelsQuantity
• SearchResultId
• SearchResultPageNumber
• SearchResultPositionInPageNumber
• SearchResultPositionNumber
• SearchResultTitleText
• SentDateTm
• SessionId
• ShoppingCartEventTypeId
• ShoppingCartId
• TargetEngagementActorId
• TaskId
• TotalAdjustmentAmount
• TotalDeliveryAmount
• TotalProductAmount
• TotalProductQuantity
• TotalProductTaxAmount
• TotalTaxAmount
• UIComponentId
• UserAgentText
• UtmCampaignName
• UtmContentDescription
• UtmId
• UtmMediumName
• UtmSourceName
• UtmSourcePlatformName
• UtmTermDescription
• WebCookieId
• WebpageType
• WebSession
• WebsiteId
• WebStoreId
• WorkflowId

• Field API Name: ssot__AccountContactId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ActionCadenceStepId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__AdjustedTotalProductAmount__c
• Data Type: DOUBLE
• Description: Price of all cart items, after applying discounts and coupons (Total Product Amount: Total Adjustment Amount).

• Field API Name: ssot__BrowserName__c
• Data Type: TEXT
• Description: Name of the browser used during the engagement.

• Field API Name: ssot__BrowserRenderEngineName__c
• Data Type: TEXT
• Description: A library used in a browser to parse content, examples include: Webjet (Apple), Webkit (Google), EdgeHTML/Blink (Google), Edge (MS).

• Field API Name: ssot__BrowserVendorName__c
• Data Type: TEXT
• Description: Name of the vendor that provides the user’s web browser.

• Field API Name: ssot__BrowserVersionNumber__c
• Data Type: TEXT
• Description: Version of the Browser.

• Field API Name: ssot__CaseId__c
• Data Type: TEXT
• Description: The unique identifier for the related Case record.

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ssot__CheckoutId__c
• Data Type: TEXT
• Description: Identifies an instance of the Checkout process that resulted in the Shopping Cart.

• Field API Name: ssot__ContactPointId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__CorrelationId__c
• Data Type: TEXT
• Description: An ID generated in the client during a search or other engagement, that’s available in Engagement types that operate on search results.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: Date and time when this record was created.

• Field API Name: ssot__CurrencyId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DeviceCountryId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DeviceIPAddress__c
• Data Type: TEXT
• Description: Alphanumeric string representing the device ipaddress.

• Field API Name: ssot__DeviceLatitude__c
• Data Type: DOUBLE
• Description: Numeric value representing the device latitude. Do not include currency symbols or commas.

• Field API Name: ssot__DeviceLocaleId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DeviceLongitude__c
• Data Type: DOUBLE
• Description: Numeric value representing the device longitude. Do not include currency symbols or commas.

• Field API Name: ssot__DeviceModelName__c
• Data Type: TEXT
• Description: Model name of the device used during the engagement.

• Field API Name: ssot__DevicePostalCode__c
• Data Type: TEXT
• Description: Alphanumeric string representing the device postal code.

• Field API Name: ssot__DeviceType__c
• Data Type: TEXT
• Description: Type of device used during the engagement, such as mobile, tablet, or desktop.

• Field API Name: ssot__DeviceVendorName__c
• Data Type: TEXT
• Description: Name of the maker of the device used in the engagement.

• Field API Name: ssot__EngagementAssetId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EngagementChannelActionId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EngagementChannelActionStatus__c
• Data Type: TEXT
• Description: The result of the user’s Action (browse, open, click), typically Success or Failure.

• Field API Name: ssot__EngagementChannelId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EngagementChannelTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EngagementDateTm__c
• Data Type: DATETIME
• Description: The date and time of the engagement date tm.

• Field API Name: ssot__EngagementEventDirectionId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EngagementNbr__c
• Data Type: TEXT
• Description: Alphanumeric string representing the engagement nbr.

• Field API Name: ssot__EngagementNotesTxt__c
• Data Type: TEXT
• Description: Alphanumeric string representing the engagement notes txt.

• Field API Name: ssot__EngagementPublicationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EngagementTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__EngagementVehicleId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ExternalRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ExternalSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this ShoppingCartEngagement record. Maximum size is 36 characters.

• Field API Name: ssot__IndividualId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__InternalEngagementActorId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__IsGiftOrder__c
• Data Type: TEXT
• Description: Is the whole order a gift order.

• Field API Name: ssot__IsPageView__c
• Data Type: TEXT
• Description: True if the event involved a user viewing the web page or App.

• Field API Name: ssot__IsRecognizedBrowser__c
• Data Type: BOOLEAN
• Description: True if the user’s browser is a known type.

• Field API Name: ssot__IsTestSend__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is test send.

• Field API Name: KQ_AccountContactId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountContactId

• Field API Name: KQ_CaseId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CaseId

• Field API Name: KQ_ContactPointId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ContactPointId

• Field API Name: KQ_EngagementAssetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EngagementAssetId

• Field API Name: KQ_EngagementChannelTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EngagementChannelTypeId

• Field API Name: KQ_EngagementPublicationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EngagementPublicationId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_IndividualId__c
• Data Type: TEXT
• Description: Key Qualifier system field for IndividualId

• Field API Name: KQ_LeadlId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LeadlId

• Field API Name: KQ_MarketJourneyActivityId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MarketJourneyActivityId

• Field API Name: KQ_MarketSegmentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MarketSegmentId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: KQ_SalesOrderId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SalesOrderId

• Field API Name: KQ_UtmId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtmId

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: Date and time when a user last modified this record.

• Field API Name: ssot__LeadlId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__LinkURL__c
• Data Type: TEXT
• Description: The URL for link url.

• Field API Name: ssot__MarketAudienceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__MarketingEmailListId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__MarketJourneyActivityId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__MarketSegmentId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: The primary name or label for this record.

• Field API Name: ssot__NetOrderAmount__c
• Data Type: DOUBLE
• Description: Cart order price after applying coupons, promotions and adjustments, and including taxes and shipping.

• Field API Name: ssot__OSModelName__c
• Data Type: TEXT
• Description: Alphanumeric string representing the osmodel name.

• Field API Name: ssot__OSName__c
• Data Type: TEXT
• Description: Alphanumeric string representing the osname.

• Field API Name: ssot__OSVendor__c
• Data Type: TEXT
• Description: Name of the Operating System’s seller, for example Apple or Google.

• Field API Name: ssot__OSVersionNumber__c
• Data Type: TEXT
• Description: Alphanumeric string representing the osversion number.

• Field API Name: ssot__PageId__c
• Data Type: TEXT
• Description: Unique Id of the web page the user viewed when the engagement was recorded.

• Field API Name: ssot__PageName__c
• Data Type: TEXT
• Description: The name of the web page where the engagement user viewed content.

• Field API Name: ssot__PagePublicTitleName__c
• Data Type: TEXT
• Description: The title displayed to users on the landing page where they viewed content.

• Field API Name: ssot__PageURL__c
• Data Type: TEXT
• Description: The URL of the page the user accessed.

• Field API Name: ssot__PerslServiceProviderName__c
• Data Type: TEXT
• Description: Name of the personalization service provider associated with the engagement.

• Field API Name: ssot__PersonalizationContentId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__PersonalizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__PersonalizationRequestId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ProductBrandName__c
• Data Type: TEXT
• Description: What is the brand of the product. For example, Snike shoes.

• Field API Name: ssot__ProductCategoryName__c
• Data Type: TEXT
• Description: Classes of products (shoes, hats) within a larger catalog.

• Field API Name: ssot__ProductColorName__c
• Data Type: TEXT
• Description: The product color variant displayed on the search result.

• Field API Name: ssot__ProductDisplayPosition__c
• Data Type: DOUBLE
• Description: Numeric value representing the product display position. Do not include currency symbols or commas.

• Field API Name: ssot__ProductDisplayPositionNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the product display position number. Do not include currency symbols or commas.

• Field API Name: ssot__ProductId__c
• Data Type: TEXT
• Description: What is intended to be sold. For example, goods, services, bundles, made to order products.

• Field API Name: ssot__ProductImageURL__c
• Data Type: TEXT
• Description: link to a page that hosts a product photo or image.

• Field API Name: ssot__ProductPriceAmount__c
• Data Type: DOUBLE
• Description: The product price displayed on the search result.

• Field API Name: ssot__ProductQuantity__c
• Data Type: DOUBLE
• Description: The product package quantity displayed on the search result.

• Field API Name: ssot__ProductSKU__c
• Data Type: TEXT
• Description: Alphanumeric string representing the product sku.

• Field API Name: ssot__ProductSKUNumber__c
• Data Type: TEXT
• Description: Alphanumeric string representing the product skunumber.

• Field API Name: ssot__ProductStyleName__c
• Data Type: TEXT
• Description: The product style displayed on the search result.

• Field API Name: ssot__ProductViewURL__c
• Data Type: TEXT
• Description: Link to detail page about a product that was displayed.

• Field API Name: ssot__PromotionCouponId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Referrer__c
• Data Type: TEXT
• Description: Alphanumeric string representing the referrer.

• Field API Name: ssot__ReferrerURL__c
• Data Type: TEXT
• Description: URL of the referrer website.

• Field API Name: ssot__SalesChannelId__c
• Data Type: TEXT
• Description: Which channel is used to sell goods. For example, Web Store, Retail Store, Street Faire.

• Field API Name: ssot__SalesOrderId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ScreenHeightPixelsQuantity__c
• Data Type: DOUBLE
• Description: Screen height in pixels.

• Field API Name: ssot__ScreenWidthPixelsQuantity__c
• Data Type: DOUBLE
• Description: Screen width in pixels.

• Field API Name: ssot__SearchResultId__c
• Data Type: TEXT
• Description: A context ID that relates a user’s search and any actions taken upon the results returned by that search.

• Field API Name: ssot__SearchResultPageNumber__c
• Data Type: DOUBLE
• Description: The page number of the search results based on pagination.

• Field API Name: ssot__SearchResultPositionInPageNumber__c
• Data Type: DOUBLE
• Description: The position of the result in a particular page.

• Field API Name: ssot__SearchResultPositionNumber__c
• Data Type: DOUBLE
• Description: The absolute position in the backend result set (product or component).

• Field API Name: ssot__SearchResultTitleText__c
• Data Type: TEXT
• Description: Title of a search result.

• Field API Name: ssot__SentDateTm__c
• Data Type: DATETIME
• Description: The date and time of the sent date tm.

• Field API Name: ssot__SessionId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ShoppingCartEventTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__ShoppingCartId__c
• Data Type: TEXT
• Description: Facilitates the purchase of a product or service, customers can select, review, and modify items in a shopping cart before placing a sales order.

• Field API Name: ssot__TargetEngagementActorId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__TaskId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__TotalAdjustmentAmount__c
• Data Type: DOUBLE
• Description: Sum of Total Adjustment Amount on all cart items.

• Field API Name: ssot__TotalDeliveryAmount__c
• Data Type: DOUBLE
• Description: Sum of Delivery Cost Amount on all cart items.

• Field API Name: ssot__TotalProductAmount__c
• Data Type: DOUBLE
• Description: Sum of Total Unit Price Amount and Total Adjustment Tax Amount on all line items.

• Field API Name: ssot__TotalProductQuantity__c
• Data Type: DOUBLE
• Description: The total quantity of products on all line items.

• Field API Name: ssot__TotalProductTaxAmount__c
• Data Type: DOUBLE
• Description: The total taxes for all product on the cart order.

• Field API Name: ssot__TotalTaxAmount__c
• Data Type: DOUBLE
• Description: Sum of Total Product Tax Amount on all cart items, net of adjustments.

• Field API Name: ssot__UIComponentId__c
• Data Type: TEXT
• Description: A GUID that uniqley identifies a UI component on the page the user viewed.

• Field API Name: ssot__UserAgentText__c
• Data Type: TEXT
• Description: Full user agent string identifying the browser, operating system, and device used during the engagement.

• Field API Name: ssot__UtmCampaignName__c
• Data Type: TEXT
• Description: The name of a Marketing Campaign.

• Field API Name: ssot__UtmContentDescription__c
• Data Type: TEXT
• Description: Used to differentiate creatives. For example, if you have two call-to-action links within the same email message, you can use utm_content and set different values for each so you can tell which version is more effective.

• Field API Name: ssot__UtmId__c
• Data Type: TEXT
• Description: Id of the Urchin Tracking Module (UTM), which is a set of one or more code snippets that are added to a URL to support tracking. The UTM Id usually stores the ID of a Campaign.

• Field API Name: ssot__UtmMediumName__c
• Data Type: TEXT
• Description: Identifies the vehicles that you are using to market your company.

• Field API Name: ssot__UtmSourceName__c
• Data Type: TEXT
• Description: Identifies the subchannel that’s the source of the engagement, for example Facebook or Instagram.

• Field API Name: ssot__UtmSourcePlatformName__c
• Data Type: TEXT
• Description: The platform responsible for directing traffic to a given Analytics property (such as a buying platform that manages organic traffic data). For example: Search Ads 360 or Display & Video 360.

• Field API Name: ssot__UtmTermDescription__c
• Data Type: TEXT
• Description: A paid keyword. Maximum size is 255 characters.

• Field API Name: ssot__WebCookieId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__WebpageType__c
• Data Type: TEXT
• Description: Types of pages a website. Examples include: Home, Landing, and CMS Content.

• Field API Name: ssot__WebSession__c
• Data Type: TEXT
• Description: Identifier for the web session associated with the engagement.

• Field API Name: ssot__WebsiteId__c
• Data Type: TEXT
• Description: A site that’s hosted on the internet.

• Field API Name: ssot__WebStoreId__c
• Data Type: TEXT
• Description: A website by means of which goods, services, or software may be purchased or obtained.

• Field API Name: ssot__WorkflowId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.