Century21Stores / SPECIAL

Special Projects
0 stars 0 forks source link

CDF Issues Investigation & Manual Remediation #98

Open c21hornak opened 6 years ago

c21hornak commented 6 years ago

Issues:

  1. Kids and Women's Products These appear to be distributed across your different parent categories. KIDS (Product ID's that start with 3) Most of Kids product interaction appears to be under Content WOMEN'S (Product ID's that start with 2) Most Women's product interaction appears to be under Browsing

  2. Fiscal vs. Custom Date Range The total sales shown between the fiscal and custom date ranges is the same but those sales are distributed differently. The fiscal date range uses whatever category structure was in place at the end of the month. The custom date range uses the summed cumulative daily data to produce the time period. This means that if there were any differences between the end-of-the-month CDF and the daily CDF structure then the reporting will be different.

  3. Duplicate Categories The CDF structure is: "Client ID | Category ID | Category Name | Parent Category ID" The Category ID is a alphanumeric value (such as 123) that you see in the tags The Category name is a human readable name (such as Women) that you see in the reports. I believe that you (over time) have sent us multiple category rows with different Category ID's but the same Category Name such as "Women" This is because your back end structure changes from week to week. So this week the Women category ID might be 123 and then next week Women category ID might be 456 When you look at the full month you will then see both of these as the different category ID's may these different categories that happen to have the same Category Name.

  4. The Shop All There are two things happening here:

4A- Different Shop All Pages (Makeup Shop All vs. Skin Care Shop All) have the same Page ID value of "CATEGORY: Beauty > Shop All" 4B- In the CDF you have sub-categories of "Shop All" for different classes of products such as Mens Shop All and Home Shop All. But in the CDF structure these sub-categories have the same name of "SHOP ALL" This makes it hard to differentiate these. Ideally they should have more specific Category Names such as "SHOP ALL: MENS" and "SHOP ALL: HOME"

AdenaG commented 6 years ago

Discussion/To dos:

  1. It makes sense why a number of kids categories, among other, appear under content. They are built under content navigation (as I recall they weren’t in the nav at certain points). When something doesn’t show in the standard browsing navigation, it lives in the content nav (screenshot attached). Juan to address these potentially being moved back into browsing.

  2. It makes sense why fiscal/custom date ranges pull based on different timelines, since we clone the nav atleast once a week for a release, thereby generating a new id for each category. As discussed, this is WL functionality, however, 1 solution you may want to consider to minimize the amount of duplicate/unique id’s is to not clone the nav/create releases for navigation changes as often. If you are only creating 1 or 2 new categories, and you create them in the now, and then tie them to the nav in the now, you won’t need to clone the entire nav and therefore you won’t be generating a new id for each category/nav point. - Not going to pursue for now.

  3. Duplicate categories are due to the nav cloning mentioned above.

  4. Duplicate naming conventions can be alleviated internally. For ex, you spoke to beauty category – all those ‘shop all’s are pulling in under beauty > shop all. They aren’t pulling in under beauty > makeup > shop all, for example, as they appear in the nav. To alleviate this, you shouldn’t have the same name for multiple categories. If the shop all category under makeup is created in the admin as ’makeup shop all’, it will appear in Coremetrics as such. What could be done so that the customer view doesn’t change would involve a little customization to display a different name or view on the storefront than in the admin(kind of like the VIP shopping area). Juan to look into customization appearance of these categories on storefront so their naming convention can be unique in admin for Coremetrics reporting.

c21hornak commented 6 years ago

@juanmriosv can you please add this to your priority list?