How can I create a calculated metric to determine if we exceed the conversion rate limit set by one of our providers (benz) on a weekly basis, which would result in a penalty?
We are car selling website The provider’s rule states that we incur a cost of 0.01 cents per extra call after the search-to-book (S2B) ratio exceeds 4500/1.
Here’s the data I have connected to the dashboard (columns):
date (daily)
Provider (Benz, BMW, Opel , …)
Number of searches made by users
Number of bookings made by users
Could you help me write the calculated metric based on this information?
(consider this limitation is per week not per day)
Sudo code:
first calculate s2b per week = s2b
second IF(
(‘s2b per week’-4500) * 0,01 * ‘books on that week’ < 0 ;
0 ;
(‘s2b per week’-4500) * 0,01 * ‘books on that week’
)
Hi @MajidFa,
Apologies from the community that this post was originally missed. As it’s been awhile, are you still having issues with your original request or were you able to find a work around?
One side note, when you add an additional comment to a post, it removes the topic from the ‘new’ or ‘unanswered’ list which sometimes leads to situations like this where it gets missed. I would suggest editing your original post if you ever need to add additional context for future scenarios!
Hi @MajidFa,
I’ll do my best to assist! Could you provide some additional information:
In terms of how you’d like this to show in your analysis, will you be showing multiple weeks at a given time or will you be using a parameter/filter so that the time frame will only be based on a given week? This could change how many factors we’ll need to include in the calc. field.
Is ‘books on that week’ a calculated field you’ve already created? If so, could you please share?
Last, for the S2B calculation, what’s the 4500/1 ratio based off of? Can you give an example of how that’s calculated to mark a case as exceeded?
Hi @MajidFa,
It’s been awhile since we last heard from you, if you could provide the additional information requested above, I’ll do my best to assist.
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Hi @MajidFa,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.