Trusted by 1,600+ marketing teams and agencies
E-commerce report templates
Porter’s 33 e-commerce report templates are grouped by what each one reports on. Filter by tool or use case and open a card for its preview and setup.
33 templates
Shopify and online store reports
Porter dashboard
Shopify dashboard
See net sales, orders, gross margin and returns, with your top products and customers.
Data StudioShopify report template
Report Shopify sales, tax, returns and discounts, and sales by UTM source.
Porter dashboard
Shopify store performance
See revenue, orders and conversion rate with Google Ads and GA4 traffic.
Data StudioShopify store performance
Break down revenue and conversion rate by traffic source and campaign.
Porter dashboardShopify KPIs dashboard
Check net sales, orders, returns and discounts for every day in one table.
Data StudioShopify KPIs report template
Watch daily Shopify sales, quantity and shipping next to the period totals.
Porter dashboardShopify attribution dashboard
See which UTM sources and campaigns bring Shopify sales over time.
Data StudioShopify attribution report template
Rank landing pages and UTM sources by the Shopify sales they bring.
Porter dashboard
E-commerce dashboard
Put store sales, ROI, blended ROAS and ad spend from every platform on one page.
Data StudioE-commerce report template
Compare customers, orders and ad spend by platform for your online store.
Porter dashboardDTC dashboard
See Shopify sales by UTM source and medium with orders and new customers.
Data StudioDTC report template
Put revenue and cost per acquisition from Shopify, GA4, Google Ads and Facebook Ads together.
Porter dashboardDropshipping dashboard
Follow orders, purchases, ROAS and CPA from Shopify, Meta Ads and Google Ads.
Data StudioDropshipping report template
Compare gross sales with ad spend and cost per order to see if each sale pays off.
Google SheetsShopify sales and orders
Pull Shopify sales and orders into a sheet you can total by month.
Google SheetsShopify inventory audit
Find best sellers running low on stock and slow products to promote, in Google Sheets.
Google SheetsGA4 e-commerce funnel
Follow users from item view to add to cart, checkout and purchase, month by month.Amazon Seller Central reports
Porter dashboard
Amazon Seller Central dashboard
Track Amazon order totals, sales, shipping and order status against the last period.
Data StudioAmazon Seller Central report template
Filter Amazon orders by status and product and compare sales with the previous 30 days.
Google SheetsAmazon orders and sales
Pull Amazon sales, orders, returns and fees by month into a sheet that refreshes itself.
Google SheetsAmazon FBA inventory
Check fulfillable, damaged and inbound FBA stock by SKU in Google Sheets.Ads and ROAS reports for e-commerce
Claude
ROAS dashboard template
Check each ad platform's ROAS against GA4 revenue and find campaigns below break-even.
Claude
Influencer dashboard template
See which creators bring sessions and sales, and what each returns on their fee.
ClaudeMeta Ads dashboard template
Track Meta Ads spend, ROAS and cost per purchase, and catch ad fatigue early.
ClaudeGoogle Ads dashboard template
Find search terms that waste spend and see which campaigns are limited by budget.
Porter dashboardPaid media e-commerce
Put Google Ads, Meta Ads and TikTok Ads spend next to purchases, day by day.
Data StudioPaid media e-commerce
Compare TikTok Ads, Google Ads and Meta Ads spend and purchases day by day in one table.Customer, AOV and LTV reports
Porter dashboardCustomer LTV dashboard
See how much repeat and new customers spend over time, customer by customer.
Data StudioCustomer LTV report template
Rank customers by total sales and returns and compare repeat and new buyers.
Porter dashboardAverage order value dashboard
Follow orders and average order value day by day, with payment status.
Data StudioAverage order value report template
See which orders lift average order value and how many are paid in full.
Google SheetsShopify customer cohort analysis
See how many customers from each month come back to buy again, in Google Sheets.
Google SheetsShopify acquisition analysis
Split Shopify sales, AOV and orders by source and by new or returning customer.E-commerce report example
Porter’s e-commerce report example is a Claude report on Trailgear demo data. Click through its four views before connecting anything.
What to include in an e-commerce report
An e-commerce report built on Porter’s templates has six parts, in the order a client or manager reads them.
Sales and orders
Net sales, orders, AOV and returns against the previous period: Shopify dashboard template.
Traffic and conversion
Where buyers come from and how many convert: Shopify store performance template.
Products and stock
Best sellers, slow products and items running low on stock.
Next steps
Two or three actions for the next period, such as the product to promote or the campaign to cut.
Match the detail to the reader: founders need sales, profit and ROAS; marketers need channels and campaigns. For Shopify alone, use the Shopify report templates.
How to set up an e-commerce report template
Every Porter e-commerce report template starts with one free step: connect your accounts in Porter. Then set it up in your reporting tool.
On Porter’s Free plan, Claude reads the last 15 days and Data Studio and Google Sheets up to 30 days. The 14-day trial has full access and needs no card (Porter pricing).
In Claude
Sign up free at Porter, open Data sources and connect the accounts your report needs, for example your ad accounts and GA4 property for the ROAS report.
In Claude, go to Customize → Connectors → Add custom connector, paste
https://mcp.portermetrics.com/mcpand name it Porter Metrics. Click Continue, sign in to Porter and allow access.Open a new chat, paste the install prompt and put your accounts in place of the one in brackets (Google Ads to Claude tutorial). Claude reads your data through Porter’s MCP (Model Context Protocol), an open standard that lets Claude read data from other tools.
Duplicate this Claude dashboard template and keep its layout, views and styling: https://claude.ai/artifact/SkDeerWRyTXgnPAJ5UNgFT
Then rebuild it with my own data through Porter: a ROAS dashboard for [brand] for the last 14 days from Google Ads, Meta Ads, Microsoft Ads and GA4: KPI cards for total ad spend, conversion value, ROAS, GA4 Purchase revenue and MER (GA4 Purchase revenue ÷ total ad spend); each platform's own ROAS (Google Ads Conversions value ÷ Cost, Meta Ads Purchase ROAS, Microsoft Ads Return On Ad Spend) next to GA4 Purchase revenue by Session source / medium; daily ROAS per platform and MER; every campaign's ROAS against a break-even ROAS of [2.0]; share of spend vs share of GA4 revenue; and MER by week.Claude Dashboards is in beta on Pro, Max, Team and Enterprise (Anthropic’s guide to Claude Dashboards).
As a Porter dashboard
Open a Porter dashboard card and click Download template.
Sign in to Porter and pick your accounts.
Share it with viewer or editor access, or schedule it by email.
In Data Studio
Open a Data Studio card and click Download template.
Click the three-dot menu (⋮) in the top-right corner and select Make a copy.
Choose your Porter data sources, click Copy Report and set the date range you report on, for example last month compared with the previous period.
In Google Sheets
Open a Google Sheets card and make a copy.
Install the Porter extension, authorize it and choose your accounts.
Run the prebuilt queries and set the refresh to daily or weekly.
Need Excel? In Google Sheets, choose File → Download → Microsoft Excel (.xlsx).
What makes these e-commerce report templates different
Store, marketplace and ad data live in different tools. Porter’s templates put them in one report that updates itself.
See a live example first
Click through the Claude e-commerce report example on demo data without an account.
Store and ads together
See Shopify sales next to Google Ads, Meta Ads and TikTok Ads spend, day by day.
One report, four tools
Explore it in Claude, send it as a Porter link, or keep it in Data Studio or Google Sheets.
Unlimited accounts on every plan
Connect as many accounts as you manage, even on the free-forever plan, and switch clients with one filter.
More report template galleries
Porter has a gallery for each channel, data source and tool.
E-commerce report template FAQ
Are these e-commerce report templates free?
Yes. All 33 Porter e-commerce report templates and prompts are free to download, and the Free plan never expires. Longer date ranges need the 14-day trial or a paid plan from $12.50 per account a month, billed annually (Porter pricing).
What should an e-commerce report include?
Sales and orders, traffic and conversion rate, ad spend and ROAS, repeat customers and order value, products and stock, and the next steps.
Is there an e-commerce report template for Google Sheets?
Yes. Copy a Shopify Google Sheets template, refresh it with your store, then choose File, Download, Microsoft Excel (.xlsx) if you need Excel.
Can I report on several accounts or clients?
Yes. Porter connects unlimited accounts, even on the free-forever plan. Connect every account you manage and switch between them with the account filter.
Can I send the report automatically?
Yes. A Porter dashboard shares by link and PDF and can be scheduled by email every week or month. In Data Studio, use Share, Schedule delivery.
Claude, Porter dashboard, Data Studio or Google Sheets: which should I use?
Use Claude to build the report and ask follow-up questions, but anyone opening a shared Claude dashboard needs their own Claude access (Anthropic’s guide to sharing artifacts). Use a Porter dashboard for client links and scheduled email, Data Studio if your reports live there, and Google Sheets for formulas or Excel.
Get your free e-commerce report template
Pick a template, connect your store and ad accounts for free and send your first e-commerce report today.
Free plan · 14-day trial · No card needed