View a Query

To view the details and configuration properties of a Query:

  1. Select Analytics from the top navigation bar, then select Settings > Queries from the side navigation menu. The Analytics Queries screen is displayed.

  2. Optionally, search for and select the desired Query (see Search for a Query more information on the available search options). The Query Details screen is displayed, with the Definition tab selected.

  1. The header and the tabs on this screen allow you to view various configuration details. See below for details on each of these areas.

The header area of the Query Details screen displays many of the high-level properties of this Query, including its name, description, and Execution Type. From this area, you can edit or delete an existing Query.

Also from the header area, you can copy the Query. See Create a Query for more information.

Definition Tab

The Definition tab of the Query Details screen displays the Query code and any defined parameters. See Define the Query Code for more information.

Parameters act like coding variables that can be used in a Query. For example, you could insert a Date parameter that references TODAY and use it multiple times in the Query. Then later, let’s say you need to change the Query to reference the current week, not just today. Instead of having to edit every place where the Query references TODAY, you can simply update the Date parameter, and the platform automatically updates all instances of the parameter, changing TODAY to THIS WEEK. See Define a Parameter for more information.

From this tab, you can also change the Query’s Execution Type.

Results Tab

The Results tab of the Query Details screen displays the results of the Query the last time it was executed.

From this tab, you can refresh the Query. See Refresh a Query for more information.

Also from this tab, you can export the Query results and download them to your local PC. See Export Query Results for more information.

KPIs and Lookups Tab

The KPIs and Lookups Rules tab is used to specify that the Query access a Lookup table, as it may contain data the Query needs. For example, the Query could be used to count only the Members that appear in a Lookup table, instead of all Members. See Add a Lookup Table to a Query for more information.