sterlingsky’s gists

sterlingsky / Pages with Anonymized Queries

Last active October 18, 2025 19:37

	SELECT
	url,is_anonymized_query,
	SUM(clicks) as clicks,
	SUM(impressions) as impressions,
	SAFE_DIVIDE(SUM(sum_position), SUM(impressions)) as avg_position
	FROM `project`.`searchconsole`.`searchdata_url_impression` --update project to your GSC project ID
	WHERE data_date BETWEEN '2024-09-03' AND '2025-09-09' and is_anonymized_query=true -- pick a date range you want to check
	GROUP BY url, is_anonymized_query

sterlingsky / pages losing visibility due to num=100

Last active October 18, 2025 21:02

	WITH A AS (
	SELECT
	url,
	SUM(clicks) as clicks,
	SUM(impressions) as impressions,
	SAFE_DIVIDE(SUM(sum_position), SUM(impressions)) as avg_position
	FROM `project`.`searchconsole`.`searchdata_url_impression`
	WHERE data_date BETWEEN '2025-09-03' AND '2025-09-09' -- Week 1
	AND query IS NULL
	GROUP BY url

sterlingsky / Queries missing from site after num=10000

Last active October 18, 2025 20:52

	WITH A AS (
	SELECT
	query,
	SUM(clicks) as clicks,
	SUM(impressions) as impressions
	FROM `project`.`searchconsole`.`searchdata_site_impression`
	WHERE data_date BETWEEN '2025-09-03' AND '2025-09-09' -- Week 1
	GROUP BY query
	),
	B AS (

sterlingsky / Queries missing from URLs after num 100

Last active October 18, 2025 20:53

	WITH A AS (
	SELECT
	query,
	SUM(clicks) as clicks,
	SUM(impressions) as impressions
	FROM `project`.`searchconsole`.`searchdata_url_impression`
	WHERE data_date BETWEEN '2025-09-03' AND '2025-09-09' -- Week 1
	GROUP BY query
	),
	B AS (

sterlingsky / slidePosition.gs

Created September 5, 2025 12:59

Position all slide Images to take up full slide

	function positionImagesFullCover() {
	// Get the active presentation
	const presentation = SlidesApp.getActivePresentation();

	// Get all slides in the presentation
	const slides = presentation.getSlides();

	// Get the page dimensions (standard slide size)
	const pageWidth = presentation.getPageWidth();
	const pageHeight = presentation.getPageHeight();

sterlingsky / Passage vector embeddings recipe for Screaming Frog

Last active July 6, 2025 17:30

	// Enhanced Screaming Frog Recipe: Semantic Chunking + Open Source Embeddings
	//
	// This script breaks webpage content into semantic passages (paragraphs, headings,
	// list items, etc.) and embeds each chunk using sentence-transformers/all-MiniLM-L6-v2,
	// a high-performing open-source model that ranks well on MTEB benchmarks.
	//
	// SETUP REQUIRED:
	// 1. Get a free Hugging Face token from: https://huggingface.co/settings/tokens
	// 2. Replace 'your_hf_token_here' below with your actual token
	// 3. The token will be stored in your SEO Spider configuration - be mindful when sharing

sterlingsky / gist:a0578ca6b19366cae509a03e3ab87dee

Created January 9, 2024 00:25

Build a grid of lat long points to feed into a rank tracker

	const {Client} = require('@googlemaps/google-maps-services-js');
	const geolib = require('geolib');
	const client = new Client({});

	async function isWater(latitude, longitude, apiKey) {
	try {
	const response = await client.reverseGeocode({
	params: {
	latlng: [latitude, longitude],
	key: apiKey,

sterlingsky / gist:e8dbb8f7d4770f34be9f448a9d25b991

Created January 3, 2024 15:09

Code for sending Kinect events to GA4

	<script>
	// Replace 'https://trusted-origin.com' with the
	// actual origin you expect to receive messages from.
	// no trailing slash is needed
	var trustedOrigin = ['https://trusted-origin.com','https://storage.googleapis.com'];

	window.addEventListener('message', function(event) {
	console.log(event)
	if (trustedOrigin.indexOf(event.origin) > -1) {
	var messageType = event.data && event.data.type;

sterlingsky / GBP Location Grabber

Last active November 1, 2023 15:36

Location Grabber Chrome Bookmarklet

javascript: (function (){let arr = document.querySelectorAll("tbody .uVccjd.n2Hdyf.r2A6yd.i9xfbb.N2RpBe[aria-checked='true']");console.log(arr);let output = [];for (let i = 0; i < arr.length; i++){    let item = arr[i];     let href2 =   item.closest('tr[class*=w0Oumf]').querySelector('a.DuDIZe').href ; console.log(i, " - ", href2);  let locationIn =  href2.split('/');    let location = locationIn[4]; output.push(location);  }let output1 = output.join("\n");  navigator.clipboard.writeText(output1);})();