Stay organized with collections
Save and categorize content based on your preferences.
Looker Block for Salesforce Marketing Cloud
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.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThe Looker Block for Salesforce Marketing Cloud (SFMC) provides a comprehensive overview of email broadcast activities and outbound email performance for owned media campaigns.\u003c/p\u003e\n"],["\u003cp\u003eThis block uses pre-packaged ingestion pipelines to bring SFMC email data into BigQuery, enabling quick analysis of email performance.\u003c/p\u003e\n"],["\u003cp\u003eUsers can compare email broadcast performance metrics, identify trends, and optimize email campaigns based on open rates, click-through rates, bounce rates, and unsubscribe rates.\u003c/p\u003e\n"],["\u003cp\u003eThe Looker Block for SFMC offers predefined dashboards with insights into monthly performance, email engagement, and detailed broadcast metrics.\u003c/p\u003e\n"],["\u003cp\u003eThe block can be extended to include data from other enterprise systems like CRM and ERP, through integration with the Cortex Framework, for broader marketing insights.\u003c/p\u003e\n"]]],[],null,["# Looker Block for Salesforce Marketing Cloud\n===========================================\n\nThis page describes the insights you can get from the Cortex Looker\nBlock for Salesforce Marketing Cloud (SFMC) data. Using this Looker\nBlock for SFMC, you can gain a comprehensive overview of your email broadcast\nactivities and performance of outbound emails for owned media campaigns.\n\nBy utilizing pre-packaged ingestion pipelines and connecting to reporting\ndatasets provided by Cortex Framework for SFMC, you can\ningest your email broadcast activities data on SFMC into BigQuery,\njumpstarting your owned media marketing analytics.\n\nYou can compare and benchmark email broadcasts performance to understand which\nemail communications resonate best with your customers. Identify trends and\npatterns in your email broadcasts activities data to optimize your email\nbroadcasts effectively. With this solution, you can gain out-of-the-box\ninsights into key metrics for email broadcast campaigns within a specified\ntimeframe.\n\nExtend your insights beyond marketing by integrating with other datasets in\nCortex Framework, which provide reporting views for\nenterprise data sources such as CRM and ERP systems.\n\nAvailable insights\n------------------\n\nThe Looker block for SFMC in Cortex Framework offers\na predefined high-level dashboard featuring these key insights:\n\n- **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.\n- **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.\n- **Email broadcast opened versus clicked:** Compare the number of uniquely opened emails to the number of email clicks for each email broadcast.\n- **Open rate versus click-through rate:** Monitor email broadcasts' open rate and CTR on a weekly basis to gauge customer engagement and content effectiveness.\n- **Bounce rate:** Monitor the email broadcast bounce rate, which represents the percentage of emails rejected by the mail server.\n- **Unsubscribe rate:** Monitor the monthly unsubscribe rate for email broadcasts.\n- **Email broadcast performance details:** Review performance metrics for all email broadcasts in a single visualization.\n\nRepository\n----------\n\nTo access the Cortex Looker Block for SFMC, visit its official\nGitHub repository: [**block-cortex-sfmc**](https://github.com/looker-open-source/block-cortex-sfmc).\nThis repository contains essential views, Explores and dashboards that enable you to seamlessly integrate SFMC data into your\nLooker environment. These resources provide a solid foundation\nfor creating custom reports, visualizations, and dashboards tailored to your\nspecific needs.\n\nDeployment\n----------\n\nFor instructions about how to deploy the Cortex Looker Block for\nSFMC, see\n[Deploy Looker Blocks for Cortex Framework](/cortex/docs/looker-block-deployment)."]]
