Turn your file-based dashboards into a link, and let your clients / stakeholders view them online! No more sharing files, just send the link.

Sam Partland

Enterprise & programmatic SEO consultant with 20+ years in search. More about me or get in touch.

Keep reading

Excel/Google Sheets

Dynamic Content Generation with Google Sheets

If you haven’t been following along, I’ve been documenting my journey to a 1,000+ page programmatic site in WordPress using Google sheets. The build is heavily reliant on Google Sheets to generate dynamic content…

Read post →Excel/Google Sheets

Extracting Keyword Templates/Patterns from a Keyword Set

When doing keyword research for programmatic sites, you shouldn’t be analysing each page individually. You especially can’t be optimising an entire programmatic build page by page. You should really be looking at the…

Read post →Data Analysis

Building Your Own CTR Model from Search Console Data

Rather than performing analysis using just the bare average rank, you can bring in a keyword’s search volume and add some weighting to the rank. To do this, you estimate SEO traffic for a keyword by multiplying its…

Read post →