We are doing data cleansing.
Our Target is reconciling the Items (downloadable software) Customers bought.
There are 3 components:
Item with a custitem_download_file field that holds the Item related file the Customer is entitled to
Invoice line with the Item sold
Customer Download list
I need to return a saved search or analytics workbook that lists the Customer, Customer downloads list, the Invoice Item, the Item download file so that we can validate that the Customer download list aligns with the downloadable item they bought.
I am having trouble getting to the Customer Download List. I could not get the Customer download field from the Customer. I have tried a Formula (Text) for a few field names customerdownloadlist, customer.download, customer.downloadlist, customer.downloads.file, customer.downloads but I am not successful. I receive the error : field not found.
Does anyone know the field name for the Customer>Sales>Downloads>File?
So far I am building a Transaction Saved Search to get the Customer and the Item then getting the custitem_download_file field from the Item and trying to get the Customer Download file field.
I have attached some screen shots in the attached WORD document.
I will move over to an Analytics workbook tomorrow.
Thanks