Intent labels
| # | Keyword | Volume | Intent | Deciding word |
|---|---|---|---|---|
| 1 | invoice software for freelancers | 1,300 | Commercial investigation | software |
| 2 | best invoicing app for freelancers | 480 | Commercial investigation | best |
| 3 | freelance invoice template | 2,900 | Transactional | template |
| 4 | free invoice template word | 1,600 | Transactional | template |
| 5 | how to invoice as a freelancer | 880 | Informational | how |
| 6 | how to write an invoice | 1,900 | Informational | how |
| 7 | what to include on an invoice | 590 | Informational | what |
| 8 | ledgerly login | 210 | Navigational | ledgerly |
| 9 | ledgerly pricing | 140 | Navigational | ledgerly |
| 10 | invoice app vs spreadsheet | 90 | Commercial investigation | vs |
| 11 | late payment reminder email | 720 | Informational | no modifier |
| 12 | how to ask for late payment | 390 | Informational | how |
Cluster table
Rule: cluster volume = sum of the member volumes listed in the row. Primary keyword = highest volume member. Ranked by cluster volume, highest first.
| Rank | Cluster | Intent | Primary keyword | Members (volume) | Cluster volume | KD range of members |
|---|---|---|---|---|---|---|
| 1 | Invoice templates | Transactional | freelance invoice template | freelance invoice template (2,900); free invoice template word (1,600) | 2,900 + 1,600 = 4,500 | 30 to 35 |
| 2 | Writing an invoice | Informational | how to write an invoice | how to write an invoice (1,900); what to include on an invoice (590) | 1,900 + 590 = 2,490 | 19 to 28 |
| 3 | Invoicing software | Commercial investigation | invoice software for freelancers | invoice software for freelancers (1,300); best invoicing app for freelancers (480); invoice app vs spreadsheet (90) | 1,300 + 480 + 90 = 1,870 | 15 to 42 |
| 4 | Late payments | Informational | late payment reminder email | late payment reminder email (720); how to ask for late payment (390) | 720 + 390 = 1,110 | 20 to 24 |
| 5 | Freelancer invoicing guide | Informational | how to invoice as a freelancer | how to invoice as a freelancer (880) | 880 | 22 |
Total volume across the 5 clusters = 4,500 + 2,490 + 1,870 + 1,110 + 880 = 10,850. All volumes are exact figures from your Semrush export; none is approximate.
Page mapping
| Cluster | Page | Status |
|---|---|---|
| Invoice templates | https://ledgerly.example/templates/invoice | Existing page, topic matches (free invoice template page). Add a Word download if the page does not already offer one, since "free invoice template word" names that format. |
| Writing an invoice | New page. Working title: "How to Write an Invoice: What to Include". Slug: /blog/how-to-write-an-invoice | New |
| Invoicing software | https://ledgerly.example/ | Existing page, topic matches (invoicing software) |
| Late payments | New page. Working title: "Late Payment Reminder Emails and How to Ask for Payment". Slug: /blog/late-payment-reminder-email | New |
| Freelancer invoicing guide | https://ledgerly.example/blog/how-to-invoice-as-a-freelancer | Existing page, topic matches |
Cannibalization check: no existing URL receives two clusters. One risk to watch: "Writing an invoice" (new page) and "Freelancer invoicing guide" (existing guide) are both informational invoicing topics. They are split here because one is general and one is freelancer specific, but this split is not SERP verified. If the top 10 results for "how to write an invoice" and "how to invoice as a freelancer" share 3 or more URLs, merge them into the existing guide instead of building a new page.
Unclustered or deferred keywords
| Keyword | Volume | Reason |
|---|---|---|
| ledgerly login | 210 | Navigational brand query. It belongs on a login page, which is not in your URL list, so it gets no content cluster. |
| ledgerly pricing | 140 | Navigational brand query. It belongs on a pricing page, which is not in your URL list. |
Method notes
- Volume source: Semrush, US, October 2026, as you stated.
- Grouping: lexical and intent grouping (shared core term plus same intent). Not SERP verified, because no SERP overlap data was supplied. Sending the top 10 ranking URLs per keyword would let me confirm or split the clusters.
- Max clusters: 6 allowed, 5 used. The two brand queries were left out because they are not content topics.
- Rows excluded from totals: none. Every row had a numeric volume.
- Difficulty is shown as given. I have not labeled any cluster "easy"; the lowest KD values are in Writing an invoice (19 to 28).
Needs your decision
- Approve the two new pages (/blog/how-to-write-an-invoice and /blog/late-payment-reminder-email) before they go on the content plan.
- Confirm whether a login page and a pricing page exist, so the brand queries can be mapped.
- Approve the table before I write it to any shared sheet.