De-duplicated User-item Metrics for E-commerce Conversion Funnel Diagnosis: Method, Validation, and Operational Audit Cues

Aiwei Yang*
University of International Business and Economics, Beijing 100029, China
*Corresponding email: 493093145@qq.com
https://doi.org/10.71052/hkfb2025/RLVA3957

Consumer‑to‑consumer (C2C) e-commerce sellers routinely face high exposure but low conversion. Existing research, however, relies largely on qualitative descriptions or small-scale surveys and rarely exploits behavioral logs to pinpoint where buyers drop out. Using a public Taobao user-behavior data set from 2017 as a methodological benchmark, this study constructs a de-duplicated user-item conversion framework and cross-checks it against an event-count metric. Under the de-duplicated metric, only 5.640% of interested user-item pairs culminate in purchase – well below the 36.450% implied by raw event ratios – and 75.600% of completed purchases bypass the shopping cart entirely. Conversion peaks during 10:00-13:00 and troughs during 19:00-23:00; the top 10.000% of categories account for 67.900% of sales. The bottleneck is therefore a mismatch between traffic timing and category structure, not shopping-cart abandonment. The framework itself is portable across periods, although the exact time labels must be recalibrated as the platform environment changes. This study anchors its contribution in reusable structural diagnosis rather than in point predictions for any single period.

References
[1] Li, L., Fang, X., Lim, Y. F. (2023) Asymmetric information of product authenticity on C2C e-commerce platforms: How can inspection services help? Manufacturing & Service Operations Management, 25(2), 631-647.
[2] Wang, M., Zhang, J., Cheng, T. C. E. (2024) Sharing or reselling? How does manufacturer handle used products? Naval Research Logistics, 71(5), 645-659.
[3] Moriuchi, E., Takahashi, I. (2022) The role of perceived value, trust and engagement in the C2C online secondary marketplace. Journal of Business Research, 148, 76-88.
[4] Kas, J., Corten, R., van de Rijt, A. (2023) Trust, reputation, and the value of promises in online auctions of used goods. Rationality and Society, 35(4), 387-419.
[5] Wang, L. L., Sun, H. (2023) Influencing factors of second-hand platform trading in C2C e-commerce. Journal of Intelligent Management and Decision, 2(1), 21-29.
[6] Goldstein, A., Oestreicher-Singer, G., Barzilay, O., Yahav, I. (2022) Are we there yet? Analyzing progress in the conversion funnel using the diversity of searched products. MIS Quarterly, 46(4), 2015-2054.
[7] Pang, C., Jiang, L., Li, G. (2024) Cannibalization or enhancement: Effects of consumer-to-consumer resale with consumers’ utility dependence. International Journal of Electronic Commerce, 28(3), 416-446.
[8] Nadeem, W., Salo, J. (2024) Does value co-creation matter? Assessing consumer responses in the sharing economy. Information Technology & People, 37(3), 1279-1304.
[9] Heinrich, B., Hopf, M., Lohninger, D., Schiller, A., Szubartowicz, M. (2022) Something’s missing? A procedure for extending item content data sets in the context of recommender systems. Information Systems Frontiers, 24(1), 267-286.
[10] Lin, S. C., Tseng, H. T., Shirazi, F., Hajli, N., Tsai, P. T. (2023) Exploring factors influencing impulse buying in live streaming shopping: a stimulus-organism-response (SOR) perspective. Asia Pacific Journal of Marketing and Logistics, 35(6), 1383-1403.

Share and Cite
Yang, A. (2026) De-duplicated User-item Metrics for E-commerce Conversion Funnel Diagnosis: Method, Validation, and Operational Audit Cues. Hong Kong Financial Bulletin, 2(3), 1-9. https://doi.org/10.71052/hkfb2025/RLVA3957

Published

20/08/2026