Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
8.33cm
Title Top
4.78cm
Content Top
Validation Tool Practical Exercises
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
© XTEL 2024. All rights reserved. Confidential treatment requested
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 01
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 01
8.33cm
Title Top
4.78cm
Content Top
0 cm
How would you get the weeks in the red box flagged? Response: These weeks should not be flagged, as they correspond to a seasonal event (NEW YEAR). As a rule, you could add that during seasonal events flagging will only occur if there is a price drop, indicating a promotion took place, or if there is 80% ACV or promo volume, suggesting a promotion occurred during this period.
Next
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 02
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 03
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 05
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 02
8.33cm
Title Top
4.78cm
Content Top
0 cm
Have these TPM promotions correctly been removed? Response: Yes, as we don’t see the most important metrics of promo indications being uplift & price drop. (PRICE_FLAGGING_DROP_PERC & MISSING_MULTIPLIER) You do see a lot of promo volume on some weeks, but you can never solely flag on promo volume as these are not always accurate in sellout (eg Nielsen can indicate displays only as also promo volume, ..) If you want to use promo volume as a metric to flag you should always combine it with lift rule
Next
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 03
8.33cm
Title Top
4.78cm
Content Top
0 cm
Do we have everything we need to start the flaggings process? Response: No, we are experiencing an issue with the baseline being too low at the beginning of the scope. This problem will automatically flag all the initial weeks of the scope for all products, as the baseline is nearly zero. This should be addressed with your Data Analyst to resolve it before initiating flagging.
Next
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 05
8.33cm
Title Top
4.78cm
Content Top
0 cm
Is there anything wrong with the data in this image? Response: The weekly price is consistently lower than the base price, which is incorrect. During neutral weeks, you would expect the base price to equal the weekly price. This discrepancy results in a constant 2% or more price drop, which will trigger flaggings if your rule is set at 2% for that CUSTOMER/CATEGORY pair. To resolve this issue, you should contact your Data Analyst to adjust the base price accordingly.
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Autoflagger exercises
Elsa Wong
Created on March 6, 2025
Start designing with a free template
Discover more than 1500 professional designs like these:
View
Branching Scenario Mission: Innovating for the Future
View
Piñata Challenge
View
Teaching Challenge: Transform Your Classroom
View
Frayer Model
View
Math Calculations
View
Interactive QR Code Generator
View
Interactive Scoreboard
Explore all templates
Transcript
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
8.33cm
Title Top
4.78cm
Content Top
Validation Tool Practical Exercises
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
© XTEL 2024. All rights reserved. Confidential treatment requested
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 01
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 01
8.33cm
Title Top
4.78cm
Content Top
0 cm
How would you get the weeks in the red box flagged? Response: These weeks should not be flagged, as they correspond to a seasonal event (NEW YEAR). As a rule, you could add that during seasonal events flagging will only occur if there is a price drop, indicating a promotion took place, or if there is 80% ACV or promo volume, suggesting a promotion occurred during this period.
Next
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 02
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 03
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Practical Exercises 05
8.33cm
Title Top
4.78cm
Content Top
0 cm
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 02
8.33cm
Title Top
4.78cm
Content Top
0 cm
Have these TPM promotions correctly been removed? Response: Yes, as we don’t see the most important metrics of promo indications being uplift & price drop. (PRICE_FLAGGING_DROP_PERC & MISSING_MULTIPLIER) You do see a lot of promo volume on some weeks, but you can never solely flag on promo volume as these are not always accurate in sellout (eg Nielsen can indicate displays only as also promo volume, ..) If you want to use promo volume as a metric to flag you should always combine it with lift rule
Next
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 03
8.33cm
Title Top
4.78cm
Content Top
0 cm
Do we have everything we need to start the flaggings process? Response: No, we are experiencing an issue with the baseline being too low at the beginning of the scope. This problem will automatically flag all the initial weeks of the scope for all products, as the baseline is nearly zero. This should be addressed with your Data Analyst to resolve it before initiating flagging.
Next
6.35 cm
Content Bottom
7.54 cm
Image Bottom
Middle 0cm
15.93cm
15.93 cm
Left Margin
Right Margin
0.26cm
0.26cm
Exercise Solutions and Feedback 05
8.33cm
Title Top
4.78cm
Content Top
0 cm
Is there anything wrong with the data in this image? Response: The weekly price is consistently lower than the base price, which is incorrect. During neutral weeks, you would expect the base price to equal the weekly price. This discrepancy results in a constant 2% or more price drop, which will trigger flaggings if your rule is set at 2% for that CUSTOMER/CATEGORY pair. To resolve this issue, you should contact your Data Analyst to adjust the base price accordingly.
6.35 cm
Content Bottom
7.54 cm
Image Bottom