A spreadsheet system for running edits at scale: curated columns

A spreadsheet system for running edits at scale: curated columns

Several operators shared their tracking templates; here's the merged structure.

— Core columns: host URL, target URL, anchor, type, price, date placed, dofollow Y/N (an agency template).
— Status column with a monthly re-check date — a forum thread insists on this for drop detection.
— Relevance + traffic snapshot at purchase, so you can judge value later (a Reddit tip).
— Anchor-ratio formula that flags when exact-match creeps past your cap.

Editor's note: the people who scaled cleanly all had the ratio guardrail baked into the sheet.

Pick of the week: a shared template where a conditional-format cell turns red the moment a placement isn't re-verified on time.