When exporting a Deal Smartlist that contains Product and Customer data, Zendesk creates two output files. One (Smarlist name_by_product_date_xxxx) with Product information displayed in individual rows, but without the Company data and another file (Smartlist name_date_xxx) with the Company names dispayed in individual rows, but the product names in a single csv string. Neither list enables the user to analyse Products by Customer and the two data files have to be merged and manipulated using Deal ID (the only unique common idenitifer in the two output files). If the "Smartlist name_by_product_date_xxxx" file simply had the customer name in it, the data would be useful.
Please sign in to leave a comment.