Yes! This is where RFM Calc can be even more powerful if you have some Excel skills; you can absolutely add more columns to your CSV before you upload it and our system will process this for you. For example, one of our favourites is adding a column to determine if the order was shipped to the billing address or delivery address; this can help identify where you have spikes in gift purchases and also give you an overall figure for the importance of allowing customers to ship to a different address.
In Excel, you can add another column with a header like 'Shipped to Billing Address' then use the formula =IF(ISNA(MATCH(I2,J2,0)), "No", "Yes") where I2 is the billing address and J2 is the shipping address. Then when you upload your CSV, just include 'Shipped to Billing Address' as a Custom Column and we'll do the rest.
Click here to learn more about our Custom Column reports