Affiliate Traffic Management
- Hunter Schaeffer
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 | Return | Net | Conversion % | Aff. Earnings | Aff. Earnings | Commissionable | Net | Gross | Refunded | Net Payable | S/H | S/H (Refunded) | Gross Sales | Gross Refunds | Net Sales | Company |
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 | Return | Net | Conversion % | Aff. Earnings | Aff. Earnings | Commissionable | Net | Gross | Refunded | Net Payable | S/H | S/H (Refunded) | Gross Sales | Gross Refunds | Net Sales | Company |
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 | Return | Net | Conversion % | Aff. Earnings | Aff. Earnings | Commissionable | Net | Gross | Refunded | Net Payable | S/H | S/H (Refunded) | Gross Sales | Gross Refunds | Net Sales | Company |
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.