COPING WITH THE CHALLENGE OF SORTING LARGE PRODUCT CATALOGS - PowerPoint PPT Presentation

Please write title, subtitle and speaker name in all capital letters COPING WITH THE CHALLENGE OF SORTING LARGE PRODUCT CATALOGS ONLINE - SHOP WINDOW ARRANGEMENT CAGDAS SENOL 19-06-2019

Put images in the grey Put images in the grey dotted box "unsupported dotted box "unsupported placeholder" placeholder" Please write the title in all Please write the title in all capital letters capital letters TABLE OF CONTENTS ● Challenges ● Data Driven Sorting ● Three Improvements for faster iteration ● One Open Source Contribution ● Status Quo ● Q&A 2

Put images in the grey dotted box "unsupported placeholder" ZALANDO AT A GLANCE Please write the title in all capital letters Use bullet points to > 300 visits summarize information ~ 5.4 billion EUR rather than writing long paragraphs in the text per box million month revenue 2018 > 400,000 > 27 product choices > 15,500 > 80% 17 million ~ 2,000 employees in of visits via countries brands Europe active customers mobile devices 3

Put images in the grey dotted box "unsupported placeholder" DISCLAIMER Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box 4

Put images in the grey Put images in the grey Put images in the grey dotted box "unsupported dotted box "unsupported dotted box "unsupported placeholder" placeholder" placeholder" Window Dressing Please write the title in all Please write the title in all capital letters capital letters Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 5

Put images in the grey dotted box "unsupported placeholder" “ Window dresser Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box Window dressers arrange displays of goods in shop windows or within a shop itself. Such displays are themselves known as "window dressing". They may work for design companies contracted to work for clients or for department stores, independent retailers, airport or hotel shops. “ 6

Put images in the grey Put images in the grey Put images in the grey dotted box "unsupported dotted box "unsupported dotted box "unsupported placeholder" placeholder" placeholder" DATA DRIVEN SORTING Please write the title in all Please write the title in all capital letters capital letters Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 7

Please write the title in all Please write the title in all capital letters capital letters CHALLENGES 400k 4k 15 CHALLENGES ups 17 8

Please write the title in all capital letters 9

Please write the title in all capital letters Fail fast, Iterate faster 10

Please write the title in all capital letters ITERATE FAST DESIGN A/B TESTS ANALYSIS 11

Please write the title in all capital letters Three Improvements ● Steering ● Fast Index Updates ● Sorting with functions 12

Please write the title in all capital letters First Improvement: Sort Steering 13

Please write the title in all capital letters Sort Steering - SQL Analogy Id Bucket Popularity sku1 1 0.2332332 sku2 2 0.123233 sku3 1 0.4533 Sku2 SELECT * FROM articles ORDER BY Bucket Desc, Popularity DESC Sku3 Sku1 14

Please write the title in all capital letters Sort Steering - SQL Analogy Id Bucket Popularity Popularity_male sku1 1 0.2332332 0.4 sku2 2 0.123233 0.6 sku3 1 0.4533 0.1 If category_gender == “men” SELECT * FROM articles ORDER BY Bucket DESC , Populartiy_male DESC Else SELECT * FROM articles ORDER BY Bucket DESC , Popularity DESC 15

Please write the title in all Pre-Sort Steering Architecture capital letters 16

Please write the title in all capital letters Sort Steering Added 17

Please write the title in all capital letters Sort Steering - SQL Analogy Id Bucket Popularity Popularity_male sku1 1 0.2332332 0.4 sku2 2 0.123233 0.6 sku3 1 0.4533 0.1 If category_gender == “men” SELECT * FROM articles ORDER BY Bucket DESC , Populartiy_male DESC Else SELECT * FROM articles ORDER BY Bucket DESC , Popularity DESC 18

Please write the title in all capital letters 19

Please write the title in all capital letters 2nd Improvement: Decoupled Data Ingestion 20

Please write the title in all capital letters Indexing - SQL Analogy Id Price Stock Size Partner Performance Performance_new_formula sku1 9.99 100 32 false 0.5 0.4 sku1 9.99 100 32 false 0.3 0.6 INSERT INTO articles VALUES( 9.99, 100, 32, false , 0.5, 0.4 ) INSERT INTO articles VALUES( 9.99, 100, 32, false , 0.3, 0.6 ) 21

Put images in the grey Put images in the grey dotted box "unsupported dotted box "unsupported Intake Architecture placeholder" placeholder" Please write the title in all Please write the title in all capital letters capital letters Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 22

Please write the title in all capital letters Indexing - SQL Analogy Id Price Stock Size Partner Id Performance Performance_new_formula sku1 0.5 0.4 sku1 9.99 100 32 false sku1 0.3 0.6 JOINS => Elasticsearch Id Price Stock Size Partner Performance Performance_new_formula sku1 9.99 100 32 false 0.3 0.6 23

Put images in the grey Put images in the grey dotted box "unsupported dotted box "unsupported Intake Architecture Now placeholder" placeholder" Please write the title in all Please write the title in all capital letters capital letters Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 24

Put images in the grey dotted box "unsupported placeholder" Please write the title in all capital letters Use bullet points to summarize information rather than writing long paragraphs in the text box 3rd Improvement: Sorting with Functions 25

Put images in the grey Put images in the grey dotted box "unsupported dotted box "unsupported placeholder" placeholder" Painless Scripts Please write the title in all Please write the title in all capital letters capital letters Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 26

Please write the title in all capital letters Sorting with Functions - Eliminate Reindexing Id Price Stock Size Partner clicks sales sku1 9.99 100 32 false 10000 300 SELECT * FROM articles ORDER BY popularity(sales,clicks) popularity (sales, clicks) = sales/clicks 27

Please write the title in all capital letters Sorting with Functions - Personalization Id Price Stock Size Partner popularity article_features sku1 9.99 100 32 false 1.2 [9.99, 100, 32] If known_customer : SELECT * FROM articles ORDER BY dot_product(article_feature, customer_features) Else SELECT * FROM articles ORDER BY popularity 28

Please write the title in all capital letters Sorting with Functions - Fulltext Search Id Price Stock Size Partner clicks sales sku1 9.99 100 32 false 10000 300 If fulltext_search : SELECT * FROM articles ORDER BY f(relevance_score, clicks, sales, customer_features, article_features) Else SELECT * FROM articles ORDER BY g(clicks, bucket, sales, customer_features) 29

Please write the title in all Please write the title in all capital letters capital letters EXAMPLE SORTING RULES Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 30

Please write the title in all Please write the title in all capital letters capital letters Personalization Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 31

Please write the title in all Please write the title in all capital letters capital letters Query Relevance Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 32

Please write the title in all Please write the title in all capital letters capital letters Inline Popularity Calculation Use bullet points to Use bullet points to summarize information summarize information rather than writing long rather than writing long paragraphs in the text paragraphs in the text box box 33