Promotion Consultant

Role Overview

Coupon Code Issuance, Forecasting & Actualization: Maintain Colgate Coupon database (NCH) and provide redemption estimates across all Brands & Tactics (approximately 2,000 offers per year) Solicit outside estimates from vendors when no good historical comparison can be made.

Compile and deliver monthly coupon redemption reports as well as Semi Annual Top Redeemer report to extended Teams for all CP coupons. Provide Senior Finance team Class of Trade reports by Retailer for budget allocation process.

Input all program details and costs into the National Clearing House database for compilation of Colgate coupon database.

Monthly audit of coupon database with CP Mumbai - provide back up and any revisions that need to be made within the NCH system for the true up process

Issue/dissemination of offer codes/UPC bars for all Colgate/Tom's of Maine/Colgate Canada coupons

Maintain approvals of all issued Colgate coupons for PWC audit purposes. Provide input into the yearly PWC audit by meeting with the PWC team and providing any requested documentation and clarification of the Colgate process.

Meet with account specific Teams to align on digital coupon costs and rationale.

Data/Analytics: - ROI market mix analysis exercises with various teams (Analytic Partners):

• Compile historical redemption reports by event and by customer for CMM's.
• API integration projects with Colgate/outside contractors (Colgate Analytics Team/Sigma)
• SKU level detail analysis as requested
• Post program analysis (i.e. top redeemer reports, sku level analysis, etc) as requested
• Analysis of account specific digital programs (all brand groups) vs. YAG
• Weekly update of all national oral care, personal care and household care digital programs

Fraud Mitigation Attend monthly meetings with CIC to ensure Colgate's understanding of coupon counterfeit trends/issues in the marketplace. Execute best practice standards and ensure Colgate's participation in industry-wide efforts to reduce and minimize coupon fraud. Brief Colgate Senior management (Loss Management/Legal) on ongoing counterfeit cases/lawsuits.

Work with Catalina to verify any new offer codes within the marketplace are valid. Work with CIC to take down any counterfeit offers and upload to the Early Warning File to limit Colgate exposure to fraudulent coupons being redeemed by consumers in the marketplace.

Review all counterfeit Colgate coupons submissions by NCH and CIC for authenticity and complete paperwork notification to the CIC of takedown notices as required. Maintain a database of take down notices from the CIC of all flagged Colgate counterfeit offers (roughly 5-10 offers per day)

Coupon Code Structure & Database Create/Maintain/Update Family Code structure and SKU database for all Colgate coupons. Facilitate rollout of all new products to retailers through creation/input/maintenance of coupon family code structure and all new item UPC's. Work as a liaison between brand teams and outside vendors to ensure Colgate's UPC code structure is coherent and flawless at retailer level to avoid deductions.

Partner with Colgate Puerto Rico/Pinpoint Data on their coupon programs: assisting with family code structure, Item UPC's, New item launches and any issues encountered with coupon programs

Administer and update Colgate non coupon eligible SKU List in order to work with Sales Teams and outside vendors to ensure Retailer deductions are valid.

Attend meetings and planning sessions with outside vendors (Coupon Board/NCH) for transition to 8112 UPC bar within the industry. Work to establish Colgate's readiness and compliance by providing necessary documentation for Colgate set up and roll out with Coupon Board and retailers.

Pinpoint Database: Maintain the Pinpoint database which enables Colgate to synch with Retailers POS systems as well as generate all coupon UPC bars for every coupon Colgate issues.

• maintaining the product list for all active Colgate SKU's and all new products
• creating and maintaining family code structure for all products SKU's and maintaining the product database.
• Additionally, these responsibilities are handled for Tom's of Maine and Hello

Perform reconciliation of all electronic media programs. Actualize final prints/costs for all digital programs by obtaining program results from host database and securing final costs at program end and updating CAF/NCH database/Finance/Brand Teams

Approve all Colgate coupon programs through the Popbox system to ensure accuracy of artwork and UPC bars (print offers)

Maintain hard copy files/approvals of all issued Colgate coupons for PWC audit purposes. Provide input into yearly PWC audit by meeting with PWC team and providing any requested documentation and clarification of Colgate process.

Consumer Care & Experience: Facilitate the creation of yearly Colgate coupons - Consumer Affairs Free/Cents off (US and C-P Canada), Investor Relations. Secure financial approval for all Colgate coupons from individual Brand/Finance/Region managers. Work with printer to supply all needed assets to deliver above projects.