EPN Dashboard & Transaction Detail Discrepancy SOLUTION

[mcmuney]

I wanted to post the solution on a new board since I thought it will help many of you (it can be found on the original board: http://forums.digitalpoint.com/showthread.php?t=823844):

Props to Nathy for the original post. But here it is: If I take the ((($total_amount-$1 for each ACRU)/2)+$25 for each ACRU), I come very close to my Dashboard. My Dashboard is showing $83.35 YTD. My Transactions show $117.56, which includes 1 ACRU. So here's the formula:

($117.56-1/2) = $58.28 + $25 = $83.28 (that's only off by .07cents)

If this is really true, then EPN's reporting is crap. We shouldn't have to do all this manual work!!!

I've tested the formula for April and May separately as well and it works.

[msavage]

At the risk of redundant posting, I just replied to your solution on another thread...

The forumula doesn't work in my case, the new calculated total amount is less than the dashboard amount. I actually have this formula:

((($total_amount - $1 for each ACRU) / 1.71) + $25 for each ACRU)

I don't have multiple months to test this against so at this point I have to assume your calculation is correct and I just have an inconsistency between the dashboard and the transaction report.

[Nathy]

At the risk of redundant posting, I just replied to your solution on another thread...

The forumula doesn't work in my case, the new calculated total amount is less than the dashboard amount. I actually have this formula:

((($total_amount - $1 for each ACRU) / 1.71) + $25 for each ACRU)

I don't have multiple months to test this against so at this point I have to assume your calculation is correct and I just have an inconsistency between the dashboard and the transaction report.

ePN automatically adds the incentive bonus when you hit it so make sure take that in account for how much you divide it by and how much you are putting for ACRU's.

Personally I quite like it because a script could be made to tell me the total revenue generated for everything.

[msavage]

ePN automatically adds the incentive bonus when you hit it so make sure take that in account for how much you divide it by and how much you are putting for ACRU's.

If the EPN bonus is around 10% then this formula works for me.

[msavage]

It's May 5th and my dashboard shows $27.84. I downloaded my transaction spreadsheet and it shows no ACRUs and a total amount of $68.35. If I plug that into your formula I have a mismatch of $27.84 from the dashboard vs. $34.18 using the formula. I've never had the dashboard and the transaction report tie out. Does anyone else have this discrepancy or are your numbers tying out?

[mcmuney]

Below is an update formula for May. EPN seems to be adding 10% bonus to each transaction (as msavage pointed out).

((($total_amount-$1 for each ACRU)/2)*10% bonus+$25 for each ACRU)

When I apply the above formula to May's transaction. I can tie back to every number by campaign id; however, you must EXCLUDE all transactions with a post date of 5/5/08. The Dashboard doesn't appear to include these transactions yet.


It's May 5th and my dashboard shows $27.84. I downloaded my transaction spreadsheet and it shows no ACRUs and a total amount of $68.35. If I plug that into your formula I have a mismatch of $27.84 from the dashboard vs. $34.18 using the formula. I've never had the dashboard and the transaction report tie out. Does anyone else have this discrepancy or are your numbers tying out?

The above should solve your difference (if you exclude 5/5/08 posting dated transactions). Let us know.

Update: 5/5/08 transactions are now included in the Dashboard