Show Etsy shop analytics to a person as a rich table. PREFER THIS for any user-facing shop research — 'top/best/biggest shops', 'who's selling <thing>', 'shops doing over $X/mo', competitor discovery, and any filtered or sorted request ('shops with over 1,000 sales sorted by revenue'). Use it by default for such requests; only fall back to the raw get_shops tool when you need the JSON to compute something yourself.
DEFAULT: omit `columns`. The widget then shows the same default columns the EverBee app shows, which is what the user expects to see — and the set is wide, so leaving it alone is almost always right.
Pass `columns` ONLY when the user names the shop fields they want, or asks to add or drop one ("show me price and views", "just the keyword and its volume", "add conversion rate"). It REPLACES the default set — it does not extend it — so a partial list hides every column you leave out. Filtering or sorting on a field is NOT such a request: those fields are appended automatically, and the rest of the default set still shows.
When you do pass it, list the fields in display order. Each entry may be the EverBee app label the user says OR the backend field key — "Total Sales" and "transaction_sold_count" both resolve, and matching ignores case, punctuation and spacing. Unresolvable names are dropped silently.
Available — label (field key): "Shop Name" (shop_name), "Total Sales" (transaction_sold_count), "Total Revenue" (revenue), "Mo. Sales" (sales_30_days), "Mo. Revenue" (revenue_30_days), "Shop Age" (shop_age_month), "Shop Review Score" (review_average), "Reviews" (review_count), "Total Favorites" (num_favorers), "Category" (category), "Currency" (currency_code), "Location" (shop_location_country_iso), "Active Listings" (listing_active_count), "Digital Listings" (digital_listing_count), "Review Rate" (review_rate), "Conversion Rate" (conversion_rate), "Total Views" (views), "Average price" (average_listing_price), "Listings" (listings_count), "Est. Total Revenue" (average_calculated_revenue), "Sales per Listing" (sale_per_listing), "On Etsy since" (on_etsy_since).
Default set (what you get by omitting `columns`): "Shop Name", "Total Sales", "Total Revenue", "Mo. Sales", "Mo. Revenue", "Shop Age", "Shop Review Score", "Reviews", "Total Favorites", "Category", "Currency", "Location", "Active Listings", "Digital Listings".
Rows: the table always shows 20 per page with Previous / Next. When the user asks for an exact number ("51 listings", "top 5"), set `limit` to it; otherwise leave `limit` and `params.per_page` unset to page through every match. Use ShopsParams filters/order_by to narrow and sort the underlying query.