Tweet
Tweet

Slide 1

Slide 1 text

noah@twooctobers @noahlearner Game-Changing Ways to Use the Google Search Console API Noah Learner Product Director, Two Octobers @noahlearner

Slide 2

Slide 2 text

noah@twooctobers @noahlearner [email protected] @noahlearner The Hubble Ultra Deep Field This is what 10,000 galaxies looks like.

Slide 3

Slide 3 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 4

Slide 4 text

noah@twooctobers @noahlearner [email protected] @noahlearner 100 meters away

Slide 5

Slide 5 text

noah@twooctobers @noahlearner [email protected] @noahlearner Using the API is like unleashing the power of Hubble.

Slide 6

Slide 6 text

noah@twooctobers @noahlearner [email protected] @noahlearner GSC UI

Slide 7

Slide 7 text

noah@twooctobers @noahlearner [email protected] @noahlearner GSC API

Slide 8

Slide 8 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

noah@twooctobers @noahlearner [email protected] @noahlearner Google Search Console’s performance tab is painful.

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

noah@twooctobers @noahlearner [email protected] @noahlearner How’s this for context?

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

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

Slide 25

Slide 25 text

noah@twooctobers @noahlearner [email protected] @noahlearner Build multiple layers of filters to get to answers. AND FAST

Slide 26

Slide 26 text

noah@twooctobers @noahlearner [email protected] @noahlearner Context!

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

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

Slide 33

Slide 33 text

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

Slide 34

Slide 34 text

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

Slide 35

Slide 35 text

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

Slide 36

Slide 36 text

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

Slide 37

Slide 37 text

noah@twooctobers @noahlearner [email protected] @noahlearner Segment your data by creating filters like this

Slide 38

Slide 38 text

noah@twooctobers @noahlearner [email protected] @noahlearner Learn about calculated fields + case statements

Slide 39

Slide 39 text

noah@twooctobers @noahlearner [email protected] @noahlearner BE PATIENT.

Slide 40

Slide 40 text

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

Slide 41

Slide 41 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 42

Slide 42 text

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

Slide 43

Slide 43 text

noah@twooctobers @noahlearner [email protected] @noahlearner Folder Structure

Slide 44

Slide 44 text

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

Slide 45

Slide 45 text

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

Slide 46

Slide 46 text

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

Slide 47

Slide 47 text

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

Slide 48

Slide 48 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 49

Slide 49 text

noah@twooctobers @noahlearner [email protected] @noahlearner The magic

Slide 50

Slide 50 text

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

Slide 51

Slide 51 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 52

Slide 52 text

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

Slide 53

Slide 53 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 54

Slide 54 text

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

Slide 55

Slide 55 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 56

Slide 56 text

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

Slide 57

Slide 57 text

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

Slide 58

Slide 58 text

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

Slide 59

Slide 59 text

noah@twooctobers @noahlearner [email protected] @noahlearner Keep your page that aligns with the intent you see in the serps.

Slide 60

Slide 60 text

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

Slide 61

Slide 61 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 62

Slide 62 text

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

Slide 63

Slide 63 text

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

Slide 64

Slide 64 text

noah@twooctobers @noahlearner [email protected] @noahlearner We can see low hanging fruit opportunities

Slide 65

Slide 65 text

noah@twooctobers @noahlearner [email protected] @noahlearner Striking Distance

Slide 66

Slide 66 text

noah@twooctobers @noahlearner [email protected] @noahlearner FAQs anyone? Content expansion?

Slide 67

Slide 67 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 68

Slide 68 text

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

Slide 69

Slide 69 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 70

Slide 70 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 71

Slide 71 text

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

Slide 72

Slide 72 text

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

Slide 73

Slide 73 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 74

Slide 74 text

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

Slide 75

Slide 75 text

noah@twooctobers @noahlearner [email protected] @noahlearner

Slide 76

Slide 76 text

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

Slide 77

Slide 77 text

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

Slide 78

Slide 78 text

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

Slide 79

Slide 79 text

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

Slide 80

Slide 80 text

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

Slide 81

Slide 81 text

noah@twooctobers @noahlearner [email protected] @noahlearner 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

Slide 82

Slide 82 text

noah@twooctobers @noahlearner Game-Changing Ways to Use the Google Search Console API Noah Learner Product Director, Two Octobers @noahlearner