Clicks show curiosity; approved commissions show which pages actually earn.
A review page can send 400 visitors to a merchant and still produce nothing that survives the affiliate approval window. Meanwhile, an older comparison page with far less traffic may quietly generate the commissions that matter.
That gap is easy to miss when reporting stops at outbound clicks. Clicks indicate interest, but they do not reveal whether a visitor bought, whether the sale was attributed, or whether it was later reversed. Traffic can look impressive for the same reason: it measures attention, not value.
Page-level approved revenue turns each article, guide, or comparison into something that can be judged on evidence. It exposes pages worth refreshing, protecting, and linking to internally—and pages whose strong click totals are not translating into earnings. Until commissions are connected back to the page that initiated them, content priorities are largely an educated guess.
Give each commission a page-level home
Approved revenue
The strongest outcome measure: commission that has cleared the network’s approval process, assigned to the page that sent the click.
Affiliate clicks
A useful traffic signal, but not proof of earnings. A page can generate many outbound clicks and still attract poor-fit shoppers.
Conversion rate
Approved orders or commissions divided by affiliate clicks. It helps separate a persuasive, well-matched page from one that simply gets attention.
EPC
Earnings per click: approved commission divided by affiliate clicks. It combines volume and quality into a practical comparison between pages.
Some networks report a transaction ID, click ID, sub-ID, landing URL, or campaign field that can be matched back to a page. Others provide only total commissions by merchant or period.
When a direct match is unavailable, use a consistent proxy—such as a unique sub-ID per page or a page-specific tracking link—and label the result accordingly. Do not treat recent clicks as final revenue: returns, cancellations, and approval delays can change totals days or weeks later.
A sensible routine compares pages only after the network’s usual approval window has passed. Until then, clicks and pending commissions are directional signals, not settled results.
Build the link inventory first
Before comparing earnings, create one row for every monetized page–merchant combination. A page that links to the same retailer in a product card and a closing recommendation may need two rows if the placements use different tracking links.
Useful columns include:
- Page URL and page title
- Merchant, affiliate program, and network
- Destination URL, tracking ID, and any sub-ID
- Placement: inline mention, comparison table, button, sidebar, or sitewide template
- Link status: live, redirected, replaced, or removed
Record the context, not just the URL. A “Buy” button beside a named product has a different intent from a generic footer link. Placement decisions can later be checked against guidance on where affiliate links fit naturally.
Flag complications early: shared merchants across many pages, duplicate destinations, shortened or network redirects, and links inserted by templates. Otherwise, one merchant’s total can be mistaken for one page’s result.
Mark navigation, sidebar, and footer links as template placements. Their clicks may reflect site structure more than the page’s content.
Use page IDs that survive edits
A SubID should identify the content page and meaningful placement, not every small wording change. A stable article slug such as best-budget-tripods remains useful after a headline refresh, new paragraph, or button-color test. Avoid dates, revision numbers, and vague labels like blog1; they turn ordinary maintenance into fragmented reporting.
Use a consistent, readable SubID convention, for example page--merchant--placement. Keep it short enough to recognize in a network export, using lowercase letters, hyphens, and a fixed separator. Create a new ID only when the reader intent or commercial context materially changes: a new campaign landing page, a separate comparison table, or a distinct email promotion.
A workable example
| Item | Value |
|---|---|
| Page URL | site.com/guides/best-budget-tripods/ |
| SubID | budget-tripods--acme--top-pick |
| Program link | https://merchant.example/?aff=123&subid=budget-tripods--acme--top-pick |
If the same merchant also appears in a mid-article comparison, use budget-tripods--acme--comparison. Both commissions still roll up to one page, while the placement detail explains why one link performed better. Record the final URL and SubID together in the link inventory so replacements do not quietly break the trail.
When a link stays in the same role on the same page, retain its SubID. Changing it creates an artificial before-and-after split.
Tag, test, and record each affiliate URL
-
Start with the merchant-approved destination
Copy the URL supplied by the affiliate network or merchant. Keep its required tracking ID, campaign code, and any existing query parameters intact.
-
Find the network’s supported tagging method
Use the network’s documentation or affiliate manager to identify the allowed field for a page or placement ID. It may be a sub-ID, click reference, custom parameter, or a tool-generated link—not a universal
subidparameter. -
Add the stable ID without overwriting existing data
Insert the page–merchant–placement ID in the approved field only. URL-encode spaces or special characters if required, and avoid adding a second question mark or deleting the original affiliate identifier.
-
Test the exact published link
Open it in a private browser window or after clearing relevant cookies. Confirm that it reaches the intended product or landing page; a test click is not proof that a commission will be credited.
-
Document the deployed version
Record the final on-page URL, its page ID, placement, merchant, date added, and where the network reports the identifier. Save the live URL rather than only the link-builder input.
-
Check the redirect chain preserves the tag
Follow the link through its redirect, including any site-level redirect or link-shortening tool. In the network dashboard or click report, verify that the identifier appears after a test click.
A redirect may deliver visitors to the right merchant page while stripping the page-level identifier along the way. Check after changes to link plugins, cloaking tools, consent banners, or merchant URLs. If the network does not expose sub-ID data in reports, record that limitation before relying on page-level revenue comparisons.
Maintain a transaction-ledger routine
Affiliate-network transaction reports should be treated as the revenue record. Analytics can explain traffic and outbound-click changes, but it cannot confirm whether a commission was tracked, reversed, or approved.
On a regular cadence—weekly is usually manageable—export each network’s transaction report into a spreadsheet. Keep the raw export on its own tab, then use a lookup to match the reported SubID (or equivalent tracking field) to the page–merchant–placement inventory. A simple XLOOKUP can return the originating URL, page title, and link context without retyping them.
Retain enough detail to make a surprising total explainable:
- transaction and approval dates
- merchant, order value, commission, and currency
- status: pending, approved, declined, or reversed
- SubID, page URL, placement, and tracking ID
- network and export date
Keep pending and approved amounts separate. A page may look successful this month only because its commissions have not yet been reversed; comparing approved revenue with prior periods avoids that false signal.
For interpretation, add analytics sessions and outbound clicks beside the matched page totals, rather than mixing them into the commission data. That division fits a broader affiliate revenue analytics framework: transactions establish earnings, while traffic and clicks help explain why earnings moved.
A small, consistent workbook is more useful than an elaborate dashboard that is updated only occasionally.
Save each unedited network export with its date. It provides a check when statuses or payout totals change later.
Add new SubIDs to the inventory before importing the next batch, and flag unmatched IDs instead of guessing their source.
Sort by approved commission and compare against clicks or sessions only after the page totals are reliable.
Compare pages on earnings and efficiency
A page’s approved commission is its clearest contribution: add the approved amounts assigned to that page for the selected period. This answers, “Which pages produced the most settled revenue?” It is the best starting point for decisions about updates, promotion, or further content.
Total earnings alone can favor pages with far more traffic. Pair them with two efficiency measures:
- Conversion rate = approved transactions ÷ affiliate clicks × 100
- EPC = approved commission ÷ affiliate clicks
For example, a page earning $40 from 20 clicks has a $2 EPC; a page earning $90 from 180 clicks has a $0.50 EPC. The second page currently brings in more money, while the first is more efficient and may deserve additional exposure. A simple spreadsheet makes it easy to calculate affiliate EPC for each page beside total approved earnings.
Wait for the numbers to mature
Fresh results are not final. A sale can remain pending, be reversed after a return or cancellation, or arrive in reporting days after the click. Compare pages over the same date range and, where possible, wait until the network’s usual approval or reversal window has passed.
Treat tiny samples carefully. One $60 commission can make a five-click page look exceptional, just as a handful of clicks can make conversion rate swing wildly. Mark pages with fewer than roughly 20–30 clicks as early evidence, then revisit them after more traffic and approvals accumulate.
Approved earnings identify current revenue leaders. EPC and conversion rate reveal whether those results came from efficient clicks or simply higher volume.
Turn the report into one useful monthly change
-
Refresh the settled period
At month-end, re-export the prior period and replace pending figures with approved or reversed amounts. Using the same cutoff date each month keeps rankings comparable.
-
Spot-check live identifiers
Open a handful of affiliate links from important pages. Confirm that redirects work and that the expected page or placement tag still appears in network reporting.
-
Rank contribution before rates
Sort pages by approved revenue first, then inspect EPC and conversion rate for context. A high rate on two clicks is less actionable than steady earnings from a page with meaningful traffic.
-
Choose one evidence-backed edit
Improve a strong page with a clearer link placement, or investigate a high-click page that produces few approved sales. Change one element so the next report has a fair comparison.
-
Keep thin results in view
A short-lived page or a low-volume result is not a deletion signal. Leave it in the ledger and revisit it after more traffic or a longer settled window.
Let settled revenue guide the next move
- Use approved commissions to choose priorities; use clicks and rates to diagnose them.
- Treat low-volume pages as incomplete evidence, not failures.
A monthly refresh, a few tag checks, and one measured edit can keep page-level affiliate tracking practical. The goal is not constant tinkering; it is building a record that makes the next decision less speculative.
A spreadsheet remains workable for a modest set of pages and programs. When several networks, many placement tags, and repeated manual matching make the review slow, it may be time to consider dashboard software for page-level tracking.
