Loading
Set Up Trade Promotion Management
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Example: Values for Custom Periods

            You are here:

            1. Salesforce Help
            2. Docs
            3. Set up and Maintain Trade Promotion Management

            Example: Values for Custom Periods

            Here’s an example to explain how values are read from weekly measure tables for custom periods with time scopes.

            Required Editions

            Available in: Lightning Experience

            Available in: Enterprise and Unlimited Editions where Consumer Goods Cloud is enabled
            Example
            Example

            The relevant tables are:

            • Weekly Measure Real
            • Weekly Measure Int
            • Promotion Tactic Weekly Measure Real

            Here’s a set of data.

            Sample data

            The promotion timeframe spans from Wed, Nov 11 to Sat, Nov 28 and the in-store timeframe spans from Tue, Nov 17 to Mon, Nov 23. The promotion timeframe spans across three periods, and the value of each period is determined based on the week day share profile. Here’s how the values are calculated:The resultant value of the promotion timeframe is the sum of the values of P1, P2, and P3 = 50 + 340 + 160 = 450.

            • Value of P1 = (50% of 100) = 50
            • Value of P2 = (20% of 100) + (80% of 400) = 340
            • Value of P3 = (20% of 400) + (80% of 100) = 160

            The in-store timeframe is determined based on the week day share profiles and the values stored in the relevant database table. So, value of the in-store timeframe = (70% of 400) + ((20% of 400) + (10% of 100)) = 280 + 90 = 370.

             
            Loading
            Salesforce Help | Article