Forum Discussion
hi
Hello
I have sample excel file where i have
| PROMOTION_CODE | Quantity Sold | Count of days CC | Unique Count of CUSTOMER_CODE | Count of CUSTOMER_CODE | Invoice DISTINCTCOUNT |
in this excel file i have how many quantity sold in each promotion, how many days the promotion was given, unique customer count who bought items of that promotion and repeated customers who bought items of that promotion multiplt times and lastly Number of invoices.
Most of the fields are filled with data some are empty as those promotion wasn't work er or customer didnt bought anything
my objective is i want a measure that shows me using those 5 parameters (Quantity Sold, Count of days CC, Unique Count of CUSTOMER_CODE, Count of CUSTOMER_CODE, Invoice DISTINCTCOUNT)
1) which promotion is most effective in comparison to other promotion
here is sample excel file in google drive
https://drive.google.com/drive/folders/1Rf4E-1Pa0hvExGADScvShDqxJGJtTA2O?usp=drive_link
please help me for this
thanks
hello,
can any one please help me ,
thx
3 Replies
Hi abc_777
For no3, you can use a bar or column with quantity sold broken down by promo code and are sorted from those with the highest to lowest quantity.
For 1 and 2, you need to elaborate on those. How do you know which promotion is more effective than the other? without giving enough context, it would be just the same as no 3. How do you define customer-centric or customer like? And lastly, what have you done so far? Where are stuck at?
