In the late morning Insights track, Al of So What Analytics picked up on some awesome Analytics and Data scientist tips and tricks for us all. Al’s a huge fan of Google’s Big Query, Big Data (warehousing) and Google’s sort-of-still-new Data Studio. Here’s a summary of his talk for those who didn’t make it! If you want to follow along with the slides, you can find them here on Slideshare.
The issue with data in 2017 is that as marketers, the data we need is stored in far too many disparate places. Web analytics is in Adobe or Google Analytics, ecommerce data is usually on-platform in Magento or similar, ad data in Adwords or your DSP’s, various other information is stored in both online and offline databases… and that’s why Monday morning is such a pain!
As marketers we want to spend time with the data, rather than finding it in the first place.
There are already innovations out there: Supermetrics and various Google Scripts are great at pulling data into spreadsheets for you, but you still end up with separate sheets that need internal cross-referencing to product something useful.
Google Data Studio
Google Data Studio (beta) turns your data into informative dashboard and reports that are easy to read, easy to share, and fully customisable. The list of the data sources is every changing, but the good news for SEOs is that Search Console was recently added(!). One of the most powerful (amongst other database connections) is the connection to Google’s BigQuery – Google’s data warehousing product which allows almost any data-type importing so long as you have a method of getting the data in there in the first place.
Within Data Studio, connecting to data sources is really, really painless. Google, through their standard authentication processes, have eliminated most of the potential pain points for us. For all Google products, there’s absolutely no coding required at all!
Check out the Google Data Studio Gallery if you’re looking for report inspiration!
Data Studio as a BI tool?
From reviewing the product features, in addition to the recently added connectors, it’s clear to see how Google plan to further develop the tool outside of digital marketing and into wider business information. You can connect almost anything in a database.
So.. Why Data Studio?
- It’s free (5 report limit removed Feb 2017)
- Google account for access
- Unlimited users
- Unlimited reports
- Shallow learning curve
- Drag and drop
- Standardised visual elements to change from (charts, single metrics, graphs)
- Sharing data — all reports can be shared with others through familiar Google sharing dialogs
- Data transformation
- When the data comes in, you can transform it if you want – if you don’t like to call sessions sessions, you can rename them to visitors, etc
- Create your own custom metrics
- Example: Create GA custom channel grouping (see the photo below – this looks very effective)
- Merging data sources
- One data source per component but you can multiple different components with different sources on the same report – this isn’t possible with GA
As a slight aside, Al mentioned a really poignant point that I think will come to fruition in the future. Custom Google Analytics dashboards are becoming less and less useful in comparison, so perhaps they’ll sunset this functionality in favor of Google Data Studio adoption. Just a theory, but it resonated well and I feel the same.
Al had a great case study, too, but you can check this out in his slides. Nice work in particular on that one, Al!
This post is one of 27 in our Brighton SEO 2017 collection
- Brighton SEO: Rebecca Brown – Why you should scrap your content budget line
- Brighton SEO: Fili Wiese – Link building 2018
- Brighton SEO: Sophie Coley – Answering the Public
- Brighton SEO: Stacey MacNaught – Advanced Keyword Research
- Brighton SEO: Duane Forrester – Markup, User Driven Change and Your Future
- Brighton SEO: A Different Perspective on Ranking Factors, Jo Turnbull and Daniel Furch
- Brighton SEO: Christoph Cemper, How to Grow Traffic by 500%
- SMX London: Harnessing The Power Of Online Reviews – Ben Roberts
- BrightonSEO: Samantha Noble on How To Use Paid Media To Increase The Lifetime Value Of A Customer
- BrightonSEO: Arianne Donoghu – Moving Towards Audiences in a Keyword-Based World
- BrightonSEO: Sam Charles – How to incentivise bloggers without spending money
- BrightonSEO: Charlie Williams – Shop it like it’s hot; Ecommerce content that’s worth a damn
- BrightonSEO: Julia Ogden’s 10 step checklist for a show stopping distribution plan
- BrightonSEO: Sean Butcher – So You Think You Know Canonical Tags?
- BrightonSEO: Marcus Tober – Why SEO and Content Marketing must always be data-driven
- Brighton SEO: Alexandra Lever – How partnerships and sponsorships can help your search marketing efforts
- BrightonSEO: Raj Nijjer – AI and Structured Data: How voice search raises the stakes for businesses
- Brighton SEO – Advanced Local SEO Tips to Help You Murder Your Competitors – Greg Gifford
- BrightonSEO: Tony Lu – How real time dashboards can help you make better decisions
- Al Wightman – How can Google Data Studio help me? Brighton SEO 2017
- BrightonSEO 2017: The Future Of Search – @PurnaVirji talks us through a Keywordless world
- BrightonSEO: Philip Gamble on Technical SEO beyond the initial audit
- BrightonSEO: Sophie Turton – The Psychology of Language for PPC
- BrightonSEO: Marco Volpe On How To Create Your Own Dynamic Remarketing
- BrightonSEO: Sam Vandermark – Looking Beyond Paid Search For Better Biddable Results
- BrightonSEO: Claudia Higgins – Getting the most out of the SEO data you can get for free
- BrightonSEO: Lotty Chudley – Persuading Consumers to Part with Their Cash: Tips & Tricks for Conversion
We’ve developed a Free Google Data Studio Template for Ecommerce. Just connect your own Google Data sources and start using it here: https://goo.gl/O04k38. What do you think?