Guide for affiliate

Export Data and KPIs to Measure Affiliates’ Performance

As a marketer, you absolutely want your marketing campaign will bring benefits to your business. In other words, you do not want to see your investment go down without any positive returns. And to make sure that, you have to do some analysis and calculations.

When it comes to an affiliate marketing campaign, the performance of your associates is an important factor that decides whether your campaign will succeed or not. But how can you evaluate the performance of your partners?

The answer is KPIs (key performance indicators). KPIs are essential in determining the performance of an affiliate. Because if you have a good KPI portfolio, you can analyze the efficiency of your team, then you will have a better adjustment to your marketing campaign.

With Affiliate marketing by Secomapp, we provide you with all the necessary data related to your affiliates’ performance. And this blog will show you how to export data and which KPIs that you can apply for.

1. Export Data to Excel

The Affiliate Marketing app by Secomapp shows you all the data about the number of clicks, orders, revenues, and commissions of your affiliates. Plus, our software also allows you to export these numbers to CVS, Excel or PDF files. The export feature is supported in 5 sections, including “Dashboard”, “Program”, “Affiliate and Coupon”, “Referral” and “Payments”. However, in this blog, we will focus on the data from your main dashboard.

In the main dashboard of the app, when you scroll down, there are the statistics about the earnings of your affiliates. With the purpose to make it easier for users to see, the app shows the data in both types of tables and graphs. At the bottom of the page, you can see the option to export data to Excel. If you click on the “Excel” button, the file will be automatically and immediately downloaded.

Some of you may wonder why we have to waste time to export to Excel instead of using some analytics tools such as Google Analytics? Because only our application can track and give out the above information about your affiliates, while other tools can not. Besides, other analytics tools limit you to customize the metrics, especially, in this case, when you want to calculate some KPIs. Therefore, Excel is a good choice.

In conjunction with Excel, you also can upload the file to Google Drive and use Google Sheet, which has similar functions with Excel. Using Google Sheet allows you to work online with your team, which will be convenient for you.

2. Affiliate Marketing Metrics and KPIs

After you open the downloaded Excel file, you will see there are six columns corresponding with six variants. For example, the table below is the data exported from the app.

From these above numbers, there are three main KPIs, which you can calculate. That will help you to have a look at the performances of each affiliate.

Total Revenue by Affiliate

This KPI is the most simple one because the data from the app already shows this number. From the table above, you can see that Hermione was the one that brought the highest revenue, while Ludo brought the lowest one. The total revenues partly show the performances of affiliates, but it’s not enough. You have to put all of these numbers on the over-time trend, which can be week over week (WoW) or month over month (MoM).

The weak of other analytic tools, as well as the app, is that we can not see actual WoW or MoM numbers for each affiliate. But with Excel, all you need to do is doing a simple “copy and paste” the data into an Excel spreadsheet. Then, you can easily visualize the WoW and MoM sales like the image below.

To visualize the information in Excel, you click on the “Insert” section in the toolbar, there will be a bunch of graph types for you to choose. And in this case, the line chart will be an ideal option.

Just need a glance at the graph, you can see that there are some problems with Hermione. Trending over time allows you to see the whole picture of your affiliates. Recognizing the peaks and valleys of your partners and then you can have some adjustments in a timely manner.

AOV – Average Order Value

The Average Order Value is a great indicator to evaluate both customer behavior and the efficiency of your affiliates. Since we’re already looking at revenue, this ratio of revenue-to-orders works as a barometer of how well your affiliate marketing is working.

In order to calculate this KPI, you just need to divide revenue by the number of orders. In the Excel file that exported from the app, there are revenue and the number of orders. Therefore, if we take the value of the cells of column D divided by the corresponding cell of column C, then we get the average values of each affiliate.

You also can calculate the average order value of your overall site performance. After having the AoV of your site, you can compare it to your affiliate partners to determine how they are performing compared to others. If it’s much higher, they may be doing a better job of upselling. If it’s lower, you may have some special offers so they can help drive higher sales, for example, free shipping if the shopper hits a certain spend threshold.

EPC – Earnings Per Click

The final one is Earning Per Click, which is considered as the king of all metrics in affiliate marketing. This KPI allows you to understand the earning potential of your affiliates. Below is the calculation:

($CommissionsEarned ÷ Total Clicks) x 100 = EPC

Similar to the AoV, you just need to apply the calculation to the Excel files, then you will get the results as the image below.

Look at the results, you can see that though Hermione generated more sales, Susan has a higher EPC, which means Susan is overall more efficient than Hermione. This indicator gives you a clue one which affiliates are performing well.

In addition, you can set for your affiliate marketing campaign an EPC threshold. Then, for those who have the number above this threshold, you can reward them or consider increasing their commission as an incentive for them to bring more revenue. And for those who are under the set threshold, you should help them to optimize their methods to increase their EPC.

These above 3 KPIs that you can calculate base on the data from the app will help you have better affiliate marketing success. Also, it allows you to make use of the money that you have spent on the app.

In fact, there are many other metrics that you can use to evaluate the performance of your affiliates as well as the success of your marketing campaign. But these 3 KPIs match with Secomapp Affiliate Marketing app the most. They also are the 3 metrics that best show the efficiency of affiliates. If you have other metrics that would be useful for affiliate marketing campaigns, let share with us!