Bonsai Solutions

Returns the paginated Amazon Ads conversion-path table. Each row is one Amazon simplified_path, with sales, sales share, average order value, new-to-brand, single or multi classification, and active channels. brand_name, start_date, and end_date are required and match a materialized window of at most 90 days. When the range is not materialized, slice_found is false. Use when the user asks which conversion paths produced sales. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_ads_conversion_paths

Returns aggregated Amazon Ads keyword and targeting metrics: cost, attributed sales, impressions, clicks, ACOS, ROAS, and a daily series. Grain is keyword id by campaign by ad group. Covers Sponsored Products and Sponsored Brands. Optional match_type is EXACT, PHRASE, BROAD, or TARGETING_EXPRESSION. Date range is at most 95 days. Use when the user asks for keyword spend, ACOS, or totals by match type. Does not return the keyword table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_ads_keywords_summary

Returns the paginated Amazon Ads keyword and targeting table. Each row is one keyword or product target: text, match type Exact, Phrase, Broad, or product targeting, parent campaign, ad group, bid, status, cost, sales, ACOS, and ROAS. Covers Sponsored Products and Sponsored Brands. Search matches keyword text, keyword id, campaign, or ad group. Date range is at most 95 days. Use when the user asks which keywords, match types, or product targets are running. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_ads_keywords

Returns aggregated Amazon Ads product-ad metrics: cost, attributed sales, impressions, clicks, ACOS, ROAS, and a daily series. Grain is one ad, an ad id for an ASIN in a campaign and ad group. Covers Sponsored Products and Sponsored Display. Date range is at most 95 days. Use when the user asks for product-ad totals or the product-ad trend. Does not return the ad table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_ads_product_ads_summary

Returns the paginated Amazon Ads product-ad table. Each row is one ad, with an ad id, promoting an ASIN in a campaign and ad group: ASIN, SKU, parent campaign, ad group, cost, sales, ACOS, and ROAS. Covers Sponsored Products and Sponsored Display. Date range is at most 95 days. Use when the user asks for individual product ads, including the ad id. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_ads_product_ads

Returns Amazon Ads search-term totals for queries shoppers typed: cost, sales, purchases, ACOS, ROAS, distinct terms, counts, top negative candidates with many clicks and zero purchases, top exact candidates that convert on broad or phrase without an active exact keyword, and Amazon placements whose search term is an asterisk. ad_product is required and is SPONSORED_PRODUCTS or SPONSORED_BRANDS. Date range is at most 65 days for Sponsored Products and 60 days for Sponsored Brands. Use when the user asks for search-term totals, negative or exact candidates, or placements. Does not return the full term table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_ads_search_terms_summary

Returns the paginated Amazon Ads search-term table. Each row is one shopper query, with the keyword or targeting it matched, campaign, ad group, clicks, cost, sales, ACOS, and ROAS. Placement rows whose search term is an asterisk are omitted. ad_product is required and is SPONSORED_PRODUCTS or SPONSORED_BRANDS. Date range is at most 65 days for Sponsored Products and 60 days for Sponsored Brands. Use when the user asks which search terms ran, or which queries had cost and sales. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_ads_search_terms

Lists the workspaces allowed for the signed-in agency session. Use when an agency user asks which workspaces they can open. Available for an agency sign-in. Read-only.

list_agency_tenants

Returns Amazon Brand Analytics search-term totals from Search Frequency Rank: row count, distinct terms, weighted average click share and conversion share, and the share of rows that include the customer ASIN. Dates are optional, or pass report_id. report_period is DAY, WEEK, or MONTH. Use when the user asks for Brand Analytics search-frequency totals or catalog click share. Does not return the term table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_brand_analytics_search_terms_summary

Returns the paginated Amazon Brand Analytics search-term table: search term, Search Frequency Rank, click share, conversion share, and clicked ASINs. Dates are optional, or pass report_id. report_period is DAY, WEEK, or MONTH. Use when the user asks which Brand Analytics terms rank by frequency or which ASINs were clicked. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_brand_analytics_search_terms

