{"id":50294,"date":"2020-03-12T12:59:35","date_gmt":"2020-03-12T07:29:35","guid":{"rendered":"https:\/\/vwo.com\/blog\/?p=50294"},"modified":"2025-05-05T16:37:26","modified_gmt":"2025-05-05T11:07:26","slug":"connect-vwo-dashboard-google-sheets","status":"publish","type":"post","link":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/","title":{"rendered":"Testing Visibility: Exporting Key Metrics from VWO for Stakeholders via APIs"},"content":{"rendered":"\n<p>I work as a web analytics consultant, helping companies and other organizations use data to improve their websites. Last year, I worked on a project with a large non-profit that was using VWO to A\/B test different flows through their donation funnel. The old flow hadn&#8217;t been updated in years, so they were interested in testing different page layouts and optimizing for mobile.&nbsp;<\/p>\n\n\n\n<p>This is the story of how those A\/B tests motivated me to build a universal API Connector for Google Sheets, which now has over 20,000 users and handles about 10,000 API requests a day directly from Google Sheets.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><em><a href=\"https:\/\/vwo.com\/ab-testing\/#guide-download\"><span style=\"text-decoration: underline\">Download Free: A\/B Testing Guide<\/span><\/a><\/em><\/h2>\n\n\n<h2 class=\"js-cro-guide-subheading gtm_heading \" data-level=\"level1\" data-menu=\"A Dashboard for VWO\" id=\"a-dashboard-for-vwo\" data-menu-id=\"a-dashboard-for-vwo\" style=\"text-align:left\">A Dashboard for VWO<\/h2>\n\n\n<p>Many eyes were on this project, so the client requested a summary dashboard for the duration of the A\/B tests (which continued throughout the year). The dashboard would contain some data visualizations, predicted metrics, and a summary table like this:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><br><\/td><td><strong>CONTROL<\/strong><\/td><td><strong>VARIATION<\/strong><\/td><td><strong>TOTALS<\/strong><\/td><\/tr><tr><td><strong>Visitors<\/strong><\/td><td>1000<\/td><td>1000<\/td><td>2000<\/td><\/tr><tr><td><strong>Conversion Rate<\/strong><\/td><td>1.50%<\/td><td>1.40%<\/td><td>1.45%<\/td><\/tr><tr><td><strong>$\/Donation<\/strong><\/td><td>$50<\/td><td>$55<\/td><td>$52<\/td><\/tr><tr><td><strong>$\/Visitor<\/strong><\/td><td>$0.75<\/td><td>$0.77<\/td><td>$0.76<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>All the data above is already available in VWO, but we decided to make the dashboard in Google Data Studio instead, for a few reasons:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We wanted to customize the dashboard to highlight these key metrics at a glance<\/li>\n\n\n\n<li>Not everyone in the organization had access to VWO<\/li>\n\n\n\n<li>We were running some supporting analysis outside VWO, e.g. a histogram of donation sizes, and wanted to include that in the dashboard as well.<\/li>\n<\/ul>\n\n\n<h2 class=\"js-cro-guide-subheading gtm_heading \" data-level=\"level1\" data-menu=\"Moving Data Around\" id=\"moving-data-around\" data-menu-id=\"moving-data-around\" style=\"text-align:left\">Moving Data Around<\/h2>\n\n\n<p>How do you move data from one platform to another, in this case VWO to Google Data Studio? This is a common business need, with many different approaches. On one end of the spectrum, people may simply export to CSV or email their files directly from the interface of the tool they&#8217;re using. On the other end, companies build sophisticated data warehouses that load and integrate data from all their data sources, and then run business intelligence tools on top for querying and visualizing the data.<\/p>\n\n\n\n<p>Somewhere in the middle, there are tools like Google Sheets.&nbsp; Google Sheets provides a scripting language, based on JavaScript, which has enabled a thriving ecosystem of add-ons in the G Suite Marketplace. Many add-ons connect Sheets to popular platforms like Facebook and Google Analytics (<a href=\"https:\/\/gsuite.google.com\/marketplace\/app\/supermetrics\/523876908005\" target=\"_blank\" rel=\"noreferrer noopener\">Supermetrics<\/a> is the most popular add-on of this type, with integrations for about 50 different platforms.) This lets people pull in data with the click of a button, enabling some level of automation while avoiding the cost and complexity of a full data warehouse.<\/p>\n\n\n\n<p>Google Sheets would be a great solution here, especially since it plugs directly into Google Data Studio. However, in this case, there was no existing add-on or integration for VWO.&nbsp; In fact, there were thousands and thousands of platforms without any integration. One thing nearly all these platforms had in common, though, was that they provided access to their data via an API. I checked out the <a href=\"https:\/\/developers.vwo.com\/reference\" target=\"_blank\" rel=\"noreferrer noopener\">documentation for VWO&#8217;s REST API<\/a>, which showed I could hook into it with a script to pull data from VWO into Sheets. But why stop there? I wanted a universal API connector, that would connect any API into Sheets, without requiring a pre-built integration or a custom script each time.<\/p>\n\n\n\n<p>And, fast-forwarding through several months of development, API Connector was born ? It imports data from any API into Google Sheets, using just a request URL and API key, no code required.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><em><a href=\"https:\/\/vwo.com\/ab-testing\/#guide-download\"><span style=\"text-decoration: underline\">Download Free: A\/B Testing Guide<\/span><\/a><\/em><\/h2>\n\n\n<h2 class=\"js-cro-guide-subheading gtm_heading \" data-level=\"level1\" data-menu=\"Using API Connector With VWO\" id=\"using-api-connector-with-vwo\" data-menu-id=\"using-api-connector-with-vwo\" style=\"text-align:left\">Using API Connector With VWO<\/h2>\n\n\n<p>In this section, I&#8217;ll outline how to use API Connector to pull data from <a href=\"https:\/\/vwo.com\/blog\/what-changes-for-you-with-the-launch-of-the-vwo-experience-optimization-platform\/\">the VWO <\/a>API directly into Google Sheets.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Install the API Connector add-on to Google Sheets (Go to: https:\/\/mixedanalytics.com\/api-connector\/).<\/li>\n\n\n\n<li>To access the <a href=\"https:\/\/vwo.com\/blog\/improved-productivity-using-vwo-api\/\">VWO API<\/a>, you need an API token, which is similar to a password. To generate your token, navigate to <a href=\"https:\/\/app.vwo.com\/#\/developers\/tokens\">https:\/\/app.vwo.com\/#\/developers\/tokens<\/a>.<\/li>\n\n\n\n<li>You&#8217;ll also need your account ID. Your account ID is available at the top of your VWO dashboard: <\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"227\" height=\"58\" src=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Account-ID.png\" alt=\"screenshot of an VWO account id\" class=\"wp-image-50300\" \/><\/figure>\n<\/div>\n\n\n<p>4. If you&#8217;re looking for details on a specific campaign, you&#8217;ll need to know the ID of that campaign. You can find your campaign number by clicking into the campaign while logged into your dashboard, and checking the URL:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"384\" height=\"65\" src=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Campaign-Number.png\" alt=\"screenshot of the VWO campaign number\" class=\"wp-image-50302\" srcset=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Campaign-Number.png 384w, https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Campaign-Number.png?tr=w-375 375w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/><\/figure>\n<\/div>\n\n\n<p>5. The API request URL for campaign metrics takes on the following format: &#8220;https:\/\/app.vwo.com\/api\/v2\/accounts\/{account_id}\/campaigns\/{campaign_id}&#8221;<br>Enter that URL into the API URL path field in API Connector, like this:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"375\" height=\"316\" src=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/API-Connector.png\" alt=\"screenshot of the VWO API connector\" class=\"wp-image-50303\" \/><\/figure>\n<\/div>\n\n\n<p>6. In the Headers section, enter the word <strong>token<\/strong> for your Key, and your API token for the Value, like this:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"359\" height=\"132\" src=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Headers-Section.png\" alt=\"screenshot of the headers section in the API connector tool where you need to enter the token value\" class=\"wp-image-50304\" \/><\/figure>\n<\/div>\n\n\n<p>7. Click Run and you&#8217;ll see your VWO test data populate your Sheet.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"443\" src=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Test-Data-1024x443.png\" alt=\"screenshot of test VWO data getting populated in Google Sheets\" class=\"wp-image-50306\" srcset=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Test-Data-1024x443.png?tr=w-1024 1024w, https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Test-Data-1024x443.png?tr=w-768 768w, https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Test-Data-1024x443.png?tr=w-640 640w, https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/VWO-Test-Data-1024x443.png?tr=w-375 375w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>8. Now, go forth and explore the API! Every data point from VWO is available via the API, so you can create and automate dashboards using any platform metric. Check the <a href=\"https:\/\/developers.vwo.com\/reference#introduction-1\" target=\"_blank\" rel=\"noreferrer noopener\">API documentation<\/a> for the full list of available endpoints.<\/p>\n\n\n\n<p>Fun fact: as I was the first user, VWO was the very first API ever used with API Connector. I used the first version of API Connector to connect to VWO&#8217;s API and pull in fresh data hourly. I then connected the Sheet to Data Studio to complete the A\/B testing dashboard for the donation flow test. I now use this basic setup daily to generate custom, automated reports and dashboards for my clients.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I work as a web analytics consultant, helping companies and other organizations use data to improve their websites. Last year, I worked on a project with a large non-profit that was using VWO to A\/B test different flows through their donation funnel. The old flow hadn&#8217;t been updated in years, so they were interested in&#8230;<\/p>\n","protected":false},"author":396,"featured_media":55909,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"post_read_time":4,"footnotes":""},"categories":[1850],"tags":[],"feature":[],"industry-type":[],"product":[],"role":[],"region":[],"class_list":["post-50294","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conversion-rate-optimization"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Connect VWO Dashboard To Google Sheets Through API<\/title>\n<meta name=\"description\" content=\"In this post, we describe how you can create a dashboard from your VWO data in Google sheets with the help of an API connector tool.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Connect VWO Dashboard To Google Sheets Through API\" \/>\n<meta property=\"og:description\" content=\"In this post, we describe how you can create a dashboard from your VWO data in Google sheets with the help of an API connector tool.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vwoofficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-12T07:29:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-05T11:07:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/OG-image_Testing-visibility.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ana Kravitz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mixlyt\" \/>\n<meta name=\"twitter:site\" content=\"@VWO\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ana Kravitz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/\"},\"author\":{\"name\":\"Ana Kravitz\",\"@id\":\"https:\/\/vwo.com\/blog\/#\/schema\/person\/c153d0cbca3c907b2fa93a96ccc4d6bb\"},\"headline\":\"Testing Visibility: Exporting Key Metrics from VWO for Stakeholders via APIs\",\"datePublished\":\"2020-03-12T07:29:35+00:00\",\"dateModified\":\"2025-05-05T11:07:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/\"},\"wordCount\":894,\"publisher\":{\"@id\":\"https:\/\/vwo.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png\",\"articleSection\":[\"Conversion Rate Optimization\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/\",\"url\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/\",\"name\":\"How To Connect VWO Dashboard To Google Sheets Through API\",\"isPartOf\":{\"@id\":\"https:\/\/vwo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png\",\"datePublished\":\"2020-03-12T07:29:35+00:00\",\"dateModified\":\"2025-05-05T11:07:26+00:00\",\"description\":\"In this post, we describe how you can create a dashboard from your VWO data in Google sheets with the help of an API connector tool.\",\"breadcrumb\":{\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage\",\"url\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png\",\"contentUrl\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png\",\"width\":2400,\"height\":1400,\"caption\":\"Testing Visibility\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vwo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conversion Rate Optimization\",\"item\":\"https:\/\/vwo.com\/blog\/conversion-rate-optimization\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Testing Visibility: Exporting Key Metrics from VWO for Stakeholders via APIs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vwo.com\/blog\/#website\",\"url\":\"https:\/\/vwo.com\/blog\/\",\"name\":\"Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/vwo.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vwo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/vwo.com\/blog\/#organization\",\"name\":\"VWO\",\"url\":\"https:\/\/vwo.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vwo.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2018\/09\/VWOLogo.png\",\"contentUrl\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2018\/09\/VWOLogo.png\",\"width\":780,\"height\":492,\"caption\":\"VWO\"},\"image\":{\"@id\":\"https:\/\/vwo.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vwoofficial\/\",\"https:\/\/x.com\/VWO\",\"https:\/\/www.instagram.com\/vwoofficial\/\",\"https:\/\/www.linkedin.com\/company\/vwo\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/vwo.com\/blog\/#\/schema\/person\/c153d0cbca3c907b2fa93a96ccc4d6bb\",\"name\":\"Ana Kravitz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vwo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/ana_kravitz-96x96.jpg\",\"contentUrl\":\"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/ana_kravitz-96x96.jpg\",\"caption\":\"Ana Kravitz\"},\"description\":\"Ana Kravitz is the founder of Mixed Analytics, which provides analytics consulting and extensions for Google Sheets. After receiving an MBA from New York University, she worked as a web analyst for several years before striking out on her own. Her experience working with clients led her to develop the API Connector extension for Google Sheets, which is now the primary focus of Mixed Analytics. She is based in Taiwan.\",\"sameAs\":[\"https:\/\/mixedanalytics.com\/api-connector\/\",\"https:\/\/www.linkedin.com\/in\/anakravitz\/\",\"https:\/\/x.com\/mixlyt\"],\"url\":\"https:\/\/vwo.com\/blog\/author\/anakravitz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Connect VWO Dashboard To Google Sheets Through API","description":"In this post, we describe how you can create a dashboard from your VWO data in Google sheets with the help of an API connector tool.","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:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How To Connect VWO Dashboard To Google Sheets Through API","og_description":"In this post, we describe how you can create a dashboard from your VWO data in Google sheets with the help of an API connector tool.","og_url":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/","og_site_name":"Blog","article_publisher":"https:\/\/www.facebook.com\/vwoofficial\/","article_published_time":"2020-03-12T07:29:35+00:00","article_modified_time":"2025-05-05T11:07:26+00:00","og_image":[{"width":2400,"height":1260,"url":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/OG-image_Testing-visibility.png","type":"image\/png"}],"author":"Ana Kravitz","twitter_card":"summary_large_image","twitter_creator":"@mixlyt","twitter_site":"@VWO","twitter_misc":{"Written by":"Ana Kravitz","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#article","isPartOf":{"@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/"},"author":{"name":"Ana Kravitz","@id":"https:\/\/vwo.com\/blog\/#\/schema\/person\/c153d0cbca3c907b2fa93a96ccc4d6bb"},"headline":"Testing Visibility: Exporting Key Metrics from VWO for Stakeholders via APIs","datePublished":"2020-03-12T07:29:35+00:00","dateModified":"2025-05-05T11:07:26+00:00","mainEntityOfPage":{"@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/"},"wordCount":894,"publisher":{"@id":"https:\/\/vwo.com\/blog\/#organization"},"image":{"@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png","articleSection":["Conversion Rate Optimization"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/","url":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/","name":"How To Connect VWO Dashboard To Google Sheets Through API","isPartOf":{"@id":"https:\/\/vwo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png","datePublished":"2020-03-12T07:29:35+00:00","dateModified":"2025-05-05T11:07:26+00:00","description":"In this post, we describe how you can create a dashboard from your VWO data in Google sheets with the help of an API connector tool.","breadcrumb":{"@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#primaryimage","url":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png","contentUrl":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/Feature-image_Testing-visibility.png","width":2400,"height":1400,"caption":"Testing Visibility"},{"@type":"BreadcrumbList","@id":"https:\/\/vwo.com\/blog\/connect-vwo-dashboard-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vwo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Conversion Rate Optimization","item":"https:\/\/vwo.com\/blog\/conversion-rate-optimization\/"},{"@type":"ListItem","position":3,"name":"Testing Visibility: Exporting Key Metrics from VWO for Stakeholders via APIs"}]},{"@type":"WebSite","@id":"https:\/\/vwo.com\/blog\/#website","url":"https:\/\/vwo.com\/blog\/","name":"Blog","description":"","publisher":{"@id":"https:\/\/vwo.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vwo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/vwo.com\/blog\/#organization","name":"VWO","url":"https:\/\/vwo.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vwo.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2018\/09\/VWOLogo.png","contentUrl":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2018\/09\/VWOLogo.png","width":780,"height":492,"caption":"VWO"},"image":{"@id":"https:\/\/vwo.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vwoofficial\/","https:\/\/x.com\/VWO","https:\/\/www.instagram.com\/vwoofficial\/","https:\/\/www.linkedin.com\/company\/vwo"]},{"@type":"Person","@id":"https:\/\/vwo.com\/blog\/#\/schema\/person\/c153d0cbca3c907b2fa93a96ccc4d6bb","name":"Ana Kravitz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vwo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/ana_kravitz-96x96.jpg","contentUrl":"https:\/\/static.wingify.com\/gcp\/uploads\/sites\/3\/2020\/03\/ana_kravitz-96x96.jpg","caption":"Ana Kravitz"},"description":"Ana Kravitz is the founder of Mixed Analytics, which provides analytics consulting and extensions for Google Sheets. After receiving an MBA from New York University, she worked as a web analyst for several years before striking out on her own. Her experience working with clients led her to develop the API Connector extension for Google Sheets, which is now the primary focus of Mixed Analytics. She is based in Taiwan.","sameAs":["https:\/\/mixedanalytics.com\/api-connector\/","https:\/\/www.linkedin.com\/in\/anakravitz\/","https:\/\/x.com\/mixlyt"],"url":"https:\/\/vwo.com\/blog\/author\/anakravitz\/"}]}},"_links":{"self":[{"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/posts\/50294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/users\/396"}],"replies":[{"embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/comments?post=50294"}],"version-history":[{"count":42,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/posts\/50294\/revisions"}],"predecessor-version":[{"id":87094,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/posts\/50294\/revisions\/87094"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/media\/55909"}],"wp:attachment":[{"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/media?parent=50294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/categories?post=50294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/tags?post=50294"},{"taxonomy":"feature","embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/feature?post=50294"},{"taxonomy":"industry-type","embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/industry-type?post=50294"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/product?post=50294"},{"taxonomy":"role","embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/role?post=50294"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/vwo.com\/blog\/wp-json\/wp\/v2\/region?post=50294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}