SparkPost is proud to announce a powerful new integration with Power BI. The recently formed partnership with Microsoft’s cloud-based business analytics service is designed to provide customers with a single view of critical business data.

By connecting Power BI to your existing SparkPost account, you’ll be able to use the Power BI SparkPost content pack to monitor, explore, and visualize email metrics. The content pack allows you to easily connect your SparkPost data and begin to discover insights with an out-of-the box dashboard, reports, and curated data sets on Power BI.

The Power BI content pack can help you analyze your SparkPost data next to multiple sources. For additional details on how to get started, please see the SparkPost content pack for Power BI help page.

Power BI and SparkPost

After connecting with your SparkPost credentials, your data will begin loading into Power BI and you will be notified when the dashboard is ready. In addition to the dashboard, there are three reports that you can drill into by selecting one of the tiles on the dashboard. The reports provide additional insight into bounces and other key metrics.

To begin drilling into the reports, select one of the tiles on the dashboard. For example, if you select the Accepted Rate line chart it will drill into the Metrics report.

PowerBI and SparkPost analytics

Each report includes a set of visuals with different insights. For additional information you can hover over any of the items, or select a particular value to cross filter other visuals on the page.

Power BI

You also have the ability to customize a report by selecting Edit Report in the top left corner of the page. The edit mode gives you access to the field list, allowing you access to any of the values included in the data set. It also gives you the ability you to edit or add visuals to reports. Any of the visualizations from the reports can be pinned to the dashboard by hovering over it and selecting the pin icon.

After the initial import, the dashboard and the reports will continue to update daily.

With the SparkPost content pack for Power BI, you’ll have a great initial set of metrics and insights, enabling you to explore your data even further! Product updates will roll out as new versions are released, and SparkPost will continue to support new data sets.

What you’ll need to get started:

Additional information:

 

 

One of the great perks of attending Insight, SparkPost’s annual user conference, is sharing best practices and learning from the expertise of the pros who build, manage, and use next-generation email infrastructure on a large scale. No small part of that is the hands-on sessions led by members of our product team and longtime expert customers who know how to make the SparkPost platform sing.

Three of these technical boot camp sessions dug into powerful SparkPost features: finely-grained tracking of user engagement, the rich capabilities of advanced templates, and the intelligent business logic of multi-channel email, SMS messaging, and app push notifications. Though nothing beats being there for the technical deep dives, here’s a chance for the next-best thing: notes from the sessions and the boot camp leaders’ presentations. Dig in, and enjoy!


First off the blocks was “Using the Engagement Tracking and Metrics APIs to Bring Insights to Your Business.” This informative session examined the ways SparkPost allows senders to get the most from the fine-grained information about customer behavior and interactions with messages. Engineer Steve Tuck demonstrated using SparkPost’s web user interface for interactive queries, APIs for pulling data into external systems, and Webhooks for streaming events data in real-time.

Insight User Conference Bootcamp – Use the Engagement Tracking and Metrics APIs to Bring Insights to Your Business from SparkPost

Next up, SparkPost’s Fiona Snoddy and Isaac Kim used “Advanced Templatization” to demonstrate how to use the powerful templating features of our service. SparkPost templates can incorporate substitution data, conditional statements, looping flow controls, and dynamic content pulled from other systems. Together, these features enable a sender to personalize text, optimize offers, or deploy other business logic.

Insight User Conference Bootcamp – Advanced Templatization from SparkPost

One final bootcamp discussed how to incorporate “Multi-Channel Messaging with SparkPost Elite.” Using one platform and set of APIs to generate email, SMS, and push notifications means it’s possible to send a customer the right message at the right place at the right time, whatever the medium. SparkPost’s Ewan Dennis and Bruce Nowjack teamed up to give a really compelling demonstration of building a multi-channel app in real-time.

Insight User Conference Bootcamp – Multi-Channel with SparkPost Elite from SparkPost

If these power features make you want to learn more, it’s easy to get started with SparkPost. And if you’re a developer looking to get your hands in some code, the SparkPost Developer Hub is a great place to begin.

 

—Brent
@brentsleeper

Originally posted on MarketingPersonalization.com

Chalkboard CountsThe last of the holiday emails have meandered their way into my inbox; deep discounts are starting to flow back out to sea and the volumes of marketing mails are starting to subside. The world is getting back to normal. Right? To be honest, I hope not! (more…)

Email guru David Daniel’s recently published white paper on the differing impact of marketing efforts based on email technology used is exciting to all marketers for a number of reasons.

One of these reasons is that it provides a really in-depth look on the types of challenges marketers face when using an email service provider versus an enterprise email solution (or on-premise email solution).

top-challenges

Across the board, marketers experience fewer challenges with an enterprise email solution. Only on the question of creative content development did respondents report better results with outsourced solutions, and then by only a single percentage point margin.

What’s really eye popping is the huge gap in terms of the extent of the challenges facing marketers. While not much difference exists between knowledge for optimizing marketing and creative content development, the percentages demonstrate how much more value marketers are getting from an enterprise email solution versus an email service provider.

Percentage Gap In Challenges Experienced by Marketers Using An Email Service Provider

  • Lack of data security: +11%
  • Adequate staff to manage email: +10%
  • Adequate IT support: +10%
  • Analyzing campaign results: +9%
  • List turnover subscriber churn: +9%
  • Email deliverability: +7%
  • Automate campaigns: +5%
  • Lack of budget: +4%

So, we can see that the area where enterprise email solutions are really having the most impact is in terms of security, manpower deployment, analytics and the dread customer churn. That’s a lot of cumulative areas that could add up to improving your ROI and getting that lead to convert.

Another interesting point to note is the difference in the top three challenges experienced by marketers using different solutions.

Top 3 Challenges for marketers using email service providers:

  • Analyzing campaign results: 25%
  • Ability to automate campaigns: 24%
  • Adequate staff to manage email: 24%

Top 3 Challenges for marketers using enterprise email solutions:

  • Knowledge to optimize marketing: 21%
  • Ability to automate campaigns: 19%
  • Creative content development / analyze campaign results: 16%

While both parties identified analytics and automation, these were much bigger problems for marketers using email service providers. In contrast, it is possible to surmise from the results that marketers using enterprise email solutions were focusing more on challenges to deal with optimizing content and marketing as their technology was working more effectively for them in all other areas.

Do you agree with the results? How are enterprise email solutions working better for you? We’d love to hear from you in the comments section.

(This is the third part of a series on the Unlock the Potential of Email Marketing webinar, which presents findings from a survey of 400 email marketing professionals.

Part 1: Three Email Marketing Metrics You Need To Measure
Part 2: Three Reasons Why Email Marketers Turn To In-House Email Solutions)