Clarmix

Live account-level Merchant Center issues and alerts (suspensions, policy violations, missing settings) with severity, affected destinations/countries and documentation links.

gmc_account_issues

Primary and supplemental data sources (feeds) in Merchant Center, including the Clarmix supplemental label/enrichment feeds, with feed label, language, countries and fetch schedule.

gmc_data_sources

Clicks, impressions and CTR per product from Merchant Center (free listings and ads, by marketing method), for a date range.

gmc_product_performance

Live product health in Merchant Center: active / pending / disapproved / expiring counts per destination and country, the most frequent item-level issues (with resolution hints and number of affected products), and optionally sample products affected by an issue.

gmc_product_issues

Performance Max asset groups with ad strength, metrics and what each one targets (listing-group filters: custom labels, brands, product types, item ids), sorted by cost. Also shows how Clarmix labels (clarmix_* values on the account custom label slot) are split across enabled asset groups, which labels are not targeted, and asset groups targeting all products. Enabled groups of enabled campaigns only by default.

ads_pmax_structure

Clarmix content-quality scores for the catalog (title, description, Google category, product type, highlights, details, Q&A, item group title, related products, document links, variant options, popularity rank): averages, tier distribution, custom label usage, the weakest products for a chosen attribute, and an enrichment plan: weak attributes ranked by ad spend on poor-content products, with the Clarmix action and credit cost for each.

get_content_quality

Everything Clarmix knows about one product: Merchant Center attributes, original vs AI-enriched vs manual values, all content scores with reasons, external data (Shopify cost/margin/stock/orders, CSV columns), stored Ads metrics and label history.

get_product

Runs any Google Ads Query Language SELECT on this account (ad groups, keywords, assets, audiences, geo, devices, bidding strategies…). Single SELECT only, max 1000 rows, the customer is fixed by accountId. Money fields ending in _micros are returned converted (cost_micros → cost). Always add a segments.date filter when selecting metrics: DURING accepts TODAY, YESTERDAY, LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, THIS_MONTH, LAST_MONTH, LAST_BUSINESS_WEEK, THIS_WEEK_MON_TODAY, LAST_WEEK_MON_SUN; for other periods use segments.date BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'.

run_gaql

Searches the products Clarmix holds for this account (Merchant Center data + Clarmix label + stored Google Ads metrics over the account default window + content scores + enrichment state). Use filters for labels, custom labels, brand, metric ranges or advanced conditions. sortBy can be slow on large result sets, so combine it with selective filters.

search_products

Search terms that triggered ads: Search/Shopping (search_term_view, with ad group and added/excluded status) and Performance Max search term insights (campaign_search_term_view). Filter by campaign, text, and metric thresholds. Up to 1000 terms per source (highest cost first) are fetched; page through them with limit + offset (see nextOffset) to build full lists.

ads_search_terms

Compares the live Shopify catalog with the products Clarmix has from Merchant Center: active Shopify variants not in Merchant Center (with a sample), top sellers of the last 30 days that are not in Merchant Center, variants in Merchant Center that Clarmix has not linked to Shopify, and Shopify variants missing a barcode (GTIN) or a product cost (COGS). Large stores are scanned for up to ~20 seconds, so counts can be partial (see scan.complete).

shopify_catalog_gaps

Runs a read-only Shopify Admin GraphQL query (API 2026-07) on the connected store for raw store details: a product with its variants, options, metafields or status, collections and their products, inventory items and their cost, locations, order statuses / items / discounts / refunds, shop settings. Results are raw Shopify data, not aggregated or joined with Google Ads. Query rules: query operations only; root fields: shop, products, product, productByIdentifier, productsCount, productVariants, productVariant, productVariantsCount, collections, collection, collectionByIdentifier, collectionsCount, inventoryItems, inventoryItem, locations, location, locationsCount, orders, order, ordersCount, metaobjects, metaobject, metaobjectDefinitions, sellingPlanGroups, publications; every list needs "first" (max 50), nested lists multiply (max ~2,500 items per query); use pageInfo { hasNextPage endCursor } and "after" to page. Customer and payment data (customer, email, phone, addresses, IPs, notes, payment details) is never available. Orders only go back 60 days before the store connected to Clarmix. Money is in the shop currency. Shopify GraphQL errors are returned so the query can be fixed.

shopify_query

For a period, joins Shopify sales and product costs (COGS) with live Google Ads Shopping / PMax spend per product: revenue (gross and net of discounts / returns / tax), units, gross profit (on net revenue when available), ad cost, ad conversion value, ROAS, POAS (gross profit ÷ ad cost) and profit after ads, per product, variant, vendor, product type or Clarmix label. Flags products that lose money after ad spend and reports ad spend that cannot be matched to a Shopify product. Profit figures need COGS ("Cost per item") set in Shopify and the same currency in Shopify and Google Ads.

shopify_profitability

Shopify orders for a period (stored by Clarmix from the connected store): orders, revenue, units, average order value, an optional day/week/month series, and the top products, variants, vendors, product types, collections or Clarmix labels by revenue or units, with net sales (after discounts, returns and cancellations, excluding tax and shipping). Shows how much revenue comes from products that are not in Merchant Center. Aggregates only, no customer data. Returns a "not connected" message with setup steps when the account has no active Shopify integration.

shopify_sales

Stock of the Shopify variants that are in Merchant Center, compared with sales velocity (30 / 90 days) and stored Google Ads spend: out-of-stock products still spending on ads, best sellers with low days of cover, overstock / dead stock (no sales in 90 days or too many days of cover), and products selling without ad spend, each with its Clarmix label. Totals include stock units and stock value at cost.

shopify_inventory

Live product-level Google Ads performance from Shopping and Performance Max (shopping_performance_view) for any date range: cost, revenue, ROAS, conversions, CPA, clicks, impressions, CTR, CPC, conversion rate. Group by one or several dimensions (e.g. ["product", "country"] for each product per country): product, campaign, country, language, channel (online / local), device, brand, product type L1-L5, Google category L1-L3, custom labels. Filter by offer ids, product title text, brands, product type text, countries (ISO codes), languages, channel, Clarmix labels, custom label values or campaigns; apply metric thresholds (e.g. ROAS > 4, cost > 50) and sort. granularity adds a day / week / month series per row (up to 20 rows; filter to a few products first).

ads_product_performance

Standard Shopping ad groups with metrics and what each one targets (product partitions by custom label, brand, product type, item id, with bids and exclusions in detail "full"), sorted by cost, plus how Clarmix labels are used in the partitions. Enabled ad groups of enabled campaigns only by default.

ads_shopping_structure