Blendo Data Weekly – Wed, Sep 7th, 2016

Blendo Data Weekly

How to Build a Custom Dashboard to Track the Most Important Metrics & KPIs of your Email Marketing Campaigns

 

email marketing analytics: Tracking metrics and kpis

This time we went 100% hands-on. We wrote a post with how to setup and monitor some of the most important email marketing metrics in a custom dashboard. In order to run our email marketing analytics we used three main elements:

  1. The email marketing campaign data with Mailchimp.
  2. A database to move our data to and a Data Model to work with. Blendo will help us with it.
  3. A Dashboard. for this step we are going to use on of our go-to tools for the job,Mode.

Read more on how to build a custom dashboard to track your most important metrics & KPIs of your Email Marketing Campaigns.

 

From Around The Web

 

1

Facebook + Data. Got your attention? When talking about infrastructure and scalability then looking for cases like Facebook are no brainer. They recently wrote a post with their challenges with Apache Spark where they push it to its limits. This is a 60 TB+ production use case.


2

Machine learning and Artificial Neural Networks altohugh old in concept, have a huge impact today but nobody knows quite how they work. And that means no one can predict when they might fail.

+ A 6-min read of the history of Neural Networks

+ Approaching (Almost) Any Machine Learning Problem

3

Analyzing 133 GBs of code in 16 seconds? With BigQuery. This is a 30min post by Felipe Hoffa Developer Advocate at Google. He parsed parsed a billion files among 14 programming languages to decide which one is on top.

4

An awesome talk about Excel! and why we suck at it, with Joel Spolsky (~1h video) and a great resource about Cohort Analysis by Looker.

5

A great tutorial for working with large datasets using Pandas.

+ Making publication ready Python Notebooks.

+ 80+ Free Data Science Books

6

We all know that having your data in one place created a lot of value. But how important is Data warehousing? A concrete post about the importance of Data warehousing and 6 questions that will save time and money.

7

Paddle (PArallel Distributed Deep LEarning) is Baidu’s open source deep learning framework. Originally developed by Baidu engineers for applying deep learning to Baidu.

How to load data from Pipedrive to Redshift

How to load data from Pipedrive to Redshift

Pipedrive is a sales management tool designed to help small sales teams manage intricate or lengthy sales processes successfully. What if I want to get more data-driven and analyse the CRM data you have on Pipedrive to my BI or custom analytics stack or to my data warehouse like Amazon Redshift? How can I analyse the data generated with Pipedrive? This guide is going to provide you with a clear picture about how to load data from Pipedrive to Redshift.  We will use Pipedrive’s API to access and extract your data and load it into Redshift for further analysis.

You will need to write the code to get the data and make sure that this process will run every time new data are generated. Alternatively, in order to load your data from Pipedrive to Redshift you can use products like Blendo that can handle this kind of problems automatically for you.

What is Pipedrive?

Pipedrive is a sales management tool designed to help small sales teams manage intricate or lengthy sales processes successfully. Based on a philosophy of activity-based selling, it ensures teams focus on the actions that drive deals to close. Some of the differences of Pipedrive to other CRM and sales management platforms are the following:

Continue reading

How to load data from Pipedrive to SQL Data Warehouse

Pipedrive to SQL Data Warehouse

Pipedrive is a sales management tool designed to help small sales teams manage intricate or lengthy sales processes successfully. What if I want to get more data-driven and analyse the CRM data you have on Pipedrive to my BI or custom analytics stack or to my data warehouse like SQL Data Warehouse? How can I analyse the data generated with Pipedrive? This guide is going to provide you with a clear picture about how to load data from Pipedrive to SQL Data Warehouse.  We will use Pipedrive’s API to access and extract your data and load it into Redshift for further analysis.You will need to write the code to get the data and make sure that this process will run every time new data are generated. Alternatively, you can use products like Blendo that can handle this kind of problems automatically for you.

What is Pipedrive?

Pipedrive is a sales management tool designed to help small sales teams manage intricate or lengthy sales processes successfully. Based on a philosophy of activity-based selling, it ensures teams focus on the actions that drive deals to close. Some of the differences of Pipedrive to other CRM and sales management platforms are the following:

  • Dedicated Sales Management Platform. CRM is more generic. Pipedrive instead focuses more on offering a great experience for sales teams specifically.
  • Pipeline focused. Instead of focusing on numbers and metrics, Pipedrive focuses on the sales pipeline which is the overall process that your company will be running for acquiring new customers.
  • Optimised data experience. While CRMs are all about user data, Pipedrive is built in such a way that the minimal time is spent on data entry, so your salesmen can focus on selling instead of maintaining data.

Continue reading

How to load data from Pipedrive to Google BigQuery

How to load data from Pipedrive to BigQuery

Pipedrive is a sales management tool designed to help small sales teams manage intricate or lengthy sales processes successfully. What if I want to get more data-driven and analyse the CRM data you have on Pipedrive to my BI or custom analytics stack or to my data warehouse like BigQuery? How can I analyse the data generated with Pipedrive as part of your CRM customer data? This guide is going to provide you with a clear picture about how to load data from Pipedrive to Google BigQuery.  We will use Pipedrive’s API to access and extract customer related data and load it into Google BigQuery for further analysis.

You will need to write the code to get the data and make sure that this process will run every time new data are generated. Alternatively, you can use products like Blendo that can handle this kind of problems automatically for you.

Continue reading

How to load data from Square to Redshift

How to load data from Square to Redshift

Square is a simple and powerful POS software for businesses. What if I want to get more data-driven and gather all my data from Square to my BI or custom analytics stack or to my data warehouse like Amazon Redshift? How can I analyse the data generated with Square? This guide is going to provide you with a clear picture about how to load data from Square to Redshift.  We will use Square’s API to access and extract e-mail related data and load it into Redshift for further analysis.

