My segments numbers are not adding up, please help. I used RFM model, and below are the metrics:( I only use Rencecy and frequency).
-- R: In the last 14 days, if a user has done either of viewed product/clicked email/active on site at least once then it means 「close}; if outside of 14 days, a user has done either of viewed product/clicked email/active on site at least once it means 「far」
F: if a user has done either of viewed product/clicked email/active on site greater than 1 then it means 「high}; if a user has done either of viewed product/clicked email/active on site less than 2 then it means 「Low};
-- Then we have 5 segments:
Potential Sum ( anyone has done either of viewed product/clicked email/active on site at least once over all time and hasn’t purchased)
Potential High (R is close, F is high)
Potential medium (R is close, F is low):
Potential Low (R is far, F is high):
Potential Low (R is far, F is low):
For some reasons, the potential sum somehow doesn’t equal the rest four combined. Can someone take a look and help me out please. Also can you give me some suggestions
Keep in mind whenever you use “OR” the user only needs to meet one of the conditions separated by “OR” in order to qualify for that portion of the segment definition. As a result you’ll have users overlap between segments (i.e. a user exist in more than one segment) which is why the numbers won’t necessarily add up to the sum segment. Let’s take your last segment for example, “Clicked email zero times in the last 14 days OR Viewed Product zero times in the last 14 days OR Active on Site zero times in the last 40 days”. Using “OR” separators, if the user clicked email zero times, they now “meet” that portion of the definition. They could have viewed product 1,2,3 or 4+ times and they’ll still qualify for the segment definition as long as they meet the other criteria. This is to say, for any segment criteria you want to be “required” i.e. clicked once and viewed product once you need to use “AND” between segment criteria. This ensures the user meets all of the criteria separated by “AND”. I recommend reviewing any “OR” separators with that theory in mind. This will likely resolve your concerns. Here is our guide on “AND” vs “OR” as well.
Keep in mind whenever you use “OR” the user only needs to meet one of the conditions separated by “OR” in order to qualify for that portion of the segment definition. As a result you’ll have users overlap between segments (i.e. a user exist in more than one segment) which is why the numbers won’t necessarily add up to the sum segment. Let’s take your last segment for example, “Clicked email zero times in the last 14 days OR Viewed Product zero times in the last 14 days OR Active on Site zero times in the last 40 days”. Using “OR” separators, if the user clicked email zero times, they now “meet” that portion of the definition. They could have viewed product 1,2,3 or 4+ times and they’ll still qualify for the segment definition as long as they meet the other criteria. This is to say, for any segment criteria you want to be “required” i.e. clicked once and viewed product once you need to use “AND” between segment criteria. This ensures the user meets all of the criteria separated by “AND”. I recommend reviewing any “OR” separators with that theory in mind. This will likely resolve your concerns. Here is our guide on “AND” vs “OR” as well.
By clicking “Accept All Cookies,” you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.
Privacy Preference Center
Your Privacy
Strictly Necessary Cookies
Performance Cookies
Functional Cookies
Targeting Cookies
Site Analytics
Your Privacy
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
Privacy Notice
Strictly Necessary Cookies
Always Active
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
Performance Cookies
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
Functional Cookies
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
Targeting Cookies
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Site Analytics
These cookies record your visit to our website, and are used to track your visit including information such as: web page interactions (clicks, hovers, focus, mouse movements, browsing, zooms and other interactions), referring web page/source through which you accessed the Sites, heatmaps and scrolls, screen resolution, ISP, and statistics associated with the interaction between device or browser and the Sites. If you are accessing our Services with a European IP address, you have been asked to consent to the use of these cookies (you are free to deny your consent).