Automating affiliate reporting
Bright Analytics collects transaction-level data from your affiliate networks, applies your commission rules and refreshes historical orders every morning, so reporting reflects the latest available data.
For affiliate agencies and advertiser affiliate teams.
Affiliate reporting can get complicated.
Accurate affiliate reporting takes more than collecting yesterday’s orders. Commercial terms vary, and the status of the transactions you reported last month will still be changing.
Order status keeps changing
Pending orders can be accepted or rejected months later. Keeping reporting accurate means repeatedly refreshing historical transactions, not just adding new ones.
Custom commission rules
Rates differ by publisher, product and date, with time-limited offers and individual deals to account for. Each transaction needs the right terms applied.
Delayed bonus payments
Bonuses may only be confirmed once orders have been reconciled and approved. For performance reporting, that cost needs to be allocated back to the period it relates to.
How do we solve it?
Our marketing analytics platform brings affiliate transaction data, your commercial terms and reporting together. We configure the data collection and cost model around your programme, so changing order statuses, custom commissions and delayed bonuses are reflected in the reporting your team uses every day.
Collect data
Refresh historical transactions every morning
We run a rolling refresh over a lookback window agreed around your programme’s reconciliation timescales. This picks up changes to older orders as well as new transactions, keeping pending, approved and rejected statuses current within that window.
See affiliate integrations
Model data
Maintain your commission rules and commercial agreements
We provide an interface for uploading and maintaining publisher deals, product-level rates, time-limited offers and network overrides. These rules are applied to the transaction data using the relevant terms.
Bring the full affiliate cost into one reporting model
We combine commissions, bonus payments, network overrides and agency fees, as applicable to your programme. Bonuses are allocated to the periods they relate to.
Report and analyse
Inspect performance and understand the full cost
Your team can review affiliate performance and inspect each cost component in the reporting, without rebuilding the calculations for every report.
What changes for your team
Time back for managing your programme
Less time re-exporting orders, checking commission spreadsheets and rebuilding weekly reports. More time working with publishers and improving programme performance.
An up-to-date picture, every morning
Review reporting with the latest available order statuses, your agreed commission rules and bonuses allocated to the right periods. Daily reporting becomes part of the routine, without a daily reconciliation exercise.
A clearer view of performance and cost
See what is driving the total cost of your affiliate programme, from publisher commissions to network overrides and agency fees. Investigate the detail behind a change before deciding where to focus your budget and attention.
Questions
Which affiliate networks do you connect to?
We collect transaction-level data through affiliate network APIs. Tell us which networks you use and we’ll confirm the available integrations, fields and historical data access for your programme.
What data and access do you need to get started?
We need API access to your affiliate networks, transaction-level data including order statuses, and your applicable commission rates and commercial terms. These include publisher deals, bonuses, network overrides and agency fees where relevant. We’ll confirm the details with you during setup.
Can you calculate product-level commissions?
Yes, where the transaction data includes item-level purchase details. We use those details alongside your product-level rates and the dates each rate applies. We’ll check that the required fields are available from your networks before configuring the calculations.
How do you handle bonus payments that arrive after the period they relate to?
We allocate bonuses to the period they relate to in performance reporting. For example, a bonus paid in March for February’s activity is included in February’s costs rather than distorting March’s performance.
What is a rolling refresh, and how far back does it go?
A rolling refresh re-fetches historical transactions as well as new orders, so later approvals, rejections and other status changes appear in reporting. We agree the lookback window around your programme’s reconciliation timescales and the historical data available through each network’s API.
Can you help with commission reconciliation?
Yes. We can compare network-reported commissions with calculations based on your transaction data and agreed commercial terms, then flag discrepancies for investigation. The comparison depends on the detail available from your networks.
We already have a BI tool. Do we need to replace it?
No. Our Reporting API makes the modelled affiliate data available to your existing BI tools, so your team can use the same commission calculations and cost definitions outside Bright Analytics.
How long does it take to get set up?
The timing depends on network access, historical data availability and the complexity of your commission rules. We’ll review those details on the initial call and agree a setup plan, including the scope of a trial using your data.
Your data, ready for the way your team works
Managed data pipelines, a fully customised data model, and reporting built around your business. API and MCP connections let your teams work with the same data in their BI tools and AI assistants.