tools

dominant category: 14339 Crafts
inferred category: 0
query frequency: 217
total clicks: 60

Shortcut Module Information:
RS_LISTVIEW_PLACEMENT:	7
RS_GALLERYVIEW_ROW:	2
RS_COVERAGE_TYPE:	Total Coverage
RS_TOP_DOMAINS:	6
RS_MIN_AGGREGATE_COVERAGE:	0.5
RS_MINIMUM_RESULTS:	500
RS_MAX_DOMAINS_DISPLAYED:	6
RS_DOMAIN_MIN_COVERAGE:	0.01
RS_DOMAIN_MIN_SUPPLY:	10

Search request Module
site_id = 0 and profileId = 2467
Profile tracker id: Pr2467_6_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0)))

site_id = 0 and profileId = 1145
Cannot find profileTrackerId. Look up again for SiteId= -1
Profile tracker id: Pr1145_1
Profile Expression: Pr(TitleRel(100))

site_id = 0 and profileId = 1145
Cannot find profileTrackerId. Look up again for SiteId= -1
Profile tracker id: Pr1145_1
Profile Expression: Pr(TitleRel(100))

Query : tools
Url : http://phxsibeclassicdb.vip.ebay.com:9090/koios?Qy=tools&Si=0&Aq=0.9&Vr=2&Sr=SIFFTAS+KWNV&Rf=0&Rl=0&Sq=0&Qr=tools
Query : tools
Url : http://phxsibeclassicdb.vip.ebay.com:9090/koios?Qy=tools&Si=0&Aq=0.0&Vr=2&Sr=SERENDIP&Rf=5&Rl=5&Sq=0&Qr=tools&Ca=4121

[ShowInFinding3 - EBAY_MAIN=0 STORE=2]
  ShowInSite5("0","2")

[CURRENT_ACTIVE]
  AND(
      LESSTHANEQUAL(SafeStartTime,"NOW"),
      GREATERTHAN(EndTime,"NOW"))

[MskuView - 1]
  MskuView("1")

[AllCats - 4121]
  EQUAL(AllCats,"4121")

[SIBEExpression - AND(OR(AND(OR(tool,tools,EQ(ATTR(Type,df),NAME(Tools,df)),EQ(AllCats,631)))))]
  AND(
      OR(
          AND("OR(tool,tools,EQ(ATTR(Type,df),NAME(Tools,df)),EQ(AllCats,631))")))

