<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Blend your data world - Medium]]></title>
        <description><![CDATA[Blendo helps companies get their data from anywhere into their data warehouse and reduces the time of building full data pipelines in minutes instead of months. https://www.blendo.co - Medium]]></description>
        <link>https://medium.com/blend-your-data?source=rss----196871b49dd0---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>Blend your data world - Medium</title>
            <link>https://medium.com/blend-your-data?source=rss----196871b49dd0---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 19:27:48 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/blend-your-data" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Sales Teams’ 20 Most Important KPIs]]></title>
            <link>https://medium.com/blend-your-data/sales-teams-20-most-important-kpis-8e0542e7dd2e?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/8e0542e7dd2e</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[metrics]]></category>
            <category><![CDATA[sales-kpis]]></category>
            <category><![CDATA[monitoring-and-evaluation]]></category>
            <category><![CDATA[sales]]></category>
            <dc:creator><![CDATA[George Voerakos]]></dc:creator>
            <pubDate>Thu, 08 Aug 2019 14:51:01 GMT</pubDate>
            <atom:updated>2019-08-08T14:51:01.209Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RrVSAdh_P9b4oaIvXKxOEw.jpeg" /></figure><p>Every company “gambles” its existence on the generated revenues from the products and services that are offering to its customers with no regard of the company’s product or service. Among all of the company’s teams, the one that influences the profitability the most are the sales teams. Thus, all strategic decisions that affect the operations of this team cannot be guided by intuition due to the high failure risk.</p><p>Instead, specific performance indicators must be taken into account while making decisions. Such indicators are numbers that can be turned into meaningful stories with actionable insights.</p><blockquote>So, what should a company should measure regarding its sales performance?</blockquote><h4>Key Performance Indicators</h4><p>These performance indicators are called <strong>key performance indicators (</strong><a href="https://en.wikipedia.org/wiki/Performance_indicator"><strong>KPIs</strong></a><strong>), </strong>and they are frequently used for creating the necessary reports. Thus, all tactics that you use for approaching new customers, your email campaigns, your website as well as the use of social media channels, and all the elements must be reflected in your KPIs.</p><p>The good news is that the modernized sales operations can use many different services which can provide an ocean of data. By integrating data from multiple sources into a database, you can monitor all the critical factors that affect your business.</p><h3>KPIs</h3><p>However, to identify what exactly are the KPIs, you need to pay attention to you must start thinking about the goals that you have set and the sales mix you are using. It is certain though that the goals of each company are different and as a result, the performance indicators that need to be measured.</p><p>So, there is nothing as one-size-fits-all. That is the reason, in this post, we are going to present the most critical KPIs as well as the data source you can use to calculate them.</p><h4>Types of KPIs</h4><p>When it comes down to <strong>sales</strong>, the most important performance measures have to do mainly with <a href="https://www.marketingterms.com/dictionary/conversion_rate/"><strong>conversions rates</strong></a><strong>. </strong>For example, how many leads and opportunities are converted into paying customers and what is the amount of revenue generated from them. Apart from these, you may find it useful to monitor other aspects too, such as inbound and outbound reach effectiveness or the productivity of each agent.</p><h4>Service-Based KPIs</h4><p>If you are still building your sales team and you are using some service like <a href="https://www.blendo.co/integration/salesforce/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>Salesforce</strong></a>, <a href="https://www.blendo.co/integration/hubspot/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>Hubspot</strong> </a>or <a href="https://www.blendo.co/integration/pipedrive/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>Pipedrive</strong></a>, then here are some pointers of where your KPIs should aim.</p><p>In this section, we have included a set of metrics and sales KPIs that focus on every step of the sales process. Monitoring all these steps is essential while taking a closer look at your sales team performance.</p><h4>Outbound Reach KPIs</h4><ol><li><em>The number of emails sent</em>: This KPI represents the absolute number of emails sent during the outbound lead generation.</li><li><em>Calls made</em>: It represents the absolute number of calls made during the outbound lead generation.</li><li><em>Email Open Rate</em>: The email open rate KPI measures the percentage of people who open an email from an outbound approach.</li><li><em>Click-through rate</em>: Similarly to the previous metric, click-through rate measures the percentage of email receivers that click a link included in the outbound email they received.</li><li><em>Email Response Rate</em>: Out of the total number of sent emails, how many receivers replied.</li><li><em>Average/Maximum/Minimum Lead Response Time</em>: A sales KPI regarding the time a receiver of an email, i.e., a lead, takes to reply.</li><li>Average/Maximum number of follow-ups before responding: Statistics regarding the total number of contact attempts a marketer makes before receiving a response of any kind.</li><li><em>Demos scheduled</em>: Whenever applicable, it represents the absolute number of demos scheduled during the outbound lead generation. It refers to those leads that have already responded and have expressed interest in the company’s products but have requested for a live demonstration before considering to convert.</li></ol><p>For more information regarding outbound reach, you can also check <a href="http://www.marketing-schools.org/types-of-marketing/outbound-marketing.html"><strong>here</strong></a>.</p><h3>Pipeline Metrics</h3><p>Being able to monitor the progress of the sales team on a higher level is also crucial. You can get in a blink of an eye a more unobstructed overall view of the performance without having to combine information from multiple graphs.</p><ol><li><em>Length of the sales cycle</em>: The sales cycle is the time starting from the first contact with a potential customer until his deal is finally closed (either won or lost).</li><li><em>Total Opportunities Opened by month</em>: This KPI represents the absolute number of leads that turned into opportunities each month.</li><li><em>Total Opportunities Closed by month</em>: The absolute number of opportunities closed each month either as won or lost.</li><li><em>Lead to Opportunity Conversion Rate</em>: This Sales KPI Reflects the percentage of leads that turned into opportunities each month.</li><li><em>Opportunity to Win Conversion Rate</em>: Reflects the percentage of opportunities that turned into paying customers each month.</li><li><em>Average Contract Value</em>: This metric represents the average value of each sale.</li></ol><blockquote>If you want a more detailed description you may go here and find the the <a href="https://www.blendo.co/blog/sales-kpis-sales-team/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>20 Sales KPIs for awesome sales teams</strong></a><strong>.</strong></blockquote><h3>Conversion Metrics</h3><ol><li><em>Percentage of Deals Won</em>: The KPI calculates the percentage of won deals overall closed deals over a specific period, e.g., a month or a quarter.</li><li><em>Percentage of Deals Lost</em>: The percentage of lost deals over all closed deals over a specific time, e.g., a month or a quarter.</li><li><em>The overall trend in lead generation</em> (comparison to the number of previous months): A comparative measure between the leads generated this month against those of the last.</li></ol><h3>Sales Productivity</h3><ol><li><em>Distribution of Lead per sales reps (Owner)</em>: When a lead is created, it gets assigned to an owner. Its owner is responsible for keeping in contact with this specific lead.</li><li><em>Distribution of Opportunities per sales reps (Owner)</em>: The same sales reps own opportunities as they did as leads. This metric, along with the previous one, can reflect how well each sales reps doing. Sales reps with have many owned opportunities are likely more convincing than others.</li><li><em>Percentage of sales reps achieving 100% quota</em>: Each sales representative has a daily or monthly goal. That can be expressed either as total emails sent out every day/month or as the total number of leads or opportunities that converted into paying customers. By measuring how close each representative came to his goal is a way of evaluating how productive he was.</li></ol><h3>Revenue Gain Metrics</h3><p>By integrating your data from a CRM system like <a href="https://www.blendo.co/integration/salesforce/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>Salesforce</strong></a><strong> </strong>with other Financial Services like <a href="https://www.blendo.co/integration/stripe/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>Stripe</strong></a><strong>,</strong> you can also measure:</p><ol><li><em>Total Revenue</em>: The ultimate sales KPI that instantly translates selling efforts into value. It can also work as a motivator for the sales team.</li><li><em>Total Revenue generated from top 10% customers</em>: By identifying the company’s most valuable customers and tracking the revenue generated by them can give the sales team more insight into the value of each one of them and furthermore help them prioritize the company’s customers.</li><li><em>Revenue by product</em>: This metric helps the sales team to determine what portion of the total revenue was generated by each product separately. It is even more helpful in the case of new products where this proportion is equal to the value-added by the addition of a new product or service.</li><li><em>Total Revenue in Sales Pipeline</em>: It is highly correlated with the Average Contract Value KPI mentioned before. While not all potential customers in the sales pipeline are going to convert to paying ones, monitoring their total potential revenue can help the sales time to realize how valuable each one of them is for the company.</li></ol><h3>Final thoughts on sales KPIs</h3><p>In today’s world, the competition that a company has to face is higher and more fierce than ever before. And so is the amount of the available data. Only by taking advantage of it, a company can continue to thrive through continuous monitoring of the right performance indicators and business metrics within a data-driven culture.</p><p><em>You can find more resources about sales KPIs. Check out these posts:</em></p><ul><li><a href="https://www.blendo.co/blog/salesforce-kpis-sales-dashboard-sql/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>11 Salesforce KPIs for your Sales Dashboard (incl. SQL code)</strong></a></li><li><a href="https://www.blendo.co/blog/hubspot-crm-kpis-sales-dashboard/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>6 Hubspot CRM KPIs for every Sales Manager’s Dashboard (incl. SQL code)</strong></a></li><li><a href="https://www.blendo.co/blog/pipedrive-sales-analytics-kpis/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis"><strong>Master your Pipedrive sales analytics with these KPIs</strong></a></li></ul><p>Additionally, start your free trial Blendo’s to get the most out of your data.</p><p><a href="https://www.blendo.co/signup/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=sales_kpis">Sign Up - Blendo</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8e0542e7dd2e" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/sales-teams-20-most-important-kpis-8e0542e7dd2e">Sales Teams’ 20 Most Important KPIs</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[6 Hubspot CRM KPIs for every Sales Manager’s Dashboard]]></title>
            <link>https://medium.com/blend-your-data/6-hubspot-crm-kpis-for-every-sales-managers-dashboard-642b1c9f7003?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/642b1c9f7003</guid>
            <category><![CDATA[sales]]></category>
            <category><![CDATA[kpi-dashboard]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[hubspot-crm]]></category>
            <dc:creator><![CDATA[George Voerakos]]></dc:creator>
            <pubDate>Tue, 06 Aug 2019 13:49:15 GMT</pubDate>
            <atom:updated>2019-08-06T13:49:15.275Z</atom:updated>
            <cc:license>http://creativecommons.org/publicdomain/zero/1.0/</cc:license>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*S1QECctu2NgqJr8s.png" /></figure><h4>The Modern Sales Process</h4><p>Every company’s main drive is the generating of sufficient revenues, which is highly related to survival. Thus, it becomes evident why monitoring the performance of the sales team is a must and a critical point to a sales manager’s everyday routine.</p><p>Nowadays, the use of different cloud applications like Customer Relationship Management (CRM) systems can create enough leverage for your sales team and ensure a modernized sales process. Using the valuable data residing in your CRM, you can produce all the necessary data for your key performance indicators.</p><h4>Hubspot’s Data:</h4><p><strong>Hubspot </strong>as one of the most widely used CRM systems which can centralize all information regarding companies, contacts, and deals into records. Each combination of these object types can create unique properties for assisting you in generating meaningful business insights.</p><p>That being said, the appropriate key performance indicators (KPIs) for a sales manager can create the whole picture regarding the performance of the sales team.</p><blockquote>If you are an SQL type of person you may go here and find the SQL code for these <a href="https://www.blendo.co/blog/hubspot-crm-kpis-sales-dashboard/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=hubspot_crm_kpis"><strong>Hubspot CRM KPIs</strong></a><strong>.</strong></blockquote><p>So far, we have explored a more comprehensive set of <a href="https://www.blendo.co/blog/sales-kpis-sales-team/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=hubspot_crm_kpis">Sales KPIs</a>, proven to be extremely useful for every sales team. Let’s see what we can build with the data that <strong>Hubspot CRM</strong> has available.</p><p>Using this dashboard, the key performance indicators which may be useful to monitor, as part of the prospecting activity and pipeline flow metrics, include the total number of deals generated in a specific period, e.g., month or quarter, or even their breakdown based on concrete <strong>Hubspot CRM</strong> pipelines.</p><h3>Prospecting Activity &amp; Pipeline Flow Analysis</h3><h4>Monthly Total Deals</h4><p>Usually, an initial indicator is the analysis of the Total Monthly Deals.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/842/0*HgAPeF-jCQX5rW_h.png" /></figure><p>This visualization allows you to see how your lead generation and the deals you generate advances over time. If you apply any improvements in your process, this is where you will start viewing the first results. You can also create more detailed visualizations to analyze your sales division:</p><h4>Monthly Total Deals Organized by Pipeline ID</h4><p>Furthermore, the analysis of the total deals can be used for evaluating every one of your pipelines.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/847/0*qEEkCERQgixFuvTf.png" /></figure><p>By segmenting the total deals in smaller groups based on Pipeline ID, you can extract more conclusions. For example, insights about specific actions such as inbound or outbound sales or promotion through different channels and how their performance evolves in time.</p><p>You can also dive even more in-depth and monitor in details the flow through your sales pipeline. The key performance indicators that can calculate the total number of generated leads, how many of them were marked as qualified by your sales team and finally what percentage of them ended up as won or lost deals.</p><p>These metrics reflect the effectiveness of the client acquisition approach directly. The percentage of leads that finally converted into paying customers is an indicator of your salespersons’ performance but can also provide you with additional information.</p><p>For example, if you find out that the conversion rates dramatically decrease after a certain number of touches, you can use this knowledge as a benchmark to prevent your team from insisting more than they should.</p><h4>Every deal in a microscope</h4><p>In Hubspot, each deal at any given point in time belongs to a particular pipeline stage as it processes through the sales funnel.</p><p>In the general case, these stages include leads, qualified leads, and won or lost deals.</p><p>Your sales funnel, can include many more custom-made stages specific to your business case but for simplifying this post, let’s assume that the only four stages, which previously mentioned, exist.</p><p>Monitoring the number of deals at any of these stages can easily calculate the conversion and drop-out rates while in case the results are not satisfying enough you have to dig deeper to reveal what pushes your potential customers away.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/847/0*FZGnr0edNHELG__6.png" /></figure><p>Alternatively, you can define contacts as the units of your analysis. Exactly as we did with deals above, you can monitor the total number of new contacts created in a specific period.</p><p>You can also change the granularity of such an analysis by switching from daily to monthly intervals based on what is more suitable for your specific business case.</p><h4>Contacts created by month</h4><p>Additionally, you can create dashboards with the number of contacts every month.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/662/0*wUyd1JvUVJVQCNOR.png" /></figure><h3>Sales Productivity</h3><p>Another aspect that is worth mentioning is the monitoring of productivity. Every manager wants to know how well the sales reps are performing in comparison with their co-workers. That can help him either reward those who demonstrate excellent performance and achieve the sales goals or provide further guidance to those who don’t.</p><p>For this purpose, metrics that are relevant to the distribution of lost and won deals among sales reps can be helpful.</p><p>Some of the metrics can be:</p><p>1) Deals distribution among sales reps</p><p>2) Deals distribution among sales reps organized by deal’s current stage</p><p>Monitoring the relative difference between won and lost deals for every sales representative, a manager can extract interesting information regarding his team.</p><p>In case a daily or monthly goal is set for every member of the team in terms of deal generation or deal wins, these metrics, along with other <a href="https://www.blendo.co/blog/sales-kpis-sales-team/">KPIs</a>, are valuable in quantifying the extent to which these predefined goals are achieved.</p><h3>Final Thoughts &amp; Considerations</h3><h4>Conclusion</h4><p>Thus, there are more possibilities you can read about <a href="https://www.blendo.co/blog/hubspot-crm-kpis-sales-dashboard/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=hubspot_crm_kpis"><strong>Hubspot CRM KPIs</strong></a>.</p><p>Once you have defined a basic set of KPIs that suits your business, then you can start with analyzing the information you can get out of them. You may understand why you get these results, how you can improve your sales team performance and determine if there are other KPIs that you may need to monitor as well.</p><p>After all, establishing a complete KPIs dashboard is the result of an iterative process. It requires constant revisions until the selection of the final KPIs directly reflected or are tied to an overarching goal.</p><h4>Further Considerations</h4><p>To create fast and accurate reports, it is essential that each manager collects and synchronize his data.</p><p><em>That is why you need </em><a href="https://www.blendo.co/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=hubspot_crm_kpis"><em>Blendo</em></a><em>!</em></p><p>Blendo is a simple, ETL-as-a-service platform, designed to support the integration of data from multiple SaaS applications like Hubspot.</p><p>You can get more information or <a href="https://www.blendo.co/signup/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=hubspot_crm_kpis">sign-up</a> here:</p><p><a href="https://www.blendo.co/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=hubspot_crm_kpis">Blendo - Self-serve data integration and ETL</a></p><p><em>Originally posted in </em><a href="https://www.blendo.co/blog/hubspot-crm-kpis-sales-dashboard/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=hubspot_crm_kpis"><strong><em>Blendo Blog</em></strong></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=642b1c9f7003" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/6-hubspot-crm-kpis-for-every-sales-managers-dashboard-642b1c9f7003">6 Hubspot CRM KPIs for every Sales Manager’s Dashboard</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Building Financial Analytics Dashboards with Google Data Studio and BigQuery]]></title>
            <link>https://medium.com/blend-your-data/building-financial-analytics-dashboards-with-google-data-studio-and-bigquery-19c2ef83b869?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/19c2ef83b869</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[accounting]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[xero]]></category>
            <category><![CDATA[quickbooks]]></category>
            <dc:creator><![CDATA[Blendo]]></dc:creator>
            <pubDate>Wed, 31 Oct 2018 13:51:01 GMT</pubDate>
            <atom:updated>2018-10-31T13:51:01.388Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CtHhrAvxqIVKXlgtnLCwhg.jpeg" /></figure><p>In the past, <strong>Accounting</strong> was one of the first industries disrupted by spreadsheet software. With the advent of the cloud and software as a service (SaaS), applications like <strong>Xero</strong> or <strong>QuickBooks</strong> brought <strong>accounting in the cloud</strong>. Today new technologies <strong>impact the insights you can get from your financial records</strong>. This along with non-traditional data turn industry change and technology into opportunity.</p><p>But how can we move from <strong>bookkeeping to true business analytics</strong> and turn financial information into <strong>action</strong>? We’ve created an eBook dedicated to <strong>financial analytics</strong> with the purpose of providing insight and assisting <strong>CFOs and accountants</strong> with offering advanced reporting to their customers.</p><h3>A sneak peak</h3><p>So, how can you improve the visibility of financial data like revenue growth and inventory turnover by building a fully scalable solution that will help you span data from multiple data sources? Here’s a small taste of what’s offered in our eBook.</p><p>&gt; Understand how to use data from <strong>Xero</strong> or <strong>Quickbooks</strong> for <strong>financial dashboards</strong>.<br> &gt; Learn how to use <strong>Google Sheets</strong> and <strong>Google BigQuery</strong> to work with financial data.<br> &gt; Discover how to create financial reports and dashboards in <strong>Google Data Studio</strong>.<br> &gt; Leverage Blendo’s industry-leading data solution, to aggregate different sources in one place with a few simple clicks.</p><p>These tips and insights will help you collect your data in a way that makes it easier and less time consuming to more accurately track your financial analytics and your business.</p><p>Here’s what you’ll learn in the eBook:</p><ul><li>How to generate Google Sheets reports from Xero or QuickBooks</li><li>How to use Google BigQuery to manage multiple data sources</li><li>How to create financial analytics reports from Xero or QuickBooks in Google data studio</li><li>How to use Google Data Studio to track data and create new Xero or QuickBooks reports</li><li>How to use Blendo to create a fully scalable solution to overcome the time-consuming and error-prone task of consolidating financial data</li></ul><h3>Get your copy of Building Financial Analytics Dashboards!</h3><p>Access your free copy of <a href="https://www.blendo.co/blog/ebook-financial-analytics-google-data-studio-bigquery/?utm_source=medium.com&amp;utm_medium=referral&amp;utm_campaign=financial_analytics_ebook"><strong>Building Financial Analytics Dashboards</strong></a><strong>: an eBook for accountants and CFOs</strong> to get actionable advice on managing data from <strong>Xero</strong> and <strong>QuickBooks</strong>, plus a deeper look at the options you have to help you build new services and products to harness the value that still locked into your Xero and QuickBooks data. You can also learn more about Blendo’s solution by <strong>contacting us</strong> directly: hello@blendo.co.</p><p><em>Originally published at </em><a href="https://www.blendo.co/blog/ebook-financial-analytics-google-data-studio-bigquery/"><em>www.blendo.co</em></a><em> on October 25, 2018.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=19c2ef83b869" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/building-financial-analytics-dashboards-with-google-data-studio-and-bigquery-19c2ef83b869">Building Financial Analytics Dashboards with Google Data Studio and BigQuery</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[A Guide to Tracking the Digital Marketing Metrics that Matter — New Blendo eBook Download]]></title>
            <link>https://medium.com/blend-your-data/a-guide-to-tracking-the-digital-marketing-metrics-that-matter-new-blendo-ebook-download-48dbb7c0e3a5?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/48dbb7c0e3a5</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[marketing-analytics]]></category>
            <category><![CDATA[advertising]]></category>
            <dc:creator><![CDATA[Blendo]]></dc:creator>
            <pubDate>Tue, 30 Oct 2018 12:52:51 GMT</pubDate>
            <atom:updated>2018-10-30T12:41:37.798Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MHVHwIscSMP2VWMUtAszWw.jpeg" /></figure><h3>A Guide to Tracking the Digital Marketing Metrics that Matter — New Blendo eBook Download</h3><p>We are really excited about this one. Our team has released a new eBook to show <strong>digital marketers</strong> how to use <strong>Google’s Suite</strong> of free tools currently available to them in order to <strong>drive more ROI out of the data</strong>. By using Google’s powerful <strong>Data Studio</strong>, <strong>Google Sheets</strong> and various data sources <strong>marketers can generate the insights they need for optimal marketing performance</strong>.</p><p>The eBook lays out <strong>highly actionable tips</strong> for how to use <strong>Google’s Marketing Suite</strong> to collect and manipulate the disparate data sets created by all the different advertising platforms currently in use (Facebook, Twitter, AdWords, Bing etc.) without the nightmare of needing to export CSV files into spreadsheets. By leveraging Blendo’s industry-leading data solution, marketers can aggregate different sources in various data warehouse solutions and even Google Sheets with a few simple clicks.</p><p>These tips and insights will help you collect your data in a way that makes it easier and less time consuming to more accurately track spend and performance on your campaigns.</p><p>Here’s what you’ll learn in the eBook:</p><ul><li>How to set up tracking so you can get a single picture of cross-channel data;</li><li>How to generate Google Sheets reports from Google Adwords;</li><li>How to use Google BigQuery to manage quantities of data that are too large to be handled in a single spreadsheet;</li><li>How to create marketing reports in Google data studio;</li><li>How to use Google Data Studio to track data and create new reports out of all the separate data sources;</li><li>How to use Blendo to create a fully scalable solution to overcome the time-consuming and error-prone task of manually manipulating data to track ad spend — all without the need to build or maintain an ETL infrastructure.</li></ul><p>Here are some of the specific questions the eBook answers:</p><ul><li>What information fields should I use to track ad spend in Adwords and Facebook Ads, and how should I aggregate them?</li><li>What resources are available to help me set up an Adwords or Facebook Ads data transfer into BigQuery?</li><li>How can I create a report showing the most relevant metrics Adwords ad spending tracking in Google’s Data Studio?</li><li>How can Blendo help eliminate the complexity associated with using free tools like BigQuery?</li></ul><h3>Download the eBook to Get Help Making Sense of the Digital Marketing Madness</h3><p>Digital Marketers don’t have it easy in today’s environment. Executives know how much data is out there, and it falls to you to collect it, analyze it, and execute on it. Opportunities to drive ROI have never been better — or more complicated.</p><p>We’ve designed this eBook to help you shine a little bit of light on the hidden-in-plain-sight insights currently living in your cloud. If you want to learn how you can start breaking through platform silos, consolidating your data, and getting more out of your digital marketing efforts then download your copy of our <a href="https://www.blendo.co/get-digital-marketing-metrics-guide/?utm_source=medium.com&amp;utm_medium=referral&amp;utm_campaign=marketing_devs_ebook">Tracking the Digital Marketing Metrics that Matter for Digital Marketers</a>. You can also learn more about Blendo’s solution by contacting us directly: hello@blendo.co.</p><p><em>Originally published at </em><a href="https://www.blendo.co/blog/ebook-guide-tracking-digital-marketing-metrics/"><em>www.blendo.co</em></a><em> on September 29, 2018.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=48dbb7c0e3a5" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/a-guide-to-tracking-the-digital-marketing-metrics-that-matter-new-blendo-ebook-download-48dbb7c0e3a5">A Guide to Tracking the Digital Marketing Metrics that Matter — New Blendo eBook Download</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[New Integration: Import Your QuickBooks Data into your Data Warehouse]]></title>
            <link>https://medium.com/blend-your-data/new-integration-import-your-quickbooks-data-into-your-data-warehouse-61b887f87001?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/61b887f87001</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[blendo]]></category>
            <category><![CDATA[accountancy]]></category>
            <category><![CDATA[quickbooks]]></category>
            <category><![CDATA[data-analytics]]></category>
            <dc:creator><![CDATA[Blendo]]></dc:creator>
            <pubDate>Wed, 28 Jun 2017 13:01:46 GMT</pubDate>
            <atom:updated>2019-06-06T16:04:32.709Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Do you use </em><strong><em>QuickBooks</em></strong><em> and want to sync all your </em><a href="https://www.blendo.co/integration/quickbooks/"><em>Accounting data into your data warehouse</em></a><em> in minutes? Well, we’ve got some excellent news for you! We’re excited to announce that our newest integration with QuickBooks Online is live and available for use. QuickBooks is one of the world’s leading accounting software platforms.Many companies use it to manage their invoicing and their business along the way.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SR1TpRLNeRAgaPFolfiLCw.png" /></figure><p>The new integration will connect Blendo with QuickBooks Online using our new connector. That means you can connect to QuickBooks in seconds, pull your data into your data warehouse in minutes and start working ASAP with your data. Blendo will take care all the data model and schema of your data in your data warehouse. All of our integration data models are optimized for analytics use and you as a data analyst in mind.</p><p>With the new QuickBooks connector, data analysts spend less time manually downloading order information, and more time generating smart insights. By having QuickBooks data in your database you may go beyond QuickBooks’s dashboards and drill down to your most essential QuickBooks accounting data and enable advanced tracking of your accounting and payments data.</p><p>In addition and most importantly you now have the ability to combine your accounting data with data from Facebook Ads or Google AdWords for example. Drill down to your data and see which campaign is more profitable or event understand your marketing expenses and support costs.</p><h3>How do I connect QuickBooks to sync my accounting data into your data warehouse?</h3><p>To get started <a href="https://app.blendo.co/login/signup">signup or login to Blendo</a> (you can try it free for 14 days). If you have connected a data warehouse already just add a new data source and follow the on-screen instructions to connect QuickBooks.</p><p><a href="https://www.blendo.co/">Blendo - Self-serve data integration and ETL</a></p><h3>Need help? Check out our short walkthrough below.</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*scodje1cSv7uhFTakebxZQ.gif" /></figure><p>Or check our documentation on <a href="https://www.blendo.co/documents/quickbooks-integration/">how to setup a QuickBooks integration</a>.</p><h3>SUPPORTED DATA WAREHOUSES</h3><p>With Blendo, you can now send your QuickBooks data into <a href="https://www.blendo.co/integration/quickbooks-to-amazon-redshift/">Amazon Redshift</a>, <a href="https://www.blendo.co/integration/quickbooks-to-google-bigquery/">Google BigQuery</a>, <a href="https://www.blendo.co/integration/quickbooks-to-ms-sql-server/">MS SQL Server</a>, or <a href="https://www.blendo.co/integration/quickbooks-to-postgresql/">PostgreSQL</a>.</p><h3>WHAT KIND OF QUICKBOOKS DATA AM I GOING TO SEE IN MY DATA WAREHOUSE?</h3><p>Here is an overview of the <a href="https://www.blendo.co/documents/expected-quickbooks-data/">expected QuickBooks tables and columns</a> in your data warehouse.</p><h3>WHAT’S NEXT?</h3><p>Blendo helps teams inside the various functions in a company to connect their accounting data with their data warehouse. Previously silo-ed data now they can be accessed without effort in engineering and time resources.</p><p>Want to try QuickBooks integration? <a href="https://www.blendo.co/">Try Blendo for 14 days, FREE</a>.</p><p><a href="https://www.blendo.co/">Blendo - Self-serve data integration and ETL</a></p><p><a href="https://www.blendo.co/blog/new-integration-import-your-quickbooks-data-into-your-data-warehouse/"><em>Originally posted at Blendo Blog.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=61b887f87001" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/new-integration-import-your-quickbooks-data-into-your-data-warehouse-61b887f87001">New Integration: Import Your QuickBooks Data into your Data Warehouse</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[New Integration: Import Your Google AdWords Data into your Data Warehouse]]></title>
            <link>https://medium.com/blend-your-data/new-integration-import-your-google-adwords-data-into-your-data-warehouse-c66022200204?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/c66022200204</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[advertising]]></category>
            <category><![CDATA[blendo]]></category>
            <category><![CDATA[google-adwords]]></category>
            <category><![CDATA[marketing-analytics]]></category>
            <dc:creator><![CDATA[Blendo]]></dc:creator>
            <pubDate>Tue, 20 Jun 2017 11:51:32 GMT</pubDate>
            <atom:updated>2017-06-20T11:51:21.106Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Running a social media agency? a marketing agency? an e-commerce shop? Data from your ads like Google AdWords help you have a better view of your customer’s journey. We make it easy to collect these data.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sW_WCm49OAYihwG95FPKqg.png" /></figure><p>You asked us if you can sync your <a href="https://www.blendo.co/integration/google-adwords/">Google AdWords data into your data warehouse</a>. As of today, our Google AdWords integration is live and available.</p><p><a href="https://app.blendo.co/login/signup"><strong>Connect your AdWords account to Blendo today and sync your ads data to your data warehouse.</strong></a></p><h3>WHY DOES ANYONE NEED TO SYNC GOOGLE ADWORDS DATA INTO A DATA WAREHOUSE?</h3><p>This integration connects with your AdWords account through OAuth. This allows Blendo to pull your ads data from AdWords and sync it to your data warehouse. This way you may combine your AdWords data along with other ads, marketing or support data into one place. Such a combination gives you the ability to drill down to your data from your advertisements to ad level. It also helps you really understand how much do you pay for your ads, or calculate your ROI down to the keyword and which ad converts better new users. Combine it with your event data and see if they are engaging with your product, or are they churning?</p><p><a href="https://www.blendo.co/integration/google-adwords/">Import your Google AdWords data into your data warehouse - Blendo.co</a></p><h3>Getting your Google AdWords data into your data warehouse</h3><p>Here is a short intro on <strong>how to connect Google AdWords as a data source</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QKQ7cyVLbFENVh-npREg_g.gif" /></figure><p>Check our documentation on <a href="https://www.blendo.co/documents/google-adwords-integration/">how to setup a Google Adwords integration</a>.</p><p><a href="https://www.blendo.co/documents/google-adwords-integration/">Google AdWords Integration - Blendo</a></p><h3>SUPPORTED DATA WAREHOUSES</h3><p>With Blendo, you can now send your Google Adwords data into warehouses like:</p><ul><li><a href="https://www.blendo.co/integration/google-adwords-to-amazon-redshift/">Amazon Redshift</a></li><li><a href="https://www.blendo.co/integration/google-adwords-to-google-bigquery/">Google BigQuery</a></li><li><a href="https://www.blendo.co/integration/google-adwords-to-ms-sql-server/">MS SQL Server</a></li><li><a href="https://www.blendo.co/integration/google-adwords-to-postgresql/">PostgreSQL</a></li></ul><h3>WHAT KIND OF GOOGLE ADWORDS DATA AM I GOING TO SEE IN MY DATA WAREHOUSE?</h3><p>Here is an overview of the <a href="https://www.blendo.co/documents/expected-delighted-data/">expected Google AdWords tables and columns</a> in your data warehouse.</p><h3>WHAT’S NEXT?</h3><p>Blendo helps teams inside the various functions in a company to connect their marketing, support and sales data with advertisement data to optimize better their channels and superpower their analytics. Previously silo-ed data now they can be accessed without effort in engineering and time resources.</p><p>Want to try Google AdWords integration? <a href="https://app.blendo.co/login/signup">Try Blendo for 14 days, FREE</a>.</p><p><a href="https://www.blendo.co/">Blendo - Self-serve data integration and ETL</a></p><p><a href="https://www.blendo.co/blog/new-integration-import-your-google-adwords-data-into-your-data-warehouse/"><em>Originally posted at Blendo Blog.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c66022200204" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/new-integration-import-your-google-adwords-data-into-your-data-warehouse-c66022200204">New Integration: Import Your Google AdWords Data into your Data Warehouse</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Blendo joins AWS Partner Network as an official Amazon Redshift Partner]]></title>
            <link>https://medium.com/blend-your-data/blendo-joins-aws-partner-network-as-an-official-amazon-redshift-partner-717a49fcf37?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/717a49fcf37</guid>
            <category><![CDATA[blendo]]></category>
            <category><![CDATA[amazon-redshift]]></category>
            <category><![CDATA[data-warehouse]]></category>
            <category><![CDATA[etl]]></category>
            <category><![CDATA[aws]]></category>
            <dc:creator><![CDATA[George Psistakis]]></dc:creator>
            <pubDate>Fri, 16 Jun 2017 09:41:01 GMT</pubDate>
            <atom:updated>2017-06-16T09:41:01.252Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Today we’re super excited to announce that </em><a href="https://medium.com/u/3adfd7b846b2"><em>Blendo</em></a><em> has joined AWS Partner Network as an </em><a href="https://www.blendo.co/"><strong><em>official Amazon Redshift Partner</em></strong></a><em>.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*dd8s5O-yzQL3XZatcSxX0Q.png" /></figure><p><strong>We’re pleased to announce our newest partnership with Amazon as an official APN — Amazon Redshift Partner.</strong></p><p>Data is undoubtedly one of the most powerful resources available to today’s companies. Data generate in multiple sources like your product, a company’s marketing, sales and customer support. As new data sources emerge and the volume of data increases, getting value out of these data is imperative and has to be done quickly.</p><p><strong>Blendo</strong> as an <a href="https://www.blendo.co/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=aws-redshift-announc">ETL-as-a-service platform</a> wants to take this vision further. That is why we are partnering with some of the most prominent companies in the <strong>cloud data infrastructure</strong> today and that is why we are super excited that now <a href="https://aws.amazon.com/redshift/partners-detail/blendo/">Blendo is an APN Technology Partner and authorized Amazon Redshift Partner</a>.</p><p>Blendo, allows you to connect a variety of data sources from marketing, ads, customer support or CRM e.g. Zendesk, Stripe, Intercom or Mailchimp into your data warehouse in order to build advanced data analytics infrastructure. And, it only takes a few minutes to get from zero to ‘up and running’ with your integrations and start loading your data into a single place. <a href="https://www.blendo.co/integration/amazon-redshift/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=aws-redshift-announc">Blendo provides output to multiple data warehouses and among them is Amazon Redshift</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*0BZyaIEDZpT4Y2Ms.png" /></figure><p>In order to qualify for the <strong>APN Amazon Redshift Partner program</strong> requires passing service-specific verification of customer references and a technical review from AWS. That gives our customers confidence that using Blendo means they work with an AWS partner who can offer a proven and endorsed cloud solution.</p><p>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.</p><p>If you want to give Blendo a try signup here.</p><p><a href="https://www.blendo.co/">Blendo - Self-serve data integration and ETL</a></p><p>You are also welcome to download our <strong>free e-book</strong> <a href="https://www.blendo.co/get-amazon-redshift-guide">The Complete Amazon Redshift Guide for Analysts</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*iBh592F1mq85kOpn_uI5wg.png" /></figure><h4>About Amazon Redshift Partners</h4><p><a href="https://aws.amazon.com/redshift/partners/">Amazon Redshift Data Integration Partners</a> are certified solutions of industry-leading tools and services that make it easy to load and transform data into Amazon Redshift.</p><h4>About AWS Partner Network (APN)</h4><p>The AWS Partner Network (APN) is the global partner program for AWS that encircles high-quality companies who deliver solutions on AWS.</p><h4>About Blendo</h4><p>Blendo is a simple, ETL-as-a-service platform on steroids, designed to support the integration of data from multiple SaaS applications like Zendesk, MailChimp or Intercom and loading into a data warehouse like Google BigQuery, Amazon Redshift or Microsoft SQL Server. With Blendo, you can build data pipelines and support your team of analysts or build your Analytics or BI stack in minutes. Backed by <a href="http://www.venturefriends.vc/">Venture Friends VC</a>, <a href="http://elevatorfund.com/">Elevator Fund</a> and <a href="http://www.iqbility.com/">IQbility</a> is based in Palo Alto and Athens. To learn more, visit <a href="https://www.blendo.co/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=aws-redshift-announc">www.blendo.co</a> or <a href="https://www.blendo.co/blog/?utm_medium=referral&amp;utm_source=medium.com&amp;utm_campaign=aws-redshift-announc">read our blog</a>.</p><p><a href="https://www.blendo.co/blog/blendo-joins-aws-apn-amazon-redshift-partner/"><em>Originally posted in Blendo Blog.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=717a49fcf37" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/blendo-joins-aws-partner-network-as-an-official-amazon-redshift-partner-717a49fcf37">Blendo joins AWS Partner Network as an official Amazon Redshift Partner</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[New Integration: Import Your Stripe Payments Data into your Data Warehouse]]></title>
            <link>https://medium.com/blend-your-data/new-integration-import-your-stripe-payments-data-into-your-data-warehouse-c57773504379?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/c57773504379</guid>
            <category><![CDATA[etl]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[stripe]]></category>
            <category><![CDATA[blendo]]></category>
            <category><![CDATA[analytics]]></category>
            <dc:creator><![CDATA[Blendo]]></dc:creator>
            <pubDate>Tue, 13 Jun 2017 09:11:01 GMT</pubDate>
            <atom:updated>2017-06-13T09:11:01.239Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1016/1*KLqL4giqBU5EkwEUXCns7g.png" /></figure><p>Having your <a href="https://www.blendo.co/integration/stripe/">Stripe data into your data warehouse</a> could help you access your raw Stripe payments data and get smart insights, that were not previously there. That is why companies are looking to integrate their Stripe data in their data warehouses like <strong>AWS Redshift</strong>, <strong>Google BigQuery</strong> or <strong>Microsoft SQL Server</strong>.</p><p>We are excited to introduce our latest integration with Stripe. <a href="https://stripe.com/">Stripe</a> is one of the best ways to accept payments online, and it is a robust payments platform.</p><p>Getting <strong>smart business insights</strong> and make <strong>data-driven</strong> business decisions will require you to connect the dots that will span data from your <em>product</em>, <em>marketing</em>, <em>sales</em> or <em>customer service</em>. If you add <em>revenue</em> in the loop then everything “translates” to measurable value.</p><h3>LOOKING FOR ANSWERS</h3><p>Tracking your revenue is easy. A look at your bank account or in Stripe dashboards can give you an idea. But having access to your <em>raw payment data</em> makes you more flexible on understanding where this revenue comes from and how to optimize it.</p><p>Getting your raw payment data sure has its value, but where it makes the difference is in <strong>combining multiple sources from all business functions</strong>.</p><p>Having all your raw data in one data warehouse means you can be flexible and have clarity over it and get smarter insights. You may get a lot of new users from your recent email marketing campaign, but <em>do they buy your service?</em> If they buy your service, <em>do they create havoc in your customer support department?</em> Or <em>how is your churn affected by ticket resolution time?</em></p><p>Another example would be to measure <em>customer lifetime value per channel</em>. Customers come from various touchpoints, and you may calculate the 6/conversion cost and revenue generated.</p><p>These examples can be all measured by combining data from your customer support tools like Zendesk or Intercom. Email marketing data from tools like MailChimp. Advertisement information from your Facebook Ads or Google Ads and of course your payments tool i.e. Stripe.</p><h3>NO MORE NITTY GRITTY INTEGRATIONS</h3><p>Your analyst’s job is not integrating and maintaining APIs. Even if it is easy for a dev to help, sometimes getting specific resources as you want them in a data warehouse table proves to be even trickier.</p><h3>Getting your Stripe data into your data warehouse</h3><p>With <strong>Blendo</strong> we give you super powers. Here is a short intro on <strong>how to connect Stripe as a source</strong>.</p><p>Using other popular sources like <strong>MailChimp</strong>, <strong>Intercom</strong>, <strong>Facebook Ads</strong> or <strong>Zendesk</strong>, you can <strong>connect marketing spend with support and revenue and superpower your analytics</strong>.</p><ul><li>Analyze your revenue and uncover trends.</li><li>Find out if your marketing efforts bring the return you expect.</li><li>Combine infromation from other sources like support and sales. Uncover the funnel of your users that converts better and earns you revenue.</li></ul><h3>SUPPORTED DATA WAREHOUSES</h3><p>With Blendo, you can now send your Stripe payments data into warehouses like:</p><ul><li><a href="https://www.blendo.co/integration/hubspot-to-amazon-redshift/">Amazon Redshift</a></li><li><a href="https://www.blendo.co/integration/hubspot-to-google-bigquery/">Google BigQuery</a></li><li><a href="https://www.blendo.co/integration/hubspot-to-ms-sql-server/">MS SQL Server</a></li><li><a href="https://www.blendo.co/integration/hubspot-to-postgresql/">PostgreSQL</a></li></ul><h3>WHAT’S NEXT?</h3><p>Blendo helps teams inside the various functions in a company to connect their analysis with revenue. Previously silo-ed data now they can be accessed without effort in engineering and time resources. Be up and running in minutes.</p><p>Sync all your information in a data warehouse, connect your BI tool or access the raw data and dive-in.</p><p>Blendo will take care all the heavy lifting for you; so you can create smarter insights. Today.</p><p><a href="https://www.blendo.co/documents/stripe-integration/"><strong>Check out our documentation for complete information about Stripe integration</strong></a>.</p><p>Get it now while it’s hot! <a href="https://www.blendo.co/">Try Blendo for 14 days, FREE</a>.</p><p><a href="https://www.blendo.co/integration/stripe/">Import your Stripe data into your data warehouse - Blendo.co</a></p><p><em>Originally posted in </em><a href="https://www.blendo.co/blog/new-integration-import-delighted-nps-data-data-warehouse/"><em>Blendo Blog</em></a>.</p><p><a href="https://www.blendo.co/blog/stripe-payments-data-into-data-warehouse/">New Integration: Import Your Stripe Payments Data into your Data Warehouse - Blendo</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c57773504379" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/new-integration-import-your-stripe-payments-data-into-your-data-warehouse-c57773504379">New Integration: Import Your Stripe Payments Data into your Data Warehouse</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[New Integration: Import Your Delighted NPS Data into your Data Warehouse]]></title>
            <link>https://medium.com/blend-your-data/new-integration-import-your-delighted-nps-data-into-your-data-warehouse-307878188d8b?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/307878188d8b</guid>
            <category><![CDATA[etl]]></category>
            <category><![CDATA[delighted]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[blendo]]></category>
            <dc:creator><![CDATA[Blendo]]></dc:creator>
            <pubDate>Fri, 09 Jun 2017 13:16:56 GMT</pubDate>
            <atom:updated>2017-06-09T13:16:41.969Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*uKarRkepSdfNJc16Vn_SBQ.png" /></figure><p>If you are looking to sync all your <a href="https://www.blendo.co/integration/delighted/">NPS data from Delighted into your data warehouse</a> you can now succeed it in minutes. With Delighted you can easily send NPS surveys to your customers and get actionable feedback for your product and business.</p><h3>WHY DOES ANYONE NEED TO SYNC NPS DATA INTO A DATA WAREHOUSE?</h3><p>Getting a 10, a 9 or 8 feedback for your NPS is awesome! But how is this NPS value connected with your customer support or your sales?</p><p>Here are some examples of things you can learn:</p><p>You may see how your NPS fluctuates over time and per person. Was a customer happy in the begging and today no?</p><p>Another example would be to find out what tickets and problems your customers are reporting. How do they affect your NPS and your customer’s delight?</p><p>Or, if some leads are better than others. These examples can be all measured by combining data from your customer support tools like Zendesk or Intercom. Email marketing data from tools like MailChimp. Advertisement information from your Facebook Ads or Google Ads and of course your payments tool i.e. Stripe.</p><p>Having all your data from customer support, customer success email marketing or payments tools in your data warehouse can help you ask questions in raw SQL or use a BI tool to visualize your dashboards.</p><h3>Getting your Delighted data into your data warehouse</h3><p>Here is a short intro on <strong>how to connect Delighted as a data source</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eWztt_u_y9lRjdr0mEvscw.gif" /></figure><p>Check our documentation on <a href="https://www.blendo.co/documents/delighted-integration/">how to setup a Delighted integration</a>.</p><p><a href="https://www.blendo.co/documents/delighted-integration/">Delighted Integration - Blendo</a></p><h3>SUPPORTED DATA WAREHOUSES</h3><p>With Blendo, you can now send your Delighted NPS data into warehouses like:</p><ul><li><a href="https://www.blendo.co/integration/delighted-to-amazon-redshift/">Amazon Redshift</a></li><li><a href="https://www.blendo.co/integration/delighted-to-google-bigquery/">Google BigQuery</a></li><li><a href="https://www.blendo.co/integration/delighted-to-ms-sql-server/">MS SQL Server</a></li><li><a href="https://www.blendo.co/integration/delighted-to-postgresql/">PostgreSQL</a></li></ul><h3>WHAT KIND OF DELIGHTED DATA AM I GOING TO SEE IN MY DATA WAREHOUSE?</h3><p>Here is an overview of the <a href="https://www.blendo.co/documents/expected-delighted-data/">expected Delighted tables and columns</a> in your data warehouse.</p><h3>WHAT’S NEXT?</h3><p>Blendo helps teams inside the various functions in a company to connect their analysis with NPS feedback. Previously silo-ed data now they can be accessed without effort in engineering and time resources.</p><p>Want to try Delighted integration? <a href="https://www.blendo.co/">Try Blendo for 14 days, FREE</a>.</p><p><a href="https://www.blendo.co/integration/delighted/">Import your Delighted data into your data warehouse - Blendo.co</a></p><p><em>Originally posted in </em><a href="https://www.blendo.co/blog/new-integration-import-delighted-nps-data-data-warehouse/"><em>Blendo Blog</em></a>.</p><p><a href="https://www.blendo.co/blog/new-integration-import-delighted-nps-data-data-warehouse/">New Integration: Import Your Delighted NPS Data into your Data Warehouse - Blendo</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=307878188d8b" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/new-integration-import-your-delighted-nps-data-into-your-data-warehouse-307878188d8b">New Integration: Import Your Delighted NPS Data into your Data Warehouse</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Introducing Hubspot Integration: Make your Marketing Analytics Go The Extra Mile]]></title>
            <link>https://medium.com/blend-your-data/introducing-hubspot-integration-make-your-marketing-analytics-go-the-extra-mile-273b513e6c82?source=rss----196871b49dd0---4</link>
            <guid isPermaLink="false">https://medium.com/p/273b513e6c82</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[blendo]]></category>
            <category><![CDATA[hubspot]]></category>
            <category><![CDATA[etl]]></category>
            <dc:creator><![CDATA[Blendo]]></dc:creator>
            <pubDate>Tue, 06 Jun 2017 12:12:04 GMT</pubDate>
            <atom:updated>2017-06-06T12:11:45.314Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*bsYV99c4lEtRLqP_QuYc5A.png" /></figure><p><strong>Welcome Hubspot!</strong> We are thrilled to introduce our Hubspot integration. You can now <a href="https://www.blendo.co/integration/hubspot/">load all your marketing and sales data from Hubspot to your data warehouse</a>.</p><p>If you’re a Blendo user, you already know that we make it easy to <a href="https://www.blendo.co/">collect your valuable data from any data source into your data warehouse in minutes</a>.</p><p>Marketeers know <a href="https://www.hubspot.com/">Hubspot</a> as an awesome inbound marketing and sales tool that helps attract visitors, leads, and convert them to customers. Yeah, they have an excellent <a href="https://blog.hubspot.com/marketing">marketing blog</a> too.</p><h3>MARKETING ANALYTICS</h3><p>So your company probably generates a large number of valuable data related to your marketing, sales, and customers inside Hubspot.</p><p>As a <strong>tech-savvy marketeer (or not so much)</strong> or a <strong>data analyst</strong>, you probably think that you need to get these valuable data into your <strong>BI</strong> or <strong>analytics stack</strong>. <strong>Fast</strong>. And start working with them.</p><p>From our side, we understand the importance of marketing data and the value they can bring in a company if fused with data like customer success, product, billing or customer support.</p><p>That’s why we built the integration with Hubspot.</p><p>If you think this is not for you, or it is too techie, please stay. Getting your Hubspot data into your data warehouse is a 2 minutes process and not at all techie!</p><h3>GETTING YOUR HUBSPOT DATA INTO YOUR DATA WAREHOUSE</h3><p>Here is a short intro on how to connect Hubspot as a data source.</p><p>The idea is simple:</p><p>1) You need to have a data warehouse.</p><p>2) Connect it to Blendo</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/898/0*uyMDmFBMo6soohBs.png" /></figure><p>3) Connect Hubspot to Blendo</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/735/0*28RuL4yXfoj-mjqN.png" /></figure><p>4) We connect everything</p><p><a href="https://www.blendo.co/documents/hubspot-integration/">Check out our documentation for complete information about Hubspot integration</a> and enjoy or <strong>click bellow </strong>to go to the guide.</p><p><a href="https://www.blendo.co/documents/hubspot-integration/">Hubspot Integration - Blendo</a></p><h3>YOUR HUBSPOT DATA IN YOUR DATA WAREHOUSE</h3><p>Having connected Hubspot with Blendo, you can now send your marketing data into data warehouses like:</p><ul><li><a href="https://www.blendo.co/integration/hubspot-to-amazon-redshift/">Amazon Redshift</a></li><li><a href="https://www.blendo.co/integration/hubspot-to-google-bigquery/">Google BigQuery</a></li><li><a href="https://www.blendo.co/integration/hubspot-to-ms-sql-server/">MS SQL Server</a></li><li><a href="https://www.blendo.co/integration/hubspot-to-postgresql/">PostgreSQL</a></li></ul><p>Blendo will take care all the heavy lifting for you; sync your Hubspot data, <a href="https://www.blendo.co/documents/expected-hubspot-data/">prepare the Hubspot data model in your database</a> so that you can work your way up to your insights and value for your company.</p><h3>WHAT’S NEXT?</h3><p>If you’re using SQL, you now have all your data from multiple data sources in one place to analyze. If you want to use a <a href="https://www.blendo.co/the-ultimate-list-of-custom-dashboards-and-bi-tools-to-track-your-metrics-and-gather-insights/">BI tool or dashboard</a> on top of your data warehouse, Blendo will help you supercharge your BI stack, your data reports, and your team.</p><p>Data previously inaccessible, are now on your favorite, easy to use data warehouse and tool of your choice. In minutes.</p><p><a href="https://www.blendo.co/blog/introducing-hubspot-integration-marketing-analytics/">Introducing Hubspot Integration: Make your Marketing Analytics Go The Extra Mile - Blendo</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=273b513e6c82" width="1" height="1" alt=""><hr><p><a href="https://medium.com/blend-your-data/introducing-hubspot-integration-make-your-marketing-analytics-go-the-extra-mile-273b513e6c82">Introducing Hubspot Integration: Make your Marketing Analytics Go The Extra Mile</a> was originally published in <a href="https://medium.com/blend-your-data">Blend your data world</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>