Conversational Analytics Code Interpreter

Conversational Analytics is an AI-powered data analytics tool that helps you derive advanced insights from your data by asking questions in regular, natural language. No coding experience or data expertise are required to use Conversational Analytics.

The Code Interpreter in Conversational Analytics translates your natural language questions into Python code and executes that code to provide advanced analysis and visualizations. In contrast to standard SQL-powered BI experiences, the Code Interpreter supports a wide variety of data analytics—from basic computations and charting to more advanced tasks like time series forecasting. The Code Interpreter enhances Conversational Analytics by enabling users to perform these types of advanced analysis, which typically require specialized knowledge of advanced coding or statistical methods.

Learn how and when Gemini for Google Cloud uses your data. As an early-stage technology, Gemini for Google Cloud products can generate output that seems plausible but is factually incorrect. We recommend that you validate all output from Gemini for Google Cloud products before you use it. For more information, see Gemini for Google Cloud and responsible AI.

Before you begin

To use the Code Interpreter within Conversational Analytics in Looker Studio, you must meet the following requirements:

  1. You must be a user under a Looker Studio Pro subscription. Looker Studio Pro licenses are available at no cost to Looker users.
  2. An administrator must have enabled Gemini in Looker for Looker Studio.
  3. An administrator must have also enabled the Trusted Tester features option within Gemini settings in Looker Studio.

Enable the Code Interpreter

To enable the Code Interpreter for your conversations, follow these steps:

  1. In Looker Studio, navigate to Conversational Analytics.
  2. In the left navigation panel within Conversational Analytics, click the Advanced analytics toggle to enable the Code Interpreter.
  3. With the Code Interpreter enabled, you can use Conversational Analytics as usual to start conversations and ask questions of your data. The Code Interpreter uses the engine that powers Gemini chat to translate your queries into Python code and execute that code.

Known limitations

  • The Code Interpreter uses Python to solve problems. Since Python is more flexible than structured query languages, Code Interpreter responses might have more variability than responses from the core Conversational Analytics experience.
  • For Looker data, Conversational Analytics can return a maximum of 5,000 rows per query.
  • The Code Interpreter supports these Python libraries. To request support for additional Python libraries, email conversational-analytics-feedback@google.com.

For information about additional limitations, see the documentation on known limitations in Conversational Analytics.

Supported Python libraries

Show supported Python libraries

The Code Interpreter supports the following Python libraries:

  • altair
  • attrs
  • chess
  • contourpy
  • cycler
  • entrypoints
  • fonttools
  • fpdf
  • geopandas
  • imageio
  • jinja2
  • joblib
  • jsonschema
  • jsonschema-specifications
  • kiwisolver
  • lxml
  • markupsafe
  • matplotlib
  • mpmath
  • numexpr
  • numpy
  • opencv-python
  • openpyxl
  • packaging
  • pandas
  • patsy
  • pdfminer-six
  • pillow
  • plotly
  • protobuf
  • pylatex
  • pyparsing
  • PyPDF2
  • python-dateutil
  • python-docx
  • python-pptx
  • pytz
  • referencing
  • reportlab
  • rpds-py
  • scikit-image
  • scikit-learn
  • scipy
  • seaborn
  • six
  • statsmodels
  • striprtf
  • sympy
  • tabulate
  • tensorflow
  • threadpoolctl
  • toolz
  • torch
  • tzdata
  • xlrd

Supported questions

When you enable the Code Interpreter, Python's advanced analytic capabilities enable Conversational Analytics to answer a wider range of questions, in addition to the standard types of supported questions. For example:

  • What is the lifetime value for each of my customer segments, taking into account the average purchase frequency and the average order value?
  • How do sales this year compare to sales last year?
  • Identify outliers in my sales data to help identify products or regions that are performing particularly well or particularly poorly.
  • Perform a cohort analysis to understand customer retention.
  • Are my highest margin products also the most popular products? Use this answer to provide a suggestion on how to optimize my product mix.