Download The Guide For The Maybelline TikTok Shop Dataset (September 2024)

This September 2024 TikTok Shop archive contains 40 listings from maybelline_th in Thailand. It is a historical store snapshot for practising listing classification and data-quality checks. All rows record September 20, 2024 and prices in Thai baht (THB); the file is not a current catalogue, a complete Maybelline range or a market-share report.

Verified coverage and source

Property	Verified workbook content
File	maybelline_th.xlsx
Worksheet	Sheet1; data range A1:L41
Coverage	40 listings, one shop_name value and 40 distinct product URLs
Market and platform	Thailand; THB; platform field TikTok
Observation date	September 20, 2024 in every updateTime value
Structure	12 named columns; header excluded from listing count

The review used the workbook linked from this article’s existing follow-up email and compared all 492 populated-range cells, including the header, against a separate text export. The worksheet also allocates 959 trailing empty rows; these are not additional listings. None of the 12 fields is blank in the 40 records, but populated fields alone do not establish accuracy, completeness or current availability.

What the 12 fields mean

Fields	How to use them
shop_name, name	Source store label and listing title. A store label is not a verified brand classification or proof of authorization.
url, imageUrl	Product and image references recorded in the snapshot. The product URLs contain 19-digit IDs; keep any extracted IDs as text.
country, currency, updateTime, platform	Market, currency, recorded date and source platform. Use these to prevent mixing countries, currencies or collection periods.
price, price_before_discount, discountPercent	Recorded price and reference-price fields. Validate gifts, bundles and selected variants before making comparisons.
historySold	A source sales counter. The workbook does not establish its reporting window, transaction definition, refunds or revenue.

There are no dedicated brand, SKU, shade, pack-quantity, variant-price-range or seller-ID columns. Those missing dimensions matter when matching lipstick shades, single products and bundles. Do not invent them from the price field; document any classification derived from a title in separate analysis columns.

Separate gifts, bundles and other brands

16 of the 40 titles contain [สินค้าแถม งดจำหน่าย], meaning a promotional gift that is not for sale. These rows still contain nonzero price values. Treat the title flag as a reason to inspect and classify the entry, rather than assuming that its recorded price is a normal retail offer.

For example, worksheet row 3 is Maybelline New York Lash Curler+Sticker with that gift marker, a recorded price of THB 2,169 and a reference price of THB 2,500. Row 40 is a gift-labelled Garnier Bright Complete Day & Night Serum 1.5ml. Its presence shows why filtering solely on shop_name = maybelline_th does not produce a Maybelline-only product set.

Three other titles contain the pair markers [เซ็ตคู่] or [แพ็คคู่]. Preserve these as a separate bundle flag and confirm the actual contents before comparing them with single items. A title-derived rule is a transparent starting point, not a complete product taxonomy.

Worked example: how gift rows change a price summary

Using the price column exactly as recorded, the unweighted mean across all 40 rows is THB 850.39, rounded to two decimals. If an analysis copy excludes only the 16 rows containing the exact gift marker above, 24 rows remain and their unweighted mean is THB 217.54. Keep the original workbook unchanged and record the rule alongside the result.

This calculation demonstrates sensitivity to classification. Neither number is an average market price: the remaining rows still mix product types, sizes and bundles, and the source does not identify the priced variant. Excluding gift-labelled rows also does not establish that every remaining listing was purchasable at the recorded price.

A separate arithmetic check uses worksheet row 2, SUPERSTAY LUMIMATTE FOUNDATION 35ml: THB 386 against a THB 499 reference gives (499 − 386) ÷ 499 × 100 = approximately 22.65%, consistent with the recorded 23% after rounding. The row’s historySold value of 24,761 has no verified period in this file; multiplying it by THB 386 would not establish September revenue.

A practical analysis workflow and its limits

Work from a copy, retain the original URLs and titles, and add separate gift, bundle and brand-classification columns. Review flagged rows, then compare like products with confirmed sizes and variants. For a later snapshot, match the product URL or text ID and verify the same variant before calculating any change.

This one-store snapshot cannot prove new-product demand, advertising return on investment, national sales trends or the completeness of a brand’s TikTok Shop presence. The original cover describes possible analysis themes, not measured outcomes from these 40 records. For a new collection, define stores, fields and refresh dates with our TikTok Shop data scraping service.

Request the September 2024 workbook