EPN Dashboard & Transaction Detail Discrepancy SOLUTION

Discussion in 'Commission Junction' started by mcmuney, May 2, 2008.

0
  1. #1
    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.
     
    mcmuney, May 2, 2008 IP
  2. msavage

    msavage Peon

    Messages:
    64
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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.
     
    msavage, May 2, 2008 IP
  3. Nathy

    Nathy Active Member

    Messages:
    435
    Likes Received:
    59
    Best Answers:
    0
    Trophy Points:
    70
    #3
    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.
     
    Nathy, May 3, 2008 IP
  4. msavage

    msavage Peon

    Messages:
    64
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If the EPN bonus is around 10% then this formula works for me.
     
    msavage, May 3, 2008 IP
  5. msavage

    msavage Peon

    Messages:
    64
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    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?
     
    msavage, May 5, 2008 IP
  6. mcmuney

    mcmuney Well-Known Member

    Messages:
    834
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    128
    #6
    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)
    Code (markup):
    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.


    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
     
    mcmuney, May 5, 2008 IP