# 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**](https://github.com/looker-open-source/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](https://docs.cloud.google.com/cortex/docs/v6/looker-block-deployment).