2019-12-29 21:16
What can you do this month that you couldn’t do last month?
We made quite a few cool updates in December. We now have a revamped Google Ads data connector and improved… Read More
Blog Directory > Software Blogs > Programming Blogs > Blendo: Data Management and Analytics programming Blog >
Blendo: Data Management And Analytics Blog
blog.blendo.co
Tags:
blendo
warehouse analyticsready
warehouse
server mysql mariadb
google ads
partition
sql server mysql
key takeaway
report
magento
This blog is about Data Analytics, Data Science and data management.
2019-12-17 11:38
Analyzing your Google Ads campaigns in your Business Intelligence tool seems like a no-brainer. It is an easy way to consolidate data from multiple campaigns, different chann… Read More
![Data-Driven Marketing Consultancy Creates One Source Of Truth [Case Study]](https://cdn.blogarama.com/images/posts_thumbs_site_id/3314/331398-1486514774.w320.jpg "Data-Driven Marketing Consultancy Creates One Source Of Truth [Case Study]")
2019-11-04 11:37
ONE12th is a Data, Marketing and Automation consultancy. In ONE12th they see the world rapidly heading into a more data-driven and automated future. With that vision, they ca… Read More
2019-11-01 13:34
When I first came across table partitioning and started searching, I realized two things. First, that it is a complex operation that requires good planning and second, that i… Read More
![How AgriWebb Manages To Get Timely, Accurate And Relevant Data. [Case Study]](https://cdn.blogarama.com/images/posts_thumbs_site_id/3314/331398-2826333990.w320.jpg "How AgriWebb Manages To Get Timely, Accurate And Relevant Data. [Case Study]")
2019-11-01 11:14
AgriWebb AgriWebb provides software tools and that bring modern farming practices into the digital age. At AgriWebb, they needed to find a way to create a complete 360-degre… Read More
2019-10-27 12:12
We are excited to introduce a number of new integrations as data sources. Now you can integrate S3, Heap, SFTP, and Magento with Blendo.
Let’s take a closer look at the… Read More
2019-10-11 12:04
Last week (Oct 1st) we rolled out our new data source integration with NetSuite.
Many companies use several ways to integrate their valuable data from NetSuite with their da… Read More
2019-10-08 12:40
What can you do this month that you couldn’t do last month?
We made quite a few cool updates in September. There are new major data source integrations, new functionali… Read More
2019-10-05 11:39
For some time now, we were focusing on syncing data from cloud data sources like Salesforce, Zendesk, NetSuite, etc. Which bothered us quite a lot, especially since our users… Read More
![The Ultimate List Of Business Intelligence Tools And Dashboards [Updated 2019]](https://cdn.blogarama.com/images/posts_thumbs_site_id/3314/331398-347248717.w320.jpg "The Ultimate List Of Business Intelligence Tools And Dashboards [Updated 2019]")
2019-10-03 17:41
What does it mean to be a data-driven organization? How many platforms are you running, and how useful is the business data you’ve collected from them?
Companies analyz… Read More
2019-09-19 10:54
Having accurate and current data for your Business Intelligence isn’t just nice to have. We want businesses that manage their data infrastructure with Blendo to have an… Read More
2019-09-18 15:19
Around six years ago, Amazon disrupted the data warehousing market by introducing a cloud-based and scalable solution for data warehousing, named Amazon Redshift. For the fir… Read More
2019-09-16 13:57
PostgreSQL is an amazing database! It’s one of the most well developed and mature relational database management systems, with its development, keep going for more than… Read More
2019-09-15 17:45
Bonus Material: FREE Amazon Redshift Guide for Data Analysts PDF
So you found a way to store your data in Amazon Redshift and keep them in sync. Now you want to start me… Read More
2019-08-27 13:32
“Our team had no dedicated analytics infrastructure with siloed business performance data. So we had to do a ton of detective work between excel sheets and ad-hoc platf… Read More
![How Viral Launch Used Their Data To Overcome Churn. [Case Study]](https://cdn.blogarama.com/images/posts_thumbs_site_id/3314/331398-2108626498.w320.jpg "How Viral Launch Used Their Data To Overcome Churn. [Case Study]")
2019-08-08 12:09
Viral Launch provides the software and services to let anyone research, source and sell successfully on Amazon. As VP of Product at Viral Launch, Christine McCarley need… Read More
2019-07-17 11:46
Zendesk Talk is cloud-based call center software that helps companies provide more personal, productive phone support. It’s built right into the Zendesk multi-cha… Read More
2019-06-08 08:17
PostgreSQL is a popular open source relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature… Read More
2019-06-07 15:48
Zendesk Chat is a live chat software that belongs to the Zendesk Suite (Zendesk Support, Zendesk Sell, Zendesk Guide, etc). With Chat, you may help customers in real ti… Read More
2019-06-06 17:25
Bonus Material: FREE Amazon Redshift Guide for Data Analysts PDF
All organizations, big or small, are struggling to manage the data they have and drive actionable insights. D… Read More
2019-06-02 09:36
ETL (extract, load, transform) is a decades-old, three-step process for pulling data from a single or multiple data sources to a data warehouse where you may represent it dif… Read More
2019-05-28 22:55
Businesses today have access to humongous volumes of valuable, high-quality consumer information like never before. Thanks to data analytics, companies are no longer fumbling… Read More
2019-05-22 22:39
We are excited to introduce our new integration with Mews, we have made some improvements to our Zendesk and Google Analytics connectors and some improvements in the UI in re… Read More
2019-05-16 13:02
Mews is a cloud-based, property management software that is revolutionizing hospitality operations. Mews’ platform automates check-ins, payments, booking management, a… Read More
2019-05-07 11:31
Or how the evolution of data warehouses and technology is shifting ETL.
Data-driven organizations are often on the lookout for populating their data warehouse from various da… Read More
![How MyJobNow Increased Sales And Conversions By 15% [Customer Story]](https://cdn.blogarama.com/images/posts_thumbs_site_id/3314/331398-1289447302.w320.jpg "How MyJobNow Increased Sales And Conversions By 15% [Customer Story]")
2019-04-22 12:41
This article is a guest post by Agamemnon Papazoglou co-founder of MyJobNow and their story.
MyJobNow offers a web and mobile app that matches job seekers and employers within… Read More
2019-03-15 20:41
Need to connect your destination database that resides in a private network? Blendo now supports destination connectivity with an SSH Tunnel (Bastion host).
What’s New… Read More
2019-02-21 22:36
Blendo empowers organizations to understand their customers and business with analytics-ready data. For years, business, sales or marketing executives struggled to employ their data in ways… Read More
2019-02-17 19:51
Like traveling? Chances are you have stayed at least once in a hotel or hostel. The transformation of the hotel industry operations by the use of technology, in turn, changes the guest exper… Read More
2019-01-20 18:04
Customer satisfaction is an essential metric for every company, no matter if you sell directly to customers or businesses. Customer support is fast becoming the voice of the… Read More
2018-12-17 11:43
Adrien Ulens is the Head of Marketing at Gogoprint, an online printing company operating in five Asia-Pacific countries under brand names Gogoprint and Zenprint in Australia. The tech firm a… Read More
2018-10-25 10:48
In the past, Accounting was one of the first industries disrupted by spreadsheet software. With the advent of the cloud and software as a service (SaaS), applications like Xe… Read More
2018-09-29 12:12
We are really excited about this one. Our team has released a new eBook to show digital marketers how to use Google’s Suite of free tools currently available to them in… Read More
2018-08-04 19:49
One of the most important SaaS metrics of your customer acquisition strategy is the Lifetime Value – or LTV– of a customer. Having a solid customer acquisition st… Read More
2018-07-31 22:11
Today we are really excited! We are announcing that Blendo is one of the first to join Stripe Partner Program.
Most people today don’t know that only three percent of G… Read More
2018-07-30 12:16
This post will help you with syncing your BaseCRM data to X. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of data payloads, like X… Read More
2018-07-22 19:53
What is JSON?
JSON (Javascript Object Notation) is an open-standard file format which organizes data into key-value pairs and array data types with respect to certain syntact… Read More
2018-06-30 12:14
This post will help you with syncing your BaseCRM data to Amazon Redshift. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of data pay… Read More
2018-05-31 20:43
For quite some time, customer support has stopped being considered an optional service. Although in the past, businesses used to provide no real support to customers as they… Read More
2018-05-04 15:16
One of the most basic clauses in any SQL dialect is the GROUP BY. Anyone who interacts frequently with relational databases has for sure used this clause thousands of times i… Read More
2018-04-28 11:01
This post will help you with syncing your NetSuite data to MS SQL Server. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of data payl… Read More
2018-04-26 14:23
At a time where more and more companies become data-driven, the process of decision making regarding key business activities like sales is changing once and for all. By leveraging data, a mo… Read More
2018-04-25 22:05
This post will help you with syncing your Twitter Ads data to Snowflake. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of data paylo… Read More
2018-04-24 20:56
This post will help you with syncing your DoubleClick (Ad Manager) advertising data to Snowflake. By doing this you will be able to perform advanced analytics on a system that is designed fo… Read More
2018-04-21 17:10
This post will help you with syncing your Bing Ads data to PostgreSQL. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of data payload… Read More
2018-04-20 10:47
Amazon Web Services have many benefits. Whether you choose it for the pay as you go pricing, high performance, and speed or its versatile and flexible services provided, we a… Read More
2018-04-19 18:04
This post will help you with syncing your Google Sheets data to Amazon Redshift. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of da… Read More
2018-04-17 22:35
This post will help you with syncing your QuickBooks accounting data to Google BigQuery. By doing this you will be able to perform advanced analytics on a system that is designed for this ki… Read More
2018-04-14 22:42
This post will help you with syncing your Google Analytics or clickstream data to Google BigQuery. By doing this you will be able to perform advanced analytics on a system that is designed f… Read More
2018-04-10 19:51
This post will help you with syncing your Google Search Console data to Snowflake. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of… Read More
2018-04-09 19:16
This post will help you with syncing your Chargebee data to PostgreSQL. By doing this you will be able to perform advanced analytics on a system that is designed for this kind of data payloa… Read More
2018-04-07 14:15
Some time ago we discussed how you can access data that are stored in Amazon Redshift and PostgreSQL with Python and R. Let’s say you did find an easy way to store… Read More
2018-04-04 09:46
For all companies, the generation of sufficient revenues is a process highly correlated with the company’s survival, no matter the product or the service it offers to i… Read More
2018-03-30 18:10
I guess no one would argue with me if I say that satisfied customers are a key factor in sustainability and growth of a business. As Gregory Ciotti simply put it “a sat… Read More
2018-03-25 14:15
As the saying goes “Theory is splendid but until put into practice, it is valueless”. In our previous post 20 Sales KPIs for awesome sales teams we discussed exte… Read More
2018-03-15 16:01
SQL Window Functions. Probably the coolest SQL feature which lacks popularity due to its peculiar syntax. But once you get used of it, you are running a high risk of putting… Read More
2018-01-26 22:18
The existence of every company depends on the revenues it generates from the products and services it offers to its customers – whatever the company may be. Among all t… Read More
![Startup Toolbox [2018]: Services And Tools](https://cdn.blogarama.com/images/posts_thumbs_site_id/3314/331398-3411495890.w320.jpg "Startup Toolbox [2018]: Services And Tools")
2018-01-26 13:07
As a startup, we always keep an eye on the latest marketing, customer success and productivity tools to help us stay connected and do our best work. Since the beginning of ou… Read More
2018-01-15 21:41
Whoever who has ever written code in any language would agree that date and time data types are the most frustrating of all. Of course, SQL is not an exception. Each SQL dial… Read More
2017-05-08 15:38
Following the previous posts on predicting email churn (here and here), we continued investigating different model approaches for predicting churn, utilizing some very constructive advice we… Read More
2017-04-15 14:00
...but still you may think you have a heck of a model.In the latest post of our Predicting Churn series articles, we sliced and diced the data from Mailchimp to try and gain some data insigh… Read More
2017-04-15 13:43
…but still you may think you have a heck of a model.
In the latest post of our Predicting Churn series articles, we sliced and diced the data from Mailchimp to try and gain some data… Read More
2017-04-14 14:21
Customer support is an important function of your company, and although in the past was considered more of a hassle that was keeping profits down, now people have started to realize that sup… Read More
2017-04-12 07:40
Data generation and usage is multiplying. Every day, we create 2.5 quintillion bytes of data, and that is a lot of data to gather and understand! So businesses simply have to adopt such tech… Read More
2017-03-30 19:15
We’re pleased to announce our newest partnership with Amazon as an official APN - Amazon Redshift Partner.
Data is undoubtedly one of the most powerful resources available to today&rs&hell…Read More
2017-03-27 10:06
Can I predict churn? Having an email list and being able to predict my churn, is a valuable tool in the hands of any marketer. The idea of predictive analysis and its application in email ma… Read More
2017-03-22 14:26
We are super excited to announce our partnership with Chartio. When we think of a business we focus on its product, marketing operations, sales and support data to provide valuable business… Read More
2017-02-13 16:03
Having your Stripe data into your data warehouse could help you access your raw Stripe payments data and get smart insights, that were not previously there. That is why companies are looking… Read More
2017-02-07 13:27
Welcome Hubspot! We are thrilled to introduce our Hubspot integration. You can now load all your marketing and sales data from Hubspot to your data warehouse.
If you're a Blendo user, you a… Read More
2017-01-31 23:53
Today we're super excited to announce that Blendo has joined the Confluent Partner Program to expand ETL as a service solutions and help drive the adoption and implementation of Apache Kafka… Read More
2017-01-31 22:02
Why anyone needs customer support analytics? Because things break usually.
How you fix them varies.
But analyzing and measuring your customer support metrics is equally important to al… Read More
2016-12-09 13:05
It's time to rethink how you load your data into Google BigQuery Here’s why...
Let me guess.
You want to load your data in Google BigQuery. You write your code, connect with all yo… Read More
2016-11-18 22:52
Time series data, a sequence of data points that are time ordered, often arise in analytics. Especially when we start working with user generated events. The interaction of a user with our p… Read More
2016-10-11 21:32
Do you want to improve your retargeting on Facebook?
Of course, you do. How about enriching it with some customer behavioral data from our product?
OK, let's take it a step back. Creating… Read More
2016-10-07 23:04
Are you ready to set free your SQL queries? Do you think that you have your data in silos?
If yes, then this article will show you how to own your data and then run your questions on top of… Read More
2016-09-29 22:27
You are a SaaS business and you have created the perfect customer acquisition strategy. You execute it flawlessly and people start flowing to your landing pages. Defining and keeping track o… Read More
2016-09-28 11:00
Issue 8
This week we will . and some of our favorite articles from the past week. Want these updates emailed to you right when they’re published? Join the Blendo Data newsletter here… Read More
2016-09-15 13:38
Customer Success is everywhere. It encompasses everything we do in our customer's lifetime and his interaction with our company. From sales and marketing to the moment the customer signups… Read More
2016-09-14 09:15
Want these updates emailed to you right when they’re published? Sign up here.
The most important KPIs to measure the success of your lead nurturing campaigns: A case study with Mailch… Read More
2016-09-12 21:41
The goal of marketing is to make potential customers aware of our product and to acquire some contact details that we can use to contact her in the future and try to convert her into a payin… Read More
2016-09-11 17:03
Despite the differences between transactional emails and email marketing, when it comes to analytics the fundamental metrics and KPIs that we should be tracking are quite similar. The main d… Read More
2016-09-09 08:26
How to Build a Custom Dashboard to Track the Most Important Metrics & KPIs of your Email Marketing Campaigns
This time we went 100% hands-on. We wrote a post with how to setup and mo… Read More
2016-09-01 10:17
There are over 10 million search results when searching for posts about email marketing optimization. There are even more resources on helping you to succeed this optimization. But how can y… Read More
2016-08-24 11:52
Email Marketing Data versus Transactional Email Data (read now)
As we rely more and more on analytics for email marketing, it is becoming important to select the tools that we’ll use… Read More
2016-08-21 21:39
Email marketing is still relevant and if you are not yourself already using it for your business, there are plenty of resources like these statistics out there to convince you on this fact… Read More
2016-08-17 08:20
The Best Blogs Every Data Analyst Should Follow (read now)
Data Analysts and Data Scientists are looking every day to uncover insights in a sea of data. What about looking to find the best… Read More
2016-08-14 22:00
When we discuss with our customers and our community of data analysts we always come up with a common list if go-to resources that everybody uses. Some days ago we wrote a short but awesome… Read More
2016-08-14 18:33
What is a Webhook
Usually, when we want to pull some data or ask a remote service to perform something for us, we make a request to it and we wait to get back a response. When the desired a… Read More
2016-05-09 20:28
Today we are really happy to host a post from Ariadni-Karolina Alexiou or Caroline in short. Caroline is a Data Engineer, with deep expertise in Python for Data Applications, Web Development… Read More
2016-05-03 08:08
In our previous month's Blendo Data Monthly we saw that one of the hottest topics in the Big data world today is Apache Kafka.
Apache Kafka is an open source technology that acts as a re… Read More
2016-05-02 11:54
Please raise your hands if you use Mailchimp for your marketing efforts. We use it here at Blendo to send out our blog emails.
That's why we’re happy to announce our MailChimp integra… Read More
2016-04-25 12:26
In this post, we will go through the data modeling aspect of the process of pulling data from Intercom to perform custom analytics. We will focus mainly on how data are modelled and delivere… Read More
2016-04-17 00:41
How can I get my data from Xero? How can I use Excel with Xero?
How can I have my data consistent and fresh or is It too techie for me?
You are not the only one with these questions. I hea… Read More
2016-04-12 12:34
Getting insights from data are what everybody is looking for. How about getting insights from someone that spent 30 years in digital analytics and understanding data?
Meet Stephane Hamel1… Read More
2016-04-04 12:47
There goes another Strata+Hadoop event. They are becoming more and more interesting by the time. The Strata + Hadoop World Conference in San Jose just finished.
IMHO Streaming, Apache Fli… Read More
2016-04-01 14:02
The cloud is transforming Financial Management for small and medium companies. By adopting cloud solutions, advantages once gained only through economies of scale are now accessible to all b… Read More
2016-04-01 14:02
The cloud is transforming Financial Management for small and medium companies. By adopting cloud solutions, advantages once gained only through economies of scale are now accessible to all b… Read More
2016-03-30 13:58
Strata + Hadoop World 2016, San Jose
This month's highlight is of course, Strata + Hadoop World in San Jose. According to Techcrunch there are seven things to watch for at Strata + Hadoop W… Read More
2016-03-30 13:58
Strata + Hadoop World 2016, San Jose
This month's highlight is of course, Strata + Hadoop World in San Jose. According to Techcrunch there are seven things to watch for at Strata + Hadoop W… Read More
2016-03-29 23:22
What does The Library of Alexandria, The Normans and a book have to do with data? I never thought about
The Library...
...at Alexandria was in charge of collecting all the world's knowl… Read More
Subscribe to Blendo: Data Management And Analytics
Get updates delivered right to your inbox!