Skip to content

Instantly share code, notes, and snippets.

View zldoty's full-sized avatar

Zach Doty zldoty

View GitHub Profile
@zldoty
zldoty / chrome_headless_screenshot.py
Created October 7, 2019 20:04 — forked from rverton/chrome_headless_screenshot.py
Make a screenshot with a headless google chrome in python
# Install chromedriver from https://sites.google.com/a/chromium.org/chromedriver/downloads
import os
from optparse import OptionParser
from selenium import webdriver
from selenium.webdriver.chrome.options import Options
CHROME_PATH = '/usr/bin/google-chrome'
@zldoty
zldoty / searchconsoler-add_sitemap_mechanical.r
Last active November 27, 2020 13:33
searchconsoler-add_sitemap_mechanical
# Load packages
library(searchConsoleR)
library(dplyr)
library(ggplot2)
# Authorize & choose Google profile
scr_auth()
# Specify website --- FULL URL
website <- "https://sample.com"
@zldoty
zldoty / searchconsoler-search_analytics-databydatebypage-v0.r
Created November 27, 2020 13:38
searchconsoler-search_analytics-databydatebypage-v0
# Load packages
library(searchConsoleR)
library(dplyr)
library(ggplot2)
library(writexl)
# Authorize & choose Google profile
scr_auth()
# Specify website --- CLIENT
@zldoty
zldoty / quick-check.py
Created July 8, 2021 17:02 — forked from ameesters/quick-check.py
A python script that checks multiple websites status.
#!/usr/bin/env python
import os, time, httplib
from termcolor import colored
SITES = [
"www.meesters-id.nl",
"www.carolsingers.nl",
]
while 1:
@zldoty
zldoty / zld-r-gsc-probable-voice-0
Created July 26, 2021 14:17
R Code Snippet for Extracting All Probable Voice Query Information from Google Search Console
# Load packages #
library(searchConsoleR)
library(dplyr)
library(ggplot2)
library(writexl)
library(stringr)
# Authorize & choose Google profile #
scr_auth()
@zldoty
zldoty / mechanical-google-search-console-export
Created July 28, 2021 14:44
Mechanical export of up to 16 months of Google Search Console data in R
# Load packages #
library(searchConsoleR)
library(dplyr)
library(ggplot2)
library(writexl)
library(stringr)
# Authorize & choose Google profile #
scr_auth()
@zldoty
zldoty / srContentGapRanking.vb
Created September 13, 2023 19:46
Excel macro to rank score SEO data exports
Sub semrushContentGapRanking()
Dim LastRow As Long
Dim ws As Worksheet
Dim pt As pivottable
' Set the worksheet where you want to perform the operations
Set ws = ActiveSheet
' Find the last row with data in Column A
LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
@zldoty
zldoty / srContentGapPivot.vb
Created September 13, 2023 20:03
Excel macro to summarize SEO data exports
Sub semrushContentGapPivot()
Dim PSheet As Worksheet
Dim DSheet As Worksheet
Dim PCache As PivotCache
Dim PTable As pivottable
Dim PRange As Range
Dim LastRow As Long
Dim LastCol As Long
On Error Resume Next
@zldoty
zldoty / page-performance-slope-txt.ipynb
Last active January 1, 2024 16:36
Page-Performance-Slope.txt
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@zldoty
zldoty / keyword-classification.ipynb
Created March 12, 2024 22:18
keyword-classification.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.