The wonderful combination of Google Sheets and the Google Analytics for Sheets add-on make it easy to analyze your AB tests, saving hours of trekking through GA reports after each test. Brian Massey will go over the tasks that can be automated using this powerful combination. Attendees can expect:
How to setup GA and Sheets to be your test reporting platform
Common tasks you can automate for test analysis
Link to sample spreadsheets
Attendees should be familiar with the Google Analytics for Sheets add on and the Google Analytics API.
Brian Massey is the founder of Conversion Sciences LLC and author of the book Your Customer Creation Equation. His rare combination of interests and experience was developed over 30 years as a computer programmer, entrepreneur, corporate marketer, international speaker, and writer. Founded in 2007, Conversion Sciences helps businesses transform their sites through a steady diet of visitor profiling, purposeful content, analytics, and AB testing. Massey has worked with hundreds of companies to improve their online business. He is a sought-after speaker, presenting at IBM, Inbound, LeadsCon, Content Marketing World, Affiliate Summit, and others. He has written for online publications including ClickZ, Search Engine Land and Marketing Land. Massey is the host of the Intended Consequences podcast.
You'll get a look at how the Query function in Google Sheets is similar to SQL syntax and can help you learn BigQuery.
Plus, a side-by-side comparison of actions with the Query function and BigQuery equivalents.
Ben will also use Connected Sheets to bring data from BigQuery into Sheets.
Ben helps individuals and businesses better understand their data and work more efficiently with Google Workspace tools.
Over 50,000 professionals from 1,000+ companies have enrolled in his training courses, including employees from PwC, Netflix, Verizon, Google, Capital One, and other Fortune 500 companies.
Google recognized Ben as a Google Developer Expert for Google Workspace Technology in 2019, one of only a handful worldwide.
Ben works primarily with Google Sheets and Apps Script and has extensive experience with Google Data Studio, Microsoft Excel, SQL, and Tableau. He previously taught data courses and workshops for General Assembly in Washington, D.C.