• SearchQuery:AND(MACRO(ShowInSite5,0,2),MACRO(MskuView,1),EQ(AllCats,4121),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(OR(tool,tools,EQ(ATTR(Type,df),NAME(Tools,df)),EQ(AllCats,631))))
• CompleteBackendQuery:callname=DSAggregate&requestencoding=NV&responseencoding=NV&dsHdr=0;2;4&Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C0%2C2%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C4121%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28OR%28tool%2Ctools%2CEQ%28ATTR%28Type%2Cdf%29%2CNAME%28Tools%2Cdf%29%29%2CEQ%28AllCats%2C631%29%29%29%29&Sp=RELEVANCE_SORT2&Nr=25&So=Decreasing&St=Num=1&flpr=30%7C300%7C2.13%7C0.8%7C0.8%7C3%7C100000000%7C30&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+SHIPCALC%28Fu%2CFa%2C1%2C0%2C0%2C2147483647%2C5%29+Ctry+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+eBayAdult+MotorsSubmodel+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Gb=%7BHASATTR%28ProdReferenceId%29,COUNT,Incr,0,0,0,0+%7D+%7BStoreSellerID,COUNT,Decrv%280%29,0,150,0,0+%7D+%7BSite,COUNT,Incr,0,0,0,0+%7D+%7BDsaPseudo,SUBCAT(%220%22,%224121%22),Incr,0,0,0,0+DSAJoin+qd.category.category+%2B%3D+mst.LeafCats+DSAWhere+qd.query.query+%3D+%22tools%22+AND+qd.site.site+%3D+%220%22%7D+%7BDsaPseudo,SUBDAP(%22_%7C_%22),Incr,0,0,0,0+DSAJoin+qd.dap.dap+%2B%3D+qd.dap.dap+DSAWhere+qd.query.query+%3D+%22kw%3Atools%22+AND+qd.site.site+%3D+%220%22%7D&Im=saleclass1&Rkw=%5Bkeyword%3Dtools%2Csite%3D0%2Ccategory%3D4121%5D&Pr=Pr3%28%28%28EQ%28saleclass1%2C1%29%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CEndTime%29%2C100%2C1000000%2C-864000%2C0%29%2C0%2C1000000%2C1%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28AND%28EQ%28USScore3%2C10000%29%2CEQ%28TnS_xsh%2C50%29%29%2CVARSET%28BRValue%2C985000%29%2C1000000%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CMACRO%28EffectiveStartTime%29%29%2C-100%2C1000000%2C0%2C864000%29%2C0%2C1000000%2C1%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%29&Es=saleclass1%2C1%3A72%25%3B0%3A28%25%2C25&Qi=core_all_matching_items_orch%3APageMA2ShowItems%3AM168%3A2467%3APr2467_6_Ed105_2_Ed106_2:1261421331_0x8b10.2.105.74:px-wshop064:collectibles.shop.ebay.com:v3shopcore
• SearchIndex:DSA
• BackendHost:phxsn-stitle011+phxsn-stitle019+phxsn-stitle044+phxsn-stitle349+phxsn-stitle983+phxsn-stitle300+phxsn-stitle111+phxsn-stitle113+phxsn-stitle820+phxsn-stitle154+phxsn-stitle599+phxsn-stitle608+phxsn-stitle846+phxsn-stitle992+phxsn-stitle490+phxsn-stitle960+phxsn-stitle319+phxsn-stitle242+phxsn-stitle967+phxsn-stitle403+phxsn-stitle408+phxsn-stitle752+phxsn-stitle167+phxsn-stitle637+phxsn-stitle191+phxsn-stitle366+phxsn-stitle370+phxsn-stitle197+phxsn-stitle679+phxsn-stitle376+phxsn-agg194
• QueryTimeInMicroSec:115041
• NumMatched:5438
• NumReturned:25

• SearchQuery:AND(MACRO(ShowInSite5,0,2),MACRO(MskuView,1),EQ(AllCats,4121),MACRO(IsFeaturedFirstTnsFiltered),EQ(USLevel,1),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(OR(tool,tools,EQ(ATTR(Type,df),NAME(Tools,df)),EQ(AllCats,631))))
• CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C0%2C2%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C4121%29%2CMACRO%28IsFeaturedFirstTnsFiltered%29%2CEQ%28USLevel%2C1%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28OR%28tool%2Ctools%2CEQ%28ATTR%28Type%2Cdf%29%2CNAME%28Tools%2Cdf%29%29%2CEQ%28AllCats%2C631%29%29%29%29&Sp=RELEVANCE_SORT2&Nr=10&So=Decreasing&St=Num=1&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+SHIPCALC%28Fu%2CFa%2C1%2C0%2C0%2C2147483647%2C5%29+Ctry+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+eBayAdult+MotorsSubmodel+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Rkw=%5Bkeyword%3Dtools%2Csite%3D0%2Ccategory%3D4121%5D&Pr=Pr%28TitleRel%28100%29%29&Qi=fetch_featuredfirst_items%3APageMA2ShowItems%3AC2%3APr2467_6_Ed105_2_Ed106_2%3APr2467_6_Ed105_2_Ed106_2:1261421331_0x8b10.2.105.74:px-wshop064:collectibles.shop.ebay.com:v3shopcore
• SearchIndex:ExpressSale
• BackendHost:phxsn-stitle007+phxsn-stitle020+phxsn-stitle918+phxsn-stitle057+phxsn-stitle074+phxsn-stitle085+phxsn-stitle544+phxsn-stitle580+phxsn-stitle820+phxsn-stitle801+phxsn-stitle268+phxsn-stitle810+phxsn-stitle949+phxsn-stitle437+phxsn-stitle869+phxsn-stitle695+phxsn-stitle828+phxsn-stitle099+phxsn-stitle291+phxsn-stitle452+phxsn-stitle358+phxsn-stitle752+phxsn-stitle168+phxsn-stitle631+phxsn-stitle469+phxsn-stitle646+phxsn-stitle477+phxsn-stitle677+phxsn-stitle375+phxsn-stitle682+phxsn-agg220
• QueryTimeInMicroSec:57136
• NumMatched:0
• NumReturned:0

