In this video, I walk you through my Google Data Studio dashboard, focusing on the brand vs. non-brand filter and how I present this data to stakeholders. I explain the importance of categorizing keywords and how it helps showcase SEO progress, especially when dealing with non-brand clicks. I also share insights on using Regex for filtering and highlight the need for careful data management when exporting queries. If you have any questions or need assistance with your own dashboards, feel free to reach out!
00:00 Introduction to Dashboard
02:10 Adding Advanced Filters
04:10 Service Category Breakdown
07:30 Presenting to Stakeholders
11:19 Exporting Data from Search Console
15:30 Focus on Non-Brand Queries
20:16 Conclusion and Next Steps
YouTube won't let me add the formula I use.
Find my Sheets formula to identity the new Keywords comparing to the comparison period and Looker Studio calculated fields here: https://mktlinkmedia.com/blog/how-to-...