Continue reading

How to load data from SendGrid to Redshift

How to load data from SendGrid to Redshift

Continuing with our view on the transactional email services, today we are going to see Sendgrid. SendGrid is a transactional email service. But what if I want to get more data-driven and gather all my transactional data from SendGrid to my BI or custom analytics stack or to my data warehouse like Amazon Redshift? How can I analyse the data generated with SendGrid as part of your transactional email campaigns? This guide is going to provide you with a clear picture about how to load data from SendGrid to Redshift.  We will use SendGrid’s API to access and extract e-mail related data and load it into Redshift for further analysis.

Continue reading

How to Load data from SendGrid to Google BigQuery

How to load data from SendGrid to BigQuery

Continuing with our view on the transactional email services, today we are going to see Sendgrid. SendGrid is a transactional email service. But what if I want to get more data-driven and gather all my transactional data from SendGrid to my BI or custom analytics stack or to my data warehouse like BigQuery? How can I analyse the data generated with SendGrid as part of your transactional email campaigns? This guide is going to provide you with a clear picture about how to load data from SendGrid to Google BigQuery.  We will use SendGrid’s API to access and extract e-mail related data and load it into Google BigQuery for further analysis.

Continue reading

How to Load data from Square to SQL Data Warehouse

How to load data from Square to AzureSQL

Square is a simple and powerful POS software for businesses. What if I want to get more data-driven and gather all my data from Square to my BI or custom analytics stack or to my data warehouse like SQL Data Warehouse? How can I analyse the data generated with Square? This guide is going to provide you with a clear picture about how to load data from Square to SQL Data Warehouse.  We will use Square’s API to access and extract e-mail related data and load it into SQL Data Warehouse for further analysis.

Continue reading

How to Load data from Mandrill to Google BigQuery

How to load data from Mandrill to BigQuery

There’s a continually growing usage of services like Mandrill. Mandrill  is a transactional email API for Mailchimp Users and it is ideal for sending data-driven emails, including targeted and personalized one-to-one messages to your customers. But that traffic creates more data. How can you analyse the data you generate with Mandrill as part of your transactional email campaigns, on BigQuery? This guide is going to provide you with a clear picture about how to load data from Mandrill to Google BigQuery.  Alternatively, you can use products like Blendo that can handle this kind of problems automatically for you.

ETL your Mandrill data into your Data warehouse

We will use Mandrill’s API to access and extract e-mail related data and load it into Google BigQuery for further analysis. You will need to write the code to get the data and make sure that this process will run every time new data are generated.

What is Mandrill?

Mandrill is a transactional email API for Mailchimp Users. Although in the past, Mandrill was perceived as a different product than Mailchimp, right now it is offered as a Mailchimp plugin. Mandrill is reliable, powerful and ideal for sending data-driven emails, including targeted and personalised one-to-one messages to your customers. You might wonder what are the differences between Mandrill and Mailchimp, as both of them handle the delivery of emails to your customers. Some key differences between the two are the following:

  • Mandrill is designed for developers. If you are not comfortable with writing code then it would be better if you find someone before you start using it. On the other hand, Mailchimp is designed mainly for marketeers so no technical skills are required to use it.
  • Mandrill focuses more on transactional e-mails, which are different than the promotional/campaign based emails that marketeers send using Mailchimp. Transactional e-mails are more tailor made for cases like one to one messages to your customers, like resetting passwords, welcoming them etc.
  • Mailchimp offers richer reporting, but with Mandrill it is easier to have access to all the raw events related to your e-mails as they happen, so you can run your own analytics if you wish. In general, raw data from Mandrill are much more accessible than in Mailchimp.
  • If you wish to run complicated campaigns with Mandrill you will have to implement the logic behind running them, with Mailchimp you can do that using the drag-n-drop environment that it offers.
How to load data from Mandrill to Google BigQuery

How to load data from Mandrill to Redshift

In general, you can perceive the two services as complementary, Mailchimp allows your marketing department to easily and fast execute their marketing strategies, while with Mandrill you have access to a very flexible and rich environment where you can build complex products on top of e-mail services, but it requires the involvement of your R&D team.

Mandrill, as an email API, exposes all its functionality through it. So apart from being possible to execute a number of operations like sending emails based on specific events, we can also use this API to pull out data or setup our infrastructure in such a way that Mandrill will send to us data over time they are generated. In this article, we will see in detail the different ways of pulling data from Mandrill that can be useful for running our analytics.

Continue reading

How to load data from Mandrill to Redshift

How to load data from SendGrid to Redshift

There’s a continually growing usage of services like Mandrill. Mandrill  is a transactional email API for Mailchimp Users and it is ideal for sending data-driven emails, including targeted and personalised one-to-one messages to your customers. But that traffic creates more data. How can you analyse the data you generate with Mandrill as part of your transactional email campaigns, on Amazon Redshift? This guide is going to provide you with a clear picture about how to load data from Mandrill to Redshift Alternatively, in order to load your data from Mandrill to Redshift you can check Blendo that can handle this kind of problems automatically for you.

ETL your Mandrill data into your Data warehouse

We will use Mandrill’s API to access and extract e-mail related data and load it into Redshift for further analysis. You will need to write the code to get the data and make sure that this process will run every time new data are generated.

What is Mandrill?

Mandrill is a transactional email API for Mailchimp Users. Although in the past, Mandrill was perceived as a different product than Mailchimp, right now it is offered as a Mailchimp plugin. Mandrill is reliable, powerful and ideal for sending data-driven emails, including targeted and personalised one-to-one messages to your customers. You might wonder what are the differences between Mandrill and Mailchimp, as both of them handle the delivery of emails to your customers. Some key differences between the two are the following:

Continue reading