Following the successful implementation of Salesforce Marketing Cloud, PepsiCo asked DEG to produce a report for evaluating its email efforts across its business units.

The path to purchasing snack foods and beverages can vary from a split-second decision in the checkout line to a careful plan to prepare for your next family gathering or celebration. To meet consumers in the right moments and drive purchases for both immediate consumption and grocery planning, brands need the ability to activate 1:1 marketing at scale. And that requires having the right data and technology to gain insight into the messages and channels that engage best in those moments.

The challenge

PepsiCo is a multinational food, snack, and beverage corporation with a product portfolio including 23 billion-dollar brands like Quaker, Lays, Gatorade, Doritos, Mountain Dew, and Pepsi. Following the successful implementation of Salesforce Marketing Cloud, PepsiCo asked DEG to produce a report for evaluating its email efforts across its business units.

To select the best opportunities for 1:1 marketing growth, marketers need data visualizations that are clear, understandable, and representative of real-time consumer engagement. To meet these needs, PepsiCo and DEG sought to transform the consumer relationship marketing report and improve data transparency and access to real-time performance metrics for the organization.

The strategy

PepsiCo was already using Datorama for evaluating its paid media efforts, so it made sense to see if the platform could also provide insights on owned-media efforts like email and SMS communications. DEG and PepsiCo evaluated Datorama and developed a plan for creating a real-time interface that would showcase the complex marketing data in a transparent and useful manner for all.

PepsiCo and DEG launched the nine Datorama dashboards in the spring of 2020, providing stakeholders with the ability to view consumer-data acquisition and activation performance in near real-time.

The solution

DEG built a custom data integration between Salesforce Marketing Cloud and Datorama, going beyond Datorama’s Integration Engine platform connectors to include custom data extracts from more than a dozen data streams to monitor contact acquisition and campaign performance. The agency’s engineering team optimized the existing Salesforce Marketing Cloud data extensions to ensure efficient delivery of relationship marketing data sets, while also improving the model for a complete view of the data.

DEG’s Analytics & Insight team worked closely with the agency’s Salesforce Marketing Cloud consultants, engineers, and strategists to build nine custom Datorama dashboards for distinct business units. DEG also developed a rollup dashboard for PepsiCo executives to monitor relationship marketing performance across brands in a single view. Each dashboard provided an enhanced view of previous PepsiCo email reports with improved visualizations and near-real-time data.

To help PepsiCo’s marketers use Datorama’s insights to optimize campaigns, DEG also created a dashboard glossary built into the solution with data definitions and explanations of terms.

“By partnering with DEG, we transformed our relationship marketing performance visualization with a custom Datorama solution aligned to our specific needs. Our dashboards now elevate the visibility of our work within the PepsiCo organization and support continued growth.” — Mike Scafidi, Global Head of Marketing Technology and AdTech, PepsiCo

The outcome

PepsiCo and DEG launched the nine Datorama dashboards in the spring of 2020, providing stakeholders with the ability to view consumer-data acquisition and activation performance in near real-time. As PepsiCo continues to grow its first-party consumer data, DEG will help manage the Datorama dashboards for optimal performance tracking, and future visualization builds within the platform to support more brands and initiatives.

Now, whether you’re craving something in the checkout line or planning for a birthday picnic, PepsiCo has the data and technology to meet you in the moment with a tailored message.