AI Assistants data reference

A per-source list of every MCP tool your connected AI assistant can call through SyncRange, and what each one returns. All tools are read-only and return aggregated, bucketed summaries rather than raw row-level exports, so responses stay fast and fit comfortably in a chat.

For setup, see AI Assistants overview, or the guides for ChatGPT, Claude, Gemini, and CLI clients.

How your assistant finds the right account

If you've connected more than one account from the same source (e.g. two Shopify stores), your assistant can work out which one you mean from how you refer to it - by its name, not some internal id. If what you said matches more than one connected account, a good assistant will simply ask you to clarify which one, the same way you'd ask a colleague.

Every connection also comes with a built-in way for your assistant to check what's connected at any time, so it can confirm an account exists (or tell you it doesn't) before answering. You can also ask directly - e.g. "what accounts do I have connected?" - and your assistant will look it up and list them by name.

Shopify

Requires the shopify scope on your token.

ToolWhat it returns
shopify_shop_summary Basic store info: name, domain, plan, currency, timezone, primary locale.
shopify_orders_summary Order count and revenue, bucketed by day or month (start, end, granularity). Date ranges are capped at ~31 days; for longer financial trends use shopify_sales_summary.
shopify_sales_summary A financial breakdown - gross sales, discounts, returns, net sales, shipping, tax, and total sales - bucketed by day or month (start, end, granularity, up to ~2 years). Mirrors Shopify's own sales-metrics accounting, so it's the better tool for "how much did I actually make" and year-long questions than shopify_orders_summary.
shopify_top_products_summary Best-selling products by revenue over a date range (start, end, limit, default 20/max 100). Date ranges capped at ~31 days.
shopify_customers_summary Customer purchasing activity over a date range: unique customer count, how many ordered more than once, and the top customers by spend (start, end, limit, default 20/max 100). Date ranges capped at ~31 days.
shopify_inventory_summary A current-state snapshot of inventory: total inventory value, out-of-stock and low-stock variant counts (low_stock_threshold, default 5), and inventory value by product type. No date range - this reflects stock right now.

Amazon Seller

Requires the amazon_seller scope on your token.

ToolWhat it returns
amazon_seller_account_summary Seller name, id, region, marketplaces, and seller country/timezone.
amazon_seller_orders_summary Order count and revenue bucketed by day or month (start, end, granularity, up to ~2 years). Amazon generates this via an asynchronous report, so this tool can take longer to respond than others - if Amazon's report doesn't finish in time, you'll be asked to try a narrower date range.

Etsy

Requires the etsy scope on your token. Reads a specific connected Etsy shop.

ToolWhat it returns
etsy_shop_summary Shop name, id, url, currency, country, and timezone.
etsy_orders_summary Order count and revenue from receipts, plus paid/shipped counts, bucketed by day or month (start, end, granularity, up to ~2 years).
etsy_listings_summary Active listing counts, stock levels (out-of-stock / low-stock), and top listings by views. Point-in-time catalog snapshot - no date range.

Google Analytics

Requires the analytics scope on your token. Reads a specific connected GA4 property.

ToolWhat it returns
google_analytics_summary Daily sessions, total users, and page views for a date range (start, end, up to ~400 days).

Google Search Console

Requires the search_console scope on your token. Reads a specific connected Search Console site.

ToolWhat it returns
google_search_console_summary Daily search clicks, impressions, click-through rate and average position for a date range (start, end, up to ~400 days).
google_search_console_queries Top search queries/keywords with clicks, impressions, CTR and average position for a date range (start, end, limit default 25 / max 100, ranked by clicks).

Google Ads

Requires the ads scope on your token. Reads a specific connected Google Ads account.

ToolWhat it returns
google_ads_campaign_summary Impressions, clicks, cost and conversions totalled across all campaigns, bucketed by day or month (start, end, granularity, up to ~400 days). For per-campaign breakdowns, use SyncRange's regular Google Ads export instead.

Google Business Profile

Requires the business_profile scope on your token. Reads a specific connected Business Profile location.

ToolWhat it returns
google_business_profile_summary Daily views (Maps and Search), phone call clicks, website clicks, and direction requests for a date range (start, end, up to ~400 days).

Meta (Facebook & Instagram)

Requires the meta scope on your token. list_connected_accounts lists your Meta ad accounts (Ads Manager), not the Facebook profile login. Pass that ad account name or id as account.

ToolWhat it returns
meta_account_summary Ad account name, id, currency, and account status.
meta_campaign_insights_summary Impressions, clicks and spend totalled across all campaigns, bucketed by day or month (start, end, granularity, up to ~400 days).

TikTok Ads

Requires the tiktok_ads scope on your token. list_connected_accounts lists your TikTok advertiser / ad accounts, not the TikTok login. Pass that ad account name or id as account.

ToolWhat it returns
tiktok_account_summary Ad account name, id, and currency.
tiktok_campaign_insights_summary Impressions, clicks and spend totalled across all campaigns, bucketed by day or month (start, end, granularity, up to ~400 days).

LinkedIn

Requires the linkedin scope on your token. list_connected_accounts lists your LinkedIn Campaign Manager ad accounts, not the LinkedIn profile login. Pass that ad account name or id as account.

ToolWhat it returns
linkedin_account_summary Ad account name, id, currency, and timezone.
linkedin_campaign_insights_summary Impressions, clicks and spend (USD) totalled across all campaigns, bucketed by day or month (start, end, granularity, up to ~400 days).

Microsoft/Bing Ads

Requires the bing_ads scope on your token. Reads a specific connected Bing Ads account.

ToolWhat it returns
bing_ads_account_summary Account name, id, customer id, currency, and timezone.
bing_ads_campaign_summary Impressions, clicks, spend and conversions totalled across all campaigns, bucketed by day or month (start, end, granularity, up to ~400 days).

Need raw row-level data?

AI Assistants return aggregated summaries sized for chat. For full exports to Google Sheets, BigQuery, or Excel, use SyncRange's regular export schedules from each connected app.

Related Documentation

Stop Juggling Dashboards. Start Growing Get your data flowing today, free plan available.