Platform Guide
A complete reference for deploying Lytica across your enterprise — from first connection to advanced AI-powered analytics across connected integrations.
1. Platform Overview
Lytica is an AI-powered analytics platform designed to unify your advertising, financial, and operational data into a single intelligent interface. Our platform enables enterprise teams to:
- Query data naturally — Use conversational AI to ask questions about your business data
- Unify disparate sources — Connect multiple data sources and view them through a normalized schema
- Automate insights — Receive intelligent recommendations and automated reporting
- Scale securely — Enterprise-grade security with role-based access control
2. Signing In and Out
Lytica uses WorkOS AuthKit for authentication, with Google as the primary identity provider. Signing in is hosted by WorkOS, so you never enter passwords directly into Lytica.
Creating an Account
New accounts are created in one of two ways:
- By invitation— Your organization admin invites you by email. Click the invite link, sign in with Google, and you'll be added to the organization automatically.
- By contacting sales— If your organization isn't on Lytica yet, reach out via our contact pageand we'll provision your workspace.
Signing In
- Visit alpha.lyticalabs.ai and click Sign In in the top-right corner.
- You'll be redirected to the WorkOS hosted sign-in page.
- Choose Continue with Google (or another configured SSO provider) and authenticate.
- After successful login, you're routed automatically based on your account state — see the diagram below.
(if multiple orgs)
(or onboarding)
Selecting an Organization
If you belong to a single organization, Lytica selects it automatically. If you belong to multiple, you'll see the Select Organization picker:
- Each card shows the organization name and your role (Admin, Member, or Viewer).
- Click an organization to bind your session to it. The current session is refreshed and you're redirected into that workspace.
- Your selection persists for the duration of your session — closing the tab or signing out resets it.
Switching Organizations
To move between organizations without signing out:
- Click your avatar in the top-right corner of any page.
- Choose Switch Organization.
- You'll be sent back to the org picker, where you can select a different workspace.
Signing Out
You can sign out from two places:
- Avatar dropdown — Click your avatar (top-right) and choose Log out.
- Account page — Navigate to Account → Profile and use the Signed in with Google control to revoke your session.
Signing out clears your WorkOS session and notifies the Chrome extension (if installed) so it logs out in lockstep with the web app.
3. Quick Start Guide
Get up and running with Lytica in minutes:
Step 1: Sign In and Pick Your Organization
Sign in at alpha.lyticalabs.ai using Google. If you belong to multiple organizations, pick the one you want to work in. New to Lytica? See Signing In and Out for the full walkthrough, or contact sales to provision a new organization.
Step 2: Connect Your First Integration
- Navigate to Settings → Integrations.
- Pick an integration from the available list.
- Enter the required credentials (API key, OAuth, or service account).
- Click Connect to establish the connection. See the per-integration guides below for step-by-step instructions.
Step 3: Start Asking Questions
Once connected, click Marli in the sidebar and ask a question about your data. See Using Marli for tips on phrasing questions, deep-link parameters, and threads.
Step 4: Set Up Alerts and Invite Your Team
- Alerts — Have Marli watch your data and notify you when something changes. See Alerts.
- Invite teammates — Open Settings → Team to add Admins, Members, or Viewers. See Team Management.
- Customize your account — Connect personal services (Drive, HubSpot) and install the Chrome extension. See Your Account.
4. Using Marli (AI Chat)
Marliis Lytica's AI analyst — the conversational surface where you actually get work done. Ask questions in plain English and Marli queries your connected integrations, builds the SQL or API calls behind the scenes, and returns answers with charts and tables.
Starting a Conversation
From any page, click Marli in the sidebar (or the Lytica logo to return to the home Marli view). The home view shows a centered prompt; once you submit a question, the conversation opens in a thread.
Three things happen behind the scenes when you submit:
- Lytica picks the right tools based on which integrations you've enabled for the conversation.
- The model executes those tools — running queries, calling APIs, fetching data.
- Results stream back as text, tables, charts, or downloadable files.
What You Can Ask
- Performance metrics — Revenue, impressions, fill rates, margins, CPM, CPC.
- Comparisons— “How did this week compare to last week?” or “Compare Limelight to Adtelligent on fill rate.”
- Breakdowns — Slice data by any available dimension (country, demand partner, campaign, etc.).
- Trends and anomalies— “What changed yesterday?” or “Where did revenue drop?”
- Financial data — Bills, invoices, payments, balances from Bill.com or QuickBooks.
- Document and file queries — Search and summarize documents in Google Drive.
- Setup actions — Marli can create alerts, configure variable mappings, and walk you through integrations.
Selecting Integrations
By default Marli has access to all connected integrations in your organization. You can narrow scope two ways:
- Mention an integration in your question — “Show me Limelightimpressions” tells Marli to query Limelight specifically.
- Use the integrations chip — Click the chip below the input box to pick exact integrations. Useful for cross-source comparisons or to keep Marli focused on one domain (e.g. only finance).
?q= to the Marli URL to pre-fill a question, e.g. /acme/marli?q=Show%20revenue%20by%20country. Combine with ?integrations=limelight,bill_com to also pre-select integrations. Great for dashboards, Slack messages, or saved bookmarks.Date Ranges
Use natural language for dates — Marli resolves them in your timezone:
- “yesterday”, “today”, “this week”, “last month”
- “last 7 days”, “past 30 days”
- “January 2026”, “Q1 2026”
- “from January 1 to January 15”
Threads and History
Every conversation is saved as a thread. Threads appear in the left sidebar under Recent:
- Open — Click a thread to resume where you left off.
- Rename — Hover and click the pencil icon to give a thread a meaningful name.
- Delete — Hover and click the trash icon to remove a thread permanently.
- Pin — Pin frequently-used threads to the top.
Snowflake and BigQuery Modes
For data warehouse queries, Lytica offers dedicated modes that surface schema introspection and SQL preview:
- BigQuery mode — Available once a BigQuery integration is connected. Marli can list datasets, inspect tables, and run typed SQL. Example: “Query the events dataset in BigQuery for last week.”
- Snowflake mode — Coming soon. Will offer the same capabilities once Snowflake support ships.
Tips for Effective Queries
- Be specific about metrics and dimensions— “Revenue by country” is better than “show me revenue.”
- Set a time window — Otherwise Marli has to guess (it usually defaults to the last 7 days).
- Iterate— If the answer isn't what you wanted, follow up: “Now break that down by demand partner” or “Filter to only mobile.”
- Ask for charts— “Show that as a bar chart” or “Plot the daily trend.”
- Use Marli for setup— “Create a threshold alert on Limelight revenue below $1k/hour” works just like the Alerts page.
5. Alerts
Alerts let Lytica watch your data for you and notify you when something interesting happens. Every alert is created via Marli — you pick a type, then describe what you want in plain English. The agent fills in the configuration based on your conversation.
Alert Types
| Type | What it does | Example |
|---|---|---|
| Threshold | Fires when a metric crosses a value you define. | Revenue drops below $1,000/hour on Adtelligent. |
| Anomaly Detection AI | Uses a baseline window and sensitivity to detect unusual patterns. | Unusual fill-rate drop across integrations. |
| Scheduled Report | Runs a query on a recurring schedule and delivers the result. | Daily revenue summary at 9 AM. |
| One-time | Fires once when a condition is met or at a specific moment. | Notify me when revenue first crosses $10k today. |
| Reminder | Sends a custom message at a specific or recurring time. | Remind me to review pacing every Monday at 9 AM. |
Creating an Alert
- Open the Alerts page from the sidebar.
- Click + Create Alert in the top-right.
- Choose an alert type from the picker. The five cards correspond to the types in the table above.
- You'll be redirected into a Marli thread with the type pre-selected as a green chip in the input box.
- Describe what you want in plain English — e.g. “Alert me when Limelight revenue drops below $500/hour.”
- Marli asks any clarifying questions (which integration, threshold value, check interval, channels), then saves the alert.
Managing Alerts
The Alerts page shows every alert in your organization as a card. From there you can:
- Filter and search — Use the toolbar to filter by type, channel, or status. The search box matches alert titles and descriptions.
- Pause / resume — Toggle an alert on or off without losing its configuration.
- Open detail — Click an alert card to open the detail sheet with full configuration, channels, and execution history.
- Edit— Continue the original Marli thread to modify the alert (“change the threshold to $750”).
- Delete— Remove an alert permanently from the detail sheet's overflow menu.
Alert Detail Sheet
The detail sheet (slides in from the right when you click a card) shows:
- Configuration — Metric, operator, threshold, schedule, and integrations the alert watches.
- Notification channels — In-app, email, and Slack (per channel, including which Slack channels and which email addresses).
- Execution history — Last N runs, with timestamps, status (success / fired / failed), and the value at evaluation time.
- Auto-disable— If an alert fails 5 times in a row (e.g. integration auth expired), Lytica automatically pauses it and notifies the alert owner so it doesn't spam channels with errors.
Notification Channels
- In-app — Always on. Notifications appear in the bell icon in the top-right.
- Email— Sent to the email addresses you configure on the alert. By default this is the alert creator's email.
- Slack — Requires the Slack integration. Once connected, you can pick any channel the Lytica bot has been invited to. See the Slack integration guide for setup.
6. Your Account
The Account page is your personal hub for profile information, connected services, the Chrome extension, and onboarding state. Open it from the avatar dropdown in the top-right of any page.
Profile
- Name and email — Synced from your Google identity. Update your name in Google to update it in Lytica.
- Avatar — Pulled from Google. The first letter of your email is used as a fallback if no avatar is available.
- Role and organization — Shows your current role (Admin, Member, Viewer) and the active organization. Use Switch Organization from the avatar dropdown to change.
Connected Accounts
Lytica uses WorkOS Pipes to let you connect personal third-party accounts (separate from organization-wide integrations). Use connected accounts when you want Marli to access something only you have credentials for — for example, your own HubSpot or Google Drive folder.
- Scroll to Connected Accounts on the Account page.
- Click Connect next to the service you want.
- Complete the OAuth flow in the popup window.
- The account is now available to Marli for queries you make.
To disconnect, click Disconnect next to a connected account. The token is revoked immediately.
Chrome Extension
The Lytica Chrome extension brings Marli into any browser tab — useful for asking questions about a page you're viewing, summarizing documents, or pulling stats without context-switching.
- On the Account page, find the Chrome Extension card.
- Click Install to open the Chrome Web Store listing.
- After install, the extension automatically picks up your Lytica session — no separate sign-in needed.
- Click the extension icon in your toolbar to open Marli over the current page.
Onboarding
The first time you sign in, Lytica walks you through a short onboarding flow: choose your use case, connect a first integration, and meet Marli. If you skipped onboarding or want to revisit it, use the Relaunch onboarding button on the Account page.
7. Team Management
The Team page (Settings → Team) is where admins manage who has access to the organization, what role they have, and pending invitations.
Roles
| Role | Permissions |
|---|---|
| Admin | Full access. Can manage integrations, billing, team members, and all settings. Can invite new members and change roles. |
| Member | Standard access. Can use Marli, create and manage their own alerts, and view all integrations. Can copy invite links to share with new members (subject to admin approval). |
| Viewer | Read-only. Can view dashboards and ask Marli questions, but cannot create alerts or modify integrations. |
Inviting Team Members
Admins can invite by email:
- Open Settings → Team.
- Click Invite member.
- Enter one or more email addresses (comma-separated) and pick a role.
- Click Send invites. Each invitee gets an email with a link to join your organization.
Members can share an invite link:
- Click Copy invite link on the Team page.
- Share the link directly. The recipient signs in with Google and is added to your org pending admin approval (configurable per org).
Managing Members
- Change role— Click a member's role badge to promote or demote them.
- Remove member — Click the overflow menu next to a member and choose Remove. They lose access immediately.
- Revoke invitation — In the Pending invites section, click the trash icon to invalidate an unaccepted invite.
- Resend invitation — If an invite email was missed, click Resend to send a fresh link.
8. Billing and Plans
Lytica is sold as a token-metered SaaS. Tokens cover Marli queries, alert evaluations, and integration data sync. The Billing page (Settings → Billing) shows your current plan, usage, and invoices.
Plan Tiers
| Plan | Tokens / month | Team size | Best for |
|---|---|---|---|
| Starter | 250k | Up to 3 seats | Solo founders and small teams piloting Lytica. |
| Standard | 2M | Up to 10 seats | Growing teams running multiple integrations. |
| Pro | 10M | Up to 50 seats | Mid-market teams with high query volume and many alerts. |
| Enterprise | Custom | Unlimited | Large orgs with custom integrations, SSO, and SLA needs. |
Exact token allocations and pricing may vary — see the pricing page for the current matrix or contact sales for an Enterprise quote.
Viewing Usage
The Billing overview shows:
- Tokens used — Tokens consumed in the current billing period, with a progress bar against your plan limit.
- Storage — Indexed files (e.g. uploaded documents) and their size.
- Team members — Active seats vs. plan limit.
- Integrations — Connected integrations vs. plan limit (Starter caps at 3, Pro and Enterprise are unlimited).
Token usage is also broken down by feature (Marli, Alerts, Sync) and by user, so you can see who's consuming what.
Upgrading or Changing Plans
- Open Settings → Billing → Plans.
- Pick a new tier and click Switch plan.
- For Starter/Standard/Pro, the change is applied immediately and prorated on your next invoice.
- For Enterprise, click Contact Sales to start a conversation with our team.
Payment Methods and Invoices
- Card on file — Update via the Payment method card. Backed by Stripe.
- Invoices — Past invoices are listed at the bottom of the page, downloadable as PDFs.
- ACH / wire — Available on Pro and Enterprise. Contact billing@lyticalabs.ai to switch from card.
9. Available Integrations
Lytica supports a growing ecosystem of integrations across advertising, finance, data warehousing, and productivity platforms.
Integration Matrix
Live connectors are marked Available. Beta and planned connectors are labeled separately so the guide can include rollout planning notes without implying they are enabled for every account. Connect available integrations from Settings → Integrations (org-wide connectors) or Account → Connected Accounts (personal connectors). Marli can query connected sources directly, and several connectors also support write actions (create, update, delete) with confirmation.
Advertising & Ad Tech
| Integration | Category | Auth Type | Status |
|---|---|---|---|
| Limelight | Ad Tech (oRTB) | API Key | Available |
| Adtelligent | Ad Tech (SSP) | API Key | Available |
| Indicue | Ad Tech (SSP) | API Key | Available |
| Publica | Ad Tech (CTV) | API Key | Available |
| Added.tv | Ad Tech (CTV) | Session (User/Pass) | Available |
| iScream | Ad Tech (SSP) | API Key | Available |
| Vistars | Ad Tech (Trading Desk) | API Key | Available |
| BurtHub | Ad Tech (Analytics) | OAuth | Available |
Data & Warehousing
| Integration | Category | Auth Type | Status |
|---|---|---|---|
| Snowflake | Data Warehouse | API Key / Token | Available |
| Databricks | Data Lakehouse | API Key / Token | Available |
| Airtable | Database | OAuth | Available |
| BigQuery | Data Warehouse | Service Account | Coming soon |
Finance & Accounting
| Integration | Category | Auth Type | Status |
|---|---|---|---|
| QuickBooks | Finance | OAuth | Available |
| Bill.com | Finance | Session | Available |
| Tipalti | Finance (Payables) | OAuth | Available |
CRM & Sales
| Integration | Category | Auth Type | Status |
|---|---|---|---|
| Salesforce | CRM | OAuth | Available |
| Wealthbox | CRM (Advisors) | API Key | Available |
| Boostr | Ad Sales / OMS | Session | Available |
| Pipedrive Read/Write | CRM | OAuth | Available |
| Calendly | Scheduling | OAuth | Available |
Storage & Files
| Integration | Category | Auth Type | Status |
|---|---|---|---|
| Google Drive | Cloud Storage | OAuth | Available |
| Google Sheets Read/Write | Spreadsheets | OAuth | Available |
| Microsoft OneDrive Read/Write | Cloud Storage | OAuth | Available |
| Microsoft SharePoint Read/Write | Cloud Storage | OAuth | Available |
Productivity & Ops
| Integration | Category | Auth Type | Status |
|---|---|---|---|
| Slack | Messaging | OAuth | Available |
| Gmail | OAuth | Available | |
| Google Calendar | Calendar | OAuth | Available |
| Microsoft Outlook Read/Write | OAuth | Available | |
| Microsoft Outlook Calendar Read/Write | Calendar | OAuth | Available |
| Microsoft Teams | Messaging | OAuth | Available |
| Zoom Read/Write | Meetings | OAuth | Available |
| Asana Read/Write | Project Mgmt | OAuth | Available |
| Monday.com Read/Write | Work Mgmt | OAuth | Available |
| Notion Read/Write | Knowledge Base | OAuth | Available |
| Linear Read/Write | Issue Tracking | OAuth | Available |
| Atlassian (Jira + Confluence) Read/Write | Project Mgmt | OAuth | Available |
Universal
| Integration | Category | Auth Type | Status |
|---|---|---|---|
| Custom MCP | Universal (any MCP server) | URL / API Key | Coming soon |
Coming Soon
Dozens of additional connectors are on the roadmap. They appear in the in-app Integrations gallery with a “Coming soon” badge. A representative selection:
| Integration | Category |
|---|---|
| HubSpot | CRM |
| Jira (standalone) | Project Management |
| Trello, ClickUp, Basecamp | Project Management |
| PostgreSQL, MySQL, MongoDB | Database |
| Amazon Redshift, Azure Synapse | Data Warehouse |
| Datadog, New Relic, Splunk, Grafana, Elasticsearch | Observability |
| Stripe, Square, PayPal, Plaid, Xero, NetSuite, Chargebee, Recurly | Finance |
| Google Analytics, Google Ads, Meta Ads, LinkedIn Ads, X Ads, TikTok Ads | Marketing & Ads |
| Mailchimp, SendGrid, Klaviyo, Segment, Mixpanel, Amplitude, Heap | Marketing & Analytics |
| Zoho CRM, Close, Copper, Apollo.io, Outreach, SalesLoft, Gong | CRM & Sales |
| Intercom, Zendesk, Freshdesk | Support |
| Discord | Messaging |
| Shopify, WooCommerce, BigCommerce, Amazon Seller Central | E-commerce |
| GitHub, GitLab, Bitbucket, PagerDuty, Opsgenie, Sentry | Developer & DevOps |
| Dropbox, Box, Amazon S3, Google Cloud Storage, Azure Blob | Storage |
| Workday, BambooHR, Gusto, Rippling, Lever, Greenhouse, Deel, Lattice | HR & People |
| Zapier, Make, n8n, Workato | Automation |
10. MCP Integration
The Model Context Protocol (MCP) is an open standard that allows Lytica to connect with any MCP-compliant server, enabling real-time data access and tool execution.
What is MCP?
MCP provides:
- Standardized communication — Common protocol for AI-to-service interaction
- Tool discovery — Dynamic discovery of available capabilities
- Secure execution — Sandboxed tool execution with permission controls
- Real-time data — Live data access without batch imports
How MCP Works with Lytica
Setting Up MCP
For accounts with MCP access enabled, setup follows this pattern:
- Connect — Provide your MCP server URL in Integrations
- Discover — Lytica discovers available tools from your server
- Query — Users ask questions; Lytica calls your MCP tools
- Response — Results integrate into the AI conversation
11. Custom Integrations
For data that doesn't fit into pre-built connectors, Lytica offers flexible custom integration options.
Database Connections
- PostgreSQL — Connect with read-only access
- BigQuery — Planned managed warehouse connector
- Snowflake — Connect with read-only warehouse credentials
Spreadsheet Integrations
- Google Sheets — OAuth connection with read/write sheet actions
- Excel Upload — Planned drag-and-drop support for .xlsx, .xls, and .csv files
12. Variable Mappings
Lytica normalizes data from different sources into a standard variable schema, enabling cross-platform analysis.
Mapping Types
| Type | Description |
|---|---|
| Platform Mappings | Pre-configured mappings maintained by Lytica for each integration |
| Organization Overrides | Custom mappings specific to your organization |
| Custom Variables | Define your own variables for proprietary data |
Standard Variable Categories
- Metric — Quantitative values (impressions, bids, clicks)
- Financial — Money values (revenue, payout, cost)
- Temporal — Time dimensions (date, hour, month)
- Dimension — Categorical breakdowns (country, OS, device)
- Identifier — Entity references (partner name, publisher)
- Calculated — Derived metrics (fill rate, eCPM)
Limelight Integration
Programmatic oRTB advertising platform
How to Connect
- Go to Settings → Integrations
- Click Limelight from the available integrations
- Enter your credentials:
- Client Key — Your Limelight account client key
- Secret Key — Your Limelight account secret key
- Stats Base URL — Usually
stats.ortb.net
- Click Connect to verify and save
Available Variables
Metrics
Quantitative values you can query and aggregate:
| Variable | Description | Category |
|---|---|---|
OPPORTUNITIES | Count of opportunities presented by supply side | Metric |
BID_REQUESTS | Number of ad requests passed to the demand side | Metric |
BIDS | Total bid events received from demands | Metric |
WINS | Count of bids that result in auction win | Metric |
IMPRESSIONS | Impression events (actual ad serves) | Metric |
PUB_PAYOUT | Cost of media purchased to be paid to supply partner | Financial |
DEMAND_PAYOUT | Gross revenue charged to demand | Financial |
GROSS_REVENUE | Gross revenue (same as DEMAND_PAYOUT) | Financial |
DEMAND_SERVICE_FEE_PAYOUT | Fees charged by demand partners | Financial |
BID_RESPONSE_TIMEOUTS | Demand bid requests that timed out | Metric |
BID_RESPONSE_ERRORS | Demand bid requests that errored | Metric |
VAST_ERRORS | Wins resulting in a VAST error | Metric |
Dimensions (Breakdowns)
Dimensions you can use to slice and group your data:
| Variable | Description | Category |
|---|---|---|
DATE | Date of events (UTC timezone) | Temporal |
HOUR | Hour of day (0-23) | Temporal |
COUNTRY | 2 character country code | Dimension |
OS | Operating system (android, ios, windows) | Dimension |
AD_UNIT_TYPE | Type of ad unit (VIDEO, BANNER) | Dimension |
CHANNEL_TYPE | Channel type (Web, App) | Dimension |
DEMAND | Demand name as configured in platform | Identifier |
DEMAND_PARTNER | Demand partner name | Identifier |
DEMAND_RULE | Demand rule configuration | Identifier |
PUBLISHER | Publisher name stored in platform | Identifier |
SUPPLY_PARTNER | Supply partner name | Identifier |
AD_UNIT | Ad unit name as named in platform | Dimension |
BUNDLE | Bundle ID of In App supply | Dimension |
DOMAIN | Website domain for WEB type supply | Dimension |
APP_NAME | Application name for In App supply | Dimension |
Calculated Fields
These are computed from raw metrics (not directly available from API):
| Field | Formula | Description |
|---|---|---|
Fill Rate | IMPRESSIONS / OPPORTUNITIES × 100 | Percentage of opportunities filled |
Win Rate | WINS / BIDS × 100 | Percentage of bids that win |
Bid Rate | BIDS / BID_REQUESTS × 100 | Percentage of requests that get bids |
eCPM | PUB_PAYOUT / IMPRESSIONS × 1000 | Effective cost per mille |
Example Queries
Adtelligent Integration
Ad server and SSP platform for video advertising
How to Connect
- Go to Settings → Integrations
- Click Adtelligent
- Enter your API Key from Adtelligent dashboard
- Click Connect
Available Variables
Key Metrics
| Variable | Description | Category |
|---|---|---|
ad_requests | Number of ad requests received | Metric |
ad_opportunities | Number of ad opportunities | Metric |
impressions_good | Valid impressions served | Metric |
revenue_channel | Revenue from channel | Financial |
revenue_total | Total revenue | Financial |
ecpm | Overall eCPM | Metric |
fill_rate_ad_requests | Fill rate based on ad requests | Metric |
rtb_win_notice | RTB win notifications | Metric |
click | Number of clicks | Metric |
ctr | Click-through rate | Metric |
Key Dimensions
| Variable | Description | Category |
|---|---|---|
date | Date of events | Temporal |
hour | Hour of day | Temporal |
channel | Channel name | Identifier |
advertiser | Advertiser name | Identifier |
campaign | Campaign name | Identifier |
country | Country code | Dimension |
os | Operating system | Dimension |
device_type | Device type (Desktop, Mobile, Tablet) | Dimension |
domain | Full domain | Dimension |
app_name | Application name | Dimension |
Full variable list includes 46 metrics and 27 dimensions. See documentation for complete reference.
Example Queries
Added.tv Integration
CTV and video advertising platform
How to Connect
- Go to Settings → Integrations
- Click Added.tv
- Enter your API credentials
- Click Connect
Available Variables
Key Metrics
| Variable | Description | Category |
|---|---|---|
rev | Revenue | Financial |
profit | Profit | Financial |
imps | Impressions | Metric |
reqs | Requests | Metric |
fill | Fill rate | Metric |
ecpm | Effective CPM | Metric |
event_0 | Video start events | Metric |
event_25 | 25% completion | Metric |
event_50 | 50% completion | Metric |
event_100 | 100% completion | Metric |
Key Dimensions
| Variable | Description | Category |
|---|---|---|
dt | Date | Temporal |
channel_name | Channel name | Identifier |
device | Device type (CTV, Mobile, Desktop) | Dimension |
country | Country code | Dimension |
os | Operating system (Roku, Fire TV, tvOS) | Dimension |
contentCategory | Content category | Dimension |
contentGenre | Content genre | Dimension |
app_name | Application name | Dimension |
Full variable list includes 30 metrics and 37 dimensions.
Example Queries
Indicue Integration
SSP advertiser performance and revenue
Connect your Indicue SSP to analyze advertiser performance, impressions, and revenue directly in Marli.
How to Connect
- Go to Settings → Integrations → Indicue.
- Enter your Base URL, Site/Account ID, and API Token from your Indicue dashboard (Account Settings → API Access).
- Click Connect to verify and save.
What You Can Ask
Marli uses the getIndicueData tool to query advertiser performance and revenue data.
Publica Integration
CTV & streaming ad server analytics
Connect Publica's CTV ad server for auction, bidder, campaign, and SSAI performance analytics.
How to Connect
- Go to Settings → Integrations → Publica.
- Enter your Publica API credentials (base URL and API token).
- Click Connect to verify and save.
What You Can Ask
Marli uses the getPublicaData tool for CTV/streaming ad-server metrics (auction, bidder, campaign, SSAI).
iScream Integration
SSP revenue, impressions & profit
Connect the iScream SSP for advertising revenue, impressions, profit, and performance analytics.
How to Connect
- Go to Settings → Integrations → iScream.
- Enter your Base URL, Account ID, and API Token.
- Click Connect to verify and save.
What You Can Ask
Marli uses the getIscreamData tool for revenue, impressions, profit, and advertising metrics.
Vistars Integration
Programmatic trading desk analytics
Connect your Vistars Trading Desk for programmatic analytics across DSP, SSP, DMP, and Exchange.
How to Connect
- Go to Settings → Integrations → Vistars.
- Enter your Vistars API credentials (base URL, account ID, API token).
- Click Connect to verify and save.
What You Can Ask
Marli uses the getVistarsData tool for campaigns, ad groups, creatives, advertisers, agencies, stats, and reports.
BurtHub Integration
Unified ad-platform analytics from Burt
Connect Burt Analytics for unified ad-platform analytics (GAM, LinkedIn, benchmarks) across datasets and time-series metrics.
How to Connect
- Open Account → Connected Accounts and click Connect next to BurtHub.
- Authorize Lytica in the BurtHub OAuth window.
- You'll be redirected back once the connection is saved.
What You Can Ask
Marli uses the getBurtHubData tool for ad-platform datasets, schemas, and time-series metrics.
Snowflake Integration
Cloud data warehouse — direct SQL
Connect Snowflake to run read-only SQL against your warehouse and bring results into Marli for cross-platform analysis.
How to Connect
- Go to Settings → Integrations → Snowflake.
- Enter your account identifier, warehouse, database/schema, username, and access token.
- Click Connect to verify and save.
What You Can Ask
Marli uses the querySnowflake tool to execute SQL against your warehouse. Queries are validated read-only. See Snowflake and BigQuery Modes for tips on warehouse-mode conversations.
Databricks Integration
Data lakehouse — direct SQL
Connect Databricks to query your lakehouse with SQL and analyze results alongside your other sources.
How to Connect
- Go to Settings → Integrations → Databricks.
- Enter your workspace host, SQL warehouse HTTP path, and access token.
- Click Connect to verify and save.
What You Can Ask
Marli uses the queryDatabricks tool to execute read-only SQL against your lakehouse.
Airtable Integration
Bases, tables & records
Connect Airtable so Marli can query your bases, tables, and records for data management and analytics.
How to Connect
- Go to Settings → Integrations → Airtable.
- Click Connect and authorize Lytica in the Airtable OAuth window, selecting the bases to share.
- You'll be redirected back once the connection is saved.
What You Can Ask
Marli uses the getAirtableData tool to read Airtable bases, tables, and records.
BigQuery Integration
Google Cloud data warehouse
BigQuery is documented ahead of rollout. The in-app connector is currently marked coming soon; use this section as planning guidance until your account team enables it.
How to Connect
When BigQuery access is enabled for your organization, the setup flow will ask you to:
- Create a Service Account in Google Cloud Console
- Grant BigQuery Data Viewer and BigQuery Job User roles
- Download the JSON key file
- In Lytica, go to Settings → Integrations → BigQuery
- Upload the service account JSON key
- Specify the default dataset (optional)
Available Variables
BigQuery variables are dynamic based on your schema. After connecting, Lytica will discover available tables and columns.
Example Queries
Bill.com Integration
Accounts payable and receivable automation
How to Connect
- Go to Settings → Integrations
- Click Bill.com
- Choose authentication method (OAuth recommended)
- Authorize Lytica to access your Bill.com account
Available Variables
Document Fields
| Variable | Description | Category |
|---|---|---|
invoiceNumber | Invoice number | Identifier |
invoiceDate | Invoice date | Temporal |
dueDate | Payment due date | Temporal |
amount | Transaction amount | Financial |
amountDue | Outstanding amount due | Financial |
paidAmount | Amount already paid | Financial |
Entity Fields
| Variable | Description | Category |
|---|---|---|
vendorName | Vendor display name | Identifier |
customerId | Customer ID | Identifier |
billStatus | Bill status | Dimension |
paymentStatus | Payment status | Dimension |
Full variable list includes 57 variables across document, entity, financial, and status categories.
Example Queries
QuickBooks Integration
Accounting and invoicing software
How to Connect
- Go to Settings → Integrations
- Click QuickBooks
- Click Connect with QuickBooks
- Sign in to your Intuit account and authorize access
Available Variables
Account Variables
| Variable | Description | Category |
|---|---|---|
Account.Name | Account name | Identifier |
Account.AccountType | Account type | Dimension |
Account.CurrentBalance | Current balance | Financial |
Customer/Vendor Variables
| Variable | Description | Category |
|---|---|---|
Customer.DisplayName | Customer name | Identifier |
Customer.Balance | Customer balance | Financial |
Vendor.DisplayName | Vendor name | Identifier |
Vendor.Balance | Vendor balance | Financial |
Invoice Variables
| Variable | Description | Category |
|---|---|---|
Invoice.DocNumber | Invoice number | Identifier |
Invoice.TxnDate | Invoice date | Temporal |
Invoice.TotalAmt | Invoice total | Financial |
Invoice.Balance | Outstanding balance | Financial |
Full variable list includes 32 variables across 5 entity types.
Example Queries
Tipalti Integration
Global payables & payment reconciliation
Connect Tipalti for automated global payables, payment reconciliation, and vendor management.
How to Connect
- Go to Settings → Integrations → Tipalti.
- Click Connect and authorize Lytica in the Tipalti OAuth window.
- You'll be redirected back once the connection is saved.
What You Can Ask
Marli uses the getTipaltiData tool for payees, payments, invoices, GL accounts, and payment status.
Salesforce Integration
CRM analytics & pipeline
Connect Salesforce for CRM analytics, opportunity tracking, and revenue forecasting. Can be connected org-wide by an admin or personally per user.
How to Connect
- Go to Settings → Integrations → Salesforce (org) or Account → Connected Accounts (personal).
- Click Connect and complete the Salesforce OAuth flow.
- You'll be redirected back once the connection is saved.
What You Can Ask
Marli uses the getSalesforceData tool for accounts, contacts, opportunities, and leads.
Wealthbox Integration
CRM for financial advisors
Connect Wealthbox CRM for contact management, opportunity tracking, and advisor workflow analytics.
How to Connect
- Go to Settings → Integrations → Wealthbox.
- Enter your Wealthbox API access token (Settings → API Access in Wealthbox).
- Click Connect to verify and save.
What You Can Ask
Marli uses the getWealthboxData tool for contacts, opportunities, tasks, events, and notes.
Boostr Integration
Ad sales CRM & order management
Connect Boostr for ad-sales management — CRM, OMS, deals, insertion orders, and revenue analytics.
How to Connect
- Open Account → Connected Accounts and click Connect next to Boostr.
- Enter your Boostr email and password. Lytica establishes a secure session on your behalf.
What You Can Ask
Marli uses the getBoostrData tool for deals, IOs (insertion orders), line items, accounts, contacts, activities, and quotas.
Pipedrive Integration
Sales pipeline — read & write
Connect Pipedrive for sales pipeline analytics, deal tracking, forecasting, and CRM automation.
How to Connect
- Open Account → Connected Accounts and click Connect next to Pipedrive.
- Complete the connection dialog (managed authorization). You'll return automatically when saved.
What You Can Ask
Marli uses the getPipedriveData tool for deals, persons, organizations, activities, pipelines, stages, and notes.
Calendly Integration
Scheduled events & invitees
Connect Calendly to view scheduled events, invitees, and event types — and cancel meetings via Marli.
How to Connect
- Open Account → Connected Accounts and click Connect next to Calendly.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getCalendlyData tool for scheduled events, invitees, event types, and event cancellation.
Google Drive Integration
Cloud storage and document search
The Google Drive integration lets Marli search, read, and summarize documents in your Drive. Useful for pulling context out of contracts, meeting notes, spec docs, or spreadsheets without leaving the chat.
Connection Types
Google Drive can be connected in two ways:
- Organization connection — An admin connects a shared Drive or workspace, making the contents available to everyone in the organization. Best for team-wide knowledge bases.
- Personal connection — Each user connects their own Drive via the Account page (under Connected Accounts). Marli can only access your Drive when you ask. Best for personal docs and 1:1 use.
How to Connect (Organization)
- Go to Settings → Integrations → Google Drive.
- Click Connect. A Google OAuth popup opens.
- Sign in with the Google account that should own the integration.
- Approve the requested scopes (read access to files and metadata).
- The connection is saved and indexing begins. You'll see a status indicator on the integrations page.
How to Connect (Personal)
- Open Account from the avatar dropdown.
- Scroll to Connected Accounts and click Connect next to Google Drive.
- Complete the OAuth flow with your personal Google account.
Available AI Tools
Once connected, Marli can use the following Drive tools when answering questions:
- Search — Full-text and metadata search across your Drive (titles, content, modified date, owner).
- Get Content — Fetch the contents of a specific file (Docs, Sheets, PDFs, plain text).
- Get Metadata— Inspect a file's owner, permissions, last modified time, and link.
Example Queries
Google Sheets Integration
Read & write spreadsheets
Connect Google Sheets so Marli can read and edit spreadsheets — get values, update cells, append rows, and create sheets.
How to Connect
- Open Account → Connected Accounts and click Connect next to Google Sheets.
- Complete the Google OAuth flow and approve spreadsheet access.
What You Can Ask
Marli uses the getGoogleSheetsData tool to read and write Sheets.
Microsoft OneDrive Integration
Personal cloud files — read & write
Connect Microsoft OneDrive to browse, read, upload, and manage personal cloud files.
How to Connect
- Open Account → Connected Accounts and click Connect next to Microsoft OneDrive.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getMicrosoftOnedriveData tool for drives, items, file contents, sharing, and upload/download.
Slack Integration
Real-time alert notifications in Slack
The Slack integration is purpose-built for alert notifications. Once connected, you can route any alert (threshold, anomaly, scheduled report, one-time, reminder) to a specific Slack channel, with rich formatting that includes the metric, value, and a deep link back to Lytica.
How to Connect
- Go to Settings → Integrations → Slack.
- Click Connect. You'll be redirected to Slack's OAuth flow.
- Pick the workspace you want to connect, then approve the requested scopes (post messages, read channel list).
- You'll be redirected back to Lytica. The Lytica bot is now installed in your workspace.
- Invite the Lytica bot to any channels you want it to post in: in Slack, type
/invite @Lyticain the channel.
Configuring Alert Channels
Once Slack is connected, the Slack option appears in every alert's notification settings:
- Open an alert (Alerts page → click an alert card).
- In the detail sheet, find the Channels section.
- Toggle Slack on.
- Pick one or more channels from the dropdown (only channels the Lytica bot has been invited to are listed).
- Save. The alert will now post to those channels whenever it fires.
Message Format
Slack alerts include:
- The alert title and a short description of why it fired.
- The triggering metric, value, and threshold (if applicable).
- A timestamp and the integration the alert is watching.
- A “View in Lytica” button that deep-links to the alert detail sheet.
- For scheduled reports, the report content is rendered inline (or attached as a file if it exceeds Slack's size limit).
Example Use Cases
Searching Slack from Marli
Beyond alerts, Marli can search and summarize Slack conversations using the getSlackDatatool. It only sees conversations the connecting user is a member of, so results respect Slack's own permissions.
Gmail Integration
Search & analyze your inbox
Connect Gmail so Marli can search and analyze your inbox. Marli only accesses your own emails and conversations.
How to Connect
- Open Account → Connected Accounts and click Connect next to Gmail.
- Complete the Google OAuth flow and approve read access.
What You Can Ask
Marli uses the getGmailData tool to search emails, threads, and conversations.
Google Calendar Integration
View, create & manage events
Connect Google Calendar to view, create, and manage your events, meetings, and schedule.
How to Connect
- Open Account → Connected Accounts and click Connect next to Google Calendar.
- Complete the Google OAuth flow and approve calendar access.
What You Can Ask
Marli uses the getGoogleCalendarData tool to query events, meetings, and schedule data.
Microsoft Outlook Integration
Email — read & write
Connect Microsoft Outlook for reading, sending, and managing emails, drafts, and folders.
How to Connect
- Open Account → Connected Accounts and click Connect next to Microsoft Outlook.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getMicrosoftOutlookData tool for messages, drafts, folders, attachments, and sending mail.
Microsoft Outlook Calendar Integration
Meetings & events — read & write
Connect Microsoft Outlook Calendar for viewing, creating, and managing meetings and events.
How to Connect
- Open Account → Connected Accounts and click Connect next to Microsoft Outlook Calendar.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getMicrosoftOutlookCalendarData tool for events, meetings, attendees, and free/busy.
Microsoft Teams Integration
Teams, channels & messages
Connect Microsoft Teams for messaging, channels, meetings, and collaboration insights.
How to Connect
- Open Account → Connected Accounts and click Connect next to Microsoft Teams.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getMicrosoftTeamsData tool for teams, channels, chat messages, members, and meetings.
Zoom Integration
Meetings, webinars & recordings
Connect Zoom for meeting analytics, scheduling, attendance tracking, and recording management.
How to Connect
- Open Account → Connected Accounts and click Connect next to Zoom.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getZoomData tool for meetings, webinars, participants, recordings, registrants, and users.
Asana Integration
Tasks & projects — read & write
Connect Asana for task management, project tracking, custom-field reporting, and read/write workflow automation.
How to Connect
- Open Account → Connected Accounts and click Connect next to Asana.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getAsanaData tool for workspaces, projects, tasks, sections, custom fields, tags, stories, subtasks, and users.
Monday.com Integration
Work management — read & write
Connect Monday.com for work management, project tracking, and team collaboration. Create boards, items, and manage workflows.
How to Connect
- Go to Settings → Integrations → Monday.com.
- Click Connect and authorize Lytica in the Monday.com OAuth window.
- You'll be redirected back once the connection is saved.
What You Can Ask
Marli uses the getMondayData tool for boards, items, columns, groups, and workspaces.
Notion Integration
Pages & databases — read & write
Connect Notion for workspace analytics, database queries, page management, and knowledge automation.
How to Connect
- Open Account → Connected Accounts and click Connect next to Notion.
- Complete the connection dialog (managed authorization), selecting the pages to share.
What You Can Ask
Marli uses the getNotionData tool for workspaces, pages, databases, blocks, comments, and users.
Linear Integration
Issues & cycles — read & write
Connect Linear for issue tracking, project management, cycles, and development workflow automation.
How to Connect
- Open Account → Connected Accounts and click Connect next to Linear.
- Complete the connection dialog (managed authorization).
What You Can Ask
Marli uses the getLinearData tool for teams, projects, issues, cycles, labels, comments, and users.
Atlassian Integration
Jira + Confluence + JSM — read & write
Connect Atlassian (Jira + Confluence + Jira Service Management) for issues, pages, and tickets in a single OAuth.
How to Connect
- Open Account → Connected Accounts and click Connect next to Atlassian.
- Complete the connection dialog (managed authorization) and choose the site to connect.
What You Can Ask
Marli uses the getAtlassianData tool for Jira issues/projects, Confluence pages/spaces, and JSM tickets.
Security
Lytica is built with enterprise security requirements in mind.
Data Security
- Encryption at rest — AES-256 encryption for all stored data
- Encryption in transit — TLS 1.3 for all data transmission
- Credential isolation — Integration credentials stored separately with additional encryption
- No data persistence — Query results are not stored; data is fetched on-demand
Access Control
- SSO support — SAML 2.0 and OAuth integration (via WorkOS)
- Role-based access — Admin, Member, and Viewer roles
- Organization isolation — Complete data separation between organizations
- Audit logging — Comprehensive activity logs
Enterprise Support
Support Tiers
| Feature | Standard | Enterprise |
|---|---|---|
| Email Support | ✓ | ✓ |
| Response Time | 48 hours | 4 hours |
| Dedicated Account Manager | — | ✓ |
| Custom Integration Support | — | ✓ |
| On-call Engineering | — | ✓ |
Contact Us
Sales: sales@lyticalabs.ai · Contact form
General Support: support@lyticalabs.ai
Enterprise Support: enterprise@lyticalabs.ai
Technical / Integrations: integrations@lyticalabs.ai
Billing: billing@lyticalabs.ai
In-app help: Visit the support page