Returns paginated Amazon Ads Brand Store ASIN performance with same-day attribution on the ASIN view: views, clicks, same-day orders and units, add to cart, in-stock, and conversion rate. click_rate can exceed 100 percent. renders is an upper bound. Requires the internal Bonsai profile id, brand_entity_id, start_date, and end_date, with a maximum range of 100 days. When the store is not found, the response lists stores. Use when the user asks how ASINs seen in the Brand Store performed on the same day. Page size defaults to 50 and is at most 100. Read from cache. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_ads_brand_store_asins

Returns Amazon Ads Brand Store insights attributed to 14 days from a store visit: views, visits, visitors, 14-day orders, units, and sales, new-to-store, dwell, and bounce. Requires the internal Bonsai profile id, the store brand_entity_id, start_date, end_date, and dimension DATE, PAGE, SOURCE, TAG, or STORE. Date range is at most 100 days, with a typical lag of 2 days. When the profile or store is not found, the response lists stores already in cache. Use when the user asks for Brand Store traffic and 14-day conversion. Row page size defaults to 50. Read from cache. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_ads_brand_store_insights

Returns Amazon Ads Brand Store quality versus peers: score, dwell versus peers, sales over the fixed Amazon window of about 60 days versus peers, Amazon recommendations, and the video funnel. sales_last_60_days is that fixed window, not the sales from start_date to end_date. Requires the internal Bonsai profile id, brand_entity_id, start_date, and end_date, with a maximum range of 100 days. When the store is not found, the response lists stores. Use when the user asks for Brand Store quality, the peer score, or the 60-day sales comparison. Read from cache. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_ads_brand_store_quality

Returns the Featured Offer impact for one ASIN stated in the current user message: visits, units, revenue, trend, and scenarios. asin is required. asin_stated_by_user is true when the current message states that ASIN or the exact product name. days is from 7 to 90 and defaults to 30. Use when the current message states one ASIN and asks for its Featured Offer impact. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_buy_box_impact

Returns the competitive offers for one tracked ASIN: seller, price, shipping, fulfillment as FBM, FBA, or vendor, Prime, feedback, and which offer holds the Buy Box. Requires product_child_id or the ASIN. Amazon often returns the three most competitive offers even when more exist. Use when the user asks who is offering one identified ASIN and at what price. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_buy_box_offers

Returns the paginated table of tracked ASINs and their Buy Box state: won, lost, partially won, or absent, with your price versus the Buy Box, gap percent, and offer count. Partial wins include partial_winner. Covers tracked products. Use when the user asks which tracked ASINs won or lost the Buy Box. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_buy_box_products

Returns Amazon Buy Box totals for tracked products: how many are winning or have lost the Buy Box, the 30-day win rate, and the trend. Covers tracked products, for a seller or vendor channel. Use when the user asks how the Buy Box is going across tracked products. Does not return the ASIN table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_buy_box_summary

Returns the Amazon FBA fee and estimate snapshot: available, inbound, and reserved units, estimated storage cost, estimated fees, excess inventory, alerts, and recommended actions. warehouse_id is the Bonsai FBA warehouse id. When it is omitted and one FBA warehouse exists, that warehouse is used. Otherwise the response lists warehouses with id, name, and country. Use when the user asks for FBA storage fees, excess inventory, or estimated fees. Does not return the ASIN table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_fba_fee_estimates_summary

Returns the paginated Amazon FBA fee and estimate table: available units, inbound units, storage cost, estimated fee, excess, alert, and recommended action. warehouse_id is the Bonsai FBA warehouse id. When it is omitted and one FBA warehouse exists, that warehouse is used. Use when the user asks which ASINs have FBA storage fees, excess inventory, or a recommended warehouse action. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_fba_fee_estimates

