A customer needs to send the Effective Price key performance indicator (KPI) value, calculated at the promotion level, to an external system for each product.
How should a consultant recommend doing this?
A.
Generate Tactic Product conditions and send the records generated from the Salesforce object through a supported Salesforce integration tool.
B.
Enable the writeback of the Effective Price KPI and keep storage level as Product, and extract the data using standard Integration application programming interface (APIs) or Real-Time Reporting (RTR) CSV Extracts.
C.
Identify the Cost and Volume KPI and enable the writeback of these two KPIs at the Product storage level as a helper value to be sent using standard Integration APIs or RTR CSV Extracts.
In Consumer Goods Cloud TPM, many KPIs (like Effective Price) are calculated "on the fly" by the processing engine in the browser or the calculation grid. They do not automatically exist as stored data records in the database that an external integration tool can simply "query."
To make a calculated KPI available for integration (extraction to an ERP or Data Warehouse), you must configureWriteback. Writeback instructs the system to physically save the calculated value into a storage table (typically the Promotion Product or a generic Measurement table) whenever the promotion is saved.
The requirement asks specifically for the value "for each product." Therefore, theStorage Levelmust be set toProduct. If it were set to "Tactic" or "Promotion," the granular product-level price data would be aggregated and lost. Once Writeback is enabled and the storage level is correct, the data exists as physical records in Salesforce objects. These can then be extracted using standard methods like theIntegration APIsorRTR CSV Extracts. Option B describes this exact configuration workflow: Enable Writeback -> Set Level to Product -> Extract via API. Option A discusses "Conditions" which is a different concept related to pricing logic, not generic KPI extraction.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit