Skip to content

Instantly share code, notes, and snippets.

@mohnishkodnani

mohnishkodnani/why_no_count.cql

Created May 6, 2026 02:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mohnishkodnani/dd4b4b7f9b56f846862772bdafae177f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mohnishkodnani/dd4b4b7f9b56f846862772bdafae177f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
why_no_count.cql
container{
client_name: "urn:ebay-marketplace-consumerid:13051638-8fe9-4380-8d03-c2b176530b4a",
QueryTime: 1777590256,
customer_experience: SRP,
enable_approximate_histograms: true,
summarize_response: 1,
task_name: MainSearchInvokerTask
}(
query{
"X-EBAY-C-ENDUSERCTX": "sec-ch-ua-model=%22SM-A137F%22,sec-ch-ua-full-version=%22146.0.7680.177%22,sec-ch-ua-platform-version=%2214.0.0%22,clientId=urn%3Aebay-marketplace-consumerid%3A13051638-8fe9-4380-8d03-c2b176530b4a,ip=91.8.53.105,userAgentAccept=*%2F*,userAgentAcceptEncoding=identity,userAgent=Mozilla%2F5.0%20(Linux%3B%20Android%2010%3B%20K)%20AppleWebKit%2F537.36%20(KHTML%2C%20like%20Gecko)%20Chrome%2F146.0.0.0%20Mobile%20Safari%2F537.36,uri=%2Fsch%2Fajax%2Frefine,applicationURL=https%3A%2F%2Fwww.ebay.de%2Fsch%2Fajax%2Frefine%3F_nkw%3Diphone%252015%2520pro%2520max%26_sacat%3D0%26LH_BIN%3D1%26_udhi%3D500%26no_encode_refine_params%3D1%26modules%3DSEARCH_REFINEMENTS_MODEL_V2%26async%3Dtrue,referer=https%3A%2F%2Fwww.ebay.de%2Fsch%2Fi.html%3F_nkw%3Diphone%2B15%2Bpro%2Bmax%26_sacat%3D0%26LH_BIN%3D1%26_udhi%3D500,xff=91.8.53.105%2C%202.16.29.197%2C23.15.177.197%2C10.220.15.80%2C10.140.226.108,isPiggybacked=false,expectSecureURL=true,physicalLocation=country%3DDE%2Czip%3D32049,contextualLocation=country%3DUS,origClientId=urn%3Aebay-marketplace-consumerid%3A13051638-8fe9-4380-8d03-c2b176530b4a",
"X-EBAY-C-MARKETPLACE-ID": "EBAY-DE",
"X-EBAY-C-TRACKING": "guid=c79ee45118d0acb56572a2d5ffcc1b77,pageid=2480964,cobrandId=0",
additive_fp_adjustment_value: 0.095,
application: srp,
"bullseye.model": """{
"user": "guid:c79ee45118d0acb56572a2d5ffcc1b77",
"version": "2019.08.29.29",
"bullseye_model_id": "257",
"max_duration": 86400,
"start_timestamp": 1777590256,
"pgn_filter": 1,
"pgn_1_timestamp": -1,
"srp_page_number": 1,
"eventType": "VIEW_ITEM",
"events": [
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"p": "4429486",
"site_id": {
"string": "77"
},
"js_ev_mak": {
"string": "c79ee45118d0acb56572a2d5ffcc1b77"
},
"js_ev_orgn": null,
"current_price": {
"string": "370.0"
},
"current_price_usd": {
"string": "432.049"
},
"item_id": {
"string": "376987050753"
},
"item_condition": {
"int": 3000
},
"item_title": {
"string": "Apple iPhone 14 Pro - 128GB - Silber (Ohne Simlock) + Rechnung + GARANTIE "
},
"l1_cat_id": {
"string": "9355"
},
"l2_cat_id": null,
"leaf_cat_id": {
"string": "9355"
},
"meta_cat_id": {
"string": "15032"
},
"sale_type_enum": {
"string": "9"
},
"shipping_country_id": {
"int": 77
},
"time_remain_secs": {
"string": "1982780"
},
"timestamp": {
"long": 1777590204483
},
"collection_id": null,
"source_impression_id": null,
"current_impression_id": {
"string": "ofZ4wXc*"
},
"sellerid": {
"string": "2274593901"
},
"product_ref_id": {
"long": 22056284296
},
"product_type": null,
"listing_site_id": {
"string": "77"
},
"browsing_site_id": {
"string": "77"
},
"is_bu": false,
"is_udid": false,
"is_userid": false,
"is_cguid": true,
"respCode": null,
"numOfThemes": null,
"pidinstock": null,
"saasll": null,
"theme_details": null,
"item_details": null,
"variation_id": null,
"version_id": {
"string": "5552542897024"
},
"ImgSimEmbA": {
"array": [
963816070,
-227432317,
1636296546,
1650760911,
-1100612898,
1281926634,
-851024379,
-886060811,
-1149395302,
52306110,
-241245364,
-2065272716,
-1228949397,
-146347409,
121841472,
781936725,
1743256600,
996027006,
766493642,
967022289,
-262504872,
233179128,
-724969164,
-593552326,
-1617572034,
-1711400555,
-1079113305,
-86496068,
1092394899,
-423619961,
-1131453874,
-1684588283,
1860924522,
1736978916,
-1109429486,
1544832818,
337845997,
-1402237365,
1853722476,
233554393,
1022264989,
-358994972,
-2052887478,
971475911,
-1297852522,
-184581,
458467303,
-458183106,
-77224350,
99671393,
-590101202,
-1659899620,
1030116137,
-756420147,
977450003,
2012869446,
-1989620019,
950172660,
-59361985,
-564553854,
1924045403,
1268675327,
-432989697,
1955509769
]
},
"ItemSimEmbA": null,
"QryItemSimEmbA": {
"array": [
0.0718994,
0.1768799,
-0.0440674,
0.0415344,
0.1107178,
-0.2124023,
-0.0762939,
-0.1176147,
-0.0435486,
-0.0438843,
0.130127,
0.1292725,
-0.03039551,
0.0466919,
-0.0622864,
-0.02729797,
-0.0684204,
0.1363525,
-0.002614975,
0.02645874,
-0.0562134,
0.02433777,
0.01220703,
-0.00693893,
0.1166992,
-0.0932007,
-0.1073608,
-0.0353394,
-0.0939331,
-0.02635193,
0.0888062,
-0.0657959,
0.00908661,
0.1351318,
-0.0615845,
0.0402832,
-0.0860596,
-0.119751,
0.037384,
0.0812378,
-0.0745239,
-0.1184692,
0.01367188,
-0.1263428,
-0.0961304,
0.1165771,
-0.1716309,
0.086731,
-0.2512207,
-0.02560425,
0.0335693,
0.1483154,
-0.0740967,
0.0316467,
-1.92404e-04,
0.0756226,
0.0368958,
-0.1358643,
0.0561829,
-0.0309906,
0.1136475,
-0.1855469,
-0.0493469,
-0.1876221,
0.1351318,
-0.0922241,
0.0599365,
0.1586914,
-0.1831055,
0.0935669,
0.0574951,
-0.02583313,
-0.0637207,
-0.01713562,
0.02072144,
-0.0323486,
7.09057e-04,
0.1279297,
-0.1071777,
0.1002808,
-0.0533142,
0.1054688,
0.2053223,
-0.1044312,
0.0606995,
0.0812988,
0.1716309,
0.02044678,
0.0626221,
0.071106,
0.0336609,
0.01361084,
-0.201416,
0.2692871,
-0.1225586,
-0.0697632
]
},
"trackable_id": null
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"p": "4429486",
"site_id": {
"string": "77"
},
"js_ev_mak": {
"string": "c79ee45118d0acb56572a2d5ffcc1b77"
},
"js_ev_orgn": null,
"current_price": {
"string": "338.0"
},
"current_price_usd": {
"string": "394.6826"
},
"item_id": {
"string": "327124232699"
},
"item_condition": {
"int": 3000
},
"item_title": {
"string": "Apple iPhone 14 Pro - 128 GB - Spacegrau Schwarz - Zustand: SEHR GUT"
},
"l1_cat_id": {
"string": "9355"
},
"l2_cat_id": null,
"leaf_cat_id": {
"string": "9355"
},
"meta_cat_id": {
"string": "15032"
},
"sale_type_enum": {
"string": "9"
},
"shipping_country_id": {
"int": 77
},
"time_remain_secs": {
"string": "2186069"
},
"timestamp": {
"long": 1777590188567
},
"collection_id": null,
"source_impression_id": {
"string": "AoJcrXsY*"
},
"current_impression_id": {
"string": "obhW5Lo*"
},
"sellerid": {
"string": "812342871"
},
"product_ref_id": null,
"product_type": null,
"listing_site_id": {
"string": "77"
},
"browsing_site_id": {
"string": "77"
},
"is_bu": false,
"is_udid": false,
"is_userid": false,
"is_cguid": true,
"respCode": null,
"numOfThemes": null,
"pidinstock": null,
"saasll": null,
"theme_details": null,
"item_details": null,
"variation_id": null,
"version_id": {
"string": "5212325880011"
},
"ImgSimEmbA": {
"array": [
1002074132,
-192585548,
746968071,
970486746,
634736726,
1730881018,
1874165520,
170023040,
1656313882,
891568158,
-1191316686,
1382474266,
-2070003869,
-560258881,
-1882691726,
1162960209,
-836381538,
-1149326753,
436165545,
-1133933661,
1411058370,
-1767102608,
-826976976,
-458607302,
-1717248227,
1758956319,
-1089912429,
-1737445275,
-529281388,
-118453561,
-522659004,
951551604,
-370452798,
-1369426650,
-1061489375,
337522432,
1188460218,
2029186623,
-260731155,
1211414526,
1563200201,
1574272787,
636295634,
1408242545,
-1333127246,
-602386918,
1802676735,
86212408,
188205052,
1134361718,
-1929315308,
-833148056,
1997152968,
-1299074469,
982583600,
-1884166835,
-95856193,
134856458,
1403724965,
-1769556370,
-222190249,
1233542265,
1990189349,
-788596200
]
},
"ItemSimEmbA": null,
"QryItemSimEmbA": {
"array": [
0.0762939,
0.1876221,
-0.0360718,
0.0575256,
0.1623535,
-0.1311035,
-0.0953369,
-0.1244507,
-0.0496216,
-0.0634155,
0.1585693,
0.1306152,
-0.01052094,
0.0375977,
-0.0875854,
-0.035614,
-0.0704346,
0.1409912,
0.01811218,
0.00662994,
-0.0272522,
-4.95434e-04,
0.062561,
-0.00791931,
0.0901489,
-0.100769,
-0.1073608,
-0.02096558,
-0.1085205,
-0.0371399,
0.1035767,
-0.0542603,
-0.01191711,
0.1196899,
-0.0770264,
0.01818848,
-0.0871582,
-0.1270752,
0.01855469,
0.0672607,
-0.0587463,
-0.1130981,
-0.01600647,
-0.0753784,
-0.0754395,
0.1341553,
-0.182373,
0.0397949,
-0.2374268,
-0.033844,
0.0654297,
0.1673584,
-0.102356,
0.0127182,
0.00804901,
0.0749512,
0.0741577,
-0.1567383,
0.01628113,
-0.0318909,
0.0808716,
-0.2144775,
-0.0530396,
-0.1937256,
0.1270752,
-0.074646,
0.0602722,
0.1744385,
-0.173584,
0.0678101,
0.0728149,
0.00776291,
-0.0930786,
-0.036499,
0.0749512,
-0.01765442,
-0.002195358,
0.1326904,
-0.0874023,
0.1127319,
-0.054657,
0.1045532,
0.2224121,
-0.114563,
0.0655518,
0.0773315,
0.168335,
0.0563354,
0.056427,
0.0633545,
0.0559998,
-0.016922,
-0.1712646,
0.2211914,
-0.1013794,
-0.1119995
]
},
"trackable_id": null
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"p": "4429486",
"site_id": {
"string": "77"
},
"js_ev_mak": {
"string": "c79ee45118d0acb56572a2d5ffcc1b77"
},
"js_ev_orgn": null,
"current_price": {
"string": "370.0"
},
"current_price_usd": {
"string": "432.049"
},
"item_id": {
"string": "376987050753"
},
"item_condition": {
"int": 3000
},
"item_title": {
"string": "Apple iPhone 14 Pro - 128GB - Silber (Ohne Simlock) + Rechnung + GARANTIE "
},
"l1_cat_id": {
"string": "9355"
},
"l2_cat_id": null,
"leaf_cat_id": {
"string": "9355"
},
"meta_cat_id": {
"string": "15032"
},
"sale_type_enum": {
"string": "9"
},
"shipping_country_id": {
"int": 77
},
"time_remain_secs": {
"string": "1982870"
},
"timestamp": {
"long": 1777590114543
},
"collection_id": null,
"source_impression_id": null,
"current_impression_id": {
"string": "oJcrXsY*"
},
"sellerid": {
"string": "2274593901"
},
"product_ref_id": {
"long": 22056284296
},
"product_type": null,
"listing_site_id": {
"string": "77"
},
"browsing_site_id": {
"string": "77"
},
"is_bu": false,
"is_udid": false,
"is_userid": false,
"is_cguid": true,
"respCode": null,
"numOfThemes": null,
"pidinstock": null,
"saasll": null,
"theme_details": null,
"item_details": null,
"variation_id": null,
"version_id": {
"string": "5552542897024"
},
"ImgSimEmbA": {
"array": [
963816070,
-227432317,
1636296546,
1650760911,
-1100612898,
1281926634,
-851024379,
-886060811,
-1149395302,
52306110,
-241245364,
-2065272716,
-1228949397,
-146347409,
121841472,
781936725,
1743256600,
996027006,
766493642,
967022289,
-262504872,
233179128,
-724969164,
-593552326,
-1617572034,
-1711400555,
-1079113305,
-86496068,
1092394899,
-423619961,
-1131453874,
-1684588283,
1860924522,
1736978916,
-1109429486,
1544832818,
337845997,
-1402237365,
1853722476,
233554393,
1022264989,
-358994972,
-2052887478,
971475911,
-1297852522,
-184581,
458467303,
-458183106,
-77224350,
99671393,
-590101202,
-1659899620,
1030116137,
-756420147,
977450003,
2012869446,
-1989620019,
950172660,
-59361985,
-564553854,
1924045403,
1268675327,
-432989697,
1955509769
]
},
"ItemSimEmbA": null,
"QryItemSimEmbA": {
"array": [
0.0718994,
0.1768799,
-0.0440674,
0.0415344,
0.1107178,
-0.2124023,
-0.0762939,
-0.1176147,
-0.0435486,
-0.0438843,
0.130127,
0.1292725,
-0.03039551,
0.0466919,
-0.0622864,
-0.02729797,
-0.0684204,
0.1363525,
-0.002614975,
0.02645874,
-0.0562134,
0.02433777,
0.01220703,
-0.00693893,
0.1166992,
-0.0932007,
-0.1073608,
-0.0353394,
-0.0939331,
-0.02635193,
0.0888062,
-0.0657959,
0.00908661,
0.1351318,
-0.0615845,
0.0402832,
-0.0860596,
-0.119751,
0.037384,
0.0812378,
-0.0745239,
-0.1184692,
0.01367188,
-0.1263428,
-0.0961304,
0.1165771,
-0.1716309,
0.086731,
-0.2512207,
-0.02560425,
0.0335693,
0.1483154,
-0.0740967,
0.0316467,
-1.92404e-04,
0.0756226,
0.0368958,
-0.1358643,
0.0561829,
-0.0309906,
0.1136475,
-0.1855469,
-0.0493469,
-0.1876221,
0.1351318,
-0.0922241,
0.0599365,
0.1586914,
-0.1831055,
0.0935669,
0.0574951,
-0.02583313,
-0.0637207,
-0.01713562,
0.02072144,
-0.0323486,
7.09057e-04,
0.1279297,
-0.1071777,
0.1002808,
-0.0533142,
0.1054688,
0.2053223,
-0.1044312,
0.0606995,
0.0812988,
0.1716309,
0.02044678,
0.0626221,
0.071106,
0.0336609,
0.01361084,
-0.201416,
0.2692871,
-0.1225586,
-0.0697632
]
},
"trackable_id": null
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"p": "4429486",
"site_id": {
"string": "77"
},
"js_ev_mak": {
"string": "c79ee45118d0acb56572a2d5ffcc1b77"
},
"js_ev_orgn": null,
"current_price": {
"string": "338.0"
},
"current_price_usd": {
"string": "394.6826"
},
"item_id": {
"string": "327124232699"
},
"item_condition": {
"int": 3000
},
"item_title": {
"string": "Apple iPhone 14 Pro - 128 GB - Spacegrau Schwarz - Zustand: SEHR GUT"
},
"l1_cat_id": {
"string": "9355"
},
"l2_cat_id": null,
"leaf_cat_id": {
"string": "9355"
},
"meta_cat_id": {
"string": "15032"
},
"sale_type_enum": {
"string": "9"
},
"shipping_country_id": {
"int": 77
},
"time_remain_secs": {
"string": "2186154"
},
"timestamp": {
"long": 1777590103522
},
"collection_id": null,
"source_impression_id": null,
"current_impression_id": {
"string": "oGxfycE*"
},
"sellerid": {
"string": "812342871"
},
"product_ref_id": null,
"product_type": null,
"listing_site_id": {
"string": "77"
},
"browsing_site_id": {
"string": "77"
},
"is_bu": false,
"is_udid": false,
"is_userid": false,
"is_cguid": true,
"respCode": null,
"numOfThemes": null,
"pidinstock": null,
"saasll": null,
"theme_details": null,
"item_details": null,
"variation_id": null,
"version_id": {
"string": "5212325880011"
},
"ImgSimEmbA": {
"array": [
1002074132,
-192585548,
746968071,
970486746,
634736726,
1730881018,
1874165520,
170023040,
1656313882,
891568158,
-1191316686,
1382474266,
-2070003869,
-560258881,
-1882691726,
1162960209,
-836381538,
-1149326753,
436165545,
-1133933661,
1411058370,
-1767102608,
-826976976,
-458607302,
-1717248227,
1758956319,
-1089912429,
-1737445275,
-529281388,
-118453561,
-522659004,
951551604,
-370452798,
-1369426650,
-1061489375,
337522432,
1188460218,
2029186623,
-260731155,
1211414526,
1563200201,
1574272787,
636295634,
1408242545,
-1333127246,
-602386918,
1802676735,
86212408,
188205052,
1134361718,
-1929315308,
-833148056,
1997152968,
-1299074469,
982583600,
-1884166835,
-95856193,
134856458,
1403724965,
-1769556370,
-222190249,
1233542265,
1990189349,
-788596200
]
},
"ItemSimEmbA": null,
"QryItemSimEmbA": {
"array": [
0.0762939,
0.1876221,
-0.0360718,
0.0575256,
0.1623535,
-0.1311035,
-0.0953369,
-0.1244507,
-0.0496216,
-0.0634155,
0.1585693,
0.1306152,
-0.01052094,
0.0375977,
-0.0875854,
-0.035614,
-0.0704346,
0.1409912,
0.01811218,
0.00662994,
-0.0272522,
-4.95434e-04,
0.062561,
-0.00791931,
0.0901489,
-0.100769,
-0.1073608,
-0.02096558,
-0.1085205,
-0.0371399,
0.1035767,
-0.0542603,
-0.01191711,
0.1196899,
-0.0770264,
0.01818848,
-0.0871582,
-0.1270752,
0.01855469,
0.0672607,
-0.0587463,
-0.1130981,
-0.01600647,
-0.0753784,
-0.0754395,
0.1341553,
-0.182373,
0.0397949,
-0.2374268,
-0.033844,
0.0654297,
0.1673584,
-0.102356,
0.0127182,
0.00804901,
0.0749512,
0.0741577,
-0.1567383,
0.01628113,
-0.0318909,
0.0808716,
-0.2144775,
-0.0530396,
-0.1937256,
0.1270752,
-0.074646,
0.0602722,
0.1744385,
-0.173584,
0.0678101,
0.0728149,
0.00776291,
-0.0930786,
-0.036499,
0.0749512,
-0.01765442,
-0.002195358,
0.1326904,
-0.0874023,
0.1127319,
-0.054657,
0.1045532,
0.2224121,
-0.114563,
0.0655518,
0.0773315,
0.168335,
0.0563354,
0.056427,
0.0633545,
0.0559998,
-0.016922,
-0.1712646,
0.2211914,
-0.1013794,
-0.1119995
]
},
"trackable_id": null
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"p": "4429486",
"site_id": {
"string": "77"
},
"js_ev_mak": {
"string": "c79ee45118d0acb56572a2d5ffcc1b77"
},
"js_ev_orgn": null,
"current_price": {
"string": "485.0"
},
"current_price_usd": {
"string": "566.3345"
},
"item_id": {
"string": "135522596272"
},
"item_condition": {
"int": 3000
},
"item_title": {
"string": "Apple iPhone 15 Pro - 128 256 512 1TB - Titan Schwarz Weiß Natur Blau - XXL Set"
},
"l1_cat_id": {
"string": "9355"
},
"l2_cat_id": null,
"leaf_cat_id": {
"string": "9355"
},
"meta_cat_id": {
"string": "15032"
},
"sale_type_enum": {
"string": "9"
},
"shipping_country_id": {
"int": 77
},
"time_remain_secs": {
"string": "2403523"
},
"timestamp": {
"long": 1777590012094
},
"collection_id": null,
"source_impression_id": null,
"current_impression_id": {
"string": "nwTuhzk*"
},
"sellerid": {
"string": "2410677789"
},
"product_ref_id": null,
"product_type": null,
"listing_site_id": {
"string": "77"
},
"browsing_site_id": {
"string": "77"
},
"is_bu": false,
"is_udid": false,
"is_userid": false,
"is_cguid": true,
"respCode": null,
"numOfThemes": null,
"pidinstock": null,
"saasll": null,
"theme_details": null,
"item_details": null,
"variation_id": {
"string": "434891463927"
},
"version_id": {
"string": "5756902112003"
},
"ImgSimEmbA": {
"array": [
2110134451,
-628149956,
80639514,
1388860121,
655287963,
-1221906580,
1670663885,
57131016,
1681480719,
80486682,
-1417920793,
1908722439,
-1273086146,
-790283737,
500977202,
68507896,
-1641945700,
-1196267183,
978807729,
791238579,
1408974351,
831229810,
-895110568,
1068435772,
-638256464,
1760478129,
-132509193,
-589701587,
-530036293,
1895005389,
-25483906,
-664825171,
185159342,
1878067671,
-1916939760,
280626982,
1391752112,
1299115599,
-53478774,
1454814834,
-1943653878,
-1779093610,
-438482598,
1441079990,
-511264812,
-665902472,
1910285275,
-1403504109,
1381190265,
-1694053723,
1190389213,
-955931074,
-463277926,
-583208965,
686648452,
266842308,
-1879242627,
-1063219234,
-1482250511,
-864957686,
-1305353975,
1191442461,
-556201641,
349664345
]
},
"ItemSimEmbA": null,
"QryItemSimEmbA": {
"array": [
0.1106567,
0.1275635,
0.02748108,
-0.01426697,
0.142334,
0.01399994,
-0.0445557,
-0.2479248,
0.02024841,
-0.01850891,
0.1442871,
0.1815186,
0.01899719,
-0.0544128,
-0.0830078,
-0.1876221,
0.00813293,
0.0650024,
0.00522232,
0.002304077,
-0.0649414,
0.0467529,
0.0721436,
0.0413513,
0.0617371,
-0.1687012,
-0.0872192,
-0.1867676,
-0.072876,
-0.0848999,
0.002182007,
0.0435181,
-0.02430725,
0.0408325,
-0.1217041,
0.0823975,
-0.0366211,
-0.1057739,
-0.0269165,
0.01361847,
-0.1124268,
-0.1315918,
0.0350037,
-0.0488892,
-0.1861572,
0.052948,
-0.1682129,
0.02815247,
-0.1211548,
-0.067688,
-0.0526733,
0.1855469,
-0.0509644,
0.1295166,
0.0428467,
0.02529907,
0.1149902,
-0.1497803,
-0.0630493,
0.0620728,
-0.00754547,
-0.2110596,
-0.1057739,
-0.086792,
0.0940552,
0.00512314,
0.0662842,
0.0365295,
-0.0996094,
0.00792694,
0.0898438,
0.02365112,
-0.1456299,
-0.01340485,
0.1157227,
-0.1072388,
0.0829468,
0.1430664,
-0.0783081,
0.184082,
0.0578308,
0.0736694,
0.1472168,
-0.0993042,
0.0565491,
0.1039429,
0.1586914,
0.0949097,
0.1243896,
0.0872192,
0.00418091,
-0.1193237,
-0.1219482,
0.2416992,
-0.0864868,
-0.0625076
]
},
"trackable_id": null
}
],
"trans": [],
"add2cart": [
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"item_id": {
"string": "147247683705"
},
"site_id": {
"int": 77
},
"listing_site_id": {
"int": 3
},
"timestamp": {
"long": 1777587476754
},
"variation_id": {
"string": "445697932073"
},
"item_title": {
"string": "Apple iPhone 14 Pro | 128GB/256GB | Very Good Condition | New Battery | Warranty"
},
"item_quantity": {
"int": 1
},
"leaf_cat_id": {
"string": "9355"
},
"carted_time": {
"long": 1777587476000
}
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"item_id": {
"string": "376987050753"
},
"site_id": {
"int": 77
},
"listing_site_id": {
"int": 77
},
"timestamp": {
"long": 1777580635702
},
"variation_id": {
"string": "0"
},
"item_title": {
"string": "Apple iPhone 14 Pro - 128GB - Silber (Ohne Simlock) + Rechnung + GARANTIE "
},
"item_quantity": {
"int": 1
},
"leaf_cat_id": {
"string": "9355"
},
"carted_time": {
"long": 1777580635000
}
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"item_id": {
"string": "327124232699"
},
"site_id": {
"int": 77
},
"listing_site_id": {
"int": 77
},
"timestamp": {
"long": 1777580603127
},
"variation_id": {
"string": "0"
},
"item_title": {
"string": "Apple iPhone 14 Pro - 128 GB - Spacegrau Schwarz - Zustand: SEHR GUT"
},
"item_quantity": {
"int": 1
},
"leaf_cat_id": {
"string": "9355"
},
"carted_time": {
"long": 1777580602000
}
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"item_id": {
"string": "397854943056"
},
"site_id": {
"int": 77
},
"listing_site_id": {
"int": 77
},
"timestamp": {
"long": 1777239215861
},
"variation_id": {
"string": "0"
},
"item_title": {
"string": "Apple iPhone 14 Pro - 128GB - Schwarz (Ohne Simlock) - Exzellent"
},
"item_quantity": {
"int": 1
},
"leaf_cat_id": {
"string": "9355"
},
"carted_time": {
"long": 1777239214000
}
},
{
"u": {
"string": "guid:c79ee45118d0acb56572a2d5ffcc1b77"
},
"item_id": {
"string": "186893097181"
},
"site_id": {
"int": 77
},
"listing_site_id": {
"int": 77
},
"timestamp": {
"long": 1776975936614
},
"variation_id": {
"string": "694954398163"
},
"item_title": {
"string": "Apple iPhone 14 Pro 5G Smartphone 128GB 256GB 512GB 1TB Schwarz Gold"
},
"item_quantity": {
"int": 1
},
"leaf_cat_id": {
"string": "9355"
},
"carted_time": {
"long": 1776975935000
}
}
],
"watch": [],
"search_recent_queries": [
{
"search_query": {
"string": "iphone 15 pro max"
},
"timestamp": {
"long": 1777590248222
}
},
{
"search_query": {
"string": "iphone 16"
},
"timestamp": {
"long": 1777587555616
}
},
{
"search_query": {
"string": "iphone 14 pro"
},
"timestamp": {
"long": 1777587548462
}
},
{
"search_query": {
"string": "iphone 15 pro"
},
"timestamp": {
"long": 1777587245505
}
},
{
"search_query": {
"string": "iphone"
},
"timestamp": {
"long": 1777586958882
}
}
],
"models": [
{
"id": 100,
"name": "avg_rel_mean_price_score",
"key1": "num_vis",
"value1": 3,
"key2": "mean",
"value2": 419.59,
"key3": "threshold_met",
"value3": 1,
"key4": "score",
"value4": 0.96,
"key5": "leaf_cat_id",
"value5": 9355
},
{
"id": 101,
"name": "price_predictor",
"key1": "num_vis",
"value1": 5,
"key2": "max_timediff",
"value2": 243.00,
"key3": "pred_price_lm",
"value3": 192.79,
"key4": "pred_price_mean",
"value4": 443.96,
"key5": "pred_price_decay",
"value5": 0,
"titlekey1": "freq2_title",
"titlevalue1": "zustand spacegrau simlock silber sehr schwarz rechnung pro ohne iphone gut gb garantie apple 14 128gb 128 + ",
"titlekey2": "freq1_title",
"titlevalue2": "zustand xxl weiß titan spacegrau simlock silber set sehr schwarz rechnung pro ohne natur iphone gut gb garantie blau apple 512 256 1tb 15 14 128gb 128 + ",
"debug_key1": "prices",
"debug_value1": "[432.049, 394.6826, 432.049, 394.6826, 566.3345]",
"debug_key2": "lm_weights",
"debug_value2": "[0.296325, 0.174704, 0.136706, 0.164147, 0.151548]",
"debug_key3": "stddev",
"debug_value3": "63.428363",
"debug_key4": "coeff_of_var",
"debug_value4": "0.142870",
"debug_key5": "abs_rel_diffs",
"debug_value5": "['0.09', '0.09', '0.09', '0.30']",
"debug_key6": "score",
"debug_value6": "0.86",
"debug_key7": "leaf_cat_id",
"debug_value7": "9355"
},
{
"id": 102,
"name": "user_history",
"key1": "time_since_regstr_sec",
"value1": -1,
"key2": "num_searches",
"value2": 176,
"key3": "num_vis",
"value3": 157,
"key4": "time_since_oldest_event_sec",
"value4": 14186814,
"key5": "prev_srp_recall_size",
"value5": 8272
},
{
"id": 103,
"name": "item_buyer_affinity",
"key1": "price_pref",
"value1": 0.877213,
"key2": "gender",
"value2": 0,
"key3": "bin_pref",
"value3": 0.980000,
"key4": "new_pref",
"value4": 0.390000,
"key5": "pred_price_mean",
"value5": 0.010464,
"key6": "pred_price_sd",
"value6": 0.872629
},
{
"id": 104,
"name": "transaction_model",
"titlekey1": "freq2_title",
"titlevalue1": "",
"titlekey2": "freq1_title",
"titlevalue2": ""
}
]
}""",
buyer_country_id: 77,
buyer_gps_x: 6369,
buyer_gps_y: 4328,
buyer_gps_z: 7081,
buyer_latitude: 52.136084,
buyer_longitude: 8.707823,
buyer_preferred_language: de,
buyer_region: 0,
buyer_registration_country_id: 77,
buyer_site_id: 77,
buyer_zipcode: 33818,
category_depth: 2,
category_id: 9355,
category_path: "0.15032.9355/100",
channel: mweb,
client_ip: "91.8.53.105",
client_name: "urn:ebay-marketplace-consumerid:13051638-8fe9-4380-8d03-c2b176530b4a",
cpc_budget_pacing_treatment: A,
cpc_click_predictor_calibrator: CPC_ClickOrNot_v3_6_13_1day_calib,
currency_exchange_rate: 0.8547008547008548,
destination_country_id: 77,
destination_gps_x: 6362,
destination_gps_y: 4327,
destination_gps_z: 7086,
destination_region: 0,
destination_zipcode: 32049,
disable_bp_cpc_auto: 0,
disable_bp_cpc_manual: 0,
disable_fic_video_filters: 0,
disable_seller_id_tf_dedup: 0,
dominant_category_id: 9355,
dominant_category_path: "0.15032.9355/99",
enable_authenticity_guarantee_policy_adjustment_overwrite: 0,
enable_dynamic_query_expansion: 1,
enable_epid_expansion: 1,
enable_fic: 1,
enable_fic_video_profile: 1,
enable_item_ebr_recovery: 1,
enable_kand_expressions: 1,
enable_knowledge_service_rewrite_aspect_intent_size: 0,
enable_profile_lookup: 1,
enable_purchase_history: 1,
enable_test_pool: 1,
enable_translation: 1,
enable_trending_favorites_profile: 1,
ep_variant_ids: "305926,300959,304719,305579,305628,305827,305945,298178,305360,305284",
"epid_expansion.enable_category_whitelist": 0,
"epid_expansion.seed_filter": "model(Global_GradedRelevance_PEGFB_3_1)>3.0",
exports_CAPriorityShippingDDP_test: 1,
exports_CAPriorityShippingDDU_test: 1,
factor_name_tf_trending_score_filter: "cassini-mlr-artifacts/features/factor:Item_RevenueOptimizedTrendingScoreTFModuleV3",
factor_name_tf_trending_score_filter_xt: "cassini-mlr-artifacts/features/factor:Item_TrendingScoreTFModuleV3",
fic_video_relevance_threshold_multiplier_other_sites: 1,
fic_video_relevance_threshold_multiplier_us: 1,
fic_video_sales_count_filter_threshold: 0,
fic_video_seller_feedback_score_threshold: 0,
fic_video_seller_positive_feedback_rate_threshold: 0,
fic_video_shipping_fee_filter_threshold: 999999,
fic_video_treatment_name: fic_video_cpc,
guid: c79ee45118d0acb56572a2d5ffcc1b77,
is_auto_targeting_auto_bidding_cpc_enabled: 1,
is_destination_gbh_country: 0,
is_gbh: 0,
is_null_low_enabled: 1,
is_page2_enabled_trending_favorites: 1,
is_spell_auto_correct_enabled: 1,
is_vintage_pna_query: 0,
"item_ebr_recovery.embedding_field": ItemSimEmbB,
"item_ebr_recovery.max_distance": 0.2,
"item_ebr_recovery.min_docs": 3000,
"item_ebr_recovery.num_seeds": 5,
"item_ebr_recovery.recall_threshold": 40,
"item_ebr_recovery.seed_filter": "model(Global_GradedRelevance_PEGFB_5_1)>2.8",
"item_ebr_recovery.sort_direction": descending,
"item_ebr_recovery.sort_field": "model(Global_GradedRelevance_PEGFB_5_1)",
item_format_filter: bin,
locale: de_DE,
marketplace_id: "EBAY-DE",
mlr_calibration_fp_coefficient: 0.095,
model_name_cpc_ranker: "cassini-mlr-artifacts/models/ads/cpc:CPC_ClickOrNot_v3_6_13",
model_name_organic_bm_ebr_relevance_filter: "models/relevance:Relevance_EGFB_HY_NER_6_3",
model_name_organic_ranker: "models/ranking:masterRefreshModel_contextualCombo_1DShortIMA_R77",
model_name_organic_relevance_filter_bestmatch_launched_removing_catdem: "models/relevance:Relevance_EGFB_HY_NER_6_3",
model_name_tf_item_filter: "cassini-mlr-artifacts/models/ads/adstreams:model_trending_favorites_v0",
model_version_Buyer_CPA_UserID_Category_Encoding_v1: 3,
model_version_Item_CPA_LeafCat1_Category_Encoding_v1: 3,
multiple_dominant_category_path: "0.15032.9355/99",
null_low_threshold: 50,
partner_id: 2,
pickup_radius: 25,
query_descriptor: """{
"basic_info": [
{
"variant": "default",
"component_status": 0,
"original_token_list": "iphone 15 pro max",
"site_id": "77",
"tracker_id": "9ad35a18-6e08-4934-97c1-c9f255c2e3e5"
}
],
"category_aspect": [
{
"variant": "default",
"component_status": 0,
"dependencies": {
"query_intent_classification": "motors",
"speller": "default"
},
"category_demand": {
"categories": []
},
"dominant_category": {
"categories": [
{
"has_dominant_category": true,
"dominant_category": 9355,
"dominant_category_result": 0,
"dominant_category_path": "0.15032.9355/60",
"multi_category_path": "0.15032.9355/60",
"total_clicks": 2,
"score": 99
}
],
"has_ft_fallback": false
},
"auto_applicable_constraints": {
"constraints": [
{
"category_id": 9355,
"version": 0,
"category_id_set": [],
"aspects": []
}
]
}
}
],
"query_intent_classification": [
{
"variant": "default",
"component_status": 0,
"dependencies": {
"speller": "default"
},
"query_intents": []
},
{
"variant": "motors",
"component_status": 0,
"dependencies": {
"query_intent_classification": "default",
"speller": "default"
},
"query_intents": []
}
],
"speller": [
{
"variant": "default",
"component_status": 0,
"has_spell_suggestion": false
}
]
}""",
query_metadata: """{
"intents_ebay_live": [
{
"channelAvailable": false
},
{
"channelAvailable": false
}
]
}""",
relevance_filter_BM_threshold_launched_origin_of_recall: 2.26,
relevance_filter_BM_threshold_launched_removing_catdem: 2.14,
relevance_filter_NL_threshold_launched_removing_catdem: 1.55,
river_carousel_modules: """[
"fic",
"deals",
"popular_brand",
"trending_favorites",
"related_brands",
"top_picks"
]""",
site_id: 77,
sort_type: best_match,
tf_max_same_seller: 2,
tf_model_name_relevance_filter: Global_GradedRelevance_PEGFB_6_1,
tf_model_score_threshold: 0.0,
tf_query_level_price_stats_filter_min: 0.0,
tf_query_level_price_stats_filter_min_xt: -10000.0,
tf_relevance_threshold: 3.03,
tf_trending_score_threshold: 0.05,
tf_trending_score_threshold_xt: 0.05,
translation_site_id: 77,
use_case: buying_item_search_unified_ranking_nofilter,
use_ratetables_txt: 1,
use_shipping_params_table: 1,
user_agent: """{
"userExperience": "Mobile Web",
"isBot": false,
"isTablet": false,
"browserName": "Chrome",
"browserVersion": "146.0.7680.177",
"osName": "Samsung SM-A137F Galaxy A13",
"osVersion": "14.0.0"
}""",
view_type: LIST
}(
input: "exp_item_active+exp_seller",
tracker: "e9624a6d-8221-49a5-a7e7-55627ae6b94e",
select: and(
in_section{
tagged_constraint: keyword_constraint,
user_constraint: 1
}(
title,
raw_user_query("iphone 15 pro max", thunderstone)),
macro(SafeStartTime) <= term_int64(synthetic, query_container, QueryTime),
term_int64("exp_item_active+exp_seller", attribute, EndTime) >= term_int64(synthetic, query_container, QueryTime) + 10,
macro(MskuView,
1),
macro{
tagged_constraint: site_constraint
}(ShowInSite5,
77,
8),
hasvalue{
auto_applied: 1,
tagged_constraint: category_constraint,
user_constraint: 1
}(
term_mvalue_int64("exp_item_active+exp_seller", attribute, AllCats),
9355),
or{
tagged_constraint: list_type_constraint,
user_constraint: 1
}(
macro(SaleClass,
2)),
le{
tagged_constraint: max_price_constraint,
user_constraint: 1
}(
term_int64("exp_item_active+exp_seller", attribute, NBinPrice),
58385),
macro(MayShippedToCountryPostalCode,
77,
"32049"),
or(
term_bool("exp_item_active+exp_seller", attribute, LocalOnly) == false,
GetBOPISDistance() >= 0.0)),
named_expressions: [
FastEddIndex: macro(LessEqualShippingEDDServiceIDIndex,
3)
],
subqueries: [
query{
append_columns: 1,
has_relevance_sort: 1,
is_recall_query: 1,
page_size: 0
}(
output: findItems,
input: "exp_item_active+exp_seller",
dedupe: [
ParentID: dedupe_unless(
term_int64("exp_item_active+exp_seller", attribute, ParentID),
term_int64("exp_item_active+exp_seller", attribute, ParentID) == 0)
],
sort: [
relevance_sort_AsSortable: descending(
relevance_sort()
)
],
fields: [
ItemID: term_int64("exp_item_active+exp_seller", attribute, ItemID),
Title: term_blob("exp_item_active+exp_seller", attribute, Title),
ItemSubtitle: term_blob("exp_item_active+exp_seller", attribute, ItemSubtitle),
AllCats: term_mvalue_int64("exp_item_active+exp_seller", attribute, AllCats),
Site: term_int64("exp_item_active+exp_seller", attribute, Site),
Ctry: term_int64("exp_item_active+exp_seller", attribute, Ctry),
USLevel: term_int64("exp_item_active+exp_seller", attribute, USLevel),
PostCode: term_blob("exp_item_active+exp_seller", attribute, PostCode),
CurrentPrice: term_int64("exp_item_active+exp_seller", attribute, CurrentPrice),
MinPrice: term_int64("exp_item_active+exp_seller", attribute, MinPrice),
MaxPrice: term_int64("exp_item_active+exp_seller", attribute, MaxPrice),
Bids: term_int64("exp_item_active+exp_seller", attribute, Bids),
BinPrice: term_int64("exp_item_active+exp_seller", attribute, BinPrice),
CurrencyID: term_int64("exp_item_active+exp_seller", attribute, CurrencyID),
UKLevel: term_int64("exp_item_active+exp_seller", attribute, UKLevel),
DELevel: term_int64("exp_item_active+exp_seller", attribute, DELevel),
GlobalLevel: term_int64("exp_item_active+exp_seller", attribute, GlobalLevel),
"MACRO(eBayPicURL)": term_int64(synthetic, macro, eBayPicURL),
ParenteBayPicURLInCaty: term_bool("exp_item_active+exp_seller", attribute, ParenteBayPicURLInCaty),
"MACRO(EffectiveStartTime)": macro(EffectiveStartTime),
OriginalStartTime: term_int64("exp_item_active+exp_seller", attribute, OriginalStartTime),
EndTime: term_int64("exp_item_active+exp_seller", attribute, EndTime),
LastSaleTime: term_int64("exp_item_active+exp_seller", attribute, LastSaleTime),
eBayGalFeatured: term_bool("exp_item_active+exp_seller", attribute, eBayGalFeatured),
GalleryOffset: term_blob("exp_item_active+exp_seller", attribute, GalleryOffset),
ImgHeight: term_int64("exp_item_active+exp_seller", attribute, ImgHeight),
ImgWidth: term_int64("exp_item_active+exp_seller", attribute, ImgWidth),
eBayAdult: term_bool("exp_item_active+exp_seller", attribute, eBayAdult),
eBayBin: term_bool("exp_item_active+exp_seller", attribute, eBayBin),
eBayGal: term_bool("exp_item_active+exp_seller", attribute, eBayGal),
IsMsku: term_bool("exp_item_active+exp_seller", attribute, IsMsku),
"MACRO(IsSif)": term_int64(synthetic, macro, IsSif),
a4088: term_mvalue_blob("exp_item_active+exp_seller", attribute, a4088),
ZoomGUID: term_blob("exp_item_active+exp_seller", attribute, ZoomGUID),
ParentZoomGUID: term_blob("exp_item_active+exp_seller", attribute, ParentZoomGUID),
ParentGalleryVer: term_int64("exp_item_active+exp_seller", attribute, ParentGalleryVer),
ParentSuperGalleryVersion: term_int64("exp_item_active+exp_seller", attribute, ParentSuperGalleryVersion),
ParentSuperGalleryCount: term_int64("exp_item_active+exp_seller", attribute, ParentSuperGalleryCount),
PhotosZoomGUIDs: term_mvalue_blob("exp_item_active+exp_seller", attribute, PhotosZoomGUIDs),
MskuPictureTrait: term_int64("exp_item_active+exp_seller", attribute, MskuPictureTrait),
"MACRO(SafeStartTime)": macro(SafeStartTime),
eBaySaleType: term_int64("exp_item_active+exp_seller", attribute, eBaySaleType),
GalleryVer: term_int64("exp_item_active+exp_seller", attribute, GalleryVer),
SellerID: term_int64("exp_item_active+exp_seller", attribute, SellerID),
SuperGalleryVersion: term_int64("exp_item_active+exp_seller", attribute, SuperGalleryVersion),
StartTime: term_int64("exp_item_active+exp_seller", attribute, StartTime),
SuperGalleryCount: term_int64("exp_item_active+exp_seller", attribute, SuperGalleryCount),
MskuTraitNames: term_mvalue_blob("exp_item_active+exp_seller", attribute, MskuTraitNames),
MskuTraitValues: term_mvalue_blob("exp_item_active+exp_seller", attribute, MskuTraitValues),
MskuTraitOrder: term_mvalue_int64("exp_item_active+exp_seller", attribute, MskuTraitOrder),
eBayPayPal: term_bool("exp_item_active+exp_seller", attribute, eBayPayPal),
IsLot: term_bool("exp_item_active+exp_seller", attribute, IsLot),
eBayChar: term_bool("exp_item_active+exp_seller", attribute, eBayChar),
IsOnPromotionSale: term_bool("exp_item_active+exp_seller", attribute, IsOnPromotionSale),
FastShipping: term_bool("exp_item_active+exp_seller", attribute, FastShipping),
BestOffer: term_bool("exp_item_active+exp_seller", attribute, BestOffer),
ProductType: term_mvalue_blob("exp_item_active+exp_seller", attribute, ProductType),
CompoundQuantity: term_int64("exp_item_active+exp_seller", attribute, CompoundQuantity),
a9300: term_int64("exp_item_active+exp_seller", attribute, a9300),
a4128: term_int64("exp_item_active+exp_seller", attribute, a4128),
a4131: term_int64("exp_item_active+exp_seller", attribute, a4131),
a4129: term_int64("exp_item_active+exp_seller", attribute, a4129),
a4130: term_int64("exp_item_active+exp_seller", attribute, a4130),
SYIAutoPaySelectedFlag: term_bool("exp_item_active+exp_seller", attribute, SYIAutoPaySelectedFlag),
SellerImageDetail: term_blob("exp_item_active+exp_seller", attribute, SellerImageDetail),
SellerTargetURL: term_blob("exp_item_active+exp_seller", attribute, SellerTargetURL),
IsBrandedSeller: term_bool("exp_item_active+exp_seller", attribute, IsBrandedSeller),
IsRetailSeller: term_bool("exp_item_active+exp_seller", attribute, IsRetailSeller),
CompletedSuccessfully: term_bool("exp_item_active+exp_seller", attribute, CompletedSuccessfully),
MotorsSubmodel: term_mvalue_blob("exp_item_active+exp_seller", attribute, MotorsSubmodel),
MotorsSubtitle: term_mvalue_blob("exp_item_active+exp_seller", attribute, MotorsSubtitle),
a4148: term_mvalue_blob("exp_item_active+exp_seller", attribute, a4148),
IsOutletSeller: term_bool("exp_item_active+exp_seller", attribute, IsOutletSeller),
IsExemptSpecialitySeller: term_bool("exp_item_active+exp_seller", attribute, IsExemptSpecialitySeller),
LeafCats: term_mvalue_int64("exp_item_active+exp_seller", attribute, LeafCats),
QuantitySold: term_int64("exp_item_active+exp_seller", attribute, QuantitySold),
Quantity: term_int64("exp_item_active+exp_seller", attribute, Quantity),
EFlags: term_int64("exp_item_active+exp_seller", attribute, EFlags),
SoldAsBestOffer: term_bool("exp_item_active+exp_seller", attribute, SoldAsBestOffer),
AutotagProdRefId: term_int64("exp_item_active+exp_seller", attribute, AutotagProdRefId),
ItemHttpsCompliant: term_bool("exp_item_active+exp_seller", attribute, ItemHttpsCompliant),
ItemFeedbackTotal: term_int64("exp_item_active+exp_seller", attribute, ItemFeedbackTotal),
ItemFeedbackAverageRating: term_int64("exp_item_active+exp_seller", attribute, ItemFeedbackAverageRating),
"MACRO(ShippingNumLegs)": macro(ShippingNumLegs),
"MACRO(ShippingLegsCost)": macro(ShippingLegsCost),
"MACRO(ShippingLegsServiceId)": macro(ShippingLegsServiceId),
"MACRO(ShippingLegsSourceCountry)": macro(ShippingLegsSourceCountry),
"MACRO(ShippingLegsSourcePostalCode)": macro(ShippingLegsSourcePostalCode),
"MACRO(ShippingLegsDestCountry)": macro(ShippingLegsDestCountry),
"MACRO(ShippingLegsDestPostalCode)": macro(ShippingLegsDestPostalCode),
"MACRO(ShippingLegsHandlingDays)": macro(ShippingLegsHandlingDays),
"MACRO(ShippingLegsHandlerId)": macro(ShippingLegsHandlerId),
"MACRO(ShippingLegsHandlerType)": macro(ShippingLegsHandlerType),
"MACRO(ShippingLegsHandlerCutoffInfo)": macro(ShippingLegsHandlerCutoffInfo),
"MACRO(EEKRating)": macro(EEKRating),
"MACRO(EEKRange)": macro(EEKRange),
SellerEEKLabelZoomGUID: term_blob("exp_item_active+exp_seller", attribute, SellerEEKLabelZoomGUID),
a650: term_int64("exp_item_active+exp_seller", attribute, a650),
ShipToLocations2_new: term_mvalue_int64("exp_item_active+exp_seller", attribute, ShipToLocations2_new),
FlatShipCost: term_mvalue_int64("exp_item_active+exp_seller", attribute, FlatShipCost),
InsuranceReqdFlag: term_bool("exp_item_active+exp_seller", attribute, InsuranceReqdFlag),
ShippingFlag: term_int64("exp_item_active+exp_seller", attribute, ShippingFlag),
"MACRO(shipcalc_arg7,Fu,Fa,77,32049,0,0,5)": macro(shipcalc_arg7,
Fu,
Fa,
77,
32049,
0,
0,
5),
a228: term_int64("exp_item_active+exp_seller", attribute, a228),
"MACRO(AuthenticityGuaranteed)": macro(AuthenticityGuaranteed),
PromotedListingCampaignIDs: term_mvalue_int64("exp_item_active+exp_seller", attribute, PromotedListingCampaignIDs),
PromotedListingAdRates: term_mvalue_float("exp_item_active+exp_seller", attribute, PromotedListingAdRates),
PromotedListingAdvertiserIDs: term_mvalue_int64("exp_item_active+exp_seller", attribute, PromotedListingAdvertiserIDs),
PromotedListingEndTimes: term_mvalue_int64("exp_item_active+exp_seller", attribute, PromotedListingEndTimes),
PromotedListingCriteoCampaignID: term_int64("exp_item_active+exp_seller", attribute, PromotedListingCriteoCampaignID),
PromotedListingCriteoAdRate: term_float("exp_item_active+exp_seller", attribute, PromotedListingCriteoAdRate),
PromotedListingBid: term_int64("exp_item_active+exp_seller", attribute, PromotedListingBid),
PromotedListingCampaignID: term_int64("exp_item_active+exp_seller", attribute, PromotedListingCampaignID),
CPCAdGroupIDs: term_mvalue_int64("exp_item_active+exp_seller", attribute, CPCAdGroupIDs),
PLXAdFee: term_int64("exp_item_active+exp_seller", attribute, PLXAdFee),
PLXAdFeeCurrency: term_blob("exp_item_active+exp_seller", attribute, PLXAdFeeCurrency),
SmeOfferId: term_int64("exp_item_active+exp_seller", attribute, SmeOfferId),
SmeOfferType: term_int64("exp_item_active+exp_seller", attribute, SmeOfferType),
SmeEncOfferMsg: term_int64("exp_item_active+exp_seller", attribute, SmeEncOfferMsg),
SmeStartDate: term_int64("exp_item_active+exp_seller", attribute, SmeStartDate),
SmeEndDate: term_int64("exp_item_active+exp_seller", attribute, SmeEndDate),
SmeOfferMsg: term_blob("exp_item_active+exp_seller", attribute, SmeOfferMsg),
"ATTR(DEAL_TYPE,cat)": term_int64("exp_item_active+exp_seller", cat, DEAL_TYPE),
IMInXCarts: term_int64("exp_item_active+exp_seller", attribute, IMInXCarts),
SellerName: const{
PseudoAttribute: SellerName
}(""),
ItemCondition: term_int64("exp_item_active+exp_seller", attribute, ItemCondition),
UserDesignation: term_int64("exp_item_active+exp_seller", attribute, UserDesignation),
BopisStatus: term_int64("exp_item_active+exp_seller", attribute, BopisStatus),
a792: term_int64("exp_item_active+exp_seller", attribute, a792),
a793: term_int64("exp_item_active+exp_seller", attribute, a793),
a794: term_int64("exp_item_active+exp_seller", attribute, a794),
a795: term_int64("exp_item_active+exp_seller", attribute, a795),
WatchCount: term_int64("exp_item_active+exp_seller", attribute, WatchCount),
IsDailyDeal: term_int64("exp_item_active+exp_seller", attribute, IsDailyDeal),
IsDailyDealPerm: term_bool("exp_item_active+exp_seller", attribute, IsDailyDealPerm),
OriginalPrice: term_int64("exp_item_active+exp_seller", attribute, OriginalPrice),
SELLER_BADGE: term_blob("exp_item_active+exp_seller", attribute, SELLER_BADGE),
SELLER_BADGE_TYPE: term_int64("exp_item_active+exp_seller", attribute, SELLER_BADGE_TYPE),
SellerAccountType: term_int64("exp_item_active+exp_seller", attribute, SellerAccountType),
"ATTR(Brand,df)": term_mvalue_blob("exp_item_active+exp_seller", df, Brand),
"ATTR(RegEEKClass,df)": term_mvalue_blob("exp_item_active+exp_seller", df, RegEEKClass),
"ATTR(RegEEKClassRange,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKClassRange),
"ATTR(RegEEKDataCompleteness,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKDataCompleteness),
"ATTR(SellerEEKClass,df)": term_mvalue_blob("exp_item_active+exp_seller", df, SellerEEKClass),
"ATTR(SellerEEKClassRange,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, SellerEEKClassRange),
"ATTR(SellerEEKDataCompleteness,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, SellerEEKDataCompleteness),
"ATTR(RegEEKLabelZoomGUID,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKLabelZoomGUID),
"ATTR(RegEEKEnergyClassZoomGUID,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKEnergyClassZoomGUID),
"ATTR(RegEEKModelIdentifier,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKModelIdentifier),
"ATTR(RegEEKSizeDesignation,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKSizeDesignation),
"ATTR(RegEEKSupplierName,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKSupplierName),
"ATTR(RegEEKWetGripClass,df)": term_mvalue_blob("exp_item_active+exp_seller", df, RegEEKWetGripClass),
"ATTR(RegEEKTyreClass,df)": term_mvalue_blob("exp_item_active+exp_seller", df, RegEEKTyreClass),
"ATTR(RegEEKRollingNoiseValue,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKRollingNoiseValue),
"ATTR(RegEEKRollingNoiseClass,df)": term_mvalue_blob("exp_item_active+exp_seller", df, RegEEKRollingNoiseClass),
"ATTR(RegEEKProductionStartYear,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKProductionStartYear),
"ATTR(RegEEKProductionStartWeek,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKProductionStartWeek),
"ATTR(RegEEKProductionEndYear,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKProductionEndYear),
"ATTR(RegEEKProductionEndWeek,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, RegEEKProductionEndWeek),
"ATTR(RegEEKIsSevereSnowTyre,dyn_bool)": term_bool("exp_item_active+exp_seller", dyn_bool, RegEEKIsSevereSnowTyre),
"ATTR(RegEEKIsIceTyre,dyn_bool)": term_bool("exp_item_active+exp_seller", dyn_bool, RegEEKIsIceTyre),
"ATTR(SellerEEKProductFicheDocId,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, SellerEEKProductFicheDocId),
"ATTR(SellerEEKDataSheetZoomGUID,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, SellerEEKDataSheetZoomGUID),
"ATTR(SellerEEKLabelDocId,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, SellerEEKLabelDocId),
IsEPRELEEKOptedIn: term_bool("exp_item_active+exp_seller", attribute, IsEPRELEEKOptedIn),
"ATTR(SellerEEKLabelZoomGUID,dyn_string)": term_blob("exp_item_active+exp_seller", dyn_string, SellerEEKLabelZoomGUID),
PUDOEligibleItem: term_bool("exp_item_active+exp_seller", attribute, PUDOEligibleItem),
IsLAItem: term_bool("exp_item_active+exp_seller", attribute, IsLAItem),
QuantitySoldByLocal: term_int64("exp_item_active+exp_seller", attribute, QuantitySoldByLocal),
eBayPlusEligible: term_bool("exp_item_active+exp_seller", attribute, eBayPlusEligible),
"ATTR(ConditionNotBrokenScore,ssc)": term_int64("exp_item_active+exp_seller", ssc, ConditionNotBrokenScore),
"ATTR(DirectFromBrand,df)": term_mvalue_blob("exp_item_active+exp_seller", df, DirectFromBrand),
IsItemAuthenticated: term_bool("exp_item_active+exp_seller", attribute, IsItemAuthenticated),
"ATTR(Personalize,df)": term_mvalue_blob("exp_item_active+exp_seller", df, Personalize),
eBayLiveID: term_blob("exp_item_active+exp_seller", attribute, eBayLiveID),
eBayLiveState: term_blob("exp_item_active+exp_seller", attribute, eBayLiveState),
eBayLiveStartTS: term_int64("exp_item_active+exp_seller", attribute, eBayLiveStartTS),
eBayLiveEndTS: term_int64("exp_item_active+exp_seller", attribute, eBayLiveEndTS),
"AND(MACRO(ShowInLocation1,77,1),EQ(Site,77),EQ(eBayPayPal,true),LE(a228,1),EQ(a9501,1))": and(
macro(ShowInLocation1,
77,
1),
term_int64("exp_item_active+exp_seller", attribute, Site) == 77,
term_bool("exp_item_active+exp_seller", attribute, eBayPayPal) == true,
term_int64("exp_item_active+exp_seller", attribute, a228) <= 1,
term_int64("exp_item_active+exp_seller", attribute, a9501) == 1),
"AND(MACRO(ShowInLocation1,77,1),EQ(Site,77),LE(a228,1),EQ(a9502,1))": and(
macro(ShowInLocation1,
77,
1),
term_int64("exp_item_active+exp_seller", attribute, Site) == 77,
term_int64("exp_item_active+exp_seller", attribute, a228) <= 1,
term_int64("exp_item_active+exp_seller", attribute, a9502) == 1),
"MACRO(IsFastNFree)": macro(IsFastNFree),
"MACRO(CalendarDeliveryEstimate)": macro(CalendarDeliveryEstimate),
"MACRO(IsReturnFree,77)": macro(IsReturnFree,
77),
"MACRO(IsReturnAccepted,77)": macro(IsReturnAccepted,
77),
"MACRO(MustReturnWithinDays,77)": macro(MustReturnWithinDays,
77),
a3804: term_mvalue_int64("exp_item_active+exp_seller", attribute, a3804),
"ATTR(UnitQuantity,df)": term_mvalue_blob("exp_item_active+exp_seller", df, UnitQuantity),
"ATTR(UnitType,df)": term_mvalue_blob("exp_item_active+exp_seller", df, UnitType),
eBayGTC: term_bool("exp_item_active+exp_seller", attribute, eBayGTC),
"MACRO(SaleClass,1)": macro(SaleClass,
1),
"MACRO(SaleClass,2)": macro(SaleClass,
2),
"MACRO(SaleClass,8)": macro(SaleClass,
8),
"EQ(BestOffer,true)": term_bool("exp_item_active+exp_seller", attribute, BestOffer) == true,
eBayBold: term_bool("exp_item_active+exp_seller", attribute, eBayBold),
eBayGift: term_bool("exp_item_active+exp_seller", attribute, eBayGift),
eBayGalFeaturedInt: term_bool("exp_item_active+exp_seller", attribute, eBayGalFeaturedInt),
eBayGalInt: term_bool("exp_item_active+exp_seller", attribute, eBayGalInt),
eBayBorderInt: term_bool("exp_item_active+exp_seller", attribute, eBayBorderInt),
eBayHighlight: term_bool("exp_item_active+exp_seller", attribute, eBayHighlight),
eBayFeaturedInt: term_bool("exp_item_active+exp_seller", attribute, eBayFeaturedInt),
GiftIcon: term_int64("exp_item_active+exp_seller", attribute, GiftIcon),
SdAttrDisplay: term_blob("exp_item_active+exp_seller", attribute, SdAttrDisplay),
HashedThumbnailId: term_blob("exp_item_active+exp_seller", attribute, HashedThumbnailId),
ParentPhotoCount: term_int64("exp_item_active+exp_seller", attribute, ParentPhotoCount),
"ATTR(NMedianPrice,cat)": term_int64("exp_item_active+exp_seller", cat, NMedianPrice),
"ATTR(rpp_start,rpp)": term_mvalue_blob("exp_item_active+exp_seller", rpp, rpp_start),
"ATTR(rpp_end,rpp)": term_mvalue_blob("exp_item_active+exp_seller", rpp, rpp_end),
"MACRO(EstimatedDeliveryMaxDays)": macro(EstimatedDeliveryMaxDays),
"MACRO(EstimatedDeliveryMinDays)": macro(EstimatedDeliveryMinDays),
"MACRO(EstimatedDeliveryMinBusinessDays)": macro(EstimatedDeliveryMinBusinessDays),
"MACRO(EstimatedDeliveryMaxBusinessDays)": macro(EstimatedDeliveryMaxBusinessDays),
"MACRO(ShippingEstimatedDeliveryMaxBusinessDays)": macro(ShippingEstimatedDeliveryMaxBusinessDays),
"MACRO(VASEligibleProgramIDs,mval_int64(const_int64(12590978486),const_int64(17259771009),const_int64(23210553912),const_int64(16308205416),const_int64(60213778250),const_int64(81556377182),const_int64(97811266632),const_int64(99015252029),const_int64(106264605510),const_int64(131240813598)))": macro(VASEligibleProgramIDs,
mval_int64(
12590978486,
17259771009,
23210553912,
16308205416,
60213778250,
81556377182,
97811266632,
99015252029,
106264605510,
131240813598)),
"ATTR(ItemBestSellingEligible,ann_int64)": term_int64("exp_item_active+exp_seller", ann_int64, ItemBestSellingEligible),
"ATTR(MMImageEmbA,cub)": term_blob("exp_item_active+exp_seller", cub, MMImageEmbA),
"ATTR(BT_BuyerGroups,df)": term_mvalue_blob("exp_item_active+exp_seller", df, BT_BuyerGroups),
IMDiscountInPercent: term_int64("exp_item_active+exp_seller", attribute, IMDiscountInPercent),
SellerHandlingCutoffTime2: term_mvalue_int64("exp_item_active+exp_seller", attribute, SellerHandlingCutoffTime2),
"ATTR(27502,condition)": term_mvalue_int64("exp_item_active+exp_seller", condition, "27502"),
"ATTR(27501,condition)": term_mvalue_int64("exp_item_active+exp_seller", condition, "27501"),
ChangeTime: term_int64("exp_item_active+exp_seller", attribute, ChangeTime),
"MACRO(EEKProductFicheDocIdByLocale,DE)": macro(EEKProductFicheDocIdByLocale,
DE),
"ATTR(ks,df)": term_mvalue_blob("exp_item_active+exp_seller", df, ks),
"ATTR(VehicleMinMarketPriceLocal,cat)": term_int64("exp_item_active+exp_seller", cat, VehicleMinMarketPriceLocal),
"ATTR(VehicleMarketPriceLocal,cat)": term_int64("exp_item_active+exp_seller", cat, VehicleMarketPriceLocal),
"ATTR(VehicleMaxMarketPriceLocal,cat)": term_int64("exp_item_active+exp_seller", cat, VehicleMaxMarketPriceLocal),
"GETBOPISDISTANCE()": GetBOPISDistance(),
"GETEBNIMMEDIATEDISTANCE()": GetEBNImmediateDistance(),
"GETEBNSAMEDAYDISTANCE()": GetEBNSameDayDistance(),
"GETEBNNEXTDAYDISTANCE()": GetEBNNextDayDistance(),
VacationHoldMode: term_int64("exp_item_active+exp_seller", attribute, VacationHoldMode),
VacationHoldStartTime: term_int64("exp_item_active+exp_seller", attribute, VacationHoldStartTime),
VacationHoldEndTime: term_int64("exp_item_active+exp_seller", attribute, VacationHoldEndTime)
]
),
query(
output: "ITEM.findItems.groupby.GlobalFilters.SupplyCount.AUTHENTICITY_GUARANTEE",
input: "exp_item_active+exp_seller",
count: 3000,
group: [
"EQ(MACRO(HasVASFilterID,12590978486),true)": macro(HasVASFilterID,
12590978486) == true
],
sort: [
"AGGREGATE_COUNT()": descending(
aggregate_count()
)
]
),
query(
output: "ITEM.findItems.groupby.GlobalFilters.SupplyCount.HasAnyShippingEDD",
input: "exp_item_active+exp_seller",
count: 3000,
group: [
"EQ(MACRO(HasAnyShippingEDD),true)": macro(HasAnyShippingEDD) == true
],
sort: [
"AGGREGATE_COUNT()": descending(
aggregate_count()
)
]
),
query(
output: "ITEM.findItems.groupby.LH_ItemCondition#CountGroupby",
input: "exp_item_active+exp_seller",
count: 3000,
group: [
ItemCondition: term_int64("exp_item_active+exp_seller", attribute, ItemCondition)
],
sort: [
"AGGREGATE_COUNT()": descending(
aggregate_count()
)
]
),
query(
output: "ITEM.findItems.groupby.LH_ItemCondition#NotSpecifiedCountGb",
input: "exp_item_active+exp_seller",
count: 3000,
group: [
"AND(NOT(HASATTR(LH_SiteWideCondition)),NOT(HASATTR(ItemCondition)))": and(
not(
not(
isnull(
term_mvalue_blob("exp_item_active+exp_seller", attribute, LH_SiteWideCondition)))),
not(
not(
isnull(
term_int64("exp_item_active+exp_seller", attribute, ItemCondition)))))
],
sort: [
"AGGREGATE_COUNT()": ascending(
aggregate_count()
)
]
)
]
)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment