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.
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.
posted by rpatel at
11:03 AM
0 Comments:
Post a Comment
<< Home