使用 Power BI 连接到 SparkPostConnect to SparkPost with Power BI

SparkPost 的 Power BI 内容包允许你从 SparkPost 帐户将所有有价值的数据集提取到富有洞察力的仪表板中。The Power BI content pack for SparkPost allows you to extract valuable datasets from your SparkPost account all into one insightful dashboard. 借助 SparkPost 内容包,可以将你的电子邮件整体统计信息可视化,其中包括通过 ISP 的域、活动和参与。Using the SparkPost content pack you can visualize your overall email statistics, including domains, campaigns, and engagement by ISP.

连接到适用于 Power BI 的 SparkPost 内容包Connect to the SparkPost content pack for Power BI.

如何连接How to connect

  1. 选择左侧导航窗格底部的获取数据Select Get Data at the bottom of the left navigation pane.

  2. 服务框中,选择获取In the Services box, select Get.

  3. 选择 SparkPost 内容包,并单击获取Select the SparkPost content pack and click Get.

  4. 出现提示时,提供你的 SparkPost API 密钥,并选择“登录”。When prompted, provide your SparkPost API key and select Sign In. 请参阅下面有关查找这些参数的详细信息。See details on finding this parameters below.

  5. 数据将开始加载,这可能需要一些时间,具体取决于你帐户的大小。Your data will start to load, depending on the size of you account this may take some time. Power BI 导入数据后,你将看到默认的仪表板、报表和左侧导航窗格中的数据集,数据集是使用过去 90 天的电子邮件统计信息进行填充的。After Power BI imports the data, you’ll see the default dashboard, report, and dataset in the left navigation pane, populated with your email statistics for the past 90 days. 新的项目会以黄色星号 * 标记。New items are marked with a yellow asterisk *.

下一步?What now?

包含的内容What's included

适用于 Power BI 的 SparkPost 内容包包括信息,这些信息包括独特的单击、接受速度、跳出速度、延迟速度、拒绝速度等。The SparkPost content pack for Power BI includes information including unique clicks, accepted rates, bounce rates, delayed rates, rejection rates and more.

查找参数Finding parameters

内容包使用 API 密钥来将你的 SparkPost 帐户连接到 Power BI。The content pack uses an API key to connect your SparkPost account to Power BI. 你可以在你的帐户 > API 和 SMTP 下找到你的 API 密钥(有关详细信息,请查看此处)。You can find your API key in your account under Account > API & SMTP (more details here). 我们建议使用具有 Message Events: Read-onlyMetrics: Read-only 权限的 API 密钥We suggest using an API key with permissions for Message Events: Read-onlyand Metrics: Read-only