We are reviewing our sales history and pricing to determine if we/our Customers could sustain a price increase.
My goal is gathering data in consideration of a price increase for one of our Items, "Web Service License" but I want to understand the entire suite of products our Customers currently have, when the Customer has our Web Service Product (actually all the products this family).
As example: if we increase the price of Item/Product #1 ("Web Service License") and a Customer was invoiced for additional Item/Products, what is the $ amount of our risk of losing the Customer for all the Items/Products (Calcs & Forms & STE) purchased, if they cannot sustain a price increase on one Item/Product #1 ("Web Service License").
We need to understand a few things if we target our Item/Product #1 ("Web Service License") for an increase:
- How many Customers have purchased Item/Product #1 ("Web Service License")
- What is the Base Price for Item/Product?
- How much did the Customer pay for Item/Product?
- If a Customer purchased Item/Product #1 ("Web Service License") and it is still active, (using/renewing/paying), include all other Items/Products (Calcs & Forms & STE) that the Customer purchased.
We are a subscription model software company.
While auditing, I found Customers that purchased our "Web Service License" item long ago, but have not renewed (so should no longer be a pricing impact consideration).
I am struggling with a conflict between the Customer: Items Purchased (which is for all time) and the transaction Invoice Date criteria.
I have tried many criteria combinations and this is my current criteria.
I exported results. The results still include Customers that DID purchase the items but have since cancelled.
I want to exclude Customers and the related Items, if the customer is no longer using/renewing/paying for the Items listed in my Items Purchased criteria.
Anyone, any suggestions?
Thanks