Answer ad performance questions using data from Fivetran's ad connectors via BigQuery, Snowflake, or Databricks. Cross-channel analysis across Google Ads, Facebook Ads, Microsoft Ads, LinkedIn Ads, TikTok Ads, Pinterest Ads, and Snapchat Ads. Use when someone asks about ad spend, impressions, clicks, conversions, CPC, CPM, ROAS, CTR, or any advertising metrics. Supports cross-channel comparison, campaign drill-down, trend analysis, keyword performance, and anomaly detection. Trigger on: "how are our ads performing", "ad spend", "campaign performance", "cost per click", "ROAS", "impressions", "CTR", "ad performance", "marketing analytics", "compare channels", "cross-channel", "Facebook vs Google", "budget allocation", "LinkedIn ads", "TikTok ads", "Pinterest ads", "Snapchat ads", "LinkedIn performance", "TikTok performance", "Pinterest performance", "Snapchat performance".
customer-support-analysis Answer Zendesk customer support questions using Fivetran-synced data via BigQuery, Snowflake, or Databricks. Analyzes ticket volume and trends, first reply and resolution times (business + calendar hours), backlog aging, agent performance, SLA breach rates, CSAT, and channel/priority breakdowns using the fivetran/zendesk dbt package models (zendesk__ticket_enriched, zendesk__ticket_metrics, zendesk__ticket_field_history, zendesk__ticket_backlog, zendesk__ticket_summary, zendesk__sla_policies). Use when someone asks about support ticket volume, first reply / resolution time, backlog, agent performance, SLA breaches, CSAT, or any Zendesk metric. Trigger on: "first reply time", "first response", "resolution time", "ticket resolution", "ticket backlog", "open tickets", "SLA breach", "CSAT", "satisfaction score", "agent performance", "ticket volume", "support performance", "Zendesk", "customer support".
marketing-automation-analysis Answer marketing automation questions using Fivetran-synced data via BigQuery, Snowflake, or Databricks. Today supports Marketo via the fivetran/marketo dbt package; designed to extend to HubSpot Marketing, Pardot, Iterable, Braze, etc. as additional connector options. Analyzes funnel velocity (MQL/SAL/SQL transitions), nurture stream performance, email engagement (sends/opens/clicks/unsubscribes), campaign and program performance, lead source attribution, and lead engagement scoring using marketo__leads, marketo__lead_history, marketo__email_sends, marketo__campaigns, marketo__programs, and marketo__email_templates. Use when someone asks about lead funnel, MQL/SAL/SQL transitions, nurture performance, email engagement rates, campaign performance, lead source quality, or any marketing- automation metric. Trigger on: "funnel velocity", "MQL", "SAL", "SQL", "lead funnel", "nurture", "email open rate", "email click rate", "unsubscribe rate", "bounce rate", "campaign performance", "lead source", "attribution", "l
