How to match sales in the Payment Statement to sales in the Brand Analytics Report?
Hi Forum!
We have built an automated excel reporting that works with certain reports. One thing I cannot manage to do is to match the sales from the reports that come out of Brand Analytics to the “actual” sales in our Payment Statements. As I understand it, this is due to the fact that sales are counted in Brand Analytics once an order is placed, while the Payment Statement will record a sale once it has been paid and shipped. I thought about cross referencing the data from the Payment Statement with the data from the Order Report, since there seems to be an actual order date available in that report.
Do you guys have any thoughts on or experience with the issue?
How to match sales in the Payment Statement to sales in the Brand Analytics Report?
Hi Forum!
We have built an automated excel reporting that works with certain reports. One thing I cannot manage to do is to match the sales from the reports that come out of Brand Analytics to the “actual” sales in our Payment Statements. As I understand it, this is due to the fact that sales are counted in Brand Analytics once an order is placed, while the Payment Statement will record a sale once it has been paid and shipped. I thought about cross referencing the data from the Payment Statement with the data from the Order Report, since there seems to be an actual order date available in that report.
Do you guys have any thoughts on or experience with the issue?
