Affiliate Tracking Template

Track affiliate partners, the orders they drive, and the commission owed and paid to each.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Marketing

Tables

Affiliates, Sales

Fields

22

Views

grid, kanban, dashboard, calendar

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Affiliates

12 fields · 5 sample rows

  • Affiliates (Grid)
  • By status (Kanban)
  • Programme overview (Dashboard)
AffiliateTextContact EmailEmailWebsiteURLPlatformSingle selectCommission RatePercentStatusSingle selectJoined OnDateSalesLink to another tableOrdersCountRevenueRollupCommission EarnedRollupCommission UnpaidRollup
TechGuru Reviews[email protected]https://techguru.example.comBlog8.0%Active3 May 2026ORD-10421, ORD-105022₹70,998₹5,680₹3,680
Fit with Ritu[email protected]https://instagram.com/fitwithrituInstagram12.0%Active16 Aug 2026ORD-10457, ORD-104892₹9,498₹1,140₹1,140
DealDuniya[email protected]https://dealduniya.example.comCoupon site5.0%Active13 Jan 2026ORD-10466, ORD-105302₹10,998₹550₹100
The Morning Brief[email protected]https://morningbrief.example.comNewsletter10.0%Pending approval15 Nov 20260₹0₹0₹0
GadgetLab with Sam[email protected]https://youtube.com/@gadgetlabYouTube10.0%Paused22 Jun 2026ORD-105111₹12,999₹1,300₹0
Field details
Affiliate · Text
Contact Email · Email
Website · URL
Platform · Single select
Blog, YouTube, Instagram, Newsletter, Coupon site, Podcast
Commission Rate · Percent
Status · Single select
Active, Pending approval, Paused, Terminated
Joined On · Date
Sales · Link to another table
Links to Sales
Orders · Count
Revenue · Rollup
sum of Sale Amount via Sales
Commission Earned · Rollup
sum of Commission via Sales
Commission Unpaid · Rollup
sum of Unpaid Commission via Sales

Sales

10 fields · 7 sample rows

  • All sales (Grid)
  • Payouts (Kanban)
  • Order calendar (Calendar)
Order IDTextAffiliateLink to another tableOrder DateDateCoupon CodeTextSale AmountCurrencyRateRollupCommissionFormulaPayout StatusSingle selectUnpaid CommissionFormulaPaid OnDate
ORD-10421TechGuru Reviews25 Oct 2026TECHGURU10₹24,9998.0%₹2,000Paid₹014 Nov 2026
ORD-10457Fit with Ritu1 Nov 2026RITU15₹3,49912.0%₹420Approved₹420
ORD-10466DealDuniya4 Nov 2026DD5₹8,9995.0%₹450Paid₹014 Nov 2026
ORD-10489Fit with Ritu10 Nov 2026RITU15₹5,99912.0%₹720Pending₹720
ORD-10502TechGuru Reviews13 Nov 2026TECHGURU10₹45,9998.0%₹3,680Pending₹3,680
ORD-10511GadgetLab with Sam10 Oct 2026₹12,99910.0%₹1,300Reversed₹0
ORD-10530DealDuniya17 Nov 2026DD5₹1,9995.0%₹100Pending₹100
Field details
Order ID · Text
Affiliate · Link to another table
Links to Affiliates
Order Date · Date
Coupon Code · Text
Sale Amount · Currency
INR
Rate · Rollup
max of Commission Rate via Affiliate
Commission · Formula
ROUND({Sale Amount} * {Rate}, 0)
Payout Status · Single select
Pending, Approved, Paid, Reversed
Unpaid Commission · Formula
IF(OR({Payout Status} = 'Paid', {Payout Status} = 'Reversed'), 0, {Commission})
Paid On · Date

Affiliate Tracking Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates