Affiliate Traffic Management

About

The Affiliate system reporting tab contains a “Traffic Analysis” report. This report provides a breakdown regarding the affiliate activity for the reporting period.

Generating The Traffic Report

NAVIGATE:
Main Menu → Advanced → Affiliate Management → Reports (Tab) → Traffic Analysis Report

 

The report requires a Begin Date and End Date. Enter the date range then click submit. The generated report will be available in the report pickup location.

NAVIGATE:
Main Menu → Operations → Reporting → Report Pickup

 

The generated report contains the following worksheets and column data:

The first worksheet is the Summary.
The Summary worksheet contains the following columns:

Date

Sub Id

Affiliate ID

Affiliate Company Name

Click Count

Gross
Order Count

Return
Order Count

Net
Order Count

Conversion %

Aff. Earnings
Per Click

Aff. Earnings
Per Sale

Commissionable
Affiliate
Upsell Units

Net
Upsell Units

Gross
Commissions

Refunded
Commissions

Net Payable
Commissions

S/H

S/H (Refunded)

Gross Sales

Gross Refunds

Net Sales

Company
Net Profit

 

The next worksheet in the report is All Affiliates.
The All Affiliates worksheet contains the following columns:

Date

Affiliate ID

Affiliate Company Name

Click Count

Gross
Order Count

Return
Order Count

Net
Order Count

Conversion %

Aff. Earnings
Per Click

Aff. Earnings
Per Sale

Commissionable
Affiliate
Upsell Units

Net
Upsell Units

Gross
Commissions

Refunded
Commissions

Net Payable
Commissions

S/H

S/H (Refunded)

Gross Sales

Gross Refunds

Net Sales

Company
Net Profit

 

The next worksheet in the report is All Affiliates Sub Id.
The All Affiliates Sub Id worksheet contains the following columns:

Date

Affiliate ID

Affiliate Company Name

Click Count

Gross
Order Count

Return
Order Count

Net
Order Count

Conversion %

Aff. Earnings
Per Click

Aff. Earnings
Per Sale

Commissionable
Affiliate
Upsell Units

Net
Upsell Units

Gross
Commissions

Refunded
Commissions

Net Payable
Commissions

S/H

S/H (Refunded)

Gross Sales

Gross Refunds

Net Sales

Company
Net Profit

 

The remaining worksheets will be related to each affiliates with activity during the reporting periods. There will be one for the Affiliate Activity and another one for Affiliate Sub Id’s Activity, if Sub Id’s were configured.

Example Spreadsheet

Frequently Asked Questions

Question: Does "Net Order Count" means customers or amount of products + upsells sold in the affiliate report?

Answer: The “Net Order Count” are approved, non refunded orders, attributed to the affiliate.