You
Thursday 11:41am
Why is revenue down?
ASSISANT
Thursday 11:44am
There are many things you can do, looking at the MoM trends of the Revenue Dashboard will help to see exactly how the revenue has decreased, or we could directly query the revenue data to pull out revenue split by different demographics such as country.
Revenue Dashboard - Month on Month Revenue
Chart showing the number of distinct orders placed in the last week, excluding canceled and returned orders...
Conversational AI
Enable business users to self-serve their simple and repetitive ad-hoc requests.
Search
Navigate and understand large, unfamiliar datasets in a fraction of the time.
Rewrite using our definition of @Revenue
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
// Query to Execute Count Orders Last Week
SELECT
DATE_TRUNC(DATE(oi.created_at), WEEK(MONDAY)) AS week_start_date,
COUNT(DISTINCT oi.order_id) AS number_of_orders
FROM `bigquery-public-data.thelook_ecommerce.order_items` AS oi -- Joining on order_items to pull out order_id
WHERE oi.status NOT IN ('Cancelled', 'Returned') -- Filtering out cancelled and returned items
AND DATE(oi.created_at) >= DATE_SUB(
DATE_TRUNC(CURRENT_DATE(), WEEK(MONDAY)),
INTERVAL 1 WEEK
)
AND DATE(oi.created_at) < DATE_TRUNC(CURRENT_DATE(), WEEK(MONDAY))
GROUP BY 1
ORDER BY 1 DESC
AI SQL
2x data analyst productivity with AI-generated SQL that gets better with time.
Column Name
customer_id
description
featured_from
featured_to
Plan
Released At
released_at
Created At
created_at
Description
Customer ID labelled from sales team
Description of this customer from the sales/marketing team
The time at which the customer was officially engaged with us
The time at which the customer officially stopped engaging
The plan the customer is engaged with
When this badge was viewable within the student’s class
community
The time when this customer was created
Data Type
Integer
Text
Datetime
Datetime
Multi Select
Datetime
Datetime
Example
“15”
“Customer is on ABC plan”
“04-11-2023T18:06:24.134353”
“04-11-2023T18:06:24.134353”
“Premium”
“04-11-2023T18:06:24.134353”
“04-11-2023T18:06:24.134353”
Show More
Data Catalog
Document your data within minutes and collaborate with consistent definitions.
Integrations
David
Head of Data, Global Marketplace
Security
Your data security, our highest priority
We prioritize your privacy with strong security measures to ensure your data stays protected and confidential
We don't store your data
We only store metadata, ensuring your sensitive data stays only on your servers.
Private AI Models
Our AI models are designed to maintain privacy, never using your data for training purposes.
Custom Access
Implement precise control with granular database roles and permissions, tailored to your needs.
Data Breach Checks
We verify your password has not been exposed in any known data breaches.
Pricing
What you can do
ChatGPT-like data analysis with your data warehouse and dashboards
AI-Copilot for SQL generation with the context of your data warehouse and dashboards
AI-generated data catalog to save definitions and queries
Integrations with BigQuery and Metabase
Email support
Usage
1 user
25 messages/month
Professional
More seats, more integrations, access control, and premium support
$39
per user/month
Everything in Free, plus:
Control permissions with granular access control and user groups
Integrations with dbt, Snowflake, PowerBI, Looker, and Tableau
Python support
Premium support across Slack, email, and phone
Usage
Up to 10 users
Unlimited messages/month
Enterprise
Scale data analytics org-wide with Enterprise-grade functionality
Contact sales for pricing or to request a demo
Everything in Professional, plus:
SSO
On-premises deployment
Priority email support, onboarding assistance, and a dedicated CSM
Usage
Unlimited everything
Get in touch
Scale data analytics with Verve
Still have questions?
Can’t find the answer you’re looking for? Please chat to our friendly team.