Power BI Connector for Salesforce Data Cloud

Build 24.0.9175

ShoppingCartEngagement

The Shopping Cart Engagement DMO is a Data Cloud Data Platform data model object (DMO) for data captured from user actions, such as adding and removing items from a shopping cart.

Columns

Name Type References Description
Account Contact Varchar A reference ID to account contact.
Action Cadence Step Varchar A reference ID to action cadence step.
Adjusted Total Product Amount Double The total product amount after any adjustments.
Case Varchar A reference ID to a recorded issue, for example laptop connectivity.
Contact Point Varchar A reference ID to the accounts’ contact point, for example physical address, email address, or phone number.
Created Date Datetime The date the record was created.
Currency Varchar A reference ID to the type of currency used.
Data Source Varchar A reference ID for the logical name referring to the source of records also identified as the external source ID.
Data Source Object Varchar A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object.
Device Country Varchar A reference ID to the country where the device is located.
Device IP Address Varchar The IP address of the device.
Device Latitude Double The Geo latitude of the device when engagement was recorded.
Device Locale Varchar A reference ID to the user locale configured on the device.
Device Longitude Double The Geo longitude of device when engagement was recorded.
Device Postal Code Varchar The postal code associated with the device.
Engagement Asset Varchar A reference ID to the engagement asset.
Engagement Channel Varchar A reference ID to the engagement channel.
Engagement Channel Action Varchar A reference ID to the action taken in the engagement channel.
Engagement Channel Type Varchar A reference ID to the type of engagement channel.
Engagement Date Time Datetime The date and time of engagement. Since the engagement happens after send, the engagement date must be after the Send Date Time.
Engagement Event Direction Varchar A reference ID to the engagement event direction, such as inbound or outbound.
Engagement Notes Varchar The details and notes about the engagement.
Engagement Number Varchar A non-automatic, user-facing ID.
Engagement Publication Varchar A reference ID to a background process that generates volumes of email messages, SMS messages, or other Engagement Vehicle types.
Engagement Type Varchar A reference ID to the type of engagement, for example email or phone.
Engagement Vehicle Varchar A reference ID to the vehicle where the engagement was recorded.
External Record ID Varchar A reference ID to an external data source system.
External Source ID Varchar A reference ID to system that External Record Id was assigned.
Individual Varchar A reference ID to a contact for the account.
Internal Engagement Actor Varchar A reference ID to an engagement actor that groups the different types of individuals targeted for marketing engagements, for example leads and account contacts.
Internal Organization Varchar A reference ID to the business unit or other internal organization that owns the business account.
Is Gift Order Varchar A flag to indicate if the order is a gift.
Is Test Send Varchar A flag to indicate if an engagement record was generated as part of testing.
Last Modified Date Datetime The date when a user last modified the record.
Lead Varchar A reference ID to a person or company that showed interest in products.
Link URL Varchar A link to the web page accessed during the engagement.
Market Audience Varchar A reference ID to the intended audience that engagement was designed to reach.
Market Journey Activity Varchar A reference ID to a step or activity that a customer configures in Salesforce Journey Builder tool for marketing associated with engagement.
Market Segment Varchar A reference ID to a group of people who share one or more common characteristics, and are grouped for marketing associated with engagement.
Marketing Email List Varchar A reference ID to the marketing email list used for the engagement.
Name Varchar The name of the engagement.
Net Order Amount Double The order amount.
Product Varchar A reference ID to a product intended to be sold, for example goods, services, bundles, or made-to-order products.
Product Brand Varchar The brand of a product, for example Northern Trail Outfitters.
Product Category Varchar The class of products, such as shoes or hats.
Product Color Varchar The color variant of a product displayed on the search result.
Product Display Position Number Double The position number where the product is displayed.
Product Display Position Double The numeric position of the product in the displayed list.
Product Image URL Varchar A link to the page that hosts the product photo or image.
Product Price Double The price of the product displayed on the search result.
Product Quantity Double The product package quantity that is displayed on the search result.
Product SKU Varchar A product’s Stock Keeping Unit (SKU).
Product SKU Varchar The Stock Keeping Unit (SKU) number.
Product Style Varchar The product style displayed on the search result.
Product View URL Varchar A link to the detail page about the product displayed on the search result.
Promotion Coupon Varchar A reference ID to payment in the form of a voucher entitling the holder to a discount on a particular product.
Referrer URL Varchar The URL of an application that directed the user to the software application that generated engagement.
Sales Order Varchar An internal document generated by the seller indicating that the customer is ready to purchase products and services.
Sent Date Time Datetime The date and time of send.
Session Varchar A reference ID to a session used to group related events together.
Shopping Cart Varchar A reference ID to the shopping cart for data captured from user actions, for example adding or removing items from the shopping cart.
Shopping Cart Engagement ID Varchar A unique ID used as the primary key for the Shopping Cart Engagement DMO.
Shopping Cart Event Type Varchar A reference ID to the type of shopping cart interaction.
Target Engagement Actor Varchar A reference ID to an engagement actor that groups different types of individuals targeted for marketing associated with engagement, for example leads and account contacts.
Task Varchar A reference ID to business activity, for example making a phone call. In the user interface, tasks and event records are collectively referred to as activities.
Total Adjustment Amount Double The total amount after any adjustments.
Total Delivery Amount Double The total amount of delivery costs.
Total Product Amount Double The total product amount.
Total Product Quantity Double The total number of a product.
Total Product Tax Amount Double The total tax amount of the product.
Total Tax Amount Double The total tax amount.
Web Cookie Varchar A reference ID to a small piece of data sent from a website and stored on the user's computer by the user's web browser while the user is browsing.
Workflow Varchar A reference ID to the sequence of steps or processes from initiation to completion.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175