Power BI Connector for Salesforce Data Cloud

Build 24.0.9175

Promotion

The Promotion DMO is a Data Cloud data model object (DMO) for loyalty promotion details such as the type of promotion.

Columns

Name Type References Description
Active Promotion Datetime The start date of the promotion.
Created Date Datetime The date the record was created.
Cumulative Usage Target Amount Double The target value of promotion based on frequency of participation.
Currency Varchar A reference ID to denomination of currency defined in promotion, for example, dollars or Euro.
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.
Default Voucher Definition Varchar A reference ID to the main voucher where other vouchers are awarded to individuals.
Description Varchar The description of the promotion.
Discount Buy Amount Double The order value, before surcharges, required to receive a discount.
Discount Buy Count Double The quantity that must be purchased to receive discount or quantity of free product.
Discount Exclusivity Type Varchar A reference ID to cases where promotion recipients qualify for discounts in more than one way.
Discount Type Varchar A reference ID to types of discounts available in promotion, for example fixed price or percentage-off.
Discount Value Amount Double The amount deducted from an order subtotal if conditions are met.
End Date Datetime The last date the promotion is available to customers.
Enrollment End Date Datetime The last date when customers can enroll in the promotion.
Enrollment Start Date Datetime The first date when customers can enroll in the promotion.
Evaluation Order Rank Double The order of applying promotions to the product cost.
External Record ID Varchar A reference ID to an external data source system.
External Source ID Varchar A reference ID for the system in which the external record ID was assigned.
Fulfillment Action Varchar A reference ID to how marketing promotion provides values to customer, for example via loyalty points, cash discounts, or voucher.
Inactive Promotion Datetime The date when the promotion becomes inactive.
Internal Organization Varchar A reference ID to the business unit or other internal organization that owns the business account.
Is Active Varchar An indicator if the promotion is available to customers.
Is Enrollment Required Varchar An indicator if the promotion can only be applied to persons who have enrolled in it.
Last Modified Date Datetime The date when a user last modified the record.
Lead Varchar A reference ID to person or company that showed interest in company's products.
Lead Source Varchar A reference ID to the source where the lead was obtained.
Loyalty Program Varchar A reference ID to marketing strategy designed to encourage customers to continue shopping at or use services of a business associated with the program.
Loyalty Program Currency Varchar A reference ID to the value or currency the loyalty program offers to customers.
Name Varchar The promotion’s name.
Objective Varchar The business goal of the promotion, for example, a
Points Quantity Double The points awarded during a promotion.
Primary Campaign Varchar A reference ID to a marketing project that you want to plan, manage, and track.
Promotion Class Varchar A reference ID to categories of promotions, for example, product, order, or shipping.
Promotion Id Varchar A unique ID used as primary key for the Promotion DMO.
Promotion Method Varchar A reference ID to the method of promotion, for example, displays, coupons, or a contest.
Promotion Reason Varchar A reference ID to why promotion was created, for example advertising or publicity.
Promotion Status Varchar A reference ID to status of marketing promotion, for example draft, activated, or complete.
Promotion Type Varchar A reference ID to type of promotion.
Promotional Image Varchar A graphic used to enhance promotion in a digital format.
Promotional Message Varchar A message displayed to possible consumers of promotion, for example,
PromotionMarketSegments relationship Varchar
Start Date Datetime The date the promotion is available to customers.
Total Reward Value Amount Double The total savings or reward value accumulated for promotion.

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