PEPSICO GLOBAL AD CAMPAIGN ROI DASHBOARD

BUSINESS CASE:

PepsiCo allocated $28 million to a global advertising campaign, resulting in varied returns

ranging from a +300% ROI in Mexico to a -15% ROI in Japan. Executives are seeking an

interactive dashboard that allows them to analyze results by country and region, assess campaign

performance, and guide future marketing decisions with data-driven insights.

KPI’S Derived:

• Total Ad Spend

• Total Revenue

• Average ROI

RESULT AND DASHBOARD FOR ALL REGIONS

TOTAL AD SPEND : The total ad spend for all region was 425.56M

TOTAL REVENUE: The total revenue generated through all region was 984.91M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all the regions was

127.26.

The dashboard is shown below;

RESULT AND DASHBOARD FOR AFRICA

TOTAL AD SPEND : The total ad spend for Africa region was 4.80M.

TOTAL REVENUE: The total revenue generated through all Africa region was 9.17M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all Africa regions

was 148.38.

The dashboard is shown below;

RESULT AND DASHBOARD FOR ASIA

TOTAL AD SPEND : The total ad spend for Asia region was 5.44M.

TOTAL REVENUE: The total revenue generated through all Asia region was 15.66M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all Asia regions was

115.01.

The dashboard is shown below;

RESULT AND DASHBOARD FOR EUROPE

TOTAL AD SPEND : The total ad spend for Europe region was 235.80M.

TOTAL REVENUE: The total revenue generated through all Europe region was 502.38M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all Europe regions

was 115.01.

The dashboard is shown below;

RESULT AND DASHBOARD FOR LATAM

TOTAL AD SPEND : The total ad spend for LATAM region was 9.04M.

TOTAL REVENUE: The total revenue generated through all LATAM region was 20.57M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all LATAM regions

was 118.88.

The dashboard is shown below;

RESULT AND DASHBOARD FOR MIDDLE EAST

TOTAL AD SPEND : The total ad spend for Middle East region was 18.53M.

TOTAL REVENUE: The total revenue generated through all Middle East region was 39.08M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all Middle East

regions was 123.52.

The dashboard is shown below;

RESULT AND DASHBOARD FOR NORTH AMERICA

TOTAL AD SPEND : The total ad spend for North America region was 93.30M.

TOTAL REVENUE: The total revenue generated through all North America region was 280.60M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all North America

regions was 170.18.

The dashboard is shown below;

RESULT AND DASHBOARD FOR OCEANIA

TOTAL AD SPEND : The total ad spend for Oceania region was 58.65M.

TOTAL REVENUE: The total revenue generated through all Oceania regions was 117.45M

AVERAGE ROI : The total average of rate of interest(ROI) generated across all Oceania regions

was 106.21.

The dashboard is shown below;

Conclusion

The analysis reveals that Nigeria has the highest sum of ROI (Rate of Interest) of 1688.26

compare to other countries. While Japan has the lowest sum of ROI (Rate of Interest) of -90.35.

Also for the media channel it was deduce that Billboard has the highest Average ROI by media

channel of 148.90 while YouTube has the lowest Average ROI by media channel of 101.82.

Also from the analysis it was discovered that the Asia and Europe region has the same value of

Average ROI of 115.01.

HIGHLIGHTS HIGH/LOW PERFORMING MARKETS

1. High performing market in terms of revenue generated per region is Europe.

2. Low performing market in terms of revenue generated made per region is Africa

Recommendations

1. Re allocate budget toward high-ROI regions and channels by increasing investment in

top-performing countries and platforms.

2. Cut back or pause spending in consistently low-performing areas, such as Japan, where

all channels are underperforming.

3. Prioritize YouTube and social media in regions like LATAM, Africa, and Brazil, where

they consistently generate strong returns.

4. Leverage radio strategically in markets like China and Australia, where it proves

effective