--- title: How To Integrate quintly with Google BigQuery and Tableau description: This simple step-by-step process helps you to integrate quintly with Google BigQuery and the data visualization tool Tableau. image: https://www.quintly.com/hubfs/archive/98%20Assets_Archive/Blog/Imported_Blog_Media/BigQueryTableau_TW_840x440.jpg --- **[🚀 ANNOUNCEMENT: QUINTLY BECOMES FACELIFT DATA STUDIO→](https://www.quintly.com/quintly-becomes-facelift-data-studio)** [![facelift-datastudio-black-1](https://www.quintly.com/hubfs/facelift-datastudio-black-1.svg "facelift-datastudio-black-1")](https://www.quintly.com) ** ** Use cases [Brands Find the KPIs you need, get deep insights and build your brand by understanding your audience on social. ](https://www.quintly.com/brands) --- [Case Study: Benefit Cosmetics How the global beauty brand gained 50% growth in engagement and increased reach across the world. ](https://www.quintly.com/case-study/benefit-cosmetics) [Case Study: Meliá Hotels Int. How social media data is key to Meliá Hotels International and their brand's digital revolution. ](https://www.quintly.com/case-study/melia-hotels-international)   [Agencies Drive better decisions based on quality data using social analytics and reporting for all your clients. ](https://www.quintly.com/agencies) --- [Case Study: The Marketing Arm How this global agency uses social intelligence to win pitches and retain clients with top brands. ](https://www.quintly.com/case-study/the-marketing-arm) [Case Study: bürosüd plusNew! How bürosüd plus increased their audience by 40% ](https://www.quintly.com/case-study/burosud-plus-pr-and-communication-agency-quintly-case-study)   [Media Do more with your data using custom metrics and API integrations to optimize your social strategy. ](https://www.quintly.com/media) --- [Case Study: RTL Media Group How quintly helps a large news-media organization create a data-driven culture for their teams company-wide. ](https://www.quintly.com/case-study/rtl-media-group) [Case Study: Landau MediaNew! How Landau Media manages 50 profiles in one place ](https://www.quintly.com/case-study/landau-media) FEATURES [Analytics Track, benchmark and optimize your social media. ](https://www.quintly.com/analytics) [Data in Depth Secure, trusted data quality for better business. ](https://www.quintly.com/social-media-data)   [Reporting Create or automate reports, exports and live links. ](https://www.quintly.com/reporting) [API and Integrations Take analytics further with our API and integrations. ](https://www.quintly.com/social-media-data-integration) NETWORKS [Facebook ](https://www.quintly.com/facebook-analytics) [Instagram ](https://www.quintly.com/instagram-analytics) [Twitter ](https://www.quintly.com/twitter-analytics) [Snapchat ](https://www.quintly.com/snapchat-shows-analytics)   [LinkedIn ](https://www.quintly.com/linkedin-analytics) [YouTube ](https://www.quintly.com/youtube-analytics) [TikTokNew! ](https://www.quintly.com/tiktok-analytics) Company [About Us We’re people persons – read our story here. ](https://www.quintly.com/about) [Careers Looking for a job? See what we have to offer. ](https://quintly-jobs.personio.de/) [Contact Want to get in touch? Come say hi. ](https://www.quintly.com/contact) Resources [Blog Our latest articles, social news and industry insights. ](https://www.quintly.com/blog) [Social Media Studies Browse our collection of free reports. ](https://www.quintly.com/resources) [Knowledge Base More than a help center – updates, guides and more. ](https://help.facelift-cloud.com/en/collections/6890662-facelift-data-studio)     [Free stats portalNew! Check out popular industries & countries. ](https://info.quintly.com/free-stats) [Product newsNew! Receive the latest news on improvements and updates to our product  ](https://www.quintly.com/product-news) [![facelift-datastudio-black-1](https://www.quintly.com/hubfs/facelift-datastudio-black-1.svg "facelift-datastudio-black-1")](https://www.quintly.com) ** ** Solutions [Brands Find the KPIs you need, get deep insights and build your brand by understanding your audience on social. ](https://www.quintly.com/brands) --- [Case Study: Benefit Cosmetics How the global beauty brand gained 50% growth in engagement and increased reach across the world. ](https://www.quintly.com/case-study/benefit-cosmetics) [Case Study: Meliá Hotels How social media data is key to Meliá Hotels International and their brand's digital revolution. ](https://www.quintly.com/case-study/melia-hotels-international)   [Agencies Drive better decisions based on quality data using social analytics and reporting for all your clients. ](https://www.quintly.com/agencies) --- [Case Study: The Marketing Arm How this global agency uses social intelligence to win pitches and retain clients with top brands. ](https://www.quintly.com/case-study/the-marketing-arm) [Case Study: bürosüd plusNew! How bürosüd plus increased their audience by 40% ](https://www.quintly.com/case-study/burosud-plus-pr-and-communication-agency-quintly-case-study)   [Media Do more with your data using custom metrics and API integrations to optimize your social strategy. ](https://www.quintly.com/media) --- [Case Study: RTL Media Group How this large news-media organization creates a data-driven culture for their teams company-wide. ](https://www.quintly.com/case-study/rtl-media-group) [Case Study: Landau MediaNew! How Landau Media manages 50 profiles in one place ](https://www.quintly.com/case-study/landau-media) FEATURES [Analytics Track, benchmark and optimize your social media. ](https://www.quintly.com/analytics) [Data in Depth Secure, trusted data quality for better business. ](https://www.quintly.com/social-media-data)   [Reporting Create or automate reports, exports and live links. ](https://www.quintly.com/reporting) [API and Integrations Take analytics further with our API and integrations. ](https://www.quintly.com/social-media-data-integration) NETWORKS [Facebook ](https://www.quintly.com/facebook-analytics) [Instagram ](https://www.quintly.com/instagram-analytics) [Twitter ](https://www.quintly.com/twitter-analytics) [Snapchat ](https://www.quintly.com/snapchat-shows-analytics)   [LinkedIn ](https://www.quintly.com/linkedin-analytics) [YouTube ](https://www.quintly.com/youtube-analytics) [TikTokNew! ](https://www.quintly.com/tiktok-analytics/) Company [About Us We’re people persons – read our story here. ](https://www.quintly.com/about) [Careers Looking for a job? See what we have to offer. ](https://quintly.jobs.personio.de/) [Contact Want to get in touch? Come say hi. ](https://www.quintly.com/contact) Resources [Blog Our latest articles, social news and industry insights. ](https://www.quintly.com/blog) [Social Media Studies Browse our collection of free reports. ](https://www.quintly.com/resources) [Knowledge Base More than a help center – updates, guides and more. ](https://support.quintly.com)     [Free stats portalNew! Check out popular industries & countries. ](https://info.quintly.com/free-stats) [Product newsNew! Receive the latest news on improvements and updates to our product  ](https://www.quintly.com/product-news) [![quintly.com](https://www.quintly.com/hubfs/Design/Mayday/Pricing%20Page/white%20icons/AdvancedTraining.svg "quintly.com")](https://www.quintly.com/) ** ** [featured](https://www.quintly.com/blog/topic/featured) [Reach vs Impressions](https://www.quintly.com/blog/topic/reach-vs-impressions) [Twitter Analysis](https://www.quintly.com/blog/topic/twitter-analysis) [Youtube Analytics](https://www.quintly.com/blog/topic/youtube-analytics) [Instagram Strategy](https://www.quintly.com/blog/topic/instagram-strategy) [YouTube Data](https://www.quintly.com/blog/topic/youtube-data) [YouTube Metrics](https://www.quintly.com/blog/topic/youtube-metrics) ## [5 YouTube Analytics Metrics You Should Know](https://www.quintly.com/blog/5-youtube-analytics-metrics-you-should-know) by [David Campbell](https://www.quintly.com/blog/author/david-campbell) on August 11, 2023 [Read more](https://www.quintly.com/blog/5-youtube-analytics-metrics-you-should-know) ### Filter by Category - [Instagram Strategy (214)](https://www.quintly.com/blog/tag/instagram-strategy) - [Reach vs Impressions (213)](https://www.quintly.com/blog/tag/reach-vs-impressions) - [Twitter Analysis (213)](https://www.quintly.com/blog/tag/twitter-analysis) - [Youtube Analytics (213)](https://www.quintly.com/blog/tag/youtube-analytics) - [featured (213)](https://www.quintly.com/blog/tag/featured) [quintly Blog](https://www.quintly.com/blog)  /   [featured](https://www.quintly.com/blog/tag/featured) [Reach vs Impressions](https://www.quintly.com/blog/tag/reach-vs-impressions) [Twitter Analysis](https://www.quintly.com/blog/tag/twitter-analysis) [Youtube Analytics](https://www.quintly.com/blog/tag/youtube-analytics) [Instagram Strategy](https://www.quintly.com/blog/tag/instagram-strategy) [quintly news](https://www.quintly.com/blog/tag/quintly-news) [Features](https://www.quintly.com/blog/tag/features) [Data Integration](https://www.quintly.com/blog/tag/data-integration) 6 MINUTE READING TIME [featured](https://www.quintly.com/blog/tag/featured) [Reach vs Impressions](https://www.quintly.com/blog/tag/reach-vs-impressions) [Twitter Analysis](https://www.quintly.com/blog/tag/twitter-analysis) [Youtube Analytics](https://www.quintly.com/blog/tag/youtube-analytics) [Instagram Strategy](https://www.quintly.com/blog/tag/instagram-strategy) [quintly news](https://www.quintly.com/blog/tag/quintly-news) [Features](https://www.quintly.com/blog/tag/features) [Data Integration](https://www.quintly.com/blog/tag/data-integration) # How To Integrate quintly with Google BigQuery and Tableau by [Alexander Peiniger](https://www.quintly.com/blog/author/alexander-peiniger) on June 30, 2017 ![](https://www.quintly.com/hubfs/archive/98%20Assets_Archive/Blog/Imported_Blog_Media/BigQueryTableau_TW_840x440.jpg) We know that for many of our clients, analyzing social media data is only one of their challenges and that there are many more data buckets out there that they need to consider to achieve their overall digital marketing goals. Thus combining all these data points into one consistent story is what will lead you in the right direction in the end. That’s why at quintly we always try to be as flexible as possible, in particular when it comes to our exporting options. At the moment we already offer a vast range of export options, but sometimes a PNG, XLS, PPT or PDF export is not enough. And this is why we want to explain in this article how to combine quintly data with other data from a client’s organization. Setting up quintly with [Google BigQuery](https://bigquery.cloud.google.com) and [Tableau](https://www.tableau.com/) will not only help you to streamline your data analysis process, but also ensures that you have all the data you need integrated into one work process. We have worked closely with our clients to create a very easy and automated process. Through this we want to make sure that they can access their quintly data in any system they want to use. In addition, we also make sure that the data is updated continuously. In this blog article, I will dig deeper into the topic and show you how to integrate quintly with Google BigQuery and how to use this as a base for visualization tools like Tableau. If you follow this simple step-by-step process you can take the next step in automating your analytics workflow. [![data integration quintly ](https://www.quintly.com/hs-fs/hubfs/archive/98%20Assets_Archive/Blog/Imported_Blog_Media/338e3148-c473-4b1d-9593-459ff9035031-1.jpeg?width=930&height=338&name=338e3148-c473-4b1d-9593-459ff9035031-1.jpeg)](https://www.quintly.com/cs/c/?cta_guid=d796361a-d298-46ff-a021-292088aa3828&signature=AAH58kGjf75-mNWOs8itD_J5PQ0Ivhgu9Q&pageId=5324807478&placement_guid=43415b67-b64c-4063-b83a-fa2249e62f78&canon=https%3A%2F%2Fwww.quintly.com%2Fblog%2F2017%2F06%2Fintegrate-quintly-with-tableau&portal_id=3330298&__hstc=146014955.edf005364a2b7677ab5751a9529b665c.1692630115804.1692630115804.1692630115804.1&__hssc=146014955.100.1692630115804&__hsfp=1561754925&hsutk=edf005364a2b7677ab5751a9529b665c&contentType=blog-post) ### Step 1: Define which data to export As a starting point, you need to define which data you want to export. You can easily do this by looking at the default metrics that we have in our tool or simply build your [own custom metric](https://www.quintly.com/blog/2016/08/how-custom-metrics-can-fuel-your-social-media-reporting/) (QQL). Please note that the visualization style doesn’t play an important role here as the data will be exported in a raw format anyways, so rather look for the right content in your metric instead of focusing on the design. Depending on which visualization tool you will use in the end, this is the place where you think about how the data will be represented. Once you have found the data or metric that you want to integrate, you need to get the QQL query for this metric. You can do this very easily by clicking on the little “?” icon. In the opening popup you can just copy and paste the query. ![Custom Metric Builder QQL](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) ### Step 2: Fix table structure in BigQuery Now that you have decided on what data to export and you have the QQL query, it’s time to create the destination table in Google BigQuery where the data should be put into. To make it easy, our systems assume that the columns have the same names as they come out of the QQL query (that you got in Step 1). So if you want to have different column names, simply adjust the QQL query. As Google BigQuery is not *really* made for deleting data, you will have to create one additional column on top of the ones from the QQL. This column must be called “importTime” and is of type “DateTime”. Every time we write a row into this table, this field will be filled with the current time so that you always know when an entry was imported. This becomes especially important when we import raw level data like Facebook posts or Twitter tweets. As we will update the data every day, we will create a new line for every post every day. That means the same post could end up there multiple times, but it would show different import times. A little side note: To differentiate between the posts, only take the one with the most up-to-date “importTime” value. ![integrate quintly BigQuery](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) ### Step 3: Setup synchronization between quintly and BigQuery The next step is to automate the flow of data from quintly to Google BigQuery. At the moment there is no self-serve mode for this inside our tool, but you can [get in touch](http://support@quintly.com) with our support and we will help you to setup everything that is needed. With most of our clients, we already have setup a daily routine that updates the data in BigQuery, but we can adjust the frequency according to your needs. ### Step 4: Connect Tableau and Google BigQuery The last step is then to get the data from BigQuery into Tableau. You (or someone else in your company) may have done this already with lots of other data sources, so you would do it in the same way with the quintly data. If you haven’t done it before, Tableau has lots of great content to explain it in a very easy way, which can be found [here](https://www.tableau.com/learn/whitepapers/google-bigquery-tableau-best-practices). One of the first clients we have done such an integration with is [Benefit Cosmetics](https://www.benefitcosmetics.com). Their goal was to centralize all the data from the different tools they use and as they have been a long-term quintly client - We were very happy to work with them on achieving that goal together. ![integrate quintly Tableau](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) This is what they have to say: > "*Benefit Cosmetics is a brand with a large global footprint and quintly has been an invaluable partner in analyzing owned social media performance. Every quarter we launch new markets with their own respective social media accounts, and quintly helps seamlessly connect, collect, and analyze that data. * > > *In global analytics, where our goal is to aggregate data across our markets and mine it for insights, quintly is connected straight to our BigQuery data warehouse, allowing us to efficiently blend, subset, and visualize our data with the other tools in our BI stack.*" By following these four steps, you should be able to get your overall analytics to the next level. We know that social media data is only one of the many data buckets out there, so we want to be as flexible as possible with integrating it into your processes. We do this by offering a very modern API but also with integrations like the one described in this article. In case you are interested to explore a similar solution for your company, just get in touch with us and we will help you to get started. [![data integration quintly ](https://www.quintly.com/hs-fs/hubfs/archive/98%20Assets_Archive/Blog/Imported_Blog_Media/338e3148-c473-4b1d-9593-459ff9035031-1.jpeg?width=930&height=338&name=338e3148-c473-4b1d-9593-459ff9035031-1.jpeg)](https://www.quintly.com/cs/c/?cta_guid=d796361a-d298-46ff-a021-292088aa3828&signature=AAH58kGjf75-mNWOs8itD_J5PQ0Ivhgu9Q&pageId=5324807478&placement_guid=43415b67-b64c-4063-b83a-fa2249e62f78&canon=https%3A%2F%2Fwww.quintly.com%2Fblog%2F2017%2F06%2Fintegrate-quintly-with-tableau&portal_id=3330298&__hstc=146014955.edf005364a2b7677ab5751a9529b665c.1692630115804.1692630115804.1692630115804.1&__hssc=146014955.100.1692630115804&__hsfp=1561754925&hsutk=edf005364a2b7677ab5751a9529b665c&contentType=blog-post) ### **Recommended article** [Centralizing social media data with integrations and API](https://www.quintly.com/blog/social-media-data-integration) ### Related Categories [featured](https://www.quintly.com/blog/tag/featured) [Reach vs Impressions](https://www.quintly.com/blog/tag/reach-vs-impressions) [Twitter Analysis](https://www.quintly.com/blog/tag/twitter-analysis) [Youtube Analytics](https://www.quintly.com/blog/tag/youtube-analytics) [Instagram Strategy](https://www.quintly.com/blog/tag/instagram-strategy) [quintly news](https://www.quintly.com/blog/tag/quintly-news) [Features](https://www.quintly.com/blog/tag/features) [Data Integration](https://www.quintly.com/blog/tag/data-integration) ### [Alexander Peiniger](https://www.quintly.com/blog/author/alexander-peiniger) [featured](https://www.quintly.com/blog/topic/featured) [Reach vs Impressions](https://www.quintly.com/blog/topic/reach-vs-impressions) [Twitter Analysis](https://www.quintly.com/blog/topic/twitter-analysis) [Youtube Analytics](https://www.quintly.com/blog/topic/youtube-analytics) [Instagram Strategy](https://www.quintly.com/blog/topic/instagram-strategy) [YouTube Data](https://www.quintly.com/blog/topic/youtube-data) [YouTube Metrics](https://www.quintly.com/blog/topic/youtube-metrics) ## [5 YouTube Analytics Metrics You Should Know](https://www.quintly.com/blog/5-youtube-analytics-metrics-you-should-know) [Read more](https://www.quintly.com/blog/5-youtube-analytics-metrics-you-should-know) [featured](https://www.quintly.com/blog/topic/featured) [Reach vs Impressions](https://www.quintly.com/blog/topic/reach-vs-impressions) [Twitter Analysis](https://www.quintly.com/blog/topic/twitter-analysis) [Youtube Analytics](https://www.quintly.com/blog/topic/youtube-analytics) [Instagram Strategy](https://www.quintly.com/blog/topic/instagram-strategy) ## [7 Tips for Using Social Media Reporting Data To Tell a Story to Your Client](https://www.quintly.com/blog/7-tips-for-using-social-media-reporting-data-to-tell-a-story-to-your-client) [Read more](https://www.quintly.com/blog/7-tips-for-using-social-media-reporting-data-to-tell-a-story-to-your-client) [featured](https://www.quintly.com/blog/topic/featured) [Reach vs Impressions](https://www.quintly.com/blog/topic/reach-vs-impressions) [Twitter Analysis](https://www.quintly.com/blog/topic/twitter-analysis) [Youtube Analytics](https://www.quintly.com/blog/topic/youtube-analytics) [Instagram Strategy](https://www.quintly.com/blog/topic/instagram-strategy) [tiktok business](https://www.quintly.com/blog/topic/tiktok-business) ## [How to Build an Engaged Audience on TikTok](https://www.quintly.com/blog/how-to-build-an-engaged-audience-on-tiktok) [Read more](https://www.quintly.com/blog/how-to-build-an-engaged-audience-on-tiktok) ![](https://www.quintly.com/hs-fs/hubfs/Marketing%20/blog-en/General%20Files/5%20Ideas%20banner%20promo%20module-3.png?width=120&name=5%20Ideas%20banner%20promo%20module-3.png "5 Ideas banner promo module-3.png") ## 5 Ideas to Optimize Your Social Media Analysis   [Download the E-book](https://info.quintly.com/optimize-your-social-media-performance) ### Join the conversation. Leave us a comment below! ## See where you stand on social media. Get in touch today to track, benchmark and optimize your social media performance with advanced analytics made easy. #### Solutions #### Integrations #### Platform #### Networks #### Resources What's new #### Company #### Contact Copyright © 2024 Facelift Data Studio. All rights reserved. • [Terms](https://www.quintly.com/terms) • [Privacy](https://www.quintly.com/privacy) • [More...](https://www.quintly.com/transparency) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Alexander Peiniger", "url" : "https://www.quintly.com/blog/author/alexander-peiniger" }, "dateModified" : "2023-08-29T10:14:38.551Z", "datePublished" : "2017-06-29T22:00:00.000Z", "headline" : "How To Integrate quintly with Google BigQuery and Tableau", "image" : [ "https://www.quintly.com/hubfs/archive/98%20Assets_Archive/Blog/Imported_Blog_Media/BigQueryTableau_TW_840x440.jpg" ], "mainEntityOfPage" : { "@id" : "https://www.quintly.com/blog/2017/06/integrate-quintly-with-tableau", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.quintly.com/hubfs/2024-home/facelift_logo_new_black_rgb.svg" }, "name" : "Facelift brand building technologies GmbH" } } ```