Sharetribe Essentials: Prompt Starter Pack

How to Use This Starter Pack

1. Always remember to copy your System Rules along with each chosen prompt.

2. Adjust date ranges as needed for your analysis timeframe.

Pro Tip: Save your most-used prompts for even faster access to critical marketplace metrics!

System Rules

Skill: Use the Lemonado MCP to query Sharetribe marketplace data, calculate key metrics, and present results in the appropriate format.

Role: You are a marketplace analyst helping users access and analyze their Sharetribe marketplace data through Lemonado.

Goal: Provide quick, actionable Sharetribe marketplace reports with clear metrics and insights.

10 Ready-to-Go Prompts for Sharetribe Connectors

1. Last 30 Days Marketplace Overview

Full Prompt: Show me a comprehensive overview of my Sharetribe marketplace performance for the last 30 days including daily transactions, total revenue (GMV), new user signups, active listings, and transaction success rates. Break it down day-by-day so I can see trends.

Expected Output: Daily performance table with columns for date, transactions completed, revenue (GMV), new users registered, active listings, and transaction success rate percentage. Includes 30-day summary totals showing total transactions, total GMV, average order value (AOV), total new users, and overall success rate. Highlights strongest and weakest performing days.

2. Top Sellers Performance

Full Prompt: Show me the top 10 sellers in my Sharetribe marketplace by total revenue over the last 30 days. Include their transaction volume, average order value, seller rating (if available), and response time metrics so I can identify my power sellers.

Expected Output: Ranked table of top 10 sellers showing seller name/ID, total revenue generated, number of transactions, average transaction value, seller rating (if available), average response time to inquiries, and percentage of total marketplace revenue. Identifies your most valuable sellers and highlights opportunities to engage or reward top performers.

3. User Growth & Retention Analysis

Full Prompt: Analyze user growth and retention for my Sharetribe marketplace over the last 90 days. Show me new user signups by week, total active users (those who completed at least one transaction), returning user rate, and repeat transaction percentages. Help me understand if users are sticking around.

Expected Output: Weekly user metrics table showing new signups, total active users (transacted), first-time buyers vs returning buyers, repeat transaction rate percentage, and week-over-week growth rate. Includes 90-day summary with total new users, active user percentage, repeat buyer rate, and user retention trend (improving/declining). Flags weeks with unusual drop-offs or spikes.

4. Revenue by Category Breakdown

Full Prompt: Break down my Sharetribe marketplace revenue by listing category for the last 30 days. Show me which categories are driving the most transactions and revenue, average transaction values by category, and category growth rates so I can understand what's working.

Expected Output: Category performance table showing category name, transaction count, total revenue, percentage of total revenue, average transaction value, and month-over-month growth rate (if data available). Sorted by revenue descending. Identifies top-performing marketplace segments and underutilized categories that may need attention or promotion.

5. Geographic Performance Analysis

Full Prompt: Show me performance by location for my Sharetribe marketplace over the last 30 days. Which cities, states, or regions have the most active users, transactions, and revenue? Include user distribution and average transaction values by location.

Expected Output: Location performance table showing geographic area (city/state/region), number of active users, transaction volume, total revenue, percentage of total transactions, and average transaction value. Sorted by revenue or transaction volume descending. Identifies geographic concentrations, underserved areas, and location-specific opportunities for growth or targeted marketing.

6. New Listing Success Rate

Full Prompt: Analyze how quickly new listings get their first booking in my Sharetribe marketplace. Show me listings created in the last 30 days, how many got their first transaction, average time to first booking, and which listings are still waiting for their first customer.

Expected Output: New listing performance table showing listing title/ID, date created, days since creation, first booking date (if applicable), days to first booking, total bookings to date, and status (booked/pending). Includes summary metrics: total new listings, percentage that got first booking, average days to first booking, and list of listings still awaiting first transaction. Helps identify if onboarding is effective and which new listings may need promotion.

7. Payment & Payout Analysis

Full Prompt: Show me payment processing and payout metrics for my Sharetribe marketplace over the last 30 days. Track total payments processed, commission earned, payout timing to sellers, and revenue collection efficiency. Help me understand the money flow.

Expected Output: Payment metrics table showing date, payments processed, total GMV, marketplace commission earned, commission percentage, payouts to sellers, payout timing (average days), and pending payouts. Includes 30-day summary with total payments, total commission revenue, average commission rate, total payouts completed, and outstanding payout balance. Flags any delayed payouts or payment processing issues.

8. Listings by Status Breakdown

Full Prompt: Show me the distribution of listings by their current status in my Sharetribe marketplace. Break down how many listings are published, pending approval, in draft, closed, or any other status. Include metrics like average time in each status, conversion rates from draft to published, and how listing status affects marketplace inventory.

Expected Output: Listing status table showing status type (published, pending approval, draft, closed, etc.), count of listings, percentage of total listings, average days in status, and conversion rate to published (for draft/pending). Includes trends over last 30 days showing status changes (e.g., new drafts created, listings published, listings closed). Identifies bottlenecks in listing approval workflow and shows active vs inactive inventory. Helps understand listing lifecycle and seller engagement.

9. Sellers Without Payment Setup

Full Prompt: Identify all sellers in my Sharetribe marketplace who have active listings but haven't connected their Stripe payment account yet. Show me their listing count, potential revenue at risk, and how long they've been without payment setup so I can follow up with them.

Expected Output: Table of sellers without payment setup showing seller name/ID, email (if available), number of active listings, date of first listing, days since first listing, listing views (if available), and potential revenue at risk based on category averages. Sorted by days since first listing or listing count descending. Includes total count of incomplete sellers and total active listings affected. Enables targeted outreach to complete seller onboarding.

10. 30-Day Commission Calculator

Full Prompt: Calculate the total marketplace commission I've earned over the last 30 days in my Sharetribe marketplace. Break it down by transaction type (if applicable), show daily commission trends, commission rate percentages, and compare to the previous 30 days so I can track revenue growth.

Expected Output: Commission breakdown table showing date, transactions, total GMV, commission earned, effective commission rate percentage. Includes category or transaction type breakdown (if applicable) showing commission by segment. 30-day summary displays total commission earned, average daily commission, effective commission rate, comparison to previous 30 days (percentage change), and projection for next 30 days if current trend continues. Provides clear view of marketplace revenue performance.