PostHog · Schema

WebExternalClicksTableQuery

A/B TestingAnalyticsFeature FlagsOpen SourceProduct AnalyticsSession Recording

Properties

Name Type Description
aggregation_group_type_index integer Groups aggregation - not used in Web Analytics but required for type compatibility
compareFilter object
conversionGoal object
dataColorTheme number Colors used in the insight's visualization - not used in Web Analytics but required for type compatibility
dateRange object
doPathCleaning boolean
filterTestAccounts boolean
includeRevenue boolean
interval object Interval for date range calculation (affects date_to rounding for hour vs day ranges)
kind string
limit integer
modifiers object Modifiers used when performing the query
orderBy array
properties array
response object
sampling object
samplingFactor number Sampling rate
stripQueryParams boolean
tags object
useSessionsTable boolean
version number version of the node, used for schema migrations
View JSON Schema on GitHub

JSON Schema

posthog-webexternalclickstablequery-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/WebExternalClicksTableQuery",
  "title": "WebExternalClicksTableQuery",
  "additionalProperties": false,
  "properties": {
    "aggregation_group_type_index": {
      "default": null,
      "description": "Groups aggregation - not used in Web Analytics but required for type compatibility",
      "title": "Aggregation Group Type Index",
      "type": "integer",
      "nullable": true
    },
    "compareFilter": {
      "default": null,
      "allOf": [
        {
          "$ref": "#/components/schemas/CompareFilter"
        }
      ],
      "nullable": true
    },
    "conversionGoal": {
      "default": null,
      "title": "Conversiongoal",
      "anyOf": [
        {
          "$ref": "#/components/schemas/ActionConversionGoal"
        },
        {
          "$ref": "#/components/schemas/CustomEventConversionGoal"
        }
      ],
      "nullable": true
    },
    "dataColorTheme": {
      "default": null,
      "description": "Colors used in the insight's visualization - not used in Web Analytics but required for type compatibility",
      "title": "Datacolortheme",
      "type": "number",
      "nullable": true
    },
    "dateRange": {
      "default": null,
      "allOf": [
        {
          "$ref": "#/components/schemas/DateRange"
        }
      ],
      "nullable": true
    },
    "doPathCleaning": {
      "default": null,
      "title": "Dopathcleaning",
      "type": "boolean",
      "nullable": true
    },
    "filterTestAccounts": {
      "default": null,
      "title": "Filtertestaccounts",
      "type": "boolean",
      "nullable": true
    },
    "includeRevenue": {
      "default": null,
      "title": "Includerevenue",
      "type": "boolean",
      "nullable": true
    },
    "interval": {
      "default": null,
      "description": "Interval for date range calculation (affects date_to rounding for hour vs day ranges)",
      "allOf": [
        {
          "$ref": "#/components/schemas/IntervalType"
        }
      ],
      "nullable": true
    },
    "kind": {
      "default": "WebExternalClicksTableQuery",
      "title": "Kind",
      "type": "string",
      "enum": [
        "WebExternalClicksTableQuery"
      ]
    },
    "limit": {
      "default": null,
      "title": "Limit",
      "type": "integer",
      "nullable": true
    },
    "modifiers": {
      "default": null,
      "description": "Modifiers used when performing the query",
      "allOf": [
        {
          "$ref": "#/components/schemas/HogQLQueryModifiers"
        }
      ],
      "nullable": true
    },
    "orderBy": {
      "default": null,
      "title": "Orderby",
      "items": {
        "anyOf": [
          {
            "$ref": "#/components/schemas/WebAnalyticsOrderByFields"
          },
          {
            "$ref": "#/components/schemas/WebAnalyticsOrderByDirection"
          }
        ]
      },
      "type": "array",
      "nullable": true
    },
    "properties": {
      "type": "array",
      "items": {
        "anyOf": [
          {
            "$ref": "#/components/schemas/EventPropertyFilter"
          },
          {
            "$ref": "#/components/schemas/PersonPropertyFilter"
          },
          {
            "$ref": "#/components/schemas/SessionPropertyFilter"
          },
          {
            "$ref": "#/components/schemas/CohortPropertyFilter"
          }
        ]
      },
      "title": "Properties"
    },
    "response": {
      "default": null,
      "allOf": [
        {
          "$ref": "#/components/schemas/WebExternalClicksTableQueryResponse"
        }
      ],
      "nullable": true
    },
    "sampling": {
      "default": null,
      "allOf": [
        {
          "$ref": "#/components/schemas/WebAnalyticsSampling"
        }
      ],
      "nullable": true
    },
    "samplingFactor": {
      "default": null,
      "description": "Sampling rate",
      "title": "Samplingfactor",
      "type": "number",
      "nullable": true
    },
    "stripQueryParams": {
      "default": null,
      "title": "Stripqueryparams",
      "type": "boolean",
      "nullable": true
    },
    "tags": {
      "default": null,
      "allOf": [
        {
          "$ref": "#/components/schemas/QueryLogTags"
        }
      ],
      "nullable": true
    },
    "useSessionsTable": {
      "default": null,
      "title": "Usesessionstable",
      "type": "boolean",
      "nullable": true
    },
    "version": {
      "default": null,
      "description": "version of the node, used for schema migrations",
      "title": "Version",
      "type": "number",
      "nullable": true
    }
  },
  "required": [
    "properties"
  ],
  "type": "object"
}