In this episode of Amazon Data Dudes, host Will Christensen, along with guests Brandon and Nhan of Cellular Labs, dive into the complexities and frustrations of data discrepancies encountered by sellers on Amazon. The trio discusses the inherent conflict of interest within Amazon's reporting system, which often leads to inflated business reports that do not accurately reflect actual sales, profitability, or the fees deducted. They highlight how Amazon's different data sources, such as business reports and the orders API, contribute to confusion among sellers trying to understand their true profitability. Special attention is given to the challenges sellers face in reconciling Amazon-provided data with their actual bank account figures, emphasizing the importance of accessing reliable financial data directly correlating to payments received. The episode calls out the discrepancy causes like cancellations, sales tax, and other non-profit impacting items included in Amazon's estimates and encourages sellers to strive for financial data accuracy to truly understand their profitability on the platform.

00:00 Introduction to Amazon Data Dudes

00:15 The Great Data Debate: Unveiling Amazon's Reporting Discrepancies

00:59 Diving Deep into Amazon's Data Dilemmas

01:17 The Quest for Accurate Profitability Metrics

02:26 Unpacking the Business Reports vs. Actual Financial Data

04:17 The Challenge of Data Accessibility and Accuracy

06:12 Navigating Amazon's Complex Data Landscape

09:33 Seller Labs: A Solution to Amazon's Data Conflicts

10:55 Conclusion: Embracing Accurate Financial Reporting

This episode of Amazon Data Dudes features hosts Will Christensen, Nan, and Brandon discussing the challenges of counterfeit products and listing hijacking on Amazon. They introduce the Amazon Transparency app as a solution, designed to assign a unique serial number to each product in a seller's catalog, preventing unauthorized sellers from adding counterfeit goods to the listing. Nan shares his experience using the Amazon Transparency program to protect his lawn equipment parts business from listing hijacking and counterfeit sales. The hosts discuss the traditional difficulties in combating counterfeits on Amazon and how the Amazon Transparency app resolves these issues by rejecting products without a valid transparency code at Amazon's fulfillment centers. The episode also covers the launch of a new app within the Seller Labs Data Hub that allows sellers to print their own small batches of transparency labels, making the program more accessible and cost-effective for sellers with fewer sales. The episode ends with encouragement for listeners to try this new feature as part of their Seller Labs account.

00:00 Introduction to Amazon Data Dudes

00:10 Unveiling the New Superpower: Amazon Transparency

01:58 The Problem of Listing Hijacking on Amazon

04:21 The Solution: Transparency and Technological Innovation

07:10 Demo and Benefits of the New Transparency App

11:18 Closing Thoughts and Future Directions

In this episode of Amazon Data Dudes, hosts Will Christensen, Nhan, and Brandon delve into the powerful Amazon transparency app developed for sellers encountering product hijacking and counterfeit issues. Originally a solution crafted by Nan for his power equipment business to combat listing hijacking, the app leverages the Amazon Transparency program, assigning unique serial numbers to each item in a seller's catalog to prevent unauthorized selling. The discussion highlights the challenges sellers face with counterfeit products and the traditional, labor-intensive process of reporting and removing such listings from Amazon. The app presents a cost-effective, technology-driven solution allowing sellers to produce and manage smaller batches of transparency labels in-house, avoiding the prohibitive costs and logistical nightmares of outsourced bulk printing. Intended for small to medium sellers, the app is currently in beta and available through Seller Labs Data Hub, exemplifying a significant advancement in protecting sellers’ interests and maintaining product integrity on Amazon.

00:00 Introduction to Amazon Data Dudes

00:10 Unveiling the New Superpower: Amazon Transparency App

00:38 The Problem with Counterfeits and Listing Hijacks on Amazon

04:28 The Challenges of Traditional Labeling and a Technological Solution

06:58 Introducing the Beta App for Efficient Label Printing

11:19 Closing Thoughts and Future Directions

In this episode of Amazon Data Dudes, hosts Will Christensen, Brandon Chekits, and Nandeen explore the challenges of navigating Amazon's complex data architecture, specifically relating to parent and child ASINs and other key identifiers like SKU and FNSKU. They discuss the difficulties sellers and agencies face in connecting and translating between these data points due to Amazon's architectural nuances and the lack of direct reporting tools. To address these challenges, they introduce an AI-powered query builder tool built on GPT 3.5 that simplifies the process of accessing and manipulating Amazon's data. This tool enables users to easily generate SQL queries and retrieve data from a SQL database, facilitating rapid connection between data points and making the information more accessible without the need for deep technical knowledge. The tool's integration into Seller Labs and its ability to simplify data manipulation is highlighted as a significant advancement for Amazon sellers and agencies looking to unlock the full potential of their data.

