Home Our Services More Info About Us

Instructions

 

Our services

More Info

About Us

 

Instructions for Merchants Selections sheet

 

Select "Enable Macros" option, if the promt will appear during the initialization stage.

1. Fill the first four columns with data:

    1st column -Merchants with similar products/services. For example, for a one category (books, software,...).

    2nd column -Type of payment in the Merchant's affiliate program.

1=$/click          Merchant pays fixed amount per each click on the link to the Merchant site from the affiliate's site
2=% of sale      Merchant pays % from each sale to a customer, which an affiliate referres. 
3=$ per order   Merchant pays fixed amount per each order of a customer, which an affiliate referres. 

    3rd column -Amount of payment from the affiliate program.

    4th column -Conversion ratios (Share of buyers from all visitors to the site/page). This data may be obtained as from the Merchants as from independent sources, for example,  PC Data Online.

2. In the 7th column, on the right from "Average order" put the amount of average order/sale expected for this group of products/services.

3. Deactivate "Sheet1" (Click on "Sheet2")

4. Activate "Sheet1" (Click on "Sheet1")

As result of these actions the profit potentials of the Merchants will be calculated (and sorted) in the 5th column-"Profitability". This value shows how much each visitor, you will refer to the merchant site, is worth (generates income for you).

 

Merchants Type Payments Conversion Ratios Profitability Category Books
Amazon 2 0.15 0.1 0.30  
MarthaStewart 1 0.25 0.02 0.25 Average order 20
AudioBookClub 3 5 0.02 0.10
Fatbrain 2 0.20 0.02 0.08
Varsitybooks 1 0.05 0.02 0.05
ElephantBooks 2 0.125 0.02 0.05
Alibris 2 0.1 0.02 0.04
hoolooo.com 2 0.10 0.02 0.04
Borders 2 0.07 0.02 0.03
Maps 2 0.07 0.02 0.03
Booksamillion 2 0.06 0.02 0.02
DealNetworks 3 1 0.02 0.02
allbooks4less.com 2 0.05 0.02 0.02
Amazon 2 0.05 0.02 0.02
BigWords 2 0.05 0.02 0.02
BN 2 0.05 0.02 0.02
Borders 2 0.05 0.02 0.02
MarthaStewart 2 0.05 0.02 0.02
Photoeye 2 0.05 0.02 0.02
 

 

Copyright © 2001 Apfa Group
Last modified: March 09, 2001