Building a Directory Submission List and Tracking Sheet

A ship's captain keeps a log. Position, weather, course changes, repairs: written down at the time, because memory fails and the record is what you rely on when something goes wrong. A founder listing a product in several directories needs the same habit.

Without a log, directory work turns messy fast. You cannot remember whether you submitted to a particular site. You paste slightly different descriptions in different places. A listing goes dead and you never notice. A tracking sheet fixes all of this with about an hour of set-up. This guide shows how to build one and keep it useful.

Why a log pays for itself

Three problems appear in every unmanaged set of listings.

Forgotten submissions. A form submitted late at night, a confirmation email lost in a busy inbox. Months later you are unsure whether the listing exists.

Inconsistent text. Different taglines, different descriptions, even different spellings of the product name. Inconsistent details confuse visitors and make it harder to see that all the listings belong to one product.

Silent decay. A directory closes, a link breaks, or a listing is removed. Without a review date, nobody notices.

A sheet with a handful of columns solves each of these.

The core columns

Keep it plain. These columns are enough for most products.

Directory name. The name as the site writes it.

Address. The link to the site's home page or submission page.

Category on that site. Where you placed the product, since different sites use different categories.

Date submitted. The day you sent it.

Status. One word from a short list, described below.

Live listing link. The public address of your listing once it exists.

Tagged link. The link you gave that directory to use for your website, with a source tag so you can see its visitors in analytics.

Text version. A short code showing which version of your description you used, such as A or B, with the texts kept on a second tab.

Cost. What you paid, if anything, and what it covers.

Link type. Whether the directory links to you as a followed link, a nofollow link or a sponsored link, if you can tell.

Contact. A person or email address for corrections.

Review date. When you will next check it.

Notes. Anything unusual: a quirk of the form, a promised feature, a name of a person who helped.

That is thirteen columns. It looks like a lot, but each takes seconds to fill.

A short list of statuses

Use the same words every time so you can filter.

• Planned: on your short list, not yet submitted.
• Submitted: sent, waiting.
• Live: published and checked.
• Needs fix: live but something is wrong, such as an old description or broken screenshot.
• Rejected: declined, with the reason in notes.
• Retired: removed, closed or no longer worth maintaining.

Think of them as buoys along a route. A listing moves from one to the next, and the sheet shows where each one is.

The text tab

On a second tab, keep your master texts:

• A one-line description.
• A short description of a couple of sentences.
• A longer description, a few paragraphs.
• Your product name, exactly as written, including capitals.
• Your website address, company name and a contact email.
• A list of screenshot files with dates and alt-text descriptions.
• Your logo files and which size goes where.

Every time you submit, copy from here. When something changes, such as a new feature or a new price, update the master first and then the listings. This is also how you keep all the facts identical across the web.

If you describe prices, do not type a figure into each directory by hand without noting where it came from; prices change, and stale prices on third-party sites are an easy way to mislead people. Better to link to your own pricing page and keep one source of truth.

Tagged links, step by step

Most analytics tools can group visits by the campaign information in a link. Google's documentation for its analytics product explains how campaign parameters such as source and medium are read. In practice:

1. Choose a naming habit, such as the directory's name in lower case for the source and "directory" for the medium.
2. Add those to your website address when you give it to the directory.
3. Paste the tagged address in the sheet.
4. After a few weeks, look at traffic by source and note the visits next to each row.

Some directories strip or rewrite links, so test by clicking your own live listing and checking that the visit appears in your reports.

Recording how links are marked

Search engines ask sites to mark certain outbound links, such as paid or user-submitted ones, so that they are not used to manipulate rankings. Google's guidance on qualifying outbound links describes the nofollow, sponsored and user-generated markers. When your listing goes live, view the page's source or use a browser tool to see how your link is marked, and note it. It is useful to know, and it stops you from drawing wrong conclusions about what a listing does for search.

A weekly and a quarterly rhythm

A log only helps if you use it. Two small habits keep it alive.

Each time you submit or change something, update the row straight away. It takes thirty seconds and avoids guesswork later.

Once a quarter, run a review:

1. Open each live listing and check it loads.
2. Compare the text with your master. Fix differences.
3. Check the screenshots are current.
4. Note the visits from the tagged link.
5. Decide: keep, fix or retire.
6. Set the next review date.

A review of ten listings takes under an hour and prevents slow decay.

Sharing and access

If a teammate or freelancer helps with listings, share the sheet and agree who edits what. One person should be the owner of the master text so changes are not made twice. Never put passwords in the sheet. If a directory account needs a login, store it in a proper password manager and just note in the sheet which account holds the listing.

Keep the sheet private. It contains your plans and contacts.

Using colour and filters

Add simple formatting. Colour the status column so a glance shows what needs attention. Add a filter row so you can show only "Needs fix" or only listings due for review this month. Freeze the top row so headings stay visible. These small touches turn a plain table into a working instrument.

What to do with the results

After a quarter, sort by visits. You will probably see a few listings carrying most of the weight. Ask why. Is it the audience, the placement, the quality of your text? Apply what you learn to the others. If a listing has brought nothing and does not look likely to, retire it and note why. Retiring is housekeeping, not defeat.

Common mistakes

• Starting the sheet after you have submitted everywhere. You will miss some. Begin now and fill in what you remember.
• Too many columns. If it feels like a chore, trim it.
• No review date. The most important column for avoiding decay.
• Different product names in different places. Keep the master spelling.
• Passwords in the sheet. Never.
• Not recording rejections. The reason is information for next time.

On this site

The submit page is where you add an entry here, and once it is live the launches page shows how it appears to visitors. If you want to compare how other products describe themselves, the search page and categories page are good places to browse for ideas. The log you keep will make updating any of them quick.

A sample row, filled in

To see how it feels, imagine a single row for a made-up listing. Directory name: a regional small-business tools list. Category: scheduling. Date submitted: the third of March. Status: live. Live link: the public page. Tagged link: the product's home page with a source of "regionaltools" and a medium of "directory". Text version: B, the shorter description. Cost: free tier. Link type: nofollow, noted after checking the page source. Review date: the third of June. Notes: asked to resize the logo to a square, done on the sixth.

That one line tells a future you everything: what you sent, when, how, what you learned and when to look again. Multiply it by ten listings and you have a living map of your presence instead of a vague memory.

When the sheet outgrows itself

If you reach thirty or forty rows and several editors, consider moving to a simple shared database or project board, with one card per listing and the same statuses as columns. The principles do not change: one record per listing, consistent words, tagged links, review dates. Start with the humble sheet and move only when it hurts.

The short version

Keep one sheet with a few honest columns: where, when, status, live link, tagged link, text version, cost and review date. Store your master texts on a second tab, tag each directory's link, record how links are marked, update the row every time you act and review it every quarter. A captain's log, applied to listings, prevents most of the mess before it starts.