Major New Integrations: S3, Magento, Heap, SFTP as data sources!!!
You can now connect S3, Magento, Heap and SFTP as a source to Blendo, making it easier than ever to analyze your data from such sources into your data warehouse.
Hubspot Integration: We have uopdated our Hubspot integration to sync the Contact Properties History and Deal Properties History. You can now see data like when and which property changed, from which source and which Vid involves. Please read our Hubspot integration help documentation.
Salesforce Pardot integration: We have majorly improved the speed of our Salesforce Pardot connector.
New improvements: Data Source Status History and Usage Views. The two new updates we launched give you visibility into what’s driving your usage metrics, and the status of your pipelines.
New Integration: NetSuite as a data source!!! NetSuite now connects with Blendo, making it easier than ever to analyze your data in NetSuite with other business data for smarter insights. You can connect NetSuite to any popular data warehouse in your analytics stack.
Major New Integrations: SQL Server, MySQL, MariaDB + MongoDB as data sources!!!
You can now connect SQL Server, MySQL, MariaDB and MongoDB databases as a source to Blendo, making it easier than ever to analyze your data from such databases like product data into your data warehouse. You can connect PostgreSQL to any popular data warehouse in your analytics stack.
New Integration: Zendesk Talk as data source!!! Zendesk Talk now connects with Blendo, making it easier than ever to combine data and metrics from your phone support software with other business data for smarter insights. You can connect Zendesk Talk to any popular data warehouse in your analytics stack.
New Integration: PostgreSQL as data source!!! You can now connect a PostgreSQL database as a source to Blendo, making it easier than ever to combine your production data with other business data for smarter insights. You can connect PostgreSQL to any popular data warehouse in your analytics stack.
Read the recent announcement for more details →
New Integration: Zendesk Chat!!! Zendesk Chat now connects with Blendo, making it easier than ever to combine your conversations’ data with other business data for smarter insights. You may, for example, pull data from Zendesk Support or Zendesk Guide and along with Zendesk Chat sync everything to any popular data warehouse.
Zendesk Integration: Ticket metrics per ticket are now integrated into the Tickets table. This change makes loading of ticket metrics much faster, with much fewer API calls. For backward compatibility, the old ticket metrics resource still exists but is considered deprecated.
Read the recent product update for more details →
Google Analytics Integration: There are users that have multiple pipelines syncing data from Google Analytics to the same table. Identifying which rows comes from which pipeline was not that easy. From now on, all records imported will have an extra column “viewid” which indicates the view which corresponds to each row in the database.
Read the recent product update for more details →
New! UI optimizations in Pipeline Status! For a better understanding of the pipeline status, we reworked a bit the pipeline information to offer easier status display and configuration options.
New Integration: Mews!!! Mews now connects with Blendo, making it easier than ever to combine your hospitality data with other business data for smarter insights. You can connect Mews to any popular data warehouse in your analytics stack.
New! SSH Tunnels! We can connect a destination behind private network through SSH Tunnel (Bastion host).
Users with databases in a private network (not public on the internet) can connect to them using an ssh bastion host, hosted by them, provided they use our public key.
Segment Integration: You have updated our Segment integration and become an official Segment Partner. As such we participate in the launch of their new Developer Center and Blendo will be a destination in Segment. That will enable loading your raw analytics and customer data into any data warehouse, effortlessly as always – the Blendo way.
Intercom Integration: We now sync the Teams resource.
Salesforce integration: We have updated our Salesforce integration to support soft deletes. Each sync will now also fetch deleted records. Please read our Salesforce Integration help document.
Xero integration: We have updated our Xero integration to support archived Contacts. Each sync will now also fetch archived Contact records.
Various updates in the backend.
Guides: We have a new section on our website. It’s our resource library which contains the guides and ebooks we publish.
Knowledge Base: We have consolidated our Data Source integration setup help guides with the Data Model documentation so you will always have one place to search for relevant information. Start here for the Data Source help documentation.
New Integration: Twitter Ads!!! You can now sync your Twitter Ads data into your data warehouse. Read our Twitter Ads Integration documentation.
New Integration: Linkedin Ads!!! You can now sync your Linkedin Ads data into your data warehouse to work on your ad spend. Read our Linkedin Ads Integration documentation on how to get started.
Hubspot integration: We have updated our Hubspot integration and you can now sync Contact custom fields as well.
Squashing 🐛.
New Integration: Salesforce Pardot!!! You can now sync your Salesforce Pardot data into your data warehouse. Read our Pardot Integration documentation on how to get started.
New Integration: DoubleClick for Publishers!!! You can now sync your DoubleClick for Publishers data into your data warehouse.
New Integration: ActiveCampaign!!! You can now sync your ActiveCampaign data into your data warehouse. Read our ActiveCampaign Integration documentation.
New Integration: Google Search Console!!! You can now sync your Google Search Console data into your data warehouse to work on your SEO. Read our Google Search Console Integration documentation on how to get started.
New Integration: Bing Ads!!! You can now sync your Bing Ads data into your data warehouse. Read our Bing Ads Integration documentation on how to get started.
Xero integration: We have updated our Xero integration and you can now select a sync interval for your older reports to compensate on changes that affect older reports.
Squashing 🐛.
Major Update: Notifications: Now Blendo will send intelligent error notifications when something goes wrong so you will always be aware. Notifications that will be sent in almost “real time” and as needed and include cases like authentication errors, rate limit issues, Internal or External errors or availability. Read more info on troubleshooting data source integrations and troubleshooting data warehouse destinations.
Major Update: Schema Selection. You are now able to select the Schema where the data will be stored to. During the creation of a pipeline, you can select at which Schema the data from source will be stored at (with public schema as default).
Stripe Integration: Major Improvements to the data model and how we handle updates and the event resource.
Salesforce Integration: Major Improvements to the data model and data we sync from Salesforce.
Stripe Integration: We now support Orders related resources. You may now sync Orders and Returns.
Intercom Integration: You can now see even more of your support data. We now support the Conversation Rating resource to help you analyze your customer satisfaction scores. Read about the Intercom schema and tables you expect to see.
New Section in our Knowledge Base: Troubleshooting.
New Integration: Google Analytics!!! You can now sync your Google Analytics data into your data warehouse. Read our Google Analytics Integration documentation on how to get started.
New Integration: Chargebee!!! You can now sync your Chargebee subscription data into your data warehouse. Read our Chargebee Integration documentation on how to get started.
Stripe Integration: You can now see even more data. We now support the Subscription related data like Coupons, Plans, Products etc. Read about the Stripe schema and tables you expect to see.
Freshdesk Integration: You can now see even more of your support data. We now support the Survey Questions and Satisfaction Ratings resources to help you analyze your surveys’ data and customer satisfaction scores. Read about the Freshdesk schema and tables you expect to see.
Xero: integration: We have updated our Xero integration and now the precision of the float numbers returned, is the same as the one you see in the Xero app. Read about the Xero schema and tables you expect to see.
Shopify Integration: We have updated our Shopify integration to support metafields or custom fields. Read about the Shopify schema and tables you expect to see.
Better User Profile Management. Find out more in our documentation.
Squashing 🐛.
You can now get alerts on your sync volume usage 🙌. Please read our Billing FAQ on how this works.
New Data Warehouse Integration: Snowflake!!! You can now load all your data into Snowflake. Read our blog post and our Snowflake documentation on how to get started.
Working heavily in the backend + various corrections.
New Integration: Freshdesk You can now sync your Freshdesk data into your data warehouse. Read our Freshdesk integration documentation on how to get started.
New Integration: Base CRM You can now sync your Base CRM data into your data warehouse. Read our Base CRM integration documentation on how to get started.
New Integration: Salesforce integration is now available! You can now sync your Salesforce data into your data warehouse. Read our blog post and our Salesforce integration documentation on how to get started
New Integration: You can now sync your Enchant data into your data warehouse.
We are thrilled to announce our How to Predict Email Marketing Churn ebook. It is free to download and can give you some insights on email subscribers or customer churn and how proactively avoid seeing customers slipping away. Get it here.
New Integration: You can now sync your Hubspot CRM data into your data warehouse. Read our Hubspot CRM integration documentation on how to get started.
New Data Warehouse Integration: Panoply!!! You can now load all your data into Panoply. With our Panoply.io integration, you are now able to provision in minutes a Redshift instance in 1-click and connect any data source through Blendo. Read our blog post and our Panoply documentation on how to get started.
New Integration: You can now sync your AfterShip data into your data warehouse. Read our blog post and our documentation on how to get started.
Facebook Ads & Google AdWords improvements. You are now able to choose a historical data sync and attribution window in your Google AdWords and Facebook Ads integrations. Check our documentation about Google AdWords and Facebook Ads.
Various improvements and bug fixes.
New Integration: QuickBooks!!! You can now sync your QuickBooks data into your data warehouse. Read our blog post and our documentation on how to get started. See here an overview of the QuickBooks expected data and a full view of the QuickBooks expected data tables and columns here.
Facebook Ads integration: Improved data model. See here an overview of the Facebook Ads expected data schema.
Hubspot integration: New resource added: Subscriptions
. See here an overview of the Hubspot expected data schema.
Working heavily in the backend + various corrections.
New Integration: You can now sync your Google AdWords data into your data warehouse. Read our blog post and our documentation on how to get started.
Zendesk integration: New and improved data model. See here an overview of the Zendesk expected data schema and a full view of Zendesk data expected tables and columns here.
Various improvements and bug fixes.
We are thrilled to announce our Amazon Redshift Guide for Data Analysts. It is free to download and can give you an holistic view of Redshift from a Data Analyst’s eye. Get it here.
🙌We’re pleased to announce our newest partnership with Amazon as an official APN – Amazon Redshift Partner. By partnering more closely with AWS, we’re excited to make it easier for more customers to unlock the value of their data, supercharge their BI and analytics and answer questions about their business. See the list of our partners.
We are thrilled to announce our partnership with Chartio. Getting all the raw information together into your data warehouse with Blendo, Chartio will provide your organization with the ability to have a clear view of your data at any moment in time. See our partners.
Delighted integration: Having your Delighted NPS data into your data warehouse could help you combine it with your customer support or marketing data. Read our blog post about it and our documentation on how to get started. See here an overview of the Delighted expected data and a full view of the Delighted expected data tables and columns here.
New Integration: Welcome Stripe! 🙌You can now send your Stripe data into your data warehouse. Read our blog post and documentation.
Facebook Ads integration: New and improved data model. See here an overview of the Facebook Ads expected data and a full view of the Facebook Ads expected tables and columns here.
Various improvements and bug fixes.
New Integrations!
Hubspot integration: We are thrilled to introduce our Hubspot integration. You can now load all your marketing and sales data from Hubspot to your data warehouse.
Stripe integration: 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. Read more on it.
New major Improvements the last weeks. Let’s take a look:
Intercom integration: We now support User Events 🙌 Ping us if you need it enabled.
Mixpanel integration: Import data up to once every 15 minutes. ⏱ by setting the frequency in the Schedule section. Any Mixpanel import will fetch events up to 15 minutes ago, to ensure Mixpanel has all requested events available. Please check our Mixpanel Data Model documentation.
Important Mixpanel Data Model Change: Our Mixpanel data model has changed! Please check our Mixpanel Data Model documentation.
Pipedrive integration: We now offer an improved data model which uses custom field names as table columns.
Facebook Ads integration: Are you an agency managing 100’s of FB accounts? We have you covered. Blendo can now support Facebook Ads accounts with more than 100 Facebook Ads managed accounts.
We now support Google BigQuery as destination data warehouse. It is in public beta and you may read more about it in our recent post. Check our BigQuery integration documentation too.
Shopify Improvements: Added Shopify entities for Collects, Custom Collections, and Smart Collections. Find out more on Shopify Expected data and Data Model.
We changed the UI to make it more straight forward. Now it is even simpler and faster to create your data pipelines. Read more about it.
More improvements:
Ability to connect to Redshift via SSL.
Shopify Improvements: Added Shopify entities for Fulfillment related resources. Find out more on Shopify Expected data and Data Model.
Various optimizations on our Pipedrive data source integration to make it even better for your needs.
Our Google BigQuery data warehouse is in closed beta! Let us know if you are interested or get onboard and we will add you to our list.
We are great fans of transparency and reporting. So, good news, everyone – we have built the backend, and we are making parts of it available for general use. You are now able to see your usage in a simple interface and how close you’re at your monthly row limit.
More Improvements
Mailchimp: We now bring data from your Automation and Automation Reports. Read how to sync your Mailchimp data with your data warehouse.
Facebook Ads: Added support to pull Offline Conversions. Check how to sync your Facebook Ads data with your data warehouse.
Xero: Bring data from Reports and Invoices. Learn how to sync your Xero data with your data warehouse.
Minor improvements in Intercom. Read how to sync your Intercom data with your data warehouse.
Two new integrations for you to use. Blendo and Shopify integration is generally available. There’s no touch point more vital for e-commerce companies than their shopping cart. Read our documentation on how to get all your Shopify data into one place.
Pipedrive CRM integration is also available. Sync all your sales and leads data to your data warehouse and optimize your sales funnels. It is easy to set it up but if you need help we have some great documentation to get started with Pipedrive CRM.
We now support Zendesk as a data source. Zendesk is one of the most popular customer service applications and as their motto say “Businesses are made of relationships. Those relationships can be complicated, but Zendesk helps make them better”.
Zendesk has all your customer service data. But what if you want to answer questions that need data from sales, marketing, billing or your product? Now you can sync your Zendesk data with your data warehouse.