Properties
-
Name – CustomerProductRollingPeriod
-
Label – Customer Product Rolling Period
Fields
-
Customer Id – String
-
Product Id – String
-
Customer Name – String
-
Customer Hierarchy – String
-
PFX Complete Customer Hierarchy – String
-
Customer Rank – Number
-
Product Name – String
-
Product Hierarchy – String
-
Product Rank – String
-
Cross Sell – Number
-
Opportunity Price – Number
-
Pricing Opportunity – Number
-
Revenue – Number
-
Prior Revenue – Number
-
Prior Profit – Number
-
Profit – Number
-
Quantity – Number
-
Price Realization – Number
-
Reference Price – Number
-
Reference Price Extended – Number
-
Price – Number
-
Margin % – Percentage
-
Unit Margin – Number
-
Discount % – Percentage
Example Values
|
Customer Id |
Product Id |
Customer Name |
Segmentation |
Industry |
PFX Complete Customer Hierarchy |
Customer Rank |
Product Name |
Business Unit |
Product Group |
Product Rank |
Cross Sell |
Opportunity Price |
Pricing Opportunity |
Price Realization |
Revenue |
Profit |
Prior Revenue |
Prior Profit |
Reference Price |
Reference Price Extended |
Price |
Margin % |
Unit Margin |
Discount % |
|
C-0107 |
P-0449 |
Barclay |
Biotech chemicals |
Chemical |
Biotech chemicals-Chemical |
10 |
Odor Absorber 4oz |
Industrial & Scientific |
Power Transmission Products |
8 |
418.0547 |
10.6783 |
0 |
0.973009 |
1998.1 |
1083.34 |
290.13 |
154.01 |
10.45253 |
1944.17 |
10.74247 |
0.542185 |
5.824409 |
-0.9538 |
|
C-0167 |
P-0369 |
Kitchenaid, WHIRLPOOL |
Security and surveillance systems |
Electrical equipment |
Security and surveillance systems-Electrical equipment |
10 |
Ball Joint Gage |
Test, Measure & Inspect |
Dimensional Measurement |
8 |
86.20484 |
55.13189 |
0 |
0.9248 |
2759.31 |
1187.71 |
|
|
51.0362 |
2551.81 |
55.1862 |
0.430437 |
23.7542 |
-0.8268 |
|
C-0270 |
P-0029 |
Broan |
Computer hardware |
Computer and electronic product |
Computer hardware-Computer and electronic product |
10 |
Digital 6" Inside Groove Vernier Caliper |
Test, Measure & Inspect |
Dimensional Measurement |
5 |
43.22753 |
91.7376 |
0 |
0.979298 |
6437.68 |
2477.48 |
9295.53 |
3704.93 |
90.063 |
6304.41 |
91.96686 |
0.384841 |
35.39257 |
-0.9735 |
Customer Product Rolling Period table is fixed to L12M aggregation (Last 12 full months).