{"id":1102,"date":"2018-03-08T17:11:27","date_gmt":"2018-03-08T17:11:27","guid":{"rendered":"https:\/\/canonicalized.com\/?p=1102"},"modified":"2018-11-12T06:26:06","modified_gmt":"2018-11-12T06:26:06","slug":"tableau-google-analytics","status":"publish","type":"post","link":"https:\/\/canonicalized.com\/tableau-google-analytics\/","title":{"rendered":"Tableau &#038; Google Analytics &#8211; Integrate, Expand, Create"},"content":{"rendered":"<p>Love Google Analytics? Love Tableau? Why not bring them together?<\/p>\n<h3>Us &amp; Tableau<\/h3>\n<p>We are working with Google Analytics every single day. Sometimes I get the feeling we&#8217;re investing too much time into it.<\/p>\n<p>When I re-discovered Tableau, I felt it brought a whole new perspective to our analytics approach.<\/p>\n<p>The first times I tried it, I didn&#8217;t feel very comfortable with it. Or I might not have been ready for the power of Tableau.<\/p>\n<p>According to Tony Robbins, if we do the <strong>right thing<\/strong> at the <strong>wrong time<\/strong> we get <strong>pain<\/strong> in return. But the timing was right the last time.<\/p>\n<p>So hop on this ride with us to see how we can use it to supercharge our data!<\/p>\n<h2 id=\"advantages\" title=\"Advantages\">Advantages of using Tableau with Google Analytics<\/h2>\n<ol start=\"1\">\n<li>The ability to <strong>integrate<\/strong> GA data with other sources like marketing tools, CRM, ERP, databases, etc.<\/li>\n<\/ol>\n<p>Here&#8217;s a nice video example of blending GA with MySQL data<\/p>\n<p><iframe src=\"https:\/\/www.youtube-nocookie.com\/embed\/a8JcoGj48DE?rel=0\" width=\"100%\" height=\"521\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<ol start=\"2\">\n<li><strong>Supercharge<\/strong> your analysis with forecasting, clustering, etc.<\/li>\n<\/ol>\n<p><i>Example 1:<\/i> Here&#8217;s us clustering our content by visitor engagement:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/engangement-dashboard.png\" alt=\"engangement-dashboard\" \/><\/p>\n<p><i>Example 2:<\/i> use of Tableau&#8217;s forecast functionality<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/tableau-forecast.png\" alt=\"tableau-forecast\" \/><\/p>\n<ol start=\"3\">\n<li>A bit of <strong>data cleaning<\/strong>: splitting and grouping<\/li>\n<\/ol>\n<p><i>Example 1:<\/i> you have traffic reaching the same landing page, but with different parameters like below<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/landing-pages-with-parameters.png\" alt=\"landing-pages-with-parameters\" \/><\/p>\n<p>In Tableau, you can use the Split option to have the full data for your landing page.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/tableau-split.png\" alt=\"tableau-split\" \/><\/p>\n<p><i>Example 2:<\/i> you have a page for which you have changed the URL; in Tableau, you can select the old and the new URLs and group them (this way you can look at the full data for your page):<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/group-URLs-tableau.png\" alt=\"group-URLs-tableau\" \/><\/p>\n<ol start=\"4\">\n<li>The ability to <strong>calculate your measures<\/strong><\/li>\n<\/ol>\n<p><i>Example:<\/i> you want to look at <strong>User conversion rate<\/strong> instead of the <strong>session<\/strong> based one offered by Analytics. In Tableau, we can quickly create a Calculated field. Simple as this:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/user-conversion-rate-calculation.png\" alt=\"user-conversion-rate-calculation\" \/><\/p>\n<ol start=\"5\">\n<li>Interesting ways of <strong>dealing with outliers<\/strong><\/li>\n<\/ol>\n<p>Our favorite way of spotting anomalies is to put the data inside box-plots. Here we can just select and exclude exceptions from our reports:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/box-plot-outliers.png\" alt=\"box-plot-outliers\" \/><\/p>\n<p>ConversionXL has an <a href=\"https:\/\/conversionxl.com\/blog\/outliers\/\" target=\"_blank\" rel=\"noopener\">extensive guide<\/a> on how to deal with outliers. We have also written about ways to discover them in <a href=\"\/google-analytics-missing-custom-reports\/?section=box-plots-histograms\">our article on Google Analytics data visualization<\/a>.<\/p>\n<ol start=\"6\">\n<li><strong>Automated reporting and alerting<\/strong> if you are using Tableau Online or Server. There are options to do it inside GA, just that the reports are a lot uglier.<\/li>\n<\/ol>\n<p>Here&#8217;s the same daily report built on Google Analytics vs. Tableau:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/ga-report-example.png\" alt=\"ga-report-example\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/tableau-report-example.png\" alt=\"tableau-report-example\" \/><\/p>\n<ol start=\"7\">\n<li><strong>Interactivity<\/strong> in one click<\/li>\n<\/ol>\n<p>I save the best for last. In my opinion, the best part of Tableau is the ability to filter the dashboards by clicking on the visuals.<\/p>\n<h2 id=\"td-connector\" title=\"GA Connector\">The Tableau Desktop connector<\/h2>\n<p>I love the Google Analytics Connector from Tableau! It enables us to pull data quickly to whip up an analysis for any date range.<\/p>\n<p>Note that the connector is only available for paid licenses of Tableau. If you want to use Tableau Public (the free version), you can extract the data into Google Sheets using the<\/p>\n<p><a href=\"https:\/\/developers.google.com\/analytics\/solutions\/google-analytics-spreadsheet-add-on\" target=\"_blank\" rel=\"noopener\">Google Analytics Spreadsheet Add-on<\/a> and connect to it.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/tableau-connect-sheets.png\" alt=\"tableau-connect-sheets\" \/><\/p>\n<h3>Limitations<\/h3>\n<ul>\n<li>One segment at a time\n<ul>\n<li>If you have complex needs, we recommend going back to Google Analytics to create a segment that includes your desired data. Tableau will let you use any of the custom segments you have in your account.<\/li>\n<\/ul>\n<\/li>\n<li>One account at a time\n<ul>\n<li>You can play with multiple extracts, but if you want to filter easily by an account, you should start to consider placing all the GA data into a database (warehouse).<\/li>\n<\/ul>\n<\/li>\n<li>No live connection &#8211; it works only as an extract\n<ul>\n<li>You have to refresh the data source to get the latest data.<\/li>\n<\/ul>\n<\/li>\n<li>No multichannel funnels API\n<ul>\n<li>Google has a different API for working with the MCF data, so you will have to find <a href=\"\/google-analytics-missing-custom-reports\/?section=mcf-analysis\">different ways to analyze assisted conversions<\/a>. Our option is to use R to extract the Multi-Channel data.<\/li>\n<\/ul>\n<\/li>\n<li>Could be slow\/unreliable\n<ul>\n<li>If you are pulling a lot of data you should be prepared for delays, especially if you&#8217;re scheduling extracts.<\/li>\n<\/ul>\n<\/li>\n<li>No filters on the data source\n<ul>\n<li>This is not a meaningful limitation for us because we like to work with the data in the rawest form and do our filtering inside Tableau.<\/li>\n<li>As a workaround, we can create a custom segment to replicate a particular filter (it might be useful if you&#8217;re working with large amounts of data and the extract takes too long)<\/li>\n<\/ul>\n<\/li>\n<li>Problems with aggregating users\n<ul>\n<li>Let&#8217;s look at the following example: we&#8217;re pulling data about visitors by city, but some users will visit our website from different cities; if we want to see the total number of users, some of them will be counted twice. Hence, skewed data<\/li>\n<li>To overcome this issue, we would have to include the client id inside GA, and use the custom dimension in our queries; check <a href=\"https:\/\/www.simoahava.com\/analytics\/improve-data-collection-with-four-custom-dimensions\/\" target=\"_blank\" rel=\"noopener\">the guide from Simo Ahava<\/a> for the implementation<\/li>\n<li>You shouldn&#8217;t experience this kind of issues if you&#8217;re aggregating metrics such as sessions or new users<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>Sampled Data Myth<\/h3>\n<p>Don&#8217;t be fooled by old articles such as <a href=\"https:\/\/www.lunametrics.com\/blog\/2015\/10\/28\/how-to-connect-tableau-and-google-analytics\/\" target=\"_blank\" rel=\"noopener\">this one<\/a>. They were written a long time ago.<\/p>\n<p>In the technology world, things are changing every day. So has the Tableau Google Analytics Connector.<\/p>\n<p>In my opinion, it&#8217;s actually a solid option to avoid the sampling happening in Google Analytics reports.<\/p>\n<p>I agree on the part where they&#8217;re talking about filtering, but there is no sampling or incomplete data in the newest versions of Tableau. So, make sure you test before acting on old advice!<\/p>\n<h3>Use the API explorer to double-check everything<\/h3>\n<p>For me, the <a href=\"https:\/\/ga-dev-tools.appspot.com\/query-explorer\/\" target=\"_blank\" rel=\"noopener\">API explorer<\/a> is one of the most delightful gifts from Google. It&#8217;s my go-to option to check if anything is wrong with the data I pull.<\/p>\n<p>If the numbers don&#8217;t look right in Tableau, I usually start by re-creating the same query in the core reporting API explorer to check if I see the same data in terms of:<\/p>\n<ul>\n<li>number of results<\/li>\n<li>metric values<\/li>\n<li>available dimensions and metrics<\/li>\n<li>stuff that can&#8217;t be queried together<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/errors-dimensions-metrics-together.png\" alt=\"errors-dimensions-metrics-together\" \/><\/p>\n<ul>\n<li>accounts that don&#8217;t have Google Analytics API access (i.e., the Google Demo Account)<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/demo-aacount-api.png\" alt=\"demo-aacount-api\" \/><\/p>\n<p>And the list could go on.<\/p>\n<h3>Recommendations when working with GA data<\/h3>\n<ol start=\"1\">\n<li>Try to get the data in raw form out of Google Analytics<\/li>\n<li>Calculate your own metrics where it makes sense. For example Conversion Rate, Bounce Rate, etc.<\/li>\n<li>Avoid User counts if you don&#8217;t have Client IDs set up<\/li>\n<li>Try to have fun!<\/li>\n<\/ol>\n<h2 id=\"ga-warehouse\" title=\"Data Warehouse\">Using a Google Analytics data warehouse<\/h2>\n<p>The data warehouse has some advantages:<\/p>\n<ul>\n<li><strong>faster extracts<\/strong> and <strong>live connections<\/strong> since the slowness of the API no longer binds you<\/li>\n<li><strong>multiple accounts<\/strong> inside the same database; for those of us who are dealing with multiple accounts it is tremendously useful to be able to filter by account directly in Tableau instead of having to connect to a different data source<\/li>\n<li>easier data <strong>blending<\/strong> and <strong>transformation<\/strong><\/li>\n<li><strong>all<\/strong> the <strong>data<\/strong> in <strong>one place<\/strong><\/li>\n<\/ul>\n<p>Potential downsides:<\/p>\n<ul>\n<li>security<\/li>\n<li>legal stuff<\/li>\n<li>costs<\/li>\n<li>you probably need a data integration service like <a href=\"https:\/\/www.stitchdata.com\/\" target=\"_blank\" rel=\"noopener\">Stitch<\/a> or <a href=\"https:\/\/fivetran.com\/\" target=\"_blank\" rel=\"noopener\">Fivetran<\/a> (also called ETL tools &#8211; \u201cextract, transform, load\u201d)<\/li>\n<\/ul>\n<p>BigQuery is a good option for Premium users of Google Analytics since you can <a href=\"https:\/\/support.google.com\/analytics\/answer\/3437618\" target=\"_blank\" rel=\"noopener\">easily export the data<\/a>.<\/p>\n<p>Here are <a href=\"http:\/\/cutroni.com\/blog\/2011\/05\/05\/merging-google-analytics-with-your-data-warehouse\/\" target=\"_blank\" rel=\"noopener\">some thoughts from Justin Cutroni<\/a> on including GA data into a warehouse from 2011. Unlike the <a href=\"https:\/\/www.lunametrics.com\/blog\/2015\/10\/28\/how-to-connect-tableau-and-google-analytics\/\" target=\"_blank\" rel=\"noopener\">Lunametrics post<\/a>, this one still applies today.<\/p>\n<p>If you have serious Business Intelligence or Analytics ambitions, you will need a warehouse at some point. Especially if you are trying to build\/empower an analytics insight department.<\/p>\n<p>Read more about BI <a href=\"https:\/\/www.betterbuys.com\/bi\/definitive-guide-bi\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>It&#8217;s a process that brings a whole new set of issues to the table. But it comes with the territory!<\/p>\n<h2 id=\"dashboard-examples\" title=\"Dashboard Examples\">Dashboard Examples by North Star metric<\/h2>\n<p>Here are some Tableau &#8211; Google Analytics examples of us trying to have fun with the data from Google Analytics.<\/p>\n<ol start=\"1\">\n<li>Here&#8217;s an example of a <strong>SEO report<\/strong> we&#8217;re sending to our clients. The NSM is <strong>organic traffic<\/strong>, but we are also looking at the traffic quality indicators and conversions.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/report-example.png\" alt=\"report-example\" \/><\/p>\n<ol start=\"2\">\n<li>Below is a dashboard we built to look at the <strong>Adwords<\/strong> data we have in Google Analytics. The purpose of the research is to look at <strong>Cost per Revenue<\/strong> from any angle we can think of.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/adwords-dashboard.png\" alt=\"adwords-dashboard\" \/><\/p>\n<p>And a cookie from Tableau 10.5: <strong>Viz in tooltip<\/strong>. Hovering over an ad group will reveal a subtle evolution graph.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/viz-in-tooltip.png\" alt=\"viz-in-tooltip\" \/><\/p>\n<ol start=\"3\">\n<li><strong>PPC vs SEO<\/strong>: complete, don&#8217;t cannibalize!<\/li>\n<\/ol>\n<p>We found <a href=\"https:\/\/public.tableau.com\/profile\/kati.polaski4033#!\/vizhome\/Experiment-MoreEfficientPPCSpend\/CostofPPCTraffic\" target=\"_blank\" rel=\"noopener\">this great dashboard<\/a> which shouldn&#8217;t go unnoticed.<\/p>\n<p>If you have ranking data, you can easily integrate it with Adwords to get to this level of information<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/ppc-vs-seo.png\" alt=\"ppc-vs-seo\" \/><\/p>\n<ol start=\"3\">\n<li>Social traffic<\/li>\n<\/ol>\n<p>Alexander Loth created this video on how he built a social media traffic analysis dashboard:<\/p>\n<p><iframe src=\"https:\/\/www.youtube-nocookie.com\/embed\/vBvV9A0NORk?rel=0\" width=\"100%\" height=\"521\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<ol start=\"4\">\n<li>An example from Tableau: <a href=\"https:\/\/www.tableau.com\/solutions\/gallery\/website-traffic-trends\" target=\"_blank\" rel=\"noopener\">Analyze website traffic trends to optimize results<\/a><\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/website-traffic-trends.png\" alt=\"website-traffic-trends\" \/><\/p>\n<p>To be continued \u2026<\/p>\n<h3>Google Analytics Data Visualization<\/h3>\n<p>In the article about <a href=\"\/google-analytics-missing-custom-reports\/\">reports that we would like to see inside Google Analytics<\/a>, we are looking at different ways to re-work data.<\/p>\n<p>We&#8217;re employing visualizations such as:<\/p>\n<ul>\n<li>box plots<\/li>\n<li>histograms<\/li>\n<li>averages<\/li>\n<li>forecasts<\/li>\n<li>growth graphs<\/li>\n<li>clusters<\/li>\n<li>Pareto charts<\/li>\n<li>bars &amp; lines on the same chart<\/li>\n<\/ul>\n<p>Check them in the slide deck below or dig into the article!<\/p>\n<p><iframe style=\"border: 1px solid #CCC; border-width: 1px; margin-bottom: 5px; max-width: 100%;\" src=\"\/\/www.slideshare.net\/slideshow\/embed_code\/key\/eyFowtR93KIEbH\" width=\"100%\" height=\"521\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"> <\/iframe><\/p>\n<h3>Search Trends<\/h3>\n<p>Last, but not least, we wanted to share some trends with you. We leave it to you to conclude.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2018\/03\/tablea-google-analytics-trends.png\" alt=\"tableau google analytics trends\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Love Google Analytics? Love Tableau? Why not bring them together? Us &amp; Tableau We are working with Google Analytics every single day. Sometimes I get the feeling we&#8217;re investing too much time into it. When I re-discovered Tableau, I felt it brought a whole new perspective to our analytics approach. The first times I tried [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1113,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[8,16],"tags":[],"class_list":{"0":"post-1102","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-analytics","8":"category-data-visualization","9":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tableau + Google Analytics = Love \u2022 Supercharge your GA data!<\/title>\n<meta name=\"description\" content=\"Love Google Analytics? Love Tableau? Why not bring them together? \u2022 We are working with Google Analytics every single day. Sometimes I get the feeling we&#039;re investing too much time into it. \u2022 Why? \u2022 How? \u2022 Advantages of integrating Google Analytics with Tableau\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/canonicalized.com\/tableau-google-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau + Google Analytics = Love \u2022 Supercharge your GA data!\" \/>\n<meta property=\"og:description\" content=\"Love Google Analytics? Love Tableau? Why not bring them together? \u2022 We are working with Google Analytics every single day. Sometimes I get the feeling we&#039;re investing too much time into it. \u2022 Why? \u2022 How? \u2022 Advantages of integrating Google Analytics with Tableau\" \/>\n<meta property=\"og:url\" content=\"https:\/\/canonicalized.com\/tableau-google-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"Canonicalized\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/canonicalized\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-08T17:11:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-12T06:26:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/canonicalized.com\/wp-content\/uploads\/2018\/03\/google-analytics-tableau.png\" \/>\n\t<meta property=\"og:image:width\" content=\"560\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dorian Banutoiu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@canonicalizedco\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dorian Banutoiu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/canonicalized.com\/tableau-google-analytics\/\",\"url\":\"https:\/\/canonicalized.com\/tableau-google-analytics\/\",\"name\":\"Tableau + Google Analytics = Love \u2022 Supercharge your GA data!\",\"isPartOf\":{\"@id\":\"https:\/\/canonicalized.com\/#website\"},\"datePublished\":\"2018-03-08T17:11:27+00:00\",\"dateModified\":\"2018-11-12T06:26:06+00:00\",\"author\":{\"@id\":\"https:\/\/canonicalized.com\/#\/schema\/person\/ecb48c0ff5925a8e64091abf3406df8f\"},\"description\":\"Love Google Analytics? Love Tableau? Why not bring them together? \u2022 We are working with Google Analytics every single day. Sometimes I get the feeling we're investing too much time into it. \u2022 Why? \u2022 How? \u2022 Advantages of integrating Google Analytics with Tableau\",\"breadcrumb\":{\"@id\":\"https:\/\/canonicalized.com\/tableau-google-analytics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/canonicalized.com\/tableau-google-analytics\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/canonicalized.com\/tableau-google-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/canonicalized.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tableau &#038; Google Analytics &#8211; Integrate, Expand, Create\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/canonicalized.com\/#website\",\"url\":\"https:\/\/canonicalized.com\/\",\"name\":\"Canonicalized\",\"description\":\"Powered by Ideas \u00b7 Governed by Data\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/canonicalized.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/canonicalized.com\/#\/schema\/person\/ecb48c0ff5925a8e64091abf3406df8f\",\"name\":\"Dorian Banutoiu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/canonicalized.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/953aeef38bf52124ff2a243093a4147849e379c58b680dcd65c2ed4fa5d05f8b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/953aeef38bf52124ff2a243093a4147849e379c58b680dcd65c2ed4fa5d05f8b?s=96&d=mm&r=g\",\"caption\":\"Dorian Banutoiu\"},\"description\":\"Highly passionate about data, analysis, visualization, and everything that helps people make informed decisions. I love what I do! I am working to improve speed in every aspect of my life and that of our clients. I find comfort in helping people, so if you have a question, give me a shout!\",\"sameAs\":[\"https:\/\/www.facebook.com\/canonicalized\/\",\"https:\/\/twitter.com\/canonicalizedco\"],\"url\":\"https:\/\/canonicalized.com\/author\/canonicalized\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tableau + Google Analytics = Love \u2022 Supercharge your GA data!","description":"Love Google Analytics? Love Tableau? Why not bring them together? \u2022 We are working with Google Analytics every single day. Sometimes I get the feeling we're investing too much time into it. \u2022 Why? \u2022 How? \u2022 Advantages of integrating Google Analytics with Tableau","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/canonicalized.com\/tableau-google-analytics\/","og_locale":"en_US","og_type":"article","og_title":"Tableau + Google Analytics = Love \u2022 Supercharge your GA data!","og_description":"Love Google Analytics? Love Tableau? Why not bring them together? \u2022 We are working with Google Analytics every single day. Sometimes I get the feeling we're investing too much time into it. \u2022 Why? \u2022 How? \u2022 Advantages of integrating Google Analytics with Tableau","og_url":"https:\/\/canonicalized.com\/tableau-google-analytics\/","og_site_name":"Canonicalized","article_author":"https:\/\/www.facebook.com\/canonicalized\/","article_published_time":"2018-03-08T17:11:27+00:00","article_modified_time":"2018-11-12T06:26:06+00:00","og_image":[{"width":560,"height":315,"url":"https:\/\/canonicalized.com\/wp-content\/uploads\/2018\/03\/google-analytics-tableau.png","type":"image\/png"}],"author":"Dorian Banutoiu","twitter_card":"summary_large_image","twitter_creator":"@canonicalizedco","twitter_misc":{"Written by":"Dorian Banutoiu","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/canonicalized.com\/tableau-google-analytics\/","url":"https:\/\/canonicalized.com\/tableau-google-analytics\/","name":"Tableau + Google Analytics = Love \u2022 Supercharge your GA data!","isPartOf":{"@id":"https:\/\/canonicalized.com\/#website"},"datePublished":"2018-03-08T17:11:27+00:00","dateModified":"2018-11-12T06:26:06+00:00","author":{"@id":"https:\/\/canonicalized.com\/#\/schema\/person\/ecb48c0ff5925a8e64091abf3406df8f"},"description":"Love Google Analytics? Love Tableau? Why not bring them together? \u2022 We are working with Google Analytics every single day. Sometimes I get the feeling we're investing too much time into it. \u2022 Why? \u2022 How? \u2022 Advantages of integrating Google Analytics with Tableau","breadcrumb":{"@id":"https:\/\/canonicalized.com\/tableau-google-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/canonicalized.com\/tableau-google-analytics\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/canonicalized.com\/tableau-google-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/canonicalized.com\/"},{"@type":"ListItem","position":2,"name":"Tableau &#038; Google Analytics &#8211; Integrate, Expand, Create"}]},{"@type":"WebSite","@id":"https:\/\/canonicalized.com\/#website","url":"https:\/\/canonicalized.com\/","name":"Canonicalized","description":"Powered by Ideas \u00b7 Governed by Data","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/canonicalized.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/canonicalized.com\/#\/schema\/person\/ecb48c0ff5925a8e64091abf3406df8f","name":"Dorian Banutoiu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/canonicalized.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/953aeef38bf52124ff2a243093a4147849e379c58b680dcd65c2ed4fa5d05f8b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/953aeef38bf52124ff2a243093a4147849e379c58b680dcd65c2ed4fa5d05f8b?s=96&d=mm&r=g","caption":"Dorian Banutoiu"},"description":"Highly passionate about data, analysis, visualization, and everything that helps people make informed decisions. I love what I do! I am working to improve speed in every aspect of my life and that of our clients. I find comfort in helping people, so if you have a question, give me a shout!","sameAs":["https:\/\/www.facebook.com\/canonicalized\/","https:\/\/twitter.com\/canonicalizedco"],"url":"https:\/\/canonicalized.com\/author\/canonicalized\/"}]}},"_links":{"self":[{"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/posts\/1102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/comments?post=1102"}],"version-history":[{"count":2,"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/posts\/1102\/revisions"}],"predecessor-version":[{"id":1124,"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/posts\/1102\/revisions\/1124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/media\/1113"}],"wp:attachment":[{"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/media?parent=1102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/categories?post=1102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/canonicalized.com\/wp-json\/wp\/v2\/tags?post=1102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}