How to Create a Visual Report in Looker with AI

Creating a visual report in Looker Studio with AI dramatically speeds up the process of turning raw data into clear, actionable insights. Instead of spending hours manually configuring charts, you can now describe what you want to see, and AI will build a starting point for you. This guide will walk you through the entire process, from connecting your data to customizing your AI-generated visuals for a polished, professional report.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, a Quick Clarification: Looker vs. Looker Studio

Before we jump in, it's helpful to understand the distinction between two key Google products. You’ll often hear the name "Looker" used, but it’s important to know which tool you're using.

• Looker Studio (formerly Google Data Studio): This is Google's powerful and free data visualization tool. It's designed for creating interactive dashboards and reports from a wide range of data sources. It now integrates a helpful AI assistant called Gemini. This is the tool we will be focusing on in this tutorial.
• Looker (Google Cloud core service): This is a more advanced, enterprise-grade business intelligence platform. It excels in complex data modeling, governance, and embedding analytics directly into applications. While powerful, it involves a steeper learning curve and is geared toward data teams.

For most marketers, founders, and business managers looking to create performance dashboards, Looker Studio is the perfect tool for the job.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Connect Your Data Source to Looker Studio

You can't visualize data you haven't connected. The first step is always to bring your data into Looker Studio. The platform supports hundreds of connectors, making it easy to pull in information from Google products, social media platforms, databases, and more.

Let's walk through connecting a popular marketing data source: Google Analytics 4.

1. Start a New Data Source: Log in to your Looker Studio account. In the top-left menu, click "Create" and then select "Data Source."
2. Select a Connector: You'll see a gallery of "Google Connectors" at the top. Find and click on "Google Analytics."
3. Authorize and Select Your Account: If this is your first time, you'll need to click a button to authorize Looker Studio to access your Google Analytics data. Once authorized, you’ll see a list of your GA4 accounts and properties. Select the desired GA4 property you want to visualize and click the blue "Add" button in the bottom right corner.
4. Review Your Data Fields: Looker Studio will now display a screen with all the available dimensions (like Page title, Session campaign, Country) and metrics (like Users, Sessions, Conversions) from your GA4 property. You don’t need to do anything here for now, but it's good to see what data you can work with. In the top left, you can give your data source a more descriptive name, like "My Website GA4 Data," then move on.

You've successfully connected your data! This same process applies when connecting other sources like Google Sheets or Google Ads, though the authentication steps may differ slightly.

Step 2: Generate an Entire Report Automatically with AI

Now for the exciting part. Instead of starting with a blank canvas, let's have Gemini create a report for you. This is the fastest way to get a comprehensive, multi-page dashboard that covers the key aspects of your data.

1. Start with the AI Generator: Go back to the Looker Studio home screen. Click "Create" and this time select "Report." Look for the option to use AI and select "Generate report."
2. Choose Your Data Source: In the panel that appears on the right, select the Google Analytics data source you just created.
3. Write a Clear Prompt: This is where you tell the AI what you want. Think of it as giving instructions to a data analyst. For the best results, be specific about what you need to see. Mention the subject, timeframe, and key performance indicators (KPIs).

Here’s a great example prompt to analyze marketing performance:

Create a report analyzing our website's performance for the last 90 days. I need an overview page with key metrics like users, sessions, and conversions. Also, create separate pages for traffic acquisition channels that brought visitors to our site and another page to show our top-performing content.  

1. Let Gemini Work Its Magic: Click the "Generate" button. Gemini will analyze your prompt, connect to your GA4 data, and build a full report in about a minute. The result is often a surprisingly thorough multi-page dashboard, complete with charts, tables, scorecards, and descriptive titles. In this example, it would likely generate:

• An Overview Page: With scorecards for core metrics and a time series chart showing user trends.
• A Traffic Acquisition Page: Featuring a bar chart of users by channel group and a table with more detailed source/medium data.
• A Content Performance Page: With a table showing the pages with the most views.

This auto-generated report immediately saves you an enormous amount of setup time. It's not just a collection of random charts, it's a logically structured dashboard that serves as an excellent foundation.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Creating and Refining Individual Charts with AI

Once you have a general report, you might want to add more specific charts to answer follow-up questions. Instead of creating these manually, you can use Gemini to generate them one by one.

1. Open the AI Chat Interface: Inside your report, go to the toolbar and click "Insert," then select "Ask Gemini."
2. Prompt for a Specific Visualization: Let's say you want to visualize website traffic by device category. You could use this simple prompt:

Show a bar chart of sessions by device category for the last 30 days.  

1. Add the Chart to Your Report: Gemini will generate a preview of the chart. If it looks right, just click to add it to your report canvas. You can drag and resize it just like any other element.

Tips for Writing Better Prompts

Getting great results from AI is all about providing clear instructions. Follow these tips to improve your prompts:

• Be Specific: Name the exact metrics and dimensions you want (e.g., "Users" instead of "traffic," "Session source / medium" instead of "channels").
• State the Chart Type: Ask for a "pie chart," "time series chart," or "table" to guide the visual output.
• Include Timeframes: Use relative dates like "last 7 days," "this quarter," or "this year to date."
• Build in an Iterative Way: If you're building a complex visualization, start with a simple prompt and then add more detail. For example, start with "Show users by country," and once that works, ask a new prompt: "Show users by country on a map for the last 30 days."

Step 4: Customize and Polish Your Report

The AI-generated report is your first draft, not the final version. Now, it's time to apply your expertise and customize the dashboard to perfectly match your needs.

Manually Adjusting Charts and Data

Any chart created by Gemini is fully editable. Click on a chart, and a Properties Panel will appear on the right.

• Swap Metrics and Dimensions: In the "Setup" tab of the panel, you can drag and drop different fields. For example, you can change a chart showing "Users by Country" to "Sessions by City" by simply swapping the dimension.
• Change Chart Types: Not happy with the bar chart Gemini chose? With one click, you can switch it to a line chart, pie chart, or table from the chart type selector.
• Apply Filters: What if you only want to see traffic from search engines? Add a filter to your chart or the entire report page to focus on data from "Session default channel group" containing "Organic Search."

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Improve Clarity and Add Context

A great dashboard doesn't just show data, it tells a story. Add context to help your team understand what they're looking at.

• Give Everything a Clear Title: Ensure every chart has a simple, descriptive title like "User Growth Rate (Month-over-Month)" instead of just "Users."
• Add Text Boxes: Use the "Text" tool from the Insert menu to add brief explanations, call out important takeaways, or ask questions next to a chart.
• Use AI for Report Summaries: Gemini can also summarize the findings for you. In the toolbar, find the option to "Add report summary using Gemini." This creates a text box filled with natural-language insights based on the data in your report - a fantastic feature for preparing executive summaries.

Final Thoughts

Leveraging AI tools like Gemini inside Looker Studio shifts your role from a report builder to a data strategist. The technology handles the time-consuming grunt work of creating visualizations, freeing you up to focus on what the data actually means, refining the insights, and driving strategic decisions. You now have a high-functioning dashboard without spending hours on tedious manual configurations.

While Looker Studio's AI is powerful for getting visual reports set up, building a truly unified view of your business often means pulling data from multiple places - your ads, CRM, and e-commerce platform - not just your website analytics. At Graphed, we created an AI data analyst to simplify this entire process. We allow you to connect all of your marketing and sales tools in one click, and then create entire real-time dashboards by simply describing what you want in plain English, like "show me my full sales pipeline from HubSpot for this quarter." You can ask for answers and build reports in seconds, enabling your entire team to make smarter decisions without the steep learning curve.