04.09.08

Commission Junction mass lead rejection guide

Posted in Affiliate Marketing at 12:18 am by PPC Guy

, , doesn’t have an efficient method to a large number of leads within their interface. Here’s the work around.

  • First you’ll need to request a subscription ID. You can do this using the support link within the advertiser interface.
  • Once you have a subscription ID, you’ll run a detailed transaction report.
    Now download the transaction report to Excel.
  • You’ll use the detailed transaction report to identify the records that need to be rectified,
  • Once you have identified all the “bad” records, copy these records into a separate Excel sheet
  • Copy “UQL,,” on a separate column next to the OrderIDs starting from the first till the last row of OrderID
  • Copy the two columns of data into notepad
  • Replace the extra space characters with a blank
  • The final format should look similar to the format below
  • Replace the CID(this is within parenteses next to the comapany name on the top right corner of the CJ advertiser interface) and SUBID(subscription ID) with your values
  • Once your file is in the format below save your file with a “.csv” extension
  • Your final step is to email the file to import@cjdatatransfer.com

    • remove the <BR> tags”