04.09.08
Commission Junction mass lead rejection guide
Commission Junction, CJ, doesn’t have an efficient method to rejecting 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”
