Marketplace connections

TikTok Shop Analytics: The Seller Metrics That Explain Performance

Understand GMV, traffic, clicks, conversion, products, content channels, and refresh routines before building a TikTok Shop report in Google Sheets.

By the Spyliner team·10 min read

TikTok Shop performance is shaped by products, traffic sources, content, creators, advertising, and fulfilment. Looking at GMV alone tells you the outcome but not where the funnel improved or broke.

A useful report starts with a question, uses metrics from the same scope and period, and keeps marketplace definitions intact. This guide provides a practical framework; exact labels and available reports can differ by region, account type, permissions, and ongoing Seller Center updates.

01

Avoid dashboard wandering

Start with the decision, then choose the report

  • ✓Growth question: Which products, stores, or channels increased valid sales?
  • ✓Traffic question: Did impressions, product clicks, or visitors change?
  • ✓Conversion question: Are shoppers clicking but not ordering or paying?
  • ✓Content question: Which videos, LIVE sessions, creators, or product cards contributed traffic and sales?
  • ✓Operations question: Are cancellations, fulfilment problems, returns, or stock constraints reducing realised results?
02

Read the full system

Organize metrics into outcome, traffic, conversion, and operations

Outcome metrics include the marketplace's reported sales value, orders, units, buyers, refunds, and valid or completed results where available. Traffic metrics include impressions, product views, clicks, visitors, and traffic-source dimensions. Conversion metrics connect those stages, while operational metrics explain whether demand became a fulfilled and retained sale.

Do not combine values from different attribution windows or status definitions simply because the labels look similar. Record the source report, date basis, timezone, filters, and extraction time beside each dataset.

03

Find the weak stage

Read product performance as a funnel

  1. 1

    Exposure

    Track product or content impressions to understand whether the item is being shown.

  2. 2

    Interest

    Use product clicks, page views, or click-through measures to test the listing, creative, offer, and audience fit.

  3. 3

    Intent

    Review add-to-cart or checkout-related signals when available to locate friction after the product page.

  4. 4

    Purchase

    Use orders, buyers, paid sales, and conversion measures with consistent status and attribution definitions.

  5. 5

    Realisation

    Review cancellations, refunds, fulfilment, and completed outcomes so initial demand is not mistaken for retained revenue.

04

Different routes to purchase

Keep video, LIVE, affiliate, product-card, and advertising views distinct

Each channel has a different operating model. A video may accumulate views long after publication, a LIVE session has a fixed event window, an affiliate creator introduces commission and attribution questions, and paid advertising has campaign budgets and optimisation settings.

Build a common summary only after preserving channel-specific metrics. Compare contribution, trend, and efficiency within each channel before ranking unlike activities on a single ratio.

05

A manageable report

Build a weekly TikTok Shop scorecard in Google Sheets

  1. 1

    Keep raw tabs by dataset

    Separate product, order, advertising, creator, video, LIVE, or finance data so each source can be validated.

  2. 2

    Create a metric dictionary

    Document source, definition, date basis, attribution window, status scope, currency, and owner.

  3. 3

    Compare complete periods

    Mark the current incomplete day or week instead of comparing it directly with a completed period.

  4. 4

    Rank drivers

    Show which products and channels explain the change in sales, orders, traffic, and conversion.

  5. 5

    Add exception lists

    Surface products with traffic but weak conversion, strong demand but low stock, or high orders but rising cancellations.

  6. 6

    Record actions

    Assign an owner and follow-up date for pricing, listing, creator, inventory, advertising, or fulfilment actions.

06

Protect the interpretation

Avoid six common TikTok Shop reporting mistakes

  • ✓Comparing metrics from different attribution windows or timezones.
  • ✓Treating current-day data as complete.
  • ✓Mixing paid and organic results without a channel dimension.
  • ✓Ranking products by sales without checking traffic and conversion opportunity.
  • ✓Ignoring cancellations, refunds, fulfilment, stock, and late status changes.
  • ✓Changing column definitions or formulas without documenting the effective date.

Quick answers

Questions people usually ask

Which TikTok Shop metric should I check first?+

Start with the outcome tied to your decision, then move backward through orders, conversion, clicks, and impressions to locate the cause.

Why do TikTok Shop reports show different totals?+

Reports can use different date bases, attribution windows, statuses, currencies, channels, and update times. Compare the definitions and filters before comparing values.

Can I combine TikTok Shop analytics with other marketplaces?+

Yes, but preserve the original TikTok fields and definitions, then map them into a smaller canonical model for cross-marketplace reporting.