Why doesn't Looker Studio Search Console match the numbers you see in Search Console? A "fun" journey into hidden numbers and really hoping you just picked the wrong property. Video in this one, blog post in the next tweet. 1/2

How to get UA & GA4 on the same graph in Looker Studio. Had this come up a couple times recently so made a video. Bask in the joy of joined up data with metrics that are mostly the same. And back-up your data so this works past July.

It's Friday, y'all are at #brightonSEO. If you fancy your filling your 10 minute gaps between excellent speakers with more Friday knowledge, I've done a WBF on: Why you should join your SEO data together. (Even if you're just VLOOKING UP in Excel.) TL;DR: Better priority.

Have you ever wondered how involved it is to join GA4 and Search Console? Wonder no more! TL;DR: - Pretty easy for a quick estimation of revenue per keyword. - Lots of work for something repeatable. Enjoy the video, or read the blog (below). Comes with a little tool. 1/2

How to get estimated revenue/conversions/sessions per keyword. GA doesn't have keyword, so to get here we have to make some assumptions. Take this example. We don't know which query caused the conversion. But add 1 more dimension... 1/4

We've made a free Looker Studio template, to help you get started with better SEO reporting. It will let you: - Segment better. - Find winners and losers. - Examine YoY trends - Breakdown average rank - Compare against targets And it's built to be easily customisable.

Want to know how to improve your SEO reporting? This guide walks you though the key things to think about and consider when building them out.

Need a way to check indexation of hundreds of thousands/millions of pages? We do it by combining data sources. By using traffic & log data, we can easily rule out the pages which we know aren't indexed. Then we can focus the internal SC API/ rank tracking data on the rest.

Here’s a summary of the key things to consider when building a leadership / C suite level Digital Marketing / SEO dashboard.

Looking for a way to visualise the entire SEO funnel on a dashboard? All pages > Crawled pages > Indexed Pages > Pages with Organic Traffic > Pages with Conversions It's great way to show the different parts to leadership especially on a large site.

Do you spend a lot time unpicking traffic changes? Make it faster.

Do you control your brands SERP? Rank tells you you're in position 1 (hopefully), but that's table stakes. Don't use rank, instead use pixel space. We use dataforseo to add up pixel space and calculate the % of the first page which is owned. You'll get a far better picture!

Leadership team dashboard mistake 2: build a simpler dashboard

Leadership team dashboard mistakes 1: build a better date picker, don't use a custom picker.

See Tickets Oasis You call yourselves SEE tickets and the one thing I can’t do is see any tickets ….. 😩🥵😱

#MeasureCamp For anyone who enjoyed my notes (and destruction of a whiteboard) on write better SQL. Here are the rough notes. (Rough really is the word...) Step 1. Write better queries.