On this page
Key takeaways
- On the Team and Enterprise plans, bring Google Analytics reports and Search Console search performance into DashboardGPT and ask questions of them in plain English.
- Start from a ready-made report such as Traffic overview, Acquisition or Landing pages, or choose your own dimensions and metrics.
- Visitors, rates and averages are combined the way Google Analytics combines them, so a monthly bounce rate matches the one you see there.
- Access is read-only. An owner or admin chooses which workspaces can use the connection and can disconnect it at any time.
Why ask instead of digging
Google Analytics and Search Console hold the answers to most website questions: where visitors come from, which pages they land on, what people search for before they find you. Getting a straight answer still means clicking through reports, setting filters and comparing date ranges, and the result rarely ends up next to the rest of your numbers.
With DashboardGPT you add a report once. Ask a question in plain English and the answer lands on a canvas as a chart, a number or a short insight, beside your sales, marketing and finance data. The report refreshes on a schedule, so next week's answers are current too.
New to asking questions of your data? Chat with your data: the complete guide covers the basics first.
What you need
- A Team or Enterprise plan. Google Analytics and Search Console are included on Team and Enterprise. They unlock when you subscribe, so they aren't part of the free trial. On other plans the page explains what an upgrade brings.
- An owner or admin to connect a Google account that can see your Google Analytics properties or Search Console sites. This is a one-off step for your organisation.
- Editor access to the workspace for the person adding a report.
Not on Team yet? You can export a report from Google Analytics as a CSV file and upload it on any plan. How to chat with a CSV file walks you through it.
Step 1: Connect a Google account
- Open Settings, then Integrations, and choose the Google Analytics tile.
- Choose Connect Google Analytics, or Connect Search Console if search performance is all you need, and sign in to Google.
- Allow DashboardGPT read-only access. Keep every box ticked, or the account can't be used.
- Choose workspaces to decide which workspaces can use the connection. Only those workspaces can add reports from it.
Choose Test at any time to check the connection still works.
Step 2: Add a report
- On the Datasets page, choose Add from Google Analytics.
- Pick the property you want to analyse.
- Choose a ready-made report: Traffic overview, Acquisition, Landing pages, Events, E-commerce purchases, or Geography and devices. Or choose Custom report and pick your own dimensions and metrics, custom definitions included. Fields that can't be combined are flagged before you save.
- Choose a date range, from the last 7 days up to the last 13 months, or start from a date of your choice.
- Choose how often it refreshes, give it a name and save. The first sync starts straight away and the report opens when it is ready.
From then on it works like any file you upload: ask questions of it, collect the answers on a canvas and publish them to Superset.
Step 3: Ask your first question
Each Google Analytics report suggests a few questions to start with under Ask about this data. Choose one and it fills the assistant for you, or type your own, such as "Which channels bring the most sessions?" or "What are the top 10 landing pages by sessions?" Then follow up: "Only organic search", "Show it month by month", "Which of these lead to the most key events?"
Looking at spend as well as traffic? Marketing spend analysis has a set of questions to ask next.
Add Search Console
One Google account can cover both Google Analytics and Search Console. On the connected account, choose Add Search Console. Google asks the account holder to allow it, and nothing else changes.
- On the Datasets page, choose Add from Search Console.
- Pick the site.
- Choose a ready-made report: Search performance, Queries, Pages, or Countries and devices. Or build your own breakdown by date, query, page, country, device and search appearance.
- Choose the date range and refresh, name it and save.
Each report brings in clicks, impressions, click-through rate and average position, ready for questions such as "Which queries gained the most clicks this month?"
Numbers that match Google Analytics
Web analytics numbers don't simply add up. Someone who visits on three days is still one person, and a bounce rate for the month isn't the sum of thirty daily rates. DashboardGPT knows this.
- Visitors, rates and averages are combined correctly. DashboardGPT never adds them up across days. It combines them the way Google Analytics does, so a monthly bounce rate matches the one you see there, and the answer says so when it has adjusted the calculation.
- Search Console figures stay meaningful. Click-through rate and average position for a week or a month come out the way Search Console reports them, not as an average of daily figures.
- Answers straight from Google Analytics when needed. Some questions can't be answered from the stored report, such as how many different people visited over a whole month, or dates before the report's range. DashboardGPT can then ask Google Analytics directly and shows the result as a table marked Live from Google Analytics.
Keep it up to date
Every Google Analytics and Search Console report has a card on its page showing the property or site, the report, the date range, when it last synced and when the next refresh is due.
- Sync now pulls in the latest figures whenever you want them.
- Refresh on a schedule: every day, or every hour on Enterprise. Or keep it for when you sync it yourself.
- Recent syncs are listed on the card, along with any notes from Google about the data.
- Your usage, in plain sight. The Usage page shows how many syncs you have used this month.
If a sync can't finish, the card says why and who can fix it, and the report keeps the figures it already had, so nobody is left looking at an empty chart.
What DashboardGPT can see
- Read-only access. DashboardGPT can list the properties and sites the Google account can see and read the reports you choose. It never creates, edits or deletes anything in Google Analytics or Search Console.
- Only the workspaces you choose. An owner or admin decides which workspaces can use each connection.
- You stay in control. Disconnecting the account withdraws DashboardGPT's access at Google. Reports you have already added stay readable but stop refreshing.
When you ask a question, your AI provider sees the question, a description of the columns with a few sample values, and the summarised results, not the whole report. Our privacy policy sets out exactly how Google data is handled, and is my data used to train models? explains the rest in plain English. Keep the numbers from your spreadsheets alongside? How to chat with a Google Sheet shows how.
Ready to ask your website data a question? Sign up to get started, compare what each plan includes on the pricing page, or contact us if you would like a hand setting up your team.