Omnilogin Docs

English

Tiếng Việt

English

Tiếng Việt

Appearance

Tool for Aggregating Sales, Profit, and Return Data from Amazon ​

Statistics on sales, profit, removals, by day, week, month, and all-time for multiple Merch By Amazon accounts. Essential for account managers or operations teams.

sale_amz

Key Features of the Tool ​

Consolidate Statistics from Multiple Accounts Simultaneously ​

This is the core and most valuable feature. Instead of logging in manually, the tool allows you to aggregate data from all accounts into a single file, saving hours of work.

Customize Reports to Your Needs ​

You have full control over the information displayed in the report. The tool allows for flexible selection of important data columns:

  • Account Information:
    • ProfileName: The name of the Profile/Account for easy identification.
    • Tier: The current tier of the account (T10, T100, T500...).
    • Used / Slot: The number of designs used out of the total available slots.
  • Detailed Business Metrics Over Time:
    • Yesterday: Sales, Royalties, Returns, Cancellations.
    • Last 7 Days: Sales, Royalties, Returns, Cancellations.
    • This Month: Sales, Royalties, Returns, Cancellations.
    • Previous Month: Sales, Royalties, Returns.

Supports Multiple Marketplaces ​

Easily filter and export reports from specific marketplaces where you do business, including: US (Default), UK, DE, FR, IT, ES, JP. This feature helps you evaluate performance in each individual market to develop appropriate strategies.

Export Reports as Convenient CSV Files ​

All data will be exported to a ReportSalesMerch-{date-month}.csv file. The CSV format is very common and can be easily opened with Excel or Google Sheets for further processing or creating visual charts.

Specific Applications of the Merch by Amazon Tool ​

Here are practical tasks you can perform with this tool:

Application in Creating Periodic Performance Reports ​

This is the most common application, especially for those who manage accounts for clients or teams.

  • Scenario: At the end of each week or month, you need to send a summary report of the business situation to your client.
  • How to do it:
    1. Run the tool, selecting only the ProfileNames belonging to that client.
    2. Choose the data columns needed for the report, such as Last7DaysSales, Last7DaysRoyalties, ThisMonthSales, ThisMonthRoyalties.
    3. Export the CSV file.
    4. From the CSV file, you can easily copy the data, create charts, and send a professional report in just minutes instead of hours of manual login and compilation.

Application for Analyzing and Comparing Market Performance ​

  • Scenario: You have just launched a new design collection and want to know if it sells better in the US or German (DE) market.
  • How to do it:
    1. Run the tool the first time, selecting only the US market.
    2. Run the tool a second time, selecting only the DE market.
    3. Compare the two resulting CSV files to see which market has higher sales, profits, and quantities sold, then decide which market to focus on for promotion or listing optimization.

Application in Team Management and Performance Evaluation ​

  • Scenario: A team leader needs to evaluate the performance of team members based on the sales they generate on their assigned accounts.
  • How to do it:
    1. Run the tool at the end of the month, exporting a report with the ProfileName and ThisMonthRoyalties columns.
    2. In the CSV file, group the accounts by the staff member in charge.
    3. Easily calculate the total royalties each person brings in, providing a transparent and fair basis for calculating salaries, bonuses, and evaluating KPIs.

Application for Quick Problem Detection ​

  • Scenario: You suddenly see a sharp, unusual drop in total daily income but don't know the cause.
  • How to do it:
    1. Run a daily report with the YesterdaySales and YesterdayReturn columns.
    2. By looking at the consolidated report, you can quickly identify a specific account that has a sudden spike in its return rate (Return), or a large account that suddenly has no sales. From there, you can focus on investigating that specific account instead of fumbling through all of them.

Hopefully, the explanations and examples above have helped you better understand the practical applications of this tool. Each of these applications, when executed, will bring corresponding benefits such as saving time, increasing revenue, and more effective management.