Comprehensive analytics for every part of your Amazon business — from essential profit tracking to advanced insights like PPC by hour and keyword-level market share.
All reports are built for repeat-purchase brands. Track P&L by New-to-Brand vs. Repeat, monitor Subscribe & Save, LTV, and cohorts — with 12+ CPG-optimized reports to help your brand grow.
Do all your internal analytics and client reporting in one place. Build reports that look exactly like the ones your clients know — or design something completely new.
Stable database system, refreshed every hour, maintained by our data team.
Your stack
Looker, Power BI, Tableau
Native SQL connection
Excel & Google Sheets
Live refresh, no exports
dbt, Python, your app
Join it to your own data
Trusted by
1000+
industry leaders
Best Seller
in Deodorants
100%
NTB accuracy
3×
Faster Insights
Best Seller
in Sea Vegetables
2×
Subscriber Growth
40%
NTB increase
Best Seller
in Headbands
5hrs+
Saved Daily
100%
Profit Clarity
Best Seller
in Flushable Wipes
3×
Optimization
100%
Branded view
Top agency
100%
Auto Reporting
50hrs+
Saved
Best Seller
in Probiotics
4×
Efficiency Gain
100%
Cost Control
Top agency
100%
Centralized Data
5×
Reporting Speed
Best Seller
in Cutting Boards
+13%
Gross margin
−22%
Refund reduction
Best Seller
in Home & Kitchen
-18%
Wasted ad spend
10x
Decision Speed
What is the My Real Profit data warehouse?
The Amazon data warehouse by My Real Profit is a database holding your Seller Central
datasets and Amazon Ads data, along with additional tables we collect from Amazon, all
modeled so you can query them directly instead of pulling reports by hand.
You get a read-only Postgres connection to all the tables that sit behind your reports.
Standard Postgres wire protocol, so any SQL client connects with no adapter
Profit reconciled to the settlement at SKU grain, with COGS and fees applied
Cohorts, LTV, and New-to-Brand modeled for you, not left as an exercise
Schema
The Seller Central datasets you get
Everything the platform reports on sits in one PostgreSQL database you query with standard
SQL, and on the Amazon sales API. Stable names and stable types, so when Amazon changes an
endpoint we absorb it and your queries keep running.
Sales data
Orders, units sold, sale price, session counts and order IDs, down to the child ASIN.
Financial data
Every Amazon fee broken down by product, with refunds, VAT and cost of goods applied.
Advertising data
PPC metrics by campaign, keyword, search term and product.
Search Query Performance data
Child, parent, brand and account-level search query data, week by week.
Customer data
Repeat rate, LTV cohorts, Subscribe & Save and new-to-brand data.
Inventory data
FBA inventory, reserved stock, inbound and unsellable units, kept with the history Amazon does not store.
If it is in MyRealProfit, it is in here. Every Amazon fee, BSR, refunds, promotions and
adjustments included, across every connected account and marketplace.
1 hour
Refresh cadence
Full
History retained
Unlimited
Seller accounts
Read-only
Access level
Your stack
Connect Power BI, Looker, AI, or your own app
Your analysts keep the tool they already know. Nothing new to learn, and no scheduled
export to babysit.
BI & dashboards
Looker Studio
Power BI
Tableau
Metabase
Hex
Sigma
AI & agents
Claude
ChatGPT
Gemini
Cursor
Any MCP client
Spreadsheets
Excel
Google Sheets
Code & pipelines
dbt
Python
R
psql
Your warehouse
n8n & Zapier
If your client can open a Postgres connection, it works. No proprietary driver, no adapter
to install.
Pricing
One fixed price, whatever your data does
Pricing is a fixed monthly cost based on the size of your account. Nothing is metered, so the
bill you agree is the bill you keep.
Starts at
$500/month
Fixed monthly cost, set by the size of your account. One price that covers everything below.
Rows. Query as much as you like, the bill does not move.
Tables. You get the whole schema, not a per-table menu.
History. The price is the same whether you hold one year or five.
Full advanced analytics Every report in the platform, not a data-only tier.
MCP connection The same account also connects to Claude, ChatGPT or any other AI.
VIP support in Slack A shared channel with the team who maintain your tables.
Full documentation Schema reference, table definitions and query examples.
Your history is kept, all of it
There is no retention window. We do not roll off anything after twelve months and we do
not charge you more as your history grows. Data you send us stays queryable for as long as
your account is open.
Older history from before your account existed can be loaded too. Amazon does not expose
it through the API, so our team imports it by hand, quoted separately from your monthly
price.
Build vs. connect
Building an Amazon data warehouse yourself
Pulling the reports is the easy part. Keeping them accurate while Amazon keeps changing
them underneath you is the part that never finishes.
Building on raw Amazon data
Every Amazon report pulled separately, then joined together by you
Someone in-house maintaining the connection and the code, permanently
Accuracy is yours to prove, number by number, before finance will sign off
Amazon retires reports and ships new ones each quarter, so you rebuild again
Connecting My Real Profit
Every report arrives already joined, in one schema you query
We maintain the connection and the code, so you hire nobody for it
We verify the accuracy and reconcile every number to the settlement
Amazon changes each quarter, we absorb it and your data keeps flowing hourly
Security
Your Data,
Always Secure
Unbreakable Infrastructure
Powered by Google Cloud for maximum uptime, scale, and compliance. Data is encrypted at
all times — no exceptions.
Privacy by Design
Your data is locked down — never shared, never exposed. We request only the bare minimum
permissions to operate.
Engineered Secure
Every service is built in Java with mandatory reviews, rigorous testing, and strict
dependency control. No shortcuts, ever.
Proven Support
Our experts are former engineering leads and data science heads in finance, who aim to
deliver support with uncompromising security standards.
Safe data
CCPA
GDPR
ISO
Who is the Amazon data warehouse for?
Data and BI teams
Join Amazon data to finance, DTC, and ops tables you already own, and build in the BI tool your analysts know.
Brands with an in-house analyst
Skip the SP-API project. Query cohorts, repeat rate, and LTV profit without maintaining a pipeline to keep them coming.
Agencies
Build one client reporting template on top of the warehouse and point it at every account you manage.
Developers
Call the REST API from an internal tool, a warehouse job, or an agent, with no pipeline to write first.
Your queries
+
Our modeling
=
Real answers
Your Amazon data in your own SQL
Connect your account and run your first query
against real numbers, before the 21-day trial ends.
A read-only database holding the modeled tables behind your MyRealProfit reports: sales, settlements, refunds, advertising, inventory, traffic, Search Query Performance and the customer cohort tables. There is a REST API over the same figures. Everything sits at SKU and marketplace grain, already joined and reconciled.
Standard Postgres wire protocol over TLS. Any client that can talk to Postgres connects with no adapter, including Looker Studio, Power BI, Tableau, Metabase, dbt, psql, Python and Excel via ODBC.
Yes, and that is the part you cannot get from raw SP-API. You get cohort tables with repeat rate, LTV profit, new-to-brand CAC and Subscribe & Save, including the fake SnS cases. We also handle the pending-order quirk that otherwise distorts repeat metrics for subscription products.
An export is a snapshot you have to schedule, download and reassemble. A database connection is live. You write SQL against current data, join it to your own tables in finance, DTC or ops, and your dashboards refresh themselves.
Most tables refresh every hour. Financial reconciliation runs on Amazon settlement data, so profit figures firm up as Amazon posts fees and refunds, exactly as they do in the dashboards.
Up to 24 months of sales and fee data and 60 days of PPC data, which is what the Amazon APIs make available. For older periods the APIs no longer return, our team can import the data manually.
No. Access is strictly read-only on an isolated database scoped to your workspace. You can revoke the credentials whenever you want, and doing so affects neither your Amazon connection nor your dashboards.
We treat the schema as a contract. Table and column names stay stable, and when Amazon ships a breaking API change we absorb it on our side. Additive changes get announced ahead of time, and we do not make breaking changes to existing columns.
Tell us and we will trace it with you. A human data team sits behind the platform, which is usually the fastest route from a suspicious figure to the Amazon report it came from. It is included, not billed as consulting.
Database and API access is available on paid plans. Start the 21-day free trial to see the data model first. Trial workspaces are limited to two months of history, then your full history loads once you move to a paid plan. No hidden fees, no long-term commitment.
For CPG brandsAll reports are built for repeat-purchase brands. Track P&L by New-to-Brand vs. Repeat, monitor Subscribe & Save, LTV, and cohorts — with 12+ CPG-optimized reports to help your brand grow.
For agenciesDo all your internal analytics and client reporting in one place. Build reports that look exactly like the ones your clients know — or design something completely new.
CustomizationBuild dashboards that match how your team works — tailored KPIs, workflows that empower your business.
