Forum Discussion
hi
hello,
Can someone help me
I have 6 parameter
I have an item call Apple
1) Item quantity = 10 KG
2) Item Amount = 50 Dollar
3) Number of days promotion ran =10 days
4) Number of customers avail promotion = 5
5) Number of invoices generated by the promotion = 5
6) Number of times the promotion code was used = 5
If i want to ran same promotion or any other different promotion discount to any items
i want to find if i give discount of 2 Dollar or 2% and the goal is to increase customer number or quantity or invoice number and use of promotion code
So for example, i want to find out by giving 2 dollar or 2 % discount how could I know it may increase 2 customers, 3 invoices, 5 quantity, may use promotion code 2 times if i use keep the promotion for 10 days.
What i mean is if i give discount 2 dollar or 2% on apple item
then how i know
1) How many Quantity might be sold (approx)
2) How many days promotion I should ran (approx)
3) How many customer May avail promotion (approx)
4) How many invoices could generated by the promotion (approx)
5) How many times promotion code might used (approx)
I dont know if i am clear to make you understand or not
I hope you guys get it.
PLease help me by giving a pbix gile share.
Thanks
i got solution
13 Replies
- abc_777
Solution Specialist
hello,
is there any way to achive it for marketing promotional purpose?
I want to give for exmaple 55 dollar off or 10% on apple so i select apple from slicer and 10% from virtual table.
how can i know giving this promotion i will get this number of customers (approx)?
please help me from this
thnx
- AnonymousNot applicable
Hi abc_777 ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
- abc_777
Solution Specialist
Hello Anonymous ,
thanks for your email.
I have attached an excle file which is uploaded to google drive.
Please have a look and if you have any more things you think you can add please feel free to do so
10% discount on MRP how much sale quantity may sale and how much revenue may come and how many customers may purchase these things i want to find
https://drive.google.com/drive/folders/17TuU_yxVJ5ua_ItWCMctb6NONM4QIDAJ?usp=drive_link
thanks