Skip to content
Book a demo

Connect documentation

All documentation
Documentation

Adverity MCP use cases

On this page

This guide shows example tasks you can do with Adverity MCP. To see which tools your AI assistant uses for them, see Adverity MCP tools.

Use cases

To get the most relevant results, include timeframes, workspace names, or datastream names in your prompts.

Morning health check

Check the status of all pipelines without opening Adverity. Ask for failed datastreams, connections that are no longer authorized, and active errors — in a single prompt.

  • “Show me all failed datastreams and any connections that are no longer authorized.”

  • “Which datastreams are currently disabled?”

  • “List all datastreams in the Marketing workspace.”

Troubleshooting a pipeline failure

Diagnose why a datastream stopped collecting data, review the error details, and retry failed jobs once you have identified the root cause.

  • “Why did my Facebook Ads fetch fail? Show me the errors.”

  • “What were the results of recent fetches for the Pinterest datastream?”

  • “Retry this error, and every other error in the same group.”

  • “Acknowledge this error so it no longer shows in the interface.”

Setting up a new data connection

Create a new datastream and configure its authorization through a guided conversation, without navigating the Adverity interface.

  • “Help me set up a new Pinterest Ads datastream in the Marketing workspace.”

Adjusting what a datastream collects

Read a datastream’s current metrics and dimensions and add or remove fields through a guided conversation.

  • “What fields is my Facebook Ads datastream collecting? Add adset_name and adset_id.”

Downloading data on demand

Retrieve the latest data extract for any datastream directly in your AI tool — useful for ad hoc analysis or when a scheduled report is delayed.

  • “Download the latest Google Ads data extract.”

  • “Get the most recent data extract for the LinkedIn Ads datastream.”

Checking connection status

Review which authorizations are currently authorized so you can re-connect any that have dropped before they cause pipeline failures.

  • “Which of my authorizations are no longer authorized?”

  • “What is the status of my Google Ads authorization?”

  • “Re-authorize my Facebook Ads connection.”

Adding data processing to a datastream

Set up transformations for a datastream through a guided conversation — describe the processing you need and let the AI configure the steps.

  • “Create a transformation that renames campaign_name to Campaign and attach it to the Facebook Ads datastream.”

Exploring workspaces and mapping tables

Understand your workspace structure and manage the mapping tables used for data harmonization.

  • “What workspaces do I have access to?”

  • “Which datastreams belong to the Production workspace?”

  • “List all mapping tables.”

  • “Show me all entries in the Country Codes mapping table.”

  • “Add an entry to the Region mapping table: match ‘DE’, value ‘Germany’.”

Delivering data to a destination

Configure where harmonized data is delivered and how a datastream’s source columns map into each destination.

  • “List my BigQuery destinations.”

  • “Load the Google Ads datastream into my BigQuery destination.”

  • “Map the Google Ads datastream’s source columns to my reporting schema.”

Staying notified

Set up email, Slack, or Microsoft Teams notifications for pipeline events, scoped to the workspaces or datastreams you care about.

  • “Notify the #data-alerts Slack channel when any datastream in the Marketing workspace fails.”

  • “List my current email notification subscriptions.”

Querying the warehouse

Explore the columns Adverity has loaded into a workspace’s warehouse and run read-only SQL against them without leaving your AI tool.

  • “What columns are available in the Marketing workspace’s warehouse?”

  • “Total spend by campaign for the last 7 days from the Marketing workspace warehouse.”