How to use looker studio for more than monthly reports

Transcript

1. How to use looker studio for more than monthly reports Amanda Jordan RicketyRoo Speakerdeck.com/username @amandatjordan
2. SEOs are Detectives #brightonSEO @amandatjordan
3. Relying on one data source or one view is like relying on one clue to solve a mystery. There’s a chance you’re missing the bigger picture #brightonSEO @amandatjordan
4. Why go beyond monthly reporting with looker studio? ➔ Combine sources into one report ➔ Enhances the big picture ➔ Superior filtering capabilities ➔ Speeds up analysis and discovery processes #brightonSEO @amandatjordan
5. Combine sources into one report → SEMRUSH → AHREFS → CALLRAIL → BIGQUERY → LOCAL FALCON → SHOPIFY → CONTENTKING → ANYTHING THAT CAN BE EXPORTED INTO A CSV #brightonSEO @amandatjordan
6. Enhances the big picture One source: new view provides more context #brightonSEO @amandatjordan
7. Superior filtering capabilities Create customer filters with SQL CASE statements #brightonSEO @amandatjordan
8. Superior filtering capabilities #brightonSEO @amandatjordan
9. Speeds up analysis and discovery processes #brightonSEO @amandatjordan
10. CRIME SCENE #brightonSEO @amandatjordan
11. Client has spent a significant amount of time creating blog content that ranks, but brings in no leads. Client competing for keywords highly associated with IT certification quizzes. #brightonSEO @amandatjordan
12. Learn from who is winning ➔ Identified terms with clear conversion intent (Google Ads data can help a lot with this) ➔ Determined top competitors for these terms ➔ Analyzed top competitors current topical and content strategies #brightonSEO @amandatjordan
13. Identified the winningest local competitor #brightonSEO @amandatjordan
14. Compared content/topical intent #brightonSEO @amandatjordan
15. Got in the nitty gritty of each key topic #brightonSEO @amandatjordan
16. Results #brightonSEO @amandatjordan
17. Same data, different chart, big difference #brightonSEO @amandatjordan
18. Data manipulation is your friend How our internal links are distributed across all page types. #brightonSEO @amandatjordan
19. Data manipulation is your friend ➔ Categorization with CASE statements ➔ Filters other charts on the same page #brightonSEO @amandatjordan
20. Data manipulation is your friend #brightonSEO @amandatjordan
21. Data manipulation is your friend ➔ Choosing a category determines which target URLs are shown ➔ Clicking on a target URL provides additional information #brightonSEO @amandatjordan
22. Drilling down into deeper insights #brightonSEO @amandatjordan
23. CRIME SCENE #brightonSEO @amandatjordan
24. Duplicate content issue but you’re not sure how many pages are competing for the same term or topic #brightonSEO @amandatjordan
25. Cross-filtering to drill down ➔ Connect to Google Search Console ➔ Create a chart using Query and Landing Page ➔ Set Landing Page to COUNT ➔ Create a second chart for Landing Page, impressions and clicks ➔ Set up cross-filtering #brightonSEO @amandatjordan
26. Cross-filtering to drill down #brightonSEO @amandatjordan Create categories or add an advanced data control for more views
27. Are you ready to become a true SEO detective? #brightonSEO @amandatjordan
28. More reporting ideas Created by @MediaSesh ➔ Competitor internal linking strategy analysis ➔ CrUX dashboard ➔ Google Business Profile dashboard ➔ SERP visibility summary #brightonSEO @amandatjordan
29. ➔ Embrace Constraints ➔ Prioritize & Simplify ➔ Stay Adaptable #brightonSEO @amandatjordan
30. Thanks! Amanda Jordan RicketyRoo Speakerdeck.com/username @amandatjordan