Tweet
Tweet

Slide 1

Slide 1 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Google Search Console API + Google Data Studio: Big Data + Laser Focused Context for the Win

Slide 2

Slide 2 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Why are we here?

Slide 3

Slide 3 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The Google Search Console (GSC) API Revolution

Slide 4

Slide 4 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The GSC API Revolution What is It?

Slide 5

Slide 5 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS It’s a new way to find traffic growth opportunities.

Slide 6

Slide 6 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The GSC API Revolution Big data from the GSC API To provide context & Take Action.

Slide 7

Slide 7 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The GSC API Revolution Why?

Slide 8

Slide 8 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Google Search Console Just isn’t good enough.

Slide 9

Slide 9 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS 1,000 rows?

Slide 10

Slide 10 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS 1 dimension at a time?

Slide 11

Slide 11 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS It’s also slow and tedious to work with.

Slide 12

Slide 12 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Cloud Technology has evolved.

Slide 13

Slide 13 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Making it possible to get & store search data for pennies!

Slide 14

Slide 14 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The Revolution is for ALL!

Slide 15

Slide 15 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Small sites can be nimble + compete for the long tail in ways larger sites can’t.

Slide 16

Slide 16 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS It’s Google Search Console Made Meaningful.

Slide 17

Slide 17 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 18

Slide 18 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 19

Slide 19 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The API delivers 25x the data.

Slide 20

Slide 20 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS 25x the data is pretty cool, where’s the money?

Slide 21

Slide 21 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS HOW MUCH IS HIDDEN? Clicks x Conv Rate x AOV

Slide 22

Slide 22 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS 7k Clicks x Conv Rate x AOV

Slide 23

Slide 23 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS 1% Clicks x Conv Rate x AOV

Slide 24

Slide 24 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS $570 Clicks x Conv Rate x AOV

Slide 25

Slide 25 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS $40k = ~2% of revenue is hidden

Slide 26

Slide 26 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS That is 1 of 285 brands on the site.

Slide 27

Slide 27 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS HIDDEN BOF TERMS $380k

Slide 28

Slide 28 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The API offers an astonishing amount of data.

Slide 29

Slide 29 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Create UIs that match your workflows.

Slide 30

Slide 30 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Layered filtering takes us from large data to actionable insights

Slide 31

Slide 31 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS What are the Advantages?

Slide 32

Slide 32 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS HOLY MOLY it’s fast.

Slide 33

Slide 33 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS You’ll get more done in less time.

Slide 34

Slide 34 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Segment your traffic with filters in meaningful ways.

Slide 35

Slide 35 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Using GMB Queries To Drive ROI!

Slide 36

Slide 36 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS GMB Filtering Services, entities, brands, and verbs associated with your GMB categories.

Slide 37

Slide 37 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Combine this data with GA data for $$$.

Slide 38

Slide 38 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Where do they go next?

Slide 39

Slide 39 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Store pages 1. GA Audience > Users Flow 2. Change Category to Landing Page for a store page

Slide 40

Slide 40 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Store pages 1. Add content to store page to grow sales: a. Popular products b. Popular brands c. Popular categories

Slide 41

Slide 41 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Position Bucketing THIS IS $$$

Slide 42

Slide 42 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS ● Target queries by position

Slide 43

Slide 43 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS ● Target queries by position ● Target low hanging fruit

Slide 44

Slide 44 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS ● Target queries by position ● Target low hanging fruit ● Target queries just outside the local pack (4-15).

Slide 45

Slide 45 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Branded Terms

Slide 46

Slide 46 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS ● Are people searching more for my Brand?

Slide 47

Slide 47 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS ● Are people searching more for my Brand? ● Is my site ranking for more: ○ Head terms?

Slide 48

Slide 48 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS ● Are people searching more for my Brand? ● Is my site ranking for more: ○ Head terms? ○ Services?

Slide 49

Slide 49 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS ● Are people searching more for my Brand? ● Is my site ranking for more: ○ Head terms? ○ Services? ○ Products?

Slide 50

Slide 50 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 51

Slide 51 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Product Brands

Slide 52

Slide 52 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS We saw huge demand for queries including “For Sale”

Slide 53

Slide 53 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS REVENUE UP 116% over 2020

Slide 54

Slide 54 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Putting it all together: TOPIC EXPLORER

Slide 55

Slide 55 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 56

Slide 56 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Enter a head term to show relevant queries and URLS.

Slide 57

Slide 57 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 58

Slide 58 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Click a search term to find a target page to optimize

Slide 59

Slide 59 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 60

Slide 60 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS We can see: the page to optimize

Slide 61

Slide 61 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 62

Slide 62 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS We can see: cannibalization issues

Slide 63

Slide 63 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS We can see: internal linking opportunities

Slide 64

Slide 64 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Perform serp analysis to understand search intent.

Slide 65

Slide 65 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS What page types are in the Serps?

Slide 66

Slide 66 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Keep your page that aligns with the serps.

Slide 67

Slide 67 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS 301 redirect / deoptimize the other pages.

Slide 68

Slide 68 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Initial 317K 15K Step 1 25.6K 1.3K Step 2 1 5 Terms URLs

Slide 69

Slide 69 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS We can see content expansion opportunities

Slide 70

Slide 70 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 71

Slide 71 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS FAQs anyone?

Slide 72

Slide 72 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 73

Slide 73 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Take it a step further with conditional formatting.

Slide 74

Slide 74 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 75

Slide 75 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 76

Slide 76 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Process the data in BigQuery for even more $$$.

Slide 77

Slide 77 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Trending Queries = $$$

Slide 78

Slide 78 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 79

Slide 79 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS You can then create change columns that are sortable in GDS.

Slide 80

Slide 80 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS

Slide 81

Slide 81 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS GIMME GIMME GIMME!!!

Slide 82

Slide 82 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS How can I get this rolling?

Slide 83

Slide 83 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Gathering the Data

Slide 84

Slide 84 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS BigQuery Data Studio GSC API The System

Slide 85

Slide 85 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Build your own or use an ETL tool:

Slide 86

Slide 86 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Getting the data into BQ. $10 - $$$$ / month / client

Slide 87

Slide 87 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS BigQuery costs between $0.02 - $0.25 / client / month

Slide 88

Slide 88 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS DATA STUDIO IS FREE

Slide 89

Slide 89 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS What have we learned?

Slide 90

Slide 90 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The GSC API is the new table stakes.

Slide 91

Slide 91 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS The combo of API + BQ + GDS is crazy powerful.

Slide 92

Slide 92 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS You’ll build better content that ranks and converts.

Slide 93

Slide 93 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS Leave no data behind!

Slide 94

Slide 94 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS USEFUL LINKS Two Octobers Explorer for Search: https://bit.ly/388eAPC

Slide 95

Slide 95 text

noah@twooctobers @noahlearner [email protected] @noahlearner #WLSS USEFUL LINKS How to Build a Google Search Console Data Pipeline: http://bit.ly/gscPipeline Getting All Your Search Data: https://bit.ly/3fcGzC9 Building Case Statements https://support.google.com/datastudi o/answer/7020724