Supported Queries in Sprinklr Copilot for Marketing: Ads Reporting

Updated 

The introduction of chat interface in the Sprinklr Copilot lets you ask queries about the data in your dashboard enabling you to interact with the dashboard in a more conversational way. Instead of searching through charts and filters, you can simply ask questions in the chat and receive clear, meaningful insights instantly.

This article explains the types of queries you can ask in Sprinklr Copilot, along with the supported metrics and dimensions for queries that go beyond what is available in your current dashboard.

Types of Queries Supported in Sprinklr Copilot

The Sprinklr Copilot supports two main types of queries -

  1. Queries About Data Within the Current Dashboard

    You can ask questions about any data or entity currently displayed in your dashboard without any restrictions.

    • Summarize performance at different levels, such as by dashboard, tab, or widget.

      Example: Summarize tab X.

    • Ask performance-based questions directly related to the dashboard’s content.

      Example: Compare total results with respect to age and let me know the best-performing age range.

      Note:

      • When you ask queries without specifying any time range, time zone, currency or filters ( for example: channel, ad objective, media type and so on), Sprinklr Copilot will use the current dashboard-level settings to generate insights. However, if you do specify any filters, time range, time zone or currency in your questions, Sprinklr Copilot will prioritize the details mentioned in the query and generate insights based on them.

      • If you ask questions that match the data available in any existing widget in the dashboard,

        Sprinklr Copilot will use the relevant widget to generate the insights. However, if no existing widget contains the required data, Sprinklr Copilot will generate insights using the backend data instead.

        ExampleWhat is the best performing paid initiative based on spend?

        For the above query, if the dashboard contains a widget that provides insights on best performing PI based on Spend for Facebook campaigns, Sprinklr Copilot will generate insights using this widget since the query doesn’t specify the channel.

        However, if you specify the channel in your query (for example, What is the best performing paid initiative based on spend for X?) and no existing widget provides the data for X, Sprinklr Copilot will generate the insights for this query using the backend data. 

  2. Queries About Metrics and Dimensions Not Displayed in the Dashboard

    You can go beyond the data visible in the dashboard and ask any questions related to dimensions, metrics and custom metrics or custom fields.

    Example: Which campaign drove the highest clicks last month?

Notes:

  • If you don't specify any filters, time range, time zone or currency in queries about metrics and dimensions that are not displayed on the dashboard, Sprinklr Copilot will use the current dashboard-level settings (filters, time range, time zone or currency) to generate insights.

  • However, if you explicitly mention any filters, time range, time zone or currency in questions about metrics and dimensions that are not plotted on the dashboard, Sprinklr Copilot will prioritize the details mentioned in the query and generate insights based on them.