Programming Notes:

The periods are the 1st - 15th, and 16th - end of month

In the Period Pull Down Menu, I have "All Time". Just make the start Date be the first day they sent any Clicks.

No matter how many rows there are, show them on one page with the totals at the bottom.

Make the "Select by Period" and "Filter by Keyrword" Pull Down menu go to the stats when you select the period, without having to hit a "Go" button. Just on a mouse out type of function.

For the Date Range, use popup calendars like you see on http://www.orbitz.com/ ... You can copy that format in the popup menu how they use the different colors and mouseovers and highlight the day selected.

Next to "Filter by Keyword" I put a ?. You can use the red graphical ones found on the custom keyword pages. For the popup use this text:

"If you want to track your traffic from different sources, you can use the Custom Keyword Links. This allows you to better analyze your marketing efforts. If you don't have any setup yet, you need to set them up here first"

You shown us a table with the following fields (in backets I show where we are going to take the values):

Date                 (each date in selected period)

Clicks               (field hits_in from idevaff_affiliates and idevaff_iptracking tables)

Sales               (field sales from idevaff_affiliates)

Conv. Ratio       (field conv from idevaff_affiliates)

Refunds / CB    (unknown)

Revenue          (field payment from idevaff_affiliates)

Keyword: (field split from idevaff_affiliates) - If and when an affiliate uses a keyword to track their sales, it shows up in column Split

The best affilaite to test with is 2610. he uses the keywords so you can see those working in his stats.