• Home
  • Features  
  • Integrations
  • Pricing
  • Demo

Content analytics export does not match dashboard analytics

After exporting your transactions report from Affilimate, you might notice that your total commissions summed up in the Commission amount column don't match the total earnings being reported in the Affilimate dashboard.

This is because the Total earnings in your dashboard and on the Performance page inside Affilimate have already taken into account any negative commission values such as refunds, cancellations or disputes while the Transactions export includes raw transaction values.

What the numbers mean in the transactions export

In the Transactions export, there are no negative commission values reported because these are raw, individual transactions. Every transaction, whether it has been finalized or refunded, includes the value of the original commission amount as a positive number.

In this exported report, we are simply stating that a transaction occurred with a value of 1.43 (for example) whether you have been paid a 1.43 commission or your merchant has refunded 1.43 to the buyer, both of those are reported as a transaction of the amount 1.43.

This is where the Status column becomes important. In order to take these negative commission values into account and get a better snapshot of your earnings, you'll need to make some adjustments based on the status of the transaction.

To see a sum of commission amounts in the transaction export in a tool like Excel:

  • If the status column is Pending or Final, leave the amount as-is
  • If the status is Refunded, multiply the amount by -1
  • If the status is Canceled, treat as zero

We try our best to leave the original amounts visible for canceled transactions so you know the value of any lost revenue.

What the numbers mean in the content export

In the Content export, we have already combined data from different formats and sources, so you are seeing the end result of those calculations. Hence why the columns don't include raw numbers, but instead are formatted values in the account currency.

As a result, your Transactions export may appear to show higher earnings than what you see in the Content export or your Affilimate Dashboard because we have already automatically used the transaction statuses to subtract any refunded transactions from your Total earnings.

Have questions? Contact us at anytime.

Last Updated 4/22/2022

Related articles

  • Commission statuses

Try the affiliate analytics platform for content websites

Affilimate aggregates all your affiliate commissions in one place, and then adds the missing attribution data you need to maximize your affiliate revenue from every post you publish.

Create your dashboard   Book a demo

 Free 15-day trial   No credit card required

Affilimate Analytics App

Hey, I'm Monica.

I'm the co-founder of Affilimate.

Once per month, I send insider tips and strategies for affiliates in this newsletter.

It's short, practical, and original. Try it out:

No spam, unsubscribe anytime.

AffilimateBy Adaero Software