video1.0<iframe src="https://www.loom.com/embed/9deb80e896814789bd52618b64b347bd" frameborder="0" width="1662" height="1246" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>12461662Loomhttps://www.loom.com12461662https://cdn.loom.com/sessions/thumbnails/9deb80e896814789bd52618b64b347bd-5e6de468cdaa639c.gif571.138This Loom explains how to use the Perk Creative Keyword Strategy Guide spreadsheet to prioritize SEO keyword opportunities. It walks through each tab, including Competitors for the analysis baseline, Keyword Gap for keywords competitors rank for that Burke Creative does not, Local Chicago for realistic targets, and blog content tabs for informational topics that can drive traffic to landing pages. The presenter notes Burke Creative already has authority (with a domain rating of 54) and suggests starting with high commercial value keywords such as branding services for small business, citing low domain ratings of top competitors and evidence of advertiser payment indicating commercial intent. For blog posts, it highlights “wayfinding design” as a strong candidate and emphasizes matching page type to search intent.