Queries is an interactive data explorer that lets you ask questions about your marketing data without writing code. You can compose a query by selecting a source system, metrics, dimensions, and filters, and Marcenta returns the results as a table and chart. You can also type a question in plain language and the AI will interpret it, run the query, and explain what it found—all in the same interface.Documentation Index
Fetch the complete documentation index at: https://docs.marcenta.ai/llms.txt
Use this file to discover all available pages before exploring further.
Navigate to Queries
Select Queries in the left sidebar. The interface is split into a conversation area on the right and a conversations sidebar on the left, where previous query sessions are saved for you to revisit.Run a structured query
Open the query composer
Select the input area at the bottom of the Queries page to open the composer.
Select a source system
Choose the data source you want to query. The available source systems are:
- Google Ads (
google_ads) - Google Analytics 4 (
ga4) - Google Search Console (
gsc) - LinkedIn Ads (
linkedin_ads) - HubSpot (
hubspot)
Choose metrics and dimensions
Select one or more metrics and the dimensions you want to group by. The available options update based on your selected source and the data Marcenta has ingested.
Set the date range
Pick a start and end date for the query. You can also add filters to narrow results to a specific campaign, country, device, or any other available dimension.
Available metrics
The metrics available depend on the source system you select. Common metrics across sources include:- Performance
- Web analytics
- Pipeline (HubSpot)
impressions— total ad or search impressionsclicks— total clicksctr_pct— click-through rate as a percentageconversions— total conversion eventsspend— total ad spendcpc— cost per click
Available dimensions
Dimensions let you group and slice your data. Common dimensions include:| Dimension | Description |
|---|---|
date | Day-level time series |
campaign | Campaign name |
channel_group | High-level channel grouping (e.g., Paid Search, Organic) |
source | Traffic source |
medium | Traffic medium |
ad_group | Ad group name (Google Ads, LinkedIn Ads) |
keyword | Keyword term (Google Ads, Google Search Console) |
country | Country of the user or target |
region | Sub-national region |
city | City |
landing_page | Landing page URL |
device | Device category (desktop, mobile, tablet) |
job_function, job_title, seniority, company_size, and industry.
Add filters
Filters let you narrow a query before it runs. Each filter consists of a dimension field, an operator (equals, not equals, contains, greater than, etc.), and a value. You can add multiple filters and combine them with AND or OR logic.Use natural language
Instead of composing a query manually, you can type a question directly into the input area. For example:- “Show me clicks and impressions by campaign for the last 30 days from Google Ads”
- “What were my top 5 landing pages by sessions last month?”
- “Compare conversion rates by device for LinkedIn Ads this quarter”
AI Insights
After any query runs, you can select AI Insights to get a written analysis of the results. The AI looks at patterns in the data—trends, outliers, top performers, underperformers—and summarizes them in plain language. You can ask follow-up questions in the same conversation to dig deeper.AI Insights works on the result data that Marcenta already retrieved. It does not re-run the query; it analyzes the rows already returned. For very large result sets, Marcenta analyzes up to 500 rows.