Tweet
Tweet

Slide 1

Slide 1 text

How to use looker studio for more than monthly reports Amanda Jordan RicketyRoo Speakerdeck.com/username @amandatjordan

Slide 2

Slide 2 text

SEOs are Detectives #brightonSEO @amandatjordan

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

Combine sources into one report → SEMRUSH → AHREFS → CALLRAIL → BIGQUERY → LOCAL FALCON → SHOPIFY → CONTENTKING → ANYTHING THAT CAN BE EXPORTED INTO A CSV #brightonSEO @amandatjordan

Slide 6

Slide 6 text

Enhances the big picture One source: new view provides more context #brightonSEO @amandatjordan

Slide 7

Slide 7 text

Superior filtering capabilities Create customer filters with SQL CASE statements #brightonSEO @amandatjordan

Slide 8

Slide 8 text

Superior filtering capabilities #brightonSEO @amandatjordan

Slide 9

Slide 9 text

Speeds up analysis and discovery processes #brightonSEO @amandatjordan

Slide 10

Slide 10 text

CRIME SCENE #brightonSEO @amandatjordan

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

Identified the winningest local competitor #brightonSEO @amandatjordan

Slide 14

Slide 14 text

Compared content/topical intent #brightonSEO @amandatjordan

Slide 15

Slide 15 text

Got in the nitty gritty of each key topic #brightonSEO @amandatjordan

Slide 16

Slide 16 text

Results #brightonSEO @amandatjordan

Slide 17

Slide 17 text

Same data, different chart, big difference #brightonSEO @amandatjordan

Slide 18

Slide 18 text

Data manipulation is your friend How our internal links are distributed across all page types. #brightonSEO @amandatjordan

Slide 19

Slide 19 text

Data manipulation is your friend ➔ Categorization with CASE statements ➔ Filters other charts on the same page #brightonSEO @amandatjordan

Slide 20

Slide 20 text

Data manipulation is your friend #brightonSEO @amandatjordan

Slide 21

Slide 21 text

Data manipulation is your friend ➔ Choosing a category determines which target URLs are shown ➔ Clicking on a target URL provides additional information #brightonSEO @amandatjordan

Slide 22

Slide 22 text

Drilling down into deeper insights #brightonSEO @amandatjordan

Slide 23

Slide 23 text

CRIME SCENE #brightonSEO @amandatjordan

Slide 24

Slide 24 text

Duplicate content issue but you’re not sure how many pages are competing for the same term or topic #brightonSEO @amandatjordan

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

Cross-filtering to drill down #brightonSEO @amandatjordan Create categories or add an advanced data control for more views

Slide 27

Slide 27 text

Are you ready to become a true SEO detective? #brightonSEO @amandatjordan

Slide 28

Slide 28 text

More reporting ideas Created by @MediaSesh ➔ Competitor internal linking strategy analysis ➔ CrUX dashboard ➔ Google Business Profile dashboard ➔ SERP visibility summary #brightonSEO @amandatjordan

Slide 29

Slide 29 text

➔ Embrace Constraints ➔ Prioritize & Simplify ➔ Stay Adaptable #brightonSEO @amandatjordan

Slide 30

Slide 30 text

Thanks! Amanda Jordan RicketyRoo Speakerdeck.com/username @amandatjordan