Returns the paginated Amazon FBA restock table: recommended quantity to send to FBA, available units, inbound units, country, alert, days of supply, and recommended ship date. nation_iso or country_code defaults to IT. Use when the user asks which ASINs to replenish in FBA and how many units to send. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_fba_restock_products

Returns Amazon FBA restock totals: available and inbound units, recommended quantity to send to FBA, days of supply, alerts, top ASINs to replenish, and coverage KPIs when present. nation_iso or country_code defaults to IT. Use when the user asks how much to replenish in FBA or which totals the restock report shows. Does not return the ASIN table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_fba_restock_summary

Returns the paginated Amazon Feedback Intelligence ASIN table: negative and positive mentions, negative share, main topic, risk_status STABLE, WATCH, RISK, or CRITICAL, and priority. Dates are optional. Use when the user asks which ASINs have negative review topics. Does not return review text and does not send replies. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_feedback_asins

Returns Amazon Feedback Intelligence overview metrics from Product Opportunity Explorer review topics: ASINs with feedback, positive and negative mentions, distinct negative topics, latest sync times, and the top negative topics. Dates are optional. marketplace_id is an Amazon marketplace id or a nation code. Use when the user asks what customers say in Amazon review topics, as totals. Does not return review text and does not send replies. Does not return the ASIN table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_feedback_overview

Returns the paginated Amazon listing catalog-health table: SKU, ASIN, catalog_status, intervention_bucket, and issues. Status values include ACTIVE, SUPPRESSED, INACTIVE, ISSUE, and UNKNOWN. Intervention buckets include NEW_PROBLEM, PERSISTENT_PROBLEM, RESOLVED_TODAY, OK, UNKNOWN_REVIEW, and NEEDS_ACTION. Filters are marketplace_id, amazon_api_setting_id, catalog_status, intervention_bucket, and search on SKU, ASIN, or name. There is no date filter. Use when the user asks which SKUs are suppressed or need intervention. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_listing_catalog_health_products

Returns the current Amazon listing catalog-health snapshot: counts of active, suppressed, inactive, and issue SKUs, intervention buckets for new, persistent, and action-needed problems, and the match between the Bonsai catalog and Amazon. There is no date filter. Use when the user asks how many listings are suppressed or need intervention. Does not return the SKU table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_listing_catalog_health_summary

Returns the price analysis for one identified tracked ASIN: diagnosis, evidence, actions, FOEP, constraints, and tracked competitors. competitor.items lists each configured competitor with ASIN, label, product title, landed price, currency, gap_to_owned, and has_buy_box. A positive gap_to_owned means the tracked price is higher. Requires product_child_id or the ASIN. The period defaults to 30 days and is at most 95 days. Use when the user asks for the price diagnosis of one named ASIN. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_price_index_analysis

Returns the paginated table of tracked ASINs and prices: your price, Buy Box price, Price Index, gap, and diagnosis. The period defaults to 30 days and is at most 95 days. Covers tracked products. Use when the user asks which tracked ASINs are priced above or below the Buy Box. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_price_index_products

Returns the Price Index mix for tracked products: diagnosis counts and the average index. The period defaults to 30 days and is at most 95 days. Covers tracked products. Use when the user asks how tracked prices compare with the Buy Box overall. Does not return the ASIN table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_price_index_summary

Returns the sales-rank analysis for one identified tracked ASIN: diagnosis, evidence, actions, and tracked competitors. competitor.items lists each configured competitor with ASIN, label, product title, rank, gap_positions, and gap_label. The competitor whose gap_positions equals best_gap_positions is the closest listed competitor. Requires product_child_id or the ASIN. The period defaults to 30 days and is at most 95 days. Use when the user asks for the rank diagnosis of one named ASIN. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_sales_rank_analysis

Returns the paginated table of tracked ASINs and sales rank: best-seller rank, delta, trend, volatility, and diagnosis. The period defaults to 30 days and is at most 95 days. Covers tracked products. Use when the user asks which tracked ASINs gained or lost rank. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_sales_rank_products

