{"id":26773,"date":"2025-01-24T14:52:39","date_gmt":"2025-01-24T14:52:39","guid":{"rendered":"https:\/\/ecommerce.folio3.com\/blog\/?p=26773"},"modified":"2025-01-24T14:53:48","modified_gmt":"2025-01-24T14:53:48","slug":"how-to-integrate-google-bigquery-bigcommerce","status":"publish","type":"post","link":"https:\/\/ecommerce.folio3.com\/blog\/how-to-integrate-google-bigquery-bigcommerce\/","title":{"rendered":"How to Integrate Google BigQuery &#038; Bigcommerce"},"content":{"rendered":"<h2><b>Introduction<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Ecommerce businesses generate vast amounts of data. Analyzing this data effectively is crucial for success. This blog post will guide you on how to integrate Google BigQuery with your Bigcommerce store. This BigQuery integration empowers you with powerful data analysis capabilities, enabling data-driven decisions and a competitive edge.<\/span><\/p>\n<p><strong>Read Also:<\/strong> <a href=\"https:\/\/ecommerce.folio3.com\/blog\/launch-online-b2b-business-with-bigcommerce\/\" target=\"_blank\" rel=\"noopener\">10 Steps to Launch Your Online B2B Business with BigCommerce<\/a><\/p>\n<h2><b>Understanding the Need for Integration<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Bigcommerce provides valuable data on sales, orders, customers, and more. However, its native reporting features might be limited for complex analyses. Google BigQuery, a serverless data warehousing service, offers a robust and scalable solution. <\/span><\/p>\n<p><strong>By integrating BigQuery, you can:<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Perform in-depth analysis:<\/b><span style=\"font-weight: 400;\"> Explore customer behavior, identify trends, and uncover hidden insights.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Gain deeper customer understanding:<\/b><span style=\"font-weight: 400;\"> Segment customers, personalize marketing campaigns, and improve customer retention.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Optimize marketing spend:<\/b><span style=\"font-weight: 400;\"> Analyze campaign performance, identify high-value channels, and allocate budgets effectively.<\/span><\/li>\n<li><b>Improve business decisions:<\/b><span style=\"font-weight: 400;\"> Make data-driven decisions across all areas of your business, from <a href=\"https:\/\/ecommerce.folio3.com\/bigcommerce-development-company\/\" target=\"_blank\" rel=\"noopener\">BigCommerce development<\/a> for product to inventory management.<\/span><\/li>\n<\/ul>\n<h2><b>Step-by-Step Guide for Google BigQuery Integration<\/b><b><br \/>\n<\/b><\/h2>\n<p><strong>Here\u2019s how to create and manage coupon codes in your BigCommerce store:<\/strong><\/p>\n<h3><b>1. Set Up a Google Cloud Project<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">First, create a Google Cloud project to access BigQuery. Visit the <\/span><a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Google Cloud Console<\/span><\/a><span style=\"font-weight: 400;\"> and create a new project.<\/span><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-26774 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/11.jpg\" alt=\"bigcommerce\" width=\"624\" height=\"269\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/11.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/11-300x129.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<h3><b>2. Enable BigQuery API<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">From APIs &amp; Services enable BigQuery<\/span><\/li>\n<\/ul>\n<h3><b>3. Create a Dataset<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In your Google Cloud console, click the navigation icon in the top left. Scroll down to the Big Data section and click BigQuery.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">You can pin BigQuery to the top of this menu so it&#8217;s easier to access later.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">On the left side of the screen, click the \u2807next to the Project you just created and select Create dataset.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-26775 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/22.jpg\" alt=\"\" width=\"624\" height=\"293\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/22.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/22-300x141.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<h3><b>4. Create Dataset<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a Dataset ID. We recommend using your domain name (like company.com). If you have multiple stores, we recommend each store to have its own dataset.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Most merchants can leave the other default settings as is.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-26776 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/33.jpg\" alt=\"\" width=\"624\" height=\"293\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/33.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/33-300x141.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<h3><b>5. Set Up Permissions<\/b><\/h3>\n<ul>\n<li><span style=\"font-weight: 400;\">Go to IAM &amp; Admin, select your project at the top of the page, then click Grant Access. Enter the following details and click Save.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">New principals: <\/span><span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">bigcommerce@bc-data-production.iam.gserviceaccount.com<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Role: BigQuery Job User<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26777 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/44.jpg\" alt=\"\" width=\"624\" height=\"293\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/44.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/44-300x141.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<h3><b>6. Share permission<\/b><\/h3>\n<p><strong>Go to BigQuery. On the left side of the screen, select your Project and open your Dataset, then:<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">1. Click Sharing \u203a Permissions.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-weight: 400;\">2. Click Add principal and enter the following details.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">3. New principals: <\/span><span style=\"font-weight: 400;\">bigcommerce@bc-data-production.iam.gserviceaccount.com<\/span><\/p>\n<p><span style=\"font-weight: 400;\">4. Role: BigQuery Data Owner<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26778 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/55.jpg\" alt=\"\" width=\"624\" height=\"293\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/55.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/55-300x141.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">5. When you&#8217;re finished click Save. This grants BigCommerce the appropriate permissions to load data into your BigQuery account.<\/span><\/p>\n<p>6. Connect Your Store, Test Access, and Create Table<\/p>\n<p><span style=\"font-weight: 400;\">In your BigCommerce control panel, go to Settings \u203a Data solutions. Under Data warehouses, click Connect next to Google BigQuery.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26779 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/66.jpg\" alt=\"\" width=\"624\" height=\"282\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/66.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/66-300x136.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">7. enter your BigQuery Project ID and Dataset ID in the following format, then click Next.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26780 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/77.jpg\" alt=\"\" width=\"624\" height=\"214\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/77.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/77-300x103.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">enter your BigQuery Project ID and Dataset ID in the following format, <\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">e.g. <\/span><b>bigquery-integration-448610.nvl_sandbox <\/b><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">then click Next<\/span><span style=\"font-weight: 400;\">. <\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26781 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/88.jpg\" alt=\"\" width=\"624\" height=\"382\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/88.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/88-300x184.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">8. use the Test access button to ensure your project, dataset, and permission settings are configured correctly<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">If you&#8217;ve set up billing and the test still fails:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Review your Project ID and Dataset ID and ensure they are formatted correctly.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Review your permission settings and ensure they are applied to the correct Project and Dataset.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Click Next.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">9. Table creation, select your timezone and click Finish.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Note: When selecting your timezone, think about what represents a &#8220;day&#8221; to you when you&#8217;re asking analytical questions. For example, if you want to know &#8220;how much revenue did I make on Monday&#8221;, the timezone you set here will determine when Monday begins and ends.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26782 size-full\" src=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/99.jpg\" alt=\"\" width=\"624\" height=\"438\" srcset=\"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/99.jpg 624w, https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/99-300x211.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<h2><b>Conclusion<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Integrating BigCommerce with Google BigQuery empowers businesses to leverage data for growth. By following the outlined steps and best practices, you can unlock valuable insights and improve decision-making.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you&#8217;re considering Google BigQuery integration, now is the time to start enhancing your e-commerce analytics. By leveraging the combined power of these platforms, you can gain a deeper understanding of your customers, optimize your marketing efforts, and drive significant business growth.<\/span><\/p>\n<p style=\"text-align: center;\"><strong>Read Also:<\/strong> <a href=\"https:\/\/ecommerce.folio3.com\/blog\/bigcommerce-development-company-online-shopping-experience\/\">How a BigCommerce Development Company Creates a Captivating Online Shopping Experience<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Ecommerce businesses generate vast amounts of data. Analyzing this data effectively is crucial for success. This blog post will guide you on how to integrate Google BigQuery with your Bigcommerce store. This BigQuery integration empowers you with powerful data analysis capabilities, enabling data-driven decisions and a competitive edge. Read Also: 10 Steps to Launch<\/p>\n","protected":false},"author":49,"featured_media":26785,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[28],"tags":[105],"class_list":{"0":"post-26773","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-bigcommerce","8":"tag-bigcommerce"},"acf":[],"featured_image_data":{"src":"https:\/\/ecommerce.folio3.com\/blog\/wp-content\/uploads\/2025\/01\/Blue-White-Modern-Marketing-Strategy-Blog-Banner-1.png","alt":"","caption":""},"_links":{"self":[{"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/posts\/26773"}],"collection":[{"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/comments?post=26773"}],"version-history":[{"count":0,"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/posts\/26773\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/media\/26785"}],"wp:attachment":[{"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/media?parent=26773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/categories?post=26773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecommerce.folio3.com\/blog\/wp-json\/wp\/v2\/tags?post=26773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}