Click the link to use the template.
Product Sourcing for Amazon
This template mainly explains how to identify high-performing keyword roots (product words + attribute words) by comparing the titles of high-sales and low-sales products.
Step 1: Import Files as Data Tables
Import the two sample datasets. Below are the specific steps (template data is auto-generated, you can upload your own files as needed).
Step 2.1: Filtering Relevant Fields for Analysis
For instance, from the file [keepa-B0CTHM6KZP-20241127], we only need the columns “Date,Buybox Price($),BSR,Rating,Ratings” Other columns should be removed.
prompt:
Read the file keepa-B0CTHM6KZP-20241226.xlsx we only need the columns “Date,Buybox Price($),BSR,Rating,Ratings” , Other columns should be removed.
Then save them in keepa Data Analysis.
Step 2.2 Sales Data Merge
prompt:
Merge the data from keepa_Data_Analysis.xlsx and US-B0CTHM6KZP-daily-sales-20241226.xlsxUS-B0CTHM6KZP-daily-sales-20241226.xlsx based on the matching field "Date = Time" into a single new table, and combine into a new table in Final_Keepa_Analysis_Data.
Step 3. AI Data Analysis Recommendations (Seller's Perspective)
⭕️ According to the demonstration: modify the [Product Name] for analysis in the Prompt parameter box sent to Kimichat, then click the "Run" button.
Step 4. AI Data Analysis Recommendations (Buyer's Perspective)
"END: Give yourself a thumbs up for being adept at using new tools~👍 Today is another great day."
Prompt reference 1 ：
"The following data is a historical data table for an Amazon 'Women's Short Sleeve' product. Use this data to analyze the product's lifecycle by first identifying its approximate life stages. Analyze the following aspects using as much of the actual data from the table as possible. Your analysis results are intended for 'Amazon sellers who are considering sourcing similar products from 1688 based on the analysis content of this product':
Comprehensively analyze whether the product is in its growth stage and assess the competitive landscape. Here are the directions for analysis:
Sales Data:
Analysis Rule: By examining monthly sales data, you can observe the sales growth trend and determine if the product is in its growth stage.
Inventory Data:
Analysis Rule: Inventory levels and turnover rates can help evaluate the supply situation and demand intensity of the product.
Advertising and Promotional Activities:
Analysis Rule: Advertising and promotional activities directly impact sales and BSR (Best Sellers Rank), understanding this information helps analyze the reasons for product growth.
Market Competition Analysis:
Analysis Rule: By comparing the performance of similar products and competitors, you can assess the degree of market competition and the product’s market position.
Review Analysis:
Analysis Rule: The speed of growth in reviews and the ratio of positive to negative reviews can reflect the product's market acceptance and potential issues.
Price Trend Analysis:
Analysis Rule: Price trends can reflect market competition and product positioning, with frequent price changes potentially indicating intense competition.
Seasonal Factors:
Analysis Rule: Understanding the seasonality of product sales can aid in inventory planning and marketing activities.
Market Trends and Consumer Preferences:
Analysis Rule: These data can help judge the long-term potential of the product and market trends.
Product Characteristics and Differentiation:
Supply Chain Information:
Analysis Rule: The stability of the supply chain and product quality directly affects product reliability and customer satisfaction."
Prompt reference 2：
Analyze the data to find answers to the following questions:
When to Buy:
Look at the price trend data to identify the periods when the product price is typically lower, such as during sales events or promotions.
Check inventory levels to see if there’s a risk of the product selling out.
Upcoming Discounts:
Analyze advertising and promotional activity data to predict any upcoming sales or discounts. Frequent promotions might indicate regular opportunities for discounts.
Product Reviews and Quality:
Evaluate the review analysis to assess the general sentiment. Look at the ratio of positive to negative reviews to gauge customer satisfaction.
Note any recurring themes or issues mentioned in the reviews to understand potential quality aspects or problems.
Seasonal Buying Patterns:
Determine if there are seasonal trends affecting price or availability. This can help you decide the best time to make a purchase when conditions are most favorable.
By using these insights, you can make an informed decision about the best time to purchase, potential discounts, and the overall quality of the product.