About the SupermetricsQueries tab (advanced)

Created (Column G)

The date and time the query was created.

Updated (Column H)

The date and time the query was refreshed or updated.

Last status (Column I)

The last status of the query. Possible values include:

• Created successfully: Query was created and received data.

• Refreshed successfully: Query was refreshed manually from the Supermetrics sidebar.

• Refreshed successfully by trigger xyz: The query was refreshed by the automatic refresh.

Execution time (sec) (Column L)

The approximate amount of time in seconds the query took to refresh. A lower number indicates a faster query.

Object type (Column M)

Refers to the type of data visualization selected when creating the query. The default and most common value is table.

Linked chart ID (Column N)

 If Object type is anything other than table, the chart ID is displayed here.

Data source (Column O)

The shortcode for the data source. For example, Instagram Insights is IGI and Google Ads is AW.

Date range type (Column Q)

Specifies the date range for the query.

Can be any date range option from the sidebar dropdown written without spaces. For example: lastmonth, thismonth, yesterday, last3months, last3monthsinc, or custom.

• last3months will not include the current month.

• last3monthsinc will include the current month.

Example: If the current month is April, last3months will return data from January, February, and March. The last3monthsincrange will return data from February, March, and April.

If you set the Date range type to custom, you must enter the dates in the Start date and End date columns.

Start date (Column R)

The start date for a custom date range. This field is only used when Date range type is set to custom.

Use the yyyy-mm-dd format or any format accepted by PHP's strtotime (such as, "first day of last month", "last Monday", or "-28 days").

End date (Column S)

The end date for a custom date range. This field is only used when Date range type is set to custom.

Use the yyyy-mm-dd format or any format accepted by PHP's strtotime (e.g., "first day of last month", "last Monday", or "-28 days").

Compare to (Column T)

Specifies the type of comparison for the query data.

Possible values:

• prev: Previous period of the same length.

• year: Same dates a year ago.

• year_match_weekday: Same dates a year ago, matching day of the week.

• custom_yyyy-mm-dd_yyyy-mm-dd: Custom date range for comparison. For example, custom_2024-12-23_2024-12-29

Comparison value type (Column U)

Specifies how the comparison values are displayed.

Possible values: perc (% change), abs (absolute change), or value (show comparison value).

Accounts/views (Column W)

The accounts, pages, or views you want to query data from.

All accounts must be within square brackets [], each account must be within quotes "", and accounts must be separated by commas ,.

The account format (name or ID and name) varies by connector.

To check the account format, create a query in the Supermetrics sidebar.

Example: ["12345'Test - EU","67890'Test2 - LATAM"]

Metrics (Column X)

The metrics selected in your query.

All metrics must be within square brackets [], each metric must be within quotes "", and metrics must be separated by commas ,.

You can find the metric names in the field lists for each data source.

Example:["impressions", "clicks", "cost"]

Dimensions (Column Y)

The dimensions selected in your query. These will be displayed in rows.

All dimensions must be within square brackets [], each dimension must be within quotes "", and dimensions must be separated by commas ,.

You can find the dimension names in the field lists for each data source.

Example:  ["date", "country", "campaign"]

Pivot dimensions (Column Z)

The dimensions selected as pivot dimensions in your query. These will be displayed in columns.

All dimensions must be within square brackets [], each dimension must be within quotes "", and dimensions must be separated by commas ,.

You can find the dimension names in the field lists for each data source.

Example: ["browser", "device"]

Filters (Column AA)

The filters applied to the query.

All filters must be within square brackets [], each filter clause must be within curly brackets {}, and each part of the individual filter must be within quotes "". Parts of the individual filter are separated with colons :. The filter definitions are separated with commas ,.

Example: Filter that reads "Source / Medium contains google": [{"field":"sourceMedium","operator":"=@",

"value":"google","combineToPrev":";"}]

Example: Filter that reads "Source / Medium contains google AND Source / Medium contains cpc OR Source / Medium does not contain organic" [{"field":"sourceMedium","operator":"=@",

"value":"google","combineToPrev":";"},{"field":"sourceMedium","operator":"=@",

"value":"cpc","combineToPrev":";"},{"field":"sourceMedium","operator":"!@",

"value":"organic","combineToPrev":","}]

Sort (Column AC)

Specifies the sorting order for the query results. Only 2 sorts are possible.

The format is field1_asc;2nd:field2_desc.

Example: date_asc;2nd:clicks_desc

Max rows (Column AD)

The maximum number of rows to be displayed.

The minimum value is 5 and the maximum is 1000000.

Max pivot categories (Column AE)

The maximum number of columns to be displayed.

The minimum value is 3 and the maximum is 500.

Special settings (Column AF)

Includes all settings selected under the Options tab and in the Advanced settings field.

All settings are in capitals, words are separated by underscores _, and settings are separated by commas ,.

Example: BLANKS_TO_ZERO,DIMENSIONS_MAX_LENGTH_5