calling DFN surface algorithm 

Total Supply Count For Product Type:5382
Total Demand Score For Product Type:17725
PT coverage list
PT Name=Other eBay Items:	id=3294	supply=5370	raw demand=14887	demand=83.98871650211565	score=99.18815265335809	high confidence=85.0	light confidence=60.0
PT Name=Automotive Tools:	id=2871	supply=2	raw demand=2377	demand=13.410437235543018	score=0.5301496478323466	high confidence=85.0	light confidence=60.0
PT Name=Folk Art & Primitives:	id=2757	supply=7	raw demand=359	demand=2.0253878702397743	score=0.17817777778709348	high confidence=85.0	light confidence=60.0
PT Name=Architectural & Garden:	id=3060	supply=1	raw demand=75	demand=0.4231311706629055	score=0.05308274012422677	high confidence=85.0	light confidence=60.0
PT Name=Antique Decorative Arts:	id=383	supply=2	raw demand=27	demand=0.15232722143864597	score=0.05043718089823554	high confidence=85.0	light confidence=60.0
-------------------------
WinningPT is null because qualfiedPTList is empty
WinningPT is null because there is no qualified ProductType

• SearchQuery:AND(OR(EQ(OwnerId,2097928),EQ(OwnerId,36505475),EQ(OwnerId,814293091),EQ(OwnerId,164064802),EQ(OwnerId,80228305),EQ(OwnerId,111234476),EQ(OwnerId,80537512),EQ(OwnerId,571565072),EQ(OwnerId,29774890),EQ(OwnerId,15147),EQ(OwnerId,179764755),EQ(OwnerId,18298086),EQ(OwnerId,821029241),EQ(OwnerId,143443862),EQ(OwnerId,890732959),EQ(OwnerId,51542183),EQ(OwnerId,754253113)))
• CompleteBackendQuery:Vr=0.1&Qy=AND%28OR%28EQ%28OwnerId%2C2097928%29%2CEQ%28OwnerId%2C36505475%29%2CEQ%28OwnerId%2C814293091%29%2CEQ%28OwnerId%2C164064802%29%2CEQ%28OwnerId%2C80228305%29%2CEQ%28OwnerId%2C111234476%29%2CEQ%28OwnerId%2C80537512%29%2CEQ%28OwnerId%2C571565072%29%2CEQ%28OwnerId%2C29774890%29%2CEQ%28OwnerId%2C15147%29%2CEQ%28OwnerId%2C179764755%29%2CEQ%28OwnerId%2C18298086%29%2CEQ%28OwnerId%2C821029241%29%2CEQ%28OwnerId%2C143443862%29%2CEQ%28OwnerId%2C890732959%29%2CEQ%28OwnerId%2C51542183%29%2CEQ%28OwnerId%2C754253113%29%29%29&Sp=StoreId&Nr=150&So=Increasing&St=Num=1&Sk=0&Fl=StoreId+SubsLevel+SiteId+Name+OwnerId&Qi=FindingVoyagerStoreCache-StoreQuery%3A%3AFindingVoyagerStoreCache%3A%3A:1261421331_0x8b10.2.105.74:px-wshop064:collectibles.shop.ebay.com:v3shopcore
• SearchIndex:Store
• BackendHost:phxsn-sname06
• QueryTimeInMicroSec:108
• NumMatched:17
• NumReturned:17