Looker Block for Salesforce Marketing Cloud (SFMC)

This page describes the insights you can get from the Cortex Looker Block for Salesforce Marketing Cloud (SFMC) data. Using this Looker Block for SFMC, you can gain a comprehensive overview of your email broadcast activities and performance of outbound emails for owned media campaigns.

By utilizing pre-packaged ingestion pipelines and connecting to reporting datasets provided by Cortex Framework for SFMC, you can ingest your email broadcast activities data on SFMC into BigQuery, jumpstarting your owned media marketing analytics.

You can compare and benchmark email broadcasts performance to understand which email communications resonate best with your customers. Identify trends and patterns in your email broadcasts activities data to optimize your email broadcasts effectively. With this solution, you can gain out-of-the-box insights into key metrics for email broadcast campaigns within a specified timeframe.

Extend your insights beyond marketing by integrating with other datasets in Cortex Framework, which provide reporting views for enterprise data sources such as CRM and ERP systems.

Available insights

The Looker block for SFMC in Cortex Framework offers a predefined high-level dashboard featuring these key insights:

  • Monthly overview: Analyze monthly email broadcast performance by comparing the number of delivered emails to the number of uniquely opened emails, along with the corresponding open rate.
  • Email broadcast performance overview: Compare open rate and click-through rate (CTR) for each email broadcast against the total number of emails delivered and uniquely opened.
  • Email broadcast opened versus clicked: Compare the number of uniquely opened emails to the number of email clicks for each email broadcast.
  • Open rate versus click-through rate: Monitor email broadcasts' open rate and CTR on a weekly basis to gauge customer engagement and content effectiveness.
  • Bounce rate: Monitor the email broadcast bounce rate, which represents the percentage of emails rejected by the mail server.
  • Unsubscribe rate: Monitor the monthly unsubscribe rate for email broadcasts.
  • Email broadcast performance details: Review performance metrics for all email broadcasts in a single visualization.

Repository

To access the Cortex Looker Block for SFMC, visit its official GitHub repository: block-cortex-sfmc. This repository contains essential views, Explores and dashboards that enable you to seamlessly integrate SFMC data into your Looker environment. These resources provide a solid foundation for creating custom reports, visualizations, and dashboards tailored to your specific needs.

Deployment

For instructions about how to deploy the Cortex Looker Block for SFMC, see Deploy Looker blocks for Cortex Framework.