00:00 Introduction to Amazon Data Dudes

00:07 Exploring Parent and Child ASINs

00:34 Challenges with Amazon's Data Architecture

01:25 Introducing the AI Query Builder

01:58 Demonstrating the AI Query Builder's Capabilities

04:46 Advanced Data Exploration and Customization

06:31 Conclusion and Final Thoughts

In this episode of Amazon Data Dudes, hosts Will Christensen, Nhan, and Brandon discuss the complexities of selling on Amazon, especially regarding handling Amazon fees to maintain profitability. Nhan, an eight-figure seller, introduces a new report designed to help sellers track various Amazon fees, such as storage and advertising, to avoid unexpected losses like the one his friend encountered due to a fee change. He emphasizes the importance of monitoring these fees closely, as Amazon's charging patterns can lead to significant, unnoticed costs. Brandon explains the technicalities of building such a report, highlighting their use of the finances API for real-time data and the efforts to consolidate and reconcile financial data accurately. The episode underscores the value of this reporting tool in identifying anomalies in fee charges and helping sellers make informed decisions to protect their margins.

Timestamps:

00:00 Introduction to Amazon Data Dudes

00:21 Unveiling a New Report for Amazon Sellers

00:24 The Importance of Monitoring Amazon Fees

01:38 A Real-World Example of Fee Oversight

02:52 Building a Comprehensive Fee Monitoring Tool

06:25 Technical Insights: Creating the Amazon Fees Report

08:18 Wrapping Up and Future Episodes

In this episode of Data Dudes, host Will Christensen and co-hosts Brandon Checketts and Nhan Dinh discuss the growth and success of Cellular Labs. They highlight the contributions of Nan, who became a majority owner and infused the company with cash. They also introduce Brandon as a seller founder, sharing his background in the book and media industry. The team dives into the strategies they implemented to improve their seller rating and increase customer satisfaction. Tune in to learn more about their journey and the importance of customer feedback.

[00:02:54] Security flaw in MWS.

[00:04:08] Warehouse as a distraction.

[00:08:37] Understanding the Amazon API.

[00:12:43] Front-end development challenges.

[00:17:46] Product reviews and feedback.

[00:19:18] Retool's powerful features.

[00:23:47] Creating a transactions pivot.

In this captivating episode of Amazon Data Dudes, we are thrilled to welcome a very special guest, Alexi Bell, an account director at Cellulabs. With years of experience and thousands of hours immersed in Amazon Seller Central, Alexi shares her insightful perspective on the challenges of maintaining consistent data within the ever-changing landscape of Amazon. She discusses the importance of having reliable data for clients to make informed advertising decisions and the struggle for consistency on the platform. Tune in to this episode for an insider's look at the world of Amazon advertising and the expertise that Alexi brings to the table. Hosted by Will Christensen and Brandon Chekits, with Jordan Chekits chiming in, don't miss out on this deep dive into the complexities of Amazon data management.

[00:00:24] Amazon advertising insights.

[00:03:30] Amazon's fragmented data

[00:07:04] Profit margin importance.

[00:11:27] Data Accuracy Solutions

[00:15:06] Automated data capture benefits.

[00:19:36-00:19:46] Data-driven decision making.

[00:21:01-00:21:11] Amazon sales data analysis.

On this episode of Amazon Data Dudes, host Will Christensen is joined by Brandon Chekits from Cellular Labs and Gilad from VAA Philippines. Gilad explains how VAA recruits and trains virtual assistants from the Philippines to work with Amazon sellers, focusing on skills, motivation, and attention to detail. VAA's rigorous process results in a 1% acceptance rate for VAs who then undergo specialized training for different seller needs like PPC and social media. Their VAs are trained in Seller Central and relevant Amazon seller data to provide ongoing support.

[00:01:10] Amazon-focused Virtual Assistants.

[00:07:18] The intersection of people and data.

[00:11:17] The value of data.

[00:14:15] VA impact on PPC management.

[00:18:33] Automating Amazon advertising campaigns.

[00:21:10] The Superman syndrome.

[00:26:37] Delegating for business growth.

[00:29:16] Delegating tasks effectively.

[00:32:04] AI for SOP creation.

[00:35:20] Understanding mental models in business.