Brandz&Numbers | Ideas. Insights. Implications

Understanding promo effectiveness in oral care

Client

Colgate

Background

Exploring pricing thresholds in promo campaigns

The business objective of the project was to maximize the promo response, promo effectiveness and promo timings for a leading brand in oral care. Our job was to do an analysis of regular and promo pricing in leading retail outlets to suggest the right approach to promo planning in the most profitable channels to maximize volume and value for most sellable SKUs and benchmark those to the most aggressive competitive SKUs.

Outcome

Optimal regular price thresholds analyzed with a reco on acceptable range considering high anticipated inflation rates

Optimal promo price thresholds analyzed with a reco of promo discount depth and promo duration to achieve maximum sales

Elasticity analysis done for regular and promo pricing in value and volume with specific inflation and nominal price change

Analysis of optimal promo timing, duration and promo breaks is executed by channels and by SKU

Analysis of the optimal promo assortment and price indexes of own portfolio vs. competitive portfolio is cascaded to cross-functional teams

Other works

Understanding competition in canister segment of savory snacks

Creating consistency for global marketing strategy in packaging

(1/1) ErrorException

fwrite(): write of 1832 bytes failed with errno=122 Disk quota exceeded

in StreamHandler.php line 133

at HandleExceptions->handleError(8, 'fwrite(): write of 1832 bytes failed with errno=122 Disk quota exceeded', '/var/www/h68363/data/www/brandznumbers.com/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php', 133, array('stream' => resource, 'record' => array('message' => 'ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main}', 'context' => array(), 'level' => 400, 'level_name' => 'ERROR', 'channel' => 'local', 'datetime' => object(DateTime), 'extra' => array(), 'formatted' => '[2025-09-05 17:03:32] local.ERROR: ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main} ')))

at fwrite(resource, '[2025-09-05 17:03:32] local.ERROR: ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main} ')in StreamHandler.php line 133

at StreamHandler->streamWrite(resource, array('message' => 'ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main}', 'context' => array(), 'level' => 400, 'level_name' => 'ERROR', 'channel' => 'local', 'datetime' => object(DateTime), 'extra' => array(), 'formatted' => '[2025-09-05 17:03:32] local.ERROR: ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main} '))in StreamHandler.php line 119

at StreamHandler->write(array('message' => 'ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main}', 'context' => array(), 'level' => 400, 'level_name' => 'ERROR', 'channel' => 'local', 'datetime' => object(DateTime), 'extra' => array(), 'formatted' => '[2025-09-05 17:03:32] local.ERROR: ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main} '))in AbstractProcessingHandler.php line 39

at AbstractProcessingHandler->handle(array('message' => 'ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main}', 'context' => array(), 'level' => 400, 'level_name' => 'ERROR', 'channel' => 'local', 'datetime' => object(DateTime), 'extra' => array(), 'formatted' => '[2025-09-05 17:03:32] local.ERROR: ErrorException: file_put_contents(): write of 236 bytes failed with errno=122 Disk quota exceeded in /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:122Stack trace:#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(8, \'file_put_conten...\', \'/var/www/h68363...\', 122, Array)#1 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(122): file_put_contents(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', 2)#2 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/FileSessionHandler.php(83): Illuminate\\Filesystem\\Filesystem->put(\'/var/www/h68363...\', \'a:3:{s:6:"_toke...\', true)#3 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Store.php(128): Illuminate\\Session\\FileSessionHandler->write(\'Wj8fV3xOaxKTtub...\', \'a:3:{s:6:"_toke...\')#4 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(88): Illuminate\\Session\\Store->save()#5 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(218): Illuminate\\Session\\Middleware\\StartSession->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#6 /var/www/h68363/data/www/brandznumbers.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#7 /var/www/h68363/data/www/brandznumbers.com/public/index.php(64): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))#8 {main} '))in Logger.php line 344

at Logger->addRecord(400, object(ErrorException), array())in Logger.php line 712

at Logger->error(object(ErrorException), array())in Writer.php line 203

at Writer->writeLog('error', object(ErrorException), array())in Writer.php line 114

at Writer->error(object(ErrorException))in Handler.php line 71

at Handler->report(object(ErrorException))in Handler.php line 35

at Handler->report(object(ErrorException))in HandleExceptions.php line 81

at HandleExceptions->handleException(object(ErrorException))

ideas.

insights.