Audit Spreadsheets – For Brad’s Use
Variables – https://docs.google.com/spreadsheets/d/1Y8jc1duYxEYPZLgTtN30ClhGNlqDA2TyqH9pZUlp1Ns/edit#gid=0
1. Screaming Frog Report – Filename Format: screaming-frog-spreadsheet-clientname-city.xls – Description: Cleaned up – Excel File Format….NOT CSV
2. Birdeye Listing Report – Filename Format: agencyname-report-listings-clientname-city.pdf – Description: PDF
3. Screaming Frog Screenshot – Aprox. 1200 x 1700 px – Filename Format: screaming-frog-screenshot-clientname-city.png – Description: Primary URL Slugs, Titles, Descriptions, H1’s – Some URL’s can be cut off..this example could have the first column moved left a bit more.
4. Birdeye Listings Screenshot – Aprox. 1250 x 750 px. – Filename Format: birdeye-listing-errors-clientname-city.png- Description: Should be at the top and be showing listing errors and different variations of their NAP details. Scroll down to find errors if needed.
5. Whitespark Keyword Rank Screenshot – Aprox. 1400 x 1000 px. – Filename Format: keyword-rankings-clientname-city.png – Description: Should show them and 3 highest ranking competitors for the main keywords in their niche.
6. Google Maps Keyword Screenshot 1 – Aprox. 750 x 700 px. – Filename Format: mappack-city-keyword.png – Description: Should show primary keyword search and their competitors ranking in map pack as well as top couple of organic results unless it’s them. Please use private browser mode
7. Google Maps Keyword Screenshot 2 – Aprox. 750 x 700 px. – Filename Format: mappack-city-keyword2.png – Description: Should show another primary keyword search and their competitors ranking in map pack as well as top couple of organic results unless it’s them. – Please use private browser mode
8. Reviews Screenshot – Aprox. 650 x 700 px. – Filename Format: google-reviews-clientname-city.png – Description: Screenshot of reviews and want to highlight especially if they aren’t getting very many.
9. Large high res version of prospect logo – Filename Format: logo-clientname-city.png/jpg/gif – Description: Prefer PNG without Background…..otherwise white background is preferred.