Introduction
Curious about setting up a Bayesian A/B Testing dashboard? This guide will take you through the process, showing you how to create a customized dashboard to monitor your A/B test results.
Important: Before diving in, it’s essential to make sure your tracking is ready to go. If you’re using Piwik PRO or GA4 with Google Tag Manager (GTM), you’ll want to configure custom segments and dimensions to capture the right data. We have step-by-step guides to help you get that set up – it's the groundwork for the dashboard we’ll be building here.
Prerequisites
Before you begin, make sure you have access to the following tools:
Google Sheets: You'll use this to manage and input your data.
Looker Studio (formerly Google Data Studio): This will serve as your dashboard platform.
Optional: Supermetrics, Funnel, or Fivetran for automating data updates.
Step 1: Copy the Google Sheets Document
Start by making a copy of the Google Sheets document that will serve as your data source. This sheet contains templates you'll use later in Looker Studio.
Action: Click the link below to copy the document.
Step 2: Add Your Data to the 'Raw Data' Sheet
Next, you'll need to input your own data into the "Raw Data" sheet in the copied Google Sheets document.
Action: Navigate to the "Raw Data" sheet and replace the existing data with your own, keeping the same format.
Tip: If you have a tool like Supermetrics or Funnel, you can automate this process to keep your data updated in real-time.
Step 3: Verify Data in the 'Data Sheet'
After entering your data, double-check that it's correctly pulling into the "Data Sheet."
Action: Navigate to the "Data Sheet" and ensure all cells are displaying the correct information from the "Raw Data" sheet.
Step 4: Copy the Looker Studio Report
Now that your Google Sheets are set up, it’s time to copy the Looker Studio report that will serve as your dashboard.
Action: Click the link below to make a copy of the report.
Step 5: Connect Your Data Sources
After copying the report, you'll be prompted to connect your data sources to Looker Studio.
Action: Select your copied Google Sheets as the data source. You'll need to connect the sheets named "Calculations & Simulations" and "Data Sheet."
Step 6: Final Check
Before you start using your dashboard, it's essential to verify that everything is set up correctly.
Action: Double-check that all filters are working properly and that no metrics are displaying incorrect data.
Troubleshooting Tip: If something isn’t displaying correctly, ensure your data sources are correctly linked and that the metrics have been properly adjusted.
Final Checklist
Use this checklist to ensure you’ve completed all steps before using your dashboard:
Copied the Google Sheets document.
Added your data to the "Raw Data" sheet.
Verified data in the "Data Sheet."
Copied the Looker Studio report.
Connected the correct data sources.
Verified that all filters and metrics are working.
With these steps, your Bayesian A/B Testing dashboard is ready to go. Now you can dive into your test data and uncover insights with ease. Happy analyzing!