Returns sales-rank totals for tracked products: how many improved or declined, and the top movers. The period defaults to 30 days and is at most 95 days. Covers tracked products. Use when the user asks how tracked sales rank is trending overall. Does not return the ASIN table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_sales_rank_summary

Returns the Amazon Seller account snapshot for one day: sales for that day versus the day before and versus the same weekday one week earlier, orders and units, account health score from 0 to 1000, late shipment rate, order defect rate, Buy Shipping use over the last 7 days, and the top ASINs of the day. as_of_date is optional and defaults to the current day. Use when the user asks how the Seller account is doing on a given day, or for account health or Buy Shipping. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_seller_account_performance

Returns the paginated list of recorded Amazon Seller finance transactions from the finance-transactions screen. Each row includes posted date, type, status, order id, SKU, quantity shipped, marketplace name, currency, price amount, fee amount, and total amount. Date range is at most 366 days. Use when the user asks for the individual recorded Seller finance transactions on the finance-transactions screen. Does not place or send payments. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_seller_finance_transactions

Returns totals of recorded Amazon Seller finance transactions from the finance-transactions screen, grouped by currency and type, for a date range of at most 366 days. Use when the user asks for recorded Seller finance transaction totals on the finance-transactions screen. Does not place or send payments. Does not return the transaction rows. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_seller_finance_transactions_summary

Returns the paginated Amazon Seller sales table by ASIN: title, ordered units, ordered revenue, sessions, and unit conversion after summation. Dates are required, as Y-m-d. marketplace is an Amazon marketplace id or a nation code such as IT. Default sort is ordered units descending. Use when the user asks which Seller ASINs sold in a period. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_seller_sales_products

Returns Amazon Seller sales and traffic totals and a daily series for a date range: ordered revenue, units, sessions, page views, shipped amounts when present, and conversion after summation. Dates are required, as Y-m-d. marketplace is an Amazon marketplace id or a nation code such as IT. Use when the user asks for Seller sales, Seller orders, or Seller traffic over a period. Does not return the ASIN table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_seller_sales_summary

Returns the paginated list of recorded Amazon Seller finance transactions from the transactions-v2 screen. Each row includes transaction id, posted date, type, status, description, order id, marketplace, total amount, and currency. Date range is at most 366 days. Use when the user asks for the individual recorded Seller finance transactions on the transactions-v2 screen. Does not place or send payments. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_amazon_seller_transactions_v2

Returns totals of recorded Amazon Seller finance transactions from the transactions-v2 screen, grouped by currency, type, and status, for a date range of at most 366 days. Use when the user asks for recorded Seller finance transaction totals on the transactions-v2 screen. Does not place or send payments. Does not return the transaction rows. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_amazon_seller_transactions_v2_summary

Returns the paginated Seller warehouse-coverage table: SKU, warehouse, coverage status, available, stock, and predicted quantity, days of cover, demand used, lead time, reorder point, and recommended order quantity. Default sort is recommended order quantity descending. start_date and end_date do not filter this snapshot. Use when the user asks which Seller warehouse SKUs are in a coverage status or have a recommended reorder. Page size defaults to 50 and is at most 100. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

list_seller_warehouse_coverage

Returns the latest Seller warehouse-coverage snapshot: available, stock, and predicted totals, average days of cover, recommended order quantity, status mix OK, CRITICAL_OOS, WARNING_OOS, OVERSTOCK, NO_SALES, and NO_DATA, demand-method mix, the five SKUs with the highest recommended reorder, and the five SKUs with the lowest days of cover. start_date and end_date do not filter this snapshot. Use when the user asks for Seller warehouse days of cover or what to reorder for the merchant-fulfilled channel. Does not return the SKU table. Read-only. Uses the tenant on the signed-in session. The result may include a markdown link to the Bonsai screen.

get_seller_warehouse_coverage_summary