Ancestry.com Affiliate Program Updates

Thursday, January 12, 2006

Change in Comp Structure plus a Reminder

We've decided to set the 'Subscription' Merchandise Type to a flat 35%, and remove tiers involved in it.

Also, we will be evaluating the compensation amounts on a quarterly basis to ensure that affiliates are being paid the appropriate value for each product. The first evaluation will be in February, and we will be looking at the lifetime values of the products sold through the affiliate program.

One thing to remember about this change: The reason WHY we changed the structure is because of the internal accounting system not being able to attribute cancels due to package migration to the appropriate source. This also meant that when a user upgraded, we couldn't credit the referring affiliate with the sale. In order to avoid affiliates being incorrectly charged back for users changing their packages, we decided to start paying on the LifeTime Value (LTV) of the product.

What does all this gobbledy-gook mean? Basically, it means that we increased the commission percentages because we knew that the sales credited to affiliates would decrease.

We've been getting a lot of questions about decreases in sales year over year and month over month. Please do not focus on sales dollars and quantity changes from before December 8 versus afterward. If you want to compare performance, look at compensation FIRST.

Let us know if you have any questions - affiliate@ancestry.com or 801-705-7850.

Wednesday, January 11, 2006

Reporting Issues Resolutions

Over the last several weeks, we have been experiencing reporting glitches and difficulties. As you will see, there is also some to-be-resolved issues that we're trying to make happen ASAP. The following is the status/solution for each day of reporting from December 1 to present.

December 1 - 7:
Daily BeFree batch correctly uploaded, numbers verified, matches internal reporting
Status: NO ACTION NECESSARY
Accuracy: All Revenue stats are accurate for these days

December 8 - 11:
Launch of New Pricing and Packaging
Daily BeFree batch included small % of erroneous sales due to migrating old customers to the new packaging
Daily BeFree batch included small % of erroneous cancels due to migration
Fix File to correct erroneous cancels sent and uploaded on December 16
Fix File to correct erroneous sales sent and uploaded on December 21
Status: RESOLVED
Accuracy: Only NET SHIPPED SALES are accurate for these days (NOT cancels, orders or gross)

December 12 - 14:
Daily BeFree batch included small % of erroneous sales due to migrating old customers to the new packaging
Fix File to correct erroneous sales sent and uploaded on December 21
Status: RESOLVED
Accuracy: Only NET SHIPPED SALES are accurate for these days (NOT cancels, orders or gross)

December 15:
Daily BeFree batch includes correct number of products
Daily BeFree batch includes duplicate subscriptions and cancels (exact duplication - divide by 2 for accurate number)
Status: RESOLVED; fix file sent 1/7
Accuracy: Only NET SHIPPED SALES are accurate for these days (NOT cancels, orders or gross).

December 16:
Daily BeFree batch ONLY includes products, no subscriptions or cancels
Status: RESOLVED; fix file sent 1/6
Accuracy: ALL revenue stats will be accurate for this day.

December 17 - 22:
Daily BeFree batch correctly uploaded, numbers verified, matches internal reporting
Status: NO ACTION NECESSARY
Accuracy: All Revenue stats are accurate for these days

December 23 - 25:
New pricing/packaging free trialers scheduled to bill. Error in accounting system delays billing over holidays. Because of this, NO free trials bill.
Daily BeFree batch correctly uploaded, numbers verified, matches internal reporting
Status: RESOLVED; all free trials billed on 1/7
Accuracy: All Revenue stats are accurate for hard offers and free trial sign-ups ONLY, however, reporting will NOT change retroactively for these days. Billed Free Trials are attributed to January 7th.

December 26:
Daily BeFree batch includes correct number of products
Daily BeFree batch includes duplicate subscriptions and cancels (exact duplication - divide by 2 for accurate number)
Free trialers not billing through
Status: RESOLVED; fix file sent 1/7
Accuracy: Only NET SHIPPED SALES will be accurate for these days (NOT cancels, orders or gross), with the following exceptions:
Will not include billed free trials. Cancel rate will NOT be accurate.

December 27:
Daily BeFree batch ONLY includes products, no subscriptions or cancels
Free trialers not billing through
Status: RESOLVED; fix file sent 1/7
Accuracy: All revenue stats will be accurate for this day, with the following exceptions:
Will not include billed free trials. Cancel rate will NOT be accurate.

December 28 - January 1:
Daily BeFree batch correctly uploaded, numbers verified, matches internal reporting
Free trialers not billing through
Status: NO ACTION NECESSARY (except Free Trial fix)
Accuracy: All Revenue stats are accurate for hard offers and free trial sign-ups ONLY. Cancel rate will NOT be accurate.

January 2:
Daily BeFree batch includes correct number of products
Daily BeFree batch includes triplicate subscriptions and cancels (exact triplication - divide by 3 for accurate number)
Free trialers not billing through
Status: RESOLVED; fix file sent 1/7
Accuracy: Only NET SHIPPED SALES will be accurate for these days (NOT cancels, orders or gross), with the following exceptions:
Will not include billed free trials.

January 3 - 6:
Daily BeFree batch ONLY includes products, no subscriptions or cancels
Free trialers not billing through
Status: RESOLVED; fix file sent 1/7
Accuracy: ALL revenue stats will be accurate for this day, with the following exceptions:
Will not include billed free trials. Cancel rate will NOT be accurate.

January 7:
Daily BeFree batch included all Free Trials that were signed up for from Dec 8 - December 24
Status: NO ACTION NECESSARY
Accuracy: Rates of any kind are not accurate this day because of the disproportion of the data. However, Net Shipped Sales are accurate.

January 8 - 10:
Daily BeFree batch is including products from the previous day and subscriptions and cancels from 2 days prior, resulting in a delay of subscription data by 1 day
Status: NOT RESOLVED - awaiting technical fix that allows batch processing to occur in a timely manner
Accuracy: All revenue stats are accurate, they are just 1 day late

Remember, the way that we have to fix erroneous sales is by using cancels, and fixing erroneous cancels is using sales (resulting in a 100% cancel rate for thos particular errors). So the cancel rate and cancel amount cannot be trusted for the month as a whole. But there are some days (noted above) where you can use these as evaluations.

As you can see, we've gone through a lot in the last month, and it feels like every time we fix one problem, we find another. Thanks so much for your troubleshooting, and for sticking with us while these issues get worked out. Our hope is to restore your confidence in BeFree data as soon as possible.