An affiliate reporting dashboard is a single view that combines your traffic data (sessions and affiliate clicks per page or campaign) with your earnings data (conversions and commission from each network), so you can see earnings per click, conversion rate and revenue by page, program and traffic source. You can build a useful one in a spreadsheet in an afternoon, or in Google's free Data Studio (renamed from Looker Studio in April 2026) if you want automatic refreshes and charts.

The hard part is not the charts. It is choosing a short list of KPIs, getting clean data from each source and joining it on a shared key. This guide walks through all three.

The KPIs worth putting on an affiliate KPI dashboard

A dashboard with forty metrics gets ignored. Start with these, and add more only when you have a decision that needs them.

KPIFormulaWhat it tells you
SessionsFrom analyticsHow much attention a page or campaign gets
Affiliate click-through rateAffiliate clicks ÷ sessionsHow well a page moves readers to offers
Conversion rateConversions ÷ affiliate clicksHow well the offer and audience match
Earnings per click (EPC)Commission ÷ affiliate clicksThe value of a click, comparable across programs
Revenue per 1,000 sessionsCommission ÷ sessions × 1,000Page value, comparable with display ads
Approval rateApproved ÷ total conversionsLead or sale quality, and possible reversals
Profit and ROI (paid traffic)Commission − spend; profit ÷ spendWhether a campaign is worth scaling

If you need a refresher on the maths, see our guide to calculating EPC. For RevShare programs, add a column for recurring revenue from earlier months, otherwise you will undervalue pages that send long-lasting customers.

The data sources to combine

Most affiliate dashboards pull from three types of source:

  1. Web analytics (GA4, Matomo, Plausible and so on): sessions, landing pages, traffic sources and affiliate click events. If you have not set up click tracking yet, follow our guide to tracking affiliate clicks in GA4.
  2. Affiliate networks and programs: clicks, conversions, commission and status, ideally broken down by sub-ID.
  3. Costs: ad spend from traffic sources, plus fixed costs such as content and hosting if you want true profit.

If you run paid campaigns through a tracker, the tracker already joins spend, clicks and conversions for you; your dashboard then only needs tracker data plus any SEO or content traffic.

The join key: why sub-IDs make or break your dashboard

Networks report earnings; analytics reports pages. To put them side by side you need a value that appears in both. That value is the sub-ID (also called a click reference, SID or sub1, depending on the network).

A practical sub-ID scheme for content sites is page-slug, optionally followed by a position code, such as best-cam-sites_table. For paid traffic, pass the tracker's click ID instead, so each conversion can be matched to a single click. Our guide to sub-IDs covers naming rules and character limits.

Keep it consistent. Use lowercase, no spaces and the same slug format in every network. A dashboard is only as good as its messiest sub-ID: one network receiving "Best Cam Sites" and another "best-cam-sites" means two rows for the same page.

Build version one: an affiliate reporting template in a spreadsheet

A spreadsheet is the right starting point for most publishers. It is free, flexible and easy to check by hand.

Step 1: Create a raw data tab per source

Make one tab for analytics and one per network. Paste or import exports in their original columns: date, sub-ID or page, clicks, conversions, commission, currency and status. Do not edit raw tabs by hand; fix problems in formulas instead.

Step 2: Add a lookup tab

Build a small table mapping each sub-ID to a page, a program, a network and a niche or category. This is where you translate network-specific codes into your own labels.

Step 3: Normalise currencies

If networks pay in euros, dollars and pounds, convert to one reporting currency. Use a monthly average rate stored in its own tab, so figures do not move each time you open the file. Your accountant will want the actual amounts received, which is a separate record (see tracking earnings across multiple networks).

Step 4: Build the summary

Use a pivot table, or SUMIFS formulas, to total clicks, conversions and commission by page and month, then add calculated columns for click-through rate, conversion rate and EPC. Sort by commission, then by EPC, to see which pages earn and which have potential.

Step 5: Add conditional formatting

Highlight month-on-month falls of more than a threshold you choose (for example 25%) in clicks, approval rate or EPC. These are the rows worth investigating each week.

Build version two: a Data Studio (Looker Studio) affiliate dashboard

When updating the spreadsheet becomes a chore, move the reporting layer into Google's free dashboard tool. Google renamed Looker Studio back to Data Studio in April 2026; existing reports and data sources carried over, so tutorials that mention Looker Studio still apply.

  1. Connect your sources. Use the native GA4 connector for analytics and the Google Sheets connector for your network data tab. Many third-party connectors exist for networks and ad platforms, usually paid.
  2. Blend the data. Create a blended data source joining GA4 (landing page or a custom dimension holding your sub-ID) with the Sheets data on the sub-ID or page path. Check the join type: a left join from your earnings data keeps pages with conversions but no recorded sessions.
  3. Create calculated fields for EPC, conversion rate and revenue per 1,000 sessions. Calculate ratios from the summed values, not by averaging row-level ratios.
  4. Lay out three sections: a top row of scorecards (commission, clicks, EPC, approval rate, each against the previous period), a time-series chart of commission by network, and a table of pages ranked by commission with EPC and conversion rate.
  5. Add filters for date range, network, program and country.
  6. Schedule delivery: send a PDF of the report to yourself or your team each Monday.

Blends in Data Studio can be slow and fussy with large datasets. If you outgrow them, push everything into a single Google Sheet or a database first and connect the dashboard to that one table.

What a good affiliate performance report looks like

A useful report answers three questions in under a minute: are we up or down, why, and what should we do this week? A layout that works:

  • Headline: this period's commission, change versus last period and versus the same period last year.
  • Drivers: the five pages or campaigns that gained most and the five that lost most, with sessions, clicks and EPC side by side.
  • Quality: approval rate and reversals by network, so a sudden drop stands out.
  • Actions: two or three notes, such as "update the comparison table on page X" or "pause zone Y".

Hypothetical example: commission is down 12% month on month. The drivers table shows one review page lost 40% of its sessions after a ranking drop, while its EPC is unchanged. The fix is SEO, not a new offer. Without sessions and EPC side by side, you might have switched programs for no reason.

Common dashboard mistakes

  • Mixing dates. Networks often report by conversion date, analytics by session date. Decide which you use and label it.
  • Counting pending as earned. Show pending and approved commission separately.
  • Expecting clicks to match. Network clicks and analytics clicks will differ. Use one source for EPC consistently.
  • Too many charts. If nobody acts on a chart, remove it.

Next steps

Start with the spreadsheet and the seven KPIs above, and move to Data Studio once you are updating it weekly. If you would rather buy than build, compare reporting and aggregation tools in our webmaster software and services directory, and for a beginner's view of the network side, read how to read your affiliate dashboard.