Results 1 to 3 of 3
  1. #1
    Join Date
    January 17th, 2005
    Hello, I feel a little silly but after years I realize that I can't give my CEO the exact amount earned with CJ month by month.
    Checques are not indicative, and reports are thougher to use than I ever thought.

    Today is August the 1st, how can I see how much I've earned in July?

    I mean, I do not want the May and June reversals to appear, only the July reversals should be there except the checque amount.
    But I can't manage to do that.

    I had to take my calc off the drawer and calculate the raw amount, which the tenth of this month will be generously cut-off by Zxxxxxx (you know).

    And now I've learned this thing, I tried to do the same with June, just to begin a comparison but guess! the "new" status of the transaction has been erased!
    I don't know either the exact amount I earned in June.

    Please HELP me, I feel puzzled. Thanks!


  2. #2
    ABW Ambassador
    Join Date
    January 17th, 2005
    I don't count any affiliate earnings till the check is in my hands - too many get reversed etc so any amount you say would probably be wrong.

    I add cj money to my earnings when the check comes in - that's when I really earn the money anyway.

  3. #3
    Join Date
    January 17th, 2005

    If you have any July transactions extended, I'd suggest waiting till the 10th September or till they are either "locked" or "reversed".

    If not, then something like this should do for you (that's how we calculated our monthly earnings anyway):

    Pre-Selected Period: July
    Show Which Transactions: Not Corrected
    Show Which Type Of Transactions: Sale
    . (all others on default settings)

    Original, non-corrected Transactions , in time period 1-Jul-2003 - 31-Jul-2003 , of type Sale , all statuses , all websites , all advertisers

    Repeat above for any other type of transactions that you might have for the month, including Performance Incentive, Lead, Credit, Bonus, etc.

    Then the grand total of the above should be your July's earnings (before any subsequent reversals).

    However, since you are dealing with Z***** too, you might also have "Partial Returns" (e.g. when June's Corrected balance is more than July's Corrections balance), in which case, I'm not sure if these are already included in the above calculations or if they will be included in the subsequent month's totals.

    For other merchants who do their reversals not on a fixed day like Z*****, I'm afraid we can only find out any partial reversals by matching each and every Corrected transaction with its corresponding Correction transaction, which may happen in the same month, a month later, or 2 months later if they are also extended.

    Actually, if only CJ were to give us the capability to generate reports based on EVENT DATE and not POSTING DATE, then the above situation would not be a problem at all, because Corrected and Correction transactions would then be reported on the same set of EVENT DATEs (belonging to the original transaction), and one could easily compare them in total.

    But enough upgr*des for me already, so long as we get paid on time, I really don't mind these niggling problems with the reports at all.

    Hope this helps.


    P.S. Does anyone know how to generate your monthly top 10 performing merchants in one report? The "Product Performance Reports" are quite useless, IMHO.

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Performance Reports vs Transaction Reports
    By MaketheMoney in forum Commission Junction - CJ
    Replies: 2
    Last Post: April 1st, 2011, 05:04 PM
  2. Do You Like the New Reports?
    By Snowman in forum Commission Junction - CJ
    Replies: 4
    Last Post: March 6th, 2011, 09:32 AM
  3. automated downloading of reports? reports by email daily?
    By johnm in forum Commission Junction - CJ
    Replies: 4
    Last Post: November 3rd, 2005, 02:26 AM
  4. Performance reports and tracking reports inconsistent
    By Rhea in forum Commission Junction - CJ
    Replies: 12
    Last Post: February 27th, 2004, 09:41 AM
  5. Saving your daily sales reports and performance reports.
    By Dirk Gardner in forum Commission Junction - CJ
    Replies: 8
    Last Post: April 29th, 2003, 03:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts