TikTok Shop is TikTok's built-in ecommerce platform, giving sellers a direct path to reach TikTok's global audience. By connecting TikTok Shop to Power My Analytics, you can bring your order, product, and seller performance data into Looker Studio, Google Sheets, and other destinations for comprehensive ecommerce reporting.

The TikTok Shop connector is currently in BETA. Features and data availability may change as the connector matures. Please submit a ticket if you encounter any unexpected behavior.

Prerequisites

Before you begin, make sure you have:

• An active TikTok Shop Seller Center account with Admin or Shop Owner access
• A TikTok Shop that is active and approved (not suspended or in a pending-review state)
• Your TikTok Shop Seller Center login credentials (authentication is handled via OAuth — no API keys are required)

Adding TikTok Shop as a Data Source

1. Navigate to your Hub and select Sources from the menu.
2. Click + Add new source and search for "TikTok Shop." Click the TikTok Shop tile.
3. You will be redirected to TikTok Shop's OAuth authorization page. Click Authorize, then sign in with your TikTok Shop Seller Center credentials and approve the requested data-access permissions.
4. Once authorized, you will be redirected back to PMA Hub and your shop will appear in your list of active sources.

If you manage multiple TikTok Shops under one seller account, select the specific shop you want to connect on the authorization screen. Each shop must be added to Power My Analytics as a separate source.

Region note: US, UK, and Southeast Asia (SEA) TikTok Shops each use their own regional Seller Center for authorization. Make sure you sign in to the correct regional Seller Center for your shop.

Creating a Looker Studio Report

1. After adding TikTok Shop as a data source in the PMA hub, navigate to Reports > Looker Studio.
2. Select TikTok Shop under Create Looker Studio Report (this will open the official Looker Studio application in a new window).
3. Complete the Google Looker Studio configuration:
   • Step 1: Name your data source (e.g., "TikTok Shop - Organization Name"), choose your Power My Analytics hub from the dropdown, and click Next.
   • Step 2: Select your TikTok Shop account (real data) or "Sample Account" (sample data), then click Next.
   • Step 3: Choose "Clients" for reports, then click Connect (top right).
   • Step 4: Click Create Report (top right).

For a quick start, use our pre-built TikTok Shop demo template.

Key Reports and Fields

TikTok Shop data in Power My Analytics covers your shop's orders, products, and seller performance. Here are popular data groups you can use in your reports:

1. Key Performance Metrics: GMV by Date, Product Name, Day of Week; Gross Revenue; Orders by Status, Fulfillment Type; Items Sold; Customers; Avg. Order Value; Items/Order
   
2. Orders Metrics: GMV, Payment Total Amount, Discount Amount by Order ID, Create Time, Status, Fulfillment Type, Shipping Type, Warehouse ID, Recipient Region Code; Orders by Status, Hour, Shipping Type, Payment Method Name; Payment Total Amount by Payment Method Name 
   
3. Product Metrics: Items Sold and Sale Price by Product Name; GMV by Status; Items Sold, Sale Price, Tax Amount, Tax Rate by Product Name, SKU Name, Seller SKU, SKU Type 
   
4. Stock Metrics: Orders by Status; Orders and Items Sold by Warehouse ID, Order ID, Create Time, Product Name, SKU Name, Warehouse ID, Delivery Type, Tracking Number
   

For a complete list of available TikTok Shop fields in Power My Analytics, refer to the Schema Explorer.

Limitations and Important Considerations

• Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For this reason, only cached data will appear in a report or chart that pairs a unique field with the date dimension.
• Shop Analytics and account-level performance metrics are limited by TikTok's API to approximately the most recent 60 days. No historical backfill is available beyond this window for these metrics.
• Backfilling for orders, products, and transaction data: Power My Analytics initially backfills approximately 3 months of data when you first connect your shop. Up to 2 years of total history can be retrieved via manual backfill for order, product, and transaction data.
• Default time zone: UTC.
• Data propagation delay: Data may take up to 2 hours to appear after first connecting your shop.
• Deleted or archived products and orders: These may appear in TikTok's Seller Center UI but are not available through the Partner API.

Unavailable Data

The following data is not currently available through the TikTok Shop Partner API:

• Deleted orders
• Deleted or archived products
• Live-session and live-stream engagement metrics
• Creator and affiliate commission breakdowns (beyond what the Affiliate API exposes)
• Customer personally identifiable information (buyer name, phone number, full address) beyond masked values
• Custom fields
• Real-time data

Troubleshooting

Token Expiration and Re-authorization

TikTok Shop OAuth tokens can expire or be invalidated if a shop owner changes. If your TikTok Shop data stops syncing, navigate to Sources in your Hub, locate your TikTok Shop source, and re-authorize the connection.

Region and Marketplace Mismatches

TikTok Shop accounts for the US, UK, and Southeast Asia (SEA) regions each have separate Seller Center portals. If you are unable to connect or your data appears incorrect, confirm that you are authorizing with the correct regional Seller Center for your shop.

For guidance on other issues that may affect this connector, see Basic Troubleshooting.