Jays

Get Ad Insights

Fetch Meta Ads performance insights for an ad account. Returns impressions, clicks, CTR, CPC, CPM, spend, plus actions and conversions (lists of event objects from Meta, not a single scalar). spend mentioned in response is in Dirhams

Get Creative Details

Fetch Meta Ad Creative details for the configured ad account. Returns per-creative id, name, title (headline), body, image_hash, video_id, thumbnail_url, object_type, status, and object_story_spec. Creation date is not available — AdCreative has no created_time field. When top-level title/body/image_hash/video_id are empty, copy and media often live under object_story_spec (link_data, video_data, or photo_data).

Get Account Structure

Fetch Meta Ads account structure: campaigns → ad sets → ads. Returns hierarchy with budgets, bid strategy, and optimization goal. Budgets (`daily_budget`, `lifetime_budget`) and `bid_amount` are in the account currency's smallest unit (e.g. fils for AED), as numeric strings. Budget and bid strategy may live on the campaign (CBO) and/or ad set; `optimization_goal` is an ad set field.

Get Ad Delivery Status

Fetch Meta Ad delivery status diagnostics for the configured ad account. Returns per-ad id, name, status, effective_status, adset_id, campaign_id, issues_info, and ad_review_feedback. Use this to diagnose why ads are not delivering. issues_info is typically present when effective_status is WITH_ISSUES; ad_review_feedback appears when there are policy/review issues.

Get Instagram Insights

Fetch Instagram account insights for the configured business account. Returns follower_count (daily time series), follows_and_unfollows (with follow_type breakdown), reach, views, and profile_links_taps (with contact_button_type breakdown). Note: `views` replaces deprecated impressions. `profile_links_taps` replaces deprecated profile_views. follower_count and follows_and_unfollows require ≥100 followers. Insights data may lag up to ~48 hours and is typically limited to the last ~90 days.

Get Instagram Media

Fetch Instagram posts and reels with per-item engagement metrics. Returns FEED posts and REELS only (Stories are excluded). Each item includes id, caption, media_type, media_product_type, timestamp, permalink, like_count, comments_count, saved_count, shares_count, and plays (`plays` is mapped from Meta's total_views_count — aggregated views/plays including boosted/crossposted when available). Metrics may lag up to ~48 hours. like_count and comments_count are organic on the media object; saves/

Get Mentions

Fetch Instagram media where this business account was photo-tagged. Uses Meta's /{ig-user-id}/tags edge (photo tags), not caption/comment @mentions (those require webhooks and cannot be listed retrospectively). Returns posts and other tagged media Meta includes (Stories when available, typically ~24h and public accounts only). Private media is never returned. Each item includes id, caption, media_type, media_product_type, timestamp, permalink, username (media owner), like_count, comments_count

Get Media Comments

Fetch all organic comments on a given Instagram media post. Returns top-level comments (newest first) with nested replies. Each comment includes id, text, timestamp, username, like_count, hidden, from ({id, username} when available), and replies (same fields, no further nesting). Use the media `id` from get_instagram_media. Organic comments only (ad / boosted comments are not included). Requires a token with comment read permissions (instagram_manage_comments or equivalent).

Get Conversation Analytics

Fetch WhatsApp message volume, delivery, and optional template read rates. Always returns messaging analytics (sent/delivered) for the configured WABA. When `template_ids` is provided, also returns template analytics (sent/delivered/read) for those templates. Notes: - Messaging analytics lookback is typically up to ~1 year. - Template analytics lookback is up to ~90 days; read/click data is only reliable for ~7 days after send. - Read rates apply to template messages only (not free-form sess

Get Clarity Insights

Fetch stored Microsoft Clarity behavioral analytics for the website. Returns metrics such as Traffic, Popular Pages, Scroll Depth, Engagement Time, Dead Click Count, Rage Click Count, Excessive Scroll, Quickback Click, Script Error Count, and Error Click Count. Each returned document holds one metric for one dimension breakdown, with `rows` containing the raw per-segment values Clarity reported. Data is served from a scheduled snapshot store, not live: a worker pulls Clarity once a day, so fig

Get Database Schema

List the tables, columns, and relationships in the PostgreSQL database. Call this before `run_sql_query` — it is the only way to learn what can be queried. Returns one entry per table or view with its columns (name, type, nullable, default), primary key, foreign keys formatted as `orders.customer_id -> public.customers.id`, and table comment. Only tables the read-only database role can actually SELECT from are listed; Postgres system schemas are excluded. Large databases are capped at `DB_MAX_

Run Sql Query

Run one read-only SELECT against the PostgreSQL database and return rows. Use `get_database_schema` first to learn the tables and columns. Returns `columns` (ordered column names) and `rows` (a list of value lists aligned to those columns). Only a single pure read is accepted. The query is rejected with an explanatory error when it: - is anything other than SELECT, WITH ... SELECT, or a UNION/INTERSECT/EXCEPT of those — no INSERT, UPDATE, DELETE, DDL, GRANT, COPY, SET, or EXPLAIN - contains