Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

Technical Lead, Fly High Media Interested in Speeding up SEO auditing & workflows

Slide 3

Slide 3 text

ARE YOU USING AI TO GENERATE CODES TO SPEED UP WORKFLOW?

Slide 4

Slide 4 text

IS ANYONE CURRENTLY USING GOOGLE APIS?

Slide 5

Slide 5 text

TOOLS Google Sheets Google App Scripts ChatGPT

Slide 6

Slide 6 text

WHY USE GOOGLE SCRIPTS & AI?

Slide 7

Slide 7 text

SPEED

Slide 8

Slide 8 text

FREE

Slide 9

Slide 9 text

CUSTOMISABLE

Slide 10

Slide 10 text

WHAT GOOGLE APIS ARE USEFUL FOR SEARCH MARKETERS?

Slide 11

Slide 11 text

GOOGLE SEARCH CONSOLE API

Slide 12

Slide 12 text

GOOGLE ANALYTICS METRICS

Slide 13

Slide 13 text

GOOGLE ADS API

Slide 14

Slide 14 text

GOOGLE BUSINESS PROFILE API

Slide 15

Slide 15 text

PAGE SPEED & CORE WEB VITALS CRUX API / GTMETRIX

Slide 16

Slide 16 text

OTHER APIS

Slide 17

Slide 17 text

WHAT ARE GOOGLE APP SCRIPTS?

Slide 18

Slide 18 text

No content

Slide 19

Slide 19 text

No content

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

LET’S START EXTRACTING DATA FROM APIS!

Slide 22

Slide 22 text

GOOGLE SEARCH CONSOLE API

Slide 23

Slide 23 text

GET APIS FROM GOOGLE DEVELOPERS CONSOLE

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

FLYHIGHMEDIA.CO.UK/ BRIGHTONSEO-2025 GUIDE

Slide 26

Slide 26 text

LET’S EXTRACT THE CLICKS & IMPRESSIONS FOR MULTIPLE URLS

Slide 27

Slide 27 text

ASK CHATGPT/AI I WANT A FORMULA THAT EXTRACTS THE CLICKS AND IMPRESSIONS USING GOOGLE SEARCH CONSOLE API FOR A URL SELECTED IN THE FORMULA

Slide 28

Slide 28 text

ENSURE IT HAS SOMETHING LIKE THIS CLIENT_ID = 'YOUR_OAUTH_CLIENT_ID'; CLIENT_SECRET = 'YOUR_OAUTH_CLIENT_SECRET';

Slide 29

Slide 29 text

ASK CHATGPT/AI I WANT TO PROVIDE CLIENT ID & CLIENT SECRET TO GET THE DATA FROM GOOGLE SEARCH CONSOLE

Slide 30

Slide 30 text

No content

Slide 31

Slide 31 text

ASK CHATGPT/AI I WANT TO PROVIDE THE DATES AND THE DOMAIN IN THE FORMULA FROM A CELL

Slide 32

Slide 32 text

SITE URL DOMAIN PROPERTY SC-DOMAIN:YOURDOMAIN.COM URL PREFIX HTTPS://WWW.YOURDOMAIN.COM

Slide 33

Slide 33 text

ENABLE OAUTH2.0 IN GOOGLE APP SCRIPTS

Slide 34

Slide 34 text

No content

Slide 35

Slide 35 text

No content

Slide 36

Slide 36 text

No content

Slide 37

Slide 37 text

1B7FSRK5ZI6L1RSXXTDGDEUS PZLUKDSI4KGUTMORSTQHH GBZBKMUN4IDF

Slide 38

Slide 38 text

No content

Slide 39

Slide 39 text

No content

Slide 40

Slide 40 text

RECOMMENDATION SEPERATE METRICS INTO DIFFERENT FORMULAS ASK CHATGPT/AI

Slide 41

Slide 41 text

AUTHORISE THE SCRIPT

Slide 42

Slide 42 text

No content

Slide 43

Slide 43 text

No content

Slide 44

Slide 44 text

No content

Slide 45

Slide 45 text

COPY URL AND OPEN URL IN NEW TAB & THEN FOLLOW INSTRUCTIONS TO VALIDATE THE CODE

Slide 46

Slide 46 text

No content

Slide 47

Slide 47 text

No content

Slide 48

Slide 48 text

COPY FORMULA (FROM CHATGPT/AI) AND START USING THE CUSTOM FORMULA YOU HAVE MADE!

Slide 49

Slide 49 text

OTHER USE CASES

Slide 50

Slide 50 text

GSC AUTOMATED REPORTING OF SITE PERFORMANCE

Slide 51

Slide 51 text

GSC IDENTIFYING AND MONITORING CRAWL ERRORS

Slide 52

Slide 52 text

GSC GET RELATED QUERIES TO CONTENT

Slide 53

Slide 53 text

GA4 MONITOR E-COMMERCE TRACKING DATA

Slide 54

Slide 54 text

GA4 MONTHLY TRAFFIC OVERVIEW

Slide 55

Slide 55 text

GA4 TRACKING CAMPAIGN UTM PARAMETER PERFORMANCE

Slide 56

Slide 56 text

GOOGLE BUSINESS LISTINGS REPORTING ON CUSTOMER ACTIONS AND INSIGHTS FOR MULTIPLE LISTINGS

Slide 57

Slide 57 text

CRUX API EXTRACT REAL-USER EXPERIENCE DATA (CORE WEB VITALS)

Slide 58

Slide 58 text

WHY NOT USE OTHER TOOLS?

Slide 59

Slide 59 text

EXPENSIVE

Slide 60

Slide 60 text

DATA IS NOT CUSTOMISABLE

Slide 61

Slide 61 text

REAL-TIME COLLABORATION

Slide 62

Slide 62 text

ISSUES YOU MAY COME ACROSS

Slide 63

Slide 63 text

API QUOTAS AND LIMITS 1

Slide 64

Slide 64 text

AUTHENTICATION ERRORS 2

Slide 65

Slide 65 text

DATA FORMATTING ISSUES 3

Slide 66

Slide 66 text

USE AI TO TROUBLESHOOT ANY ISSUES 4

Slide 67

Slide 67 text

GET ACCESS TO SLIDES SPEAKERDECK.COM/ JONATHONROBERTSSEO

Slide 68

Slide 68 text

FLYHIGHMEDIA.CO.UK/ BRIGHTONSEO-2025 GOOGLE API GENERATION GUIDE

Slide 69

Slide 69 text

ANY FURTHER QUESTIONS? linkedin.com/in/jonathon-roberts-seo jonathonr.bsky.social @jonathonrseo www.flyhighmedia.co.uk