使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
适用于 Salesforce Marketing Cloud 的 Looker Block
本页介绍了您可以通过 Cortex Looker 块针对 Salesforce Marketing Cloud (SFMC) 数据获得哪些数据分析。借助适用于 SFMC 的此 Looker 版块,您可以全面了解电子邮件广播活动以及自有媒体广告系列的出站电子邮件效果。
通过利用预打包的提取流水线并连接到 Cortex Framework for SFMC 提供的报告数据集,您可以将 SFMC 上的电子邮件广播活动数据提取到 BigQuery,从而快速开始自有媒体营销分析。
您可以比较和对照电子邮件广播的效果,了解哪些电子邮件内容最能引起客户的共鸣。找出电子邮件广播活动数据中的趋势和模式,以便有效优化电子邮件广播。借助此解决方案,您可以立即深入了解指定时间范围内电子邮件广播广告系列的关键指标。
通过与 Cortex Framework 中的其他数据集集成,您可以将数据洞见扩展到营销领域之外,这些数据集可为 CRM 和 ERP 系统等企业数据源提供报告视图。
可用的数据洞见
Cortex Framework 中适用于 SFMC 的 Looker 区块提供了一个预定义的概览信息中心,其中包含以下关键数据洞见:
- 月度概览:通过比较已递送的电子邮件数量与唯一打开过的电子邮件数量以及相应的打开率,分析每月的电子邮件广播效果。
- 电子邮件广播效果概览:将每封电子邮件广播的打开率和点击率 (CTR) 与已投放的电子邮件和唯一打开的电子邮件总数进行比较。
- 电子邮件广播的打开次数与点击次数:比较每封电子邮件广播的不重复打开次数与电子邮件点击次数。
- 打开率与点击率:每周监控电子邮件广播的打开率和点击率,以衡量客户互动度和内容效果。
- 回弹率:监控电子邮件广播的回弹率,即邮件服务器拒收的电子邮件所占的百分比。
- 退订率:监控电子邮件广播的每月退订率。
- 电子邮件广播效果详情:在单个可视化图表中查看所有电子邮件广播的效果指标。
代码库
如需访问适用于 SFMC 的 Cortex Looker 块,请访问其官方 GitHub 代码库:block-cortex-sfmc。此代码库包含基本视图、探索和信息中心,可帮助您将 SFMC 数据无缝集成到 Looker 环境中。这些资源为您提供了坚实的基础,可帮助您根据自己的具体需求创建自定义报告、可视化图表和信息中心。
部署
如需了解如何为 SFMC 部署 Cortex Looker 块,请参阅为 Cortex Framework 部署 Looker 块。
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-08-18。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC):2025-08-18。"],[[["\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)."]]