AI Report · Seller Playbook

1. Long-horizon data: Transaction metrics go back up to ~2 years, and traffic-efficiency metrics go back up to ~1 year, supporting multi-year review and YoY comparison.
2. Flexible metric × dimension × granularity: Bring core metrics onto one page and cross-cut them by dimensions (content type, account type, time period) or drill down by product / video / LIVE / creator, without jumping between different analytics pages.
3. Customize and reuse: Configure a report manually or save it as a template, so you can reopen it and see current-period data with one click.
4. AI Assistant support: Use natural language to build a report, add or remove metrics, or change the date range, without needing to know field names.
5. Bulk export: Export data to xls files and continue analyzing them in Excel or your own local tools for pivots, modeling, or archiving.

Things to Know Before You Start

How to Access AI Report

1. From the Shop analytics top entry: Find the AI Report entry at the top of the Shop analytics page and follow the prompt to create a report.
2. From the left navigation: In the left navigation, go to Analytics and click AI Report.

1. Create New: Click Create New at the top-right of the AI Report page. The system generates a "Last 7 days GMV" draft by default. You can adjust the metrics, date range, and dimensions and then save.
2. Pre-configured template: The AI Report page includes the template L7D Shop Sales Performance Overview. Click View to see last-7-day GMV performance, then adjust and Save to make it your own template.
3. AI Assistant (Chat with AI): Type a natural-language request in the top chat box (e.g., "Build a weekly shop report for last 7 days, show me GMV, Product Impressions, Product Clicks and CTR, break down by day"), and the AI Assistant will complete the initial configuration. You can then fine-tune it manually.

Supported Metrics

This first version supports the metrics listed below. More metrics will be added over time. Please refer to the system for the latest scope.

Supported Dimensions and Drill-down Granularities

Interact with AI Assistant

Module	Screenshot	Description
Chat with AI		Supports natural-language conversation. The AI Assistant helps configure the report you want. The AI Assistant can build or adjust reports based on the time range, metrics, specific products, or dimensions you ask for. Example instructions: "add product impressions and CTR", "switch time filter to last 30 days", "delete GMV".
Metrics to show		Supports selecting metrics across multiple categories, with metric explanations available for each. The trend chart supports up to 2 metrics at the same time. You can click other selected metrics to switch what is shown.
Breakdown		Breakdown options change with the selected metrics. You can drill down by account type, content type, time period, and more. You can also target specific product IDs, video IDs, LIVE IDs, or creator IDs for ongoing analysis of best-selling products or content.

Common Scenarios

Scenario 1: Weekly shop report

1. Create New: Click Create New on the AI Report page. The system generates a "Last 7 days GMV" draft by default. Add other metrics as needed.
2. Pre-configured template: Open the L7D Shop Sales Performance Overview template and click View to see last-7-day GMV performance. Adjust as needed, then Save as your own weekly report.
3. AI Assistant: Type your request in the chat box (see the Prompt example below), and the AI Assistant will generate an initial version.

1. Metrics: Select GMV, Product Impressions, Product Clicks, and CTR.
2. Date range: Select last 7 days, or customize last Monday to Sunday.
3. Granularity: Shop (shop-level aggregation).
4. Breakdown: Optional. Select By Day to view daily trends.
5. Review the trend chart to confirm GMV movement, then use the detail table to decide whether action is needed. Click Save and name it, so you can reopen it each week and the time window will refresh automatically.

Scenario 2: Best-selling product tracking

1. Go to AI Report and click Create New.
2. Metrics: Select GMV, Product Impressions, Product Clicks, and CTR.
3. Granularity: Select Product ID / Name.
4. Breakdown values: From the granularity values, select the products you want to track (up to 500). You can also search by Product ID to pick a small set of best-selling products.
5. Date range: Select last 30 days or this month.
6. Review the trend chart to compare product performance. In the detail table, sort by GMV in descending order to quickly find best-selling products.

Scenario 3: Content channel effectiveness

1. Go to AI Report and click Create New.
2. Metrics: Select GMV, Product Impressions, Product Clicks, and CTR. To focus on short-video or LIVE performance, add Video views, Video watch duration, LIVE views, LIVE watch duration, and other traffic-efficiency metrics.
3. Dimensions: Select Content type to compare the contribution from video, live, and product card.
4. Date range: Select last 28 days or this month.
5. Granularity: To view performance at a specific video or LIVE level, switch to Video ID or LIVE ID and select the content you want to analyze.
6. Compare the GMV share changes across content types in the trend chart.

Scenario 4: Creator sales contribution

1. Go to AI Report and click Create New.
2. Metrics: Select at least GMV, Creator-attributed GMV, Seller-attributed GMV, and Items sold, plus the corresponding creator-attributed and seller-attributed items sold metrics.
3. Date range: Select last 30 days or last month for a monthly creator review.
4. Granularity:
   • Start with Shop to view overall contribution (creator contribution vs. seller-operated contribution, both trend and volume).
   • To view specific creators, switch to Creator ID and select the creators you want to focus on from the value list (the first 3 are selected by default; you can adjust up to 500).
5. Breakdown: Use By Day to observe trend changes (for example, around campaigns or on days when creators go LIVE).
6. On the result page, focus on:
   • Whether Creator-attributed GMV / Items sold moves in line with total GMV.
   • Whether Seller-attributed GMV is offset (creators bring visits but seller-operated sales decline).
   • If Refunds and cancellations are included, whether refunds rise abnormally.

Scenario 5: Monthly review (this month vs. last month)

1. Go to AI Report and click Create New.
2. Metrics: Select GMV, Items sold, and Refunds and cancellations (if needed).
3. Date range: Select this month. After saving, the report refreshes to the current month each time you open it.
4. Comparison method: Create another report with the same metrics and set Date range to last month. View the two reports side by side, or Export both to your local files for month-over-month analysis.
5. Breakdown: Select By Day or By Week to view the pace of the trend.

Scenario 6: Long-horizon review and YoY comparison

1. Go to AI Report and click Create New.
2. Metrics: Select GMV and Items sold (add Creator-attributed GMV and Seller-attributed GMV to observe structural changes).
3. Date range: Select this year, or customize any date range within the past two years (transaction metrics support up to ~2 years of history).
4. Granularity: Use Shop to get the longest single-query window.
5. Breakdown: Use the Time period dimension to switch to By month or By week, so daily data does not become overwhelming. Zoom into a specific month later if needed.
6. YoY comparison: Create another report with the same metrics and select the same period last year as the date range. View both reports side by side to complete the year-over-year comparison, or Export both and do the YoY calculation locally.

Scenario 7: Export XLS for local deep analysis

1. Configure a report using any scenario above, or open a saved report.
2. Confirm the data has finished loading (the Export button will become clickable).
3. Click Export to download the xls file.
4. Open the file in Excel and use filters, pivot tables, charts, or other functions for further analysis.

Scenario 8: Save frequently used reports for weekly or monthly review

1. After completing any report configuration, click Save.
2. Enter a name that is easy to recognize, such as "Weekly shop report - GMV + Items Sold" or "Creator monthly report".
3. Return to the AI Report list page and use the search box or Create by filter to find saved reports quickly.
4. Click View to open a report. Reports that use dynamic time (such as this week or this month) will refresh to the current period each time you open them.
5. You can also delete a saved report from either the report detail page or the list page by clicking Delete. A confirmation prompt appears before deletion to prevent mistakes.

More Prompt Cheat Sheet

FAQ