BigQuery is a Gold Mine of SEO Data I previously wrote about the benefits of exporting Google Search Console (GSC) data into BigQuery. As Search Console only displays up to 1,000 rows of data within the UI, it’s obviously very limiting for SEO’s who want to do data mining of 1st party search data. With […]
Tag: google search console
Addressing the Limitations of Google Search Console Data
Most SEO’s use some combination of Google Search Console (GSC), SEMRush and AHREFs. These are all wonderful tools that do different things. Google Search Console is obviously where most of our 1st party search data comes from aside from the likes of Google Analytics 4 (GA4). SEMRush excels at competitor analysis and keyword research data. […]
PR Media Mentions Can Lead To SEO Results
See how I went from ranking on page 2 to #1 after PR. I had been optimizing my category page and trying to improve my SEO ranking for a Yosemite keyword for three or four years by optimizing meta tags, on-page copy and product pages that link to the category pages. I wasn’t consistently ranked […]
Create SEO Python Code With Zero Coding Skills
Unlock Google Search Console Data With Google Colab & GSC API As a career marketing & SEO professional, I have a lot of different skills. I even taught myself Bootstrap when building one of the sites that I own. However, coding & engineering is just not my thing. As a marketing director I’ve always worked […]