The Crosstable view lets you analyze the relationships between two dimensions simultaneously, visualizing changes through a heatmap, making it easier to identify trends and patterns.
You can find more information in our cross table guide.
Activating the Cross Table and copying the configuration
In an analysis, click on the Cross Table symbol.
Configure the Cross Table analysis.
Finish the configuration by clicking on „Apply“.
Click “Copy JSON configuration”.
Example Call
{
"resultType": "DATA_ONLY",
"queryObject": {
"columns": [
{
"name": "pages",
"scope": "OBJECT",
"context": "PAGE",
"variant": "NORMAL",
"lowerLimit": 1,
"upperLimit": 20
},
{
"name": "pages_pageImpressions",
"columnPeriod": "ANALYSIS",
"sortDirection": "DESCENDING",
"sortIndex": 1,
"scope": "OBJECT",
"context": "PAGE",
"variant": "NORMAL"
},
{
"name": "visits",
"columnPeriod": "ANALYSIS",
"scope": "OBJECT",
"context": "SESSION",
"variant": "NORMAL"
},
{
"name": "pages_durationAvg",
"columnPeriod": "ANALYSIS",
"scope": "OBJECT",
"variant": "NORMAL"
},
{
"name": "visits_bounceRate",
"columnPeriod": "ANALYSIS",
"scope": "OBJECT",
"variant": "NORMAL"
},
{
"name": "pages_exitRate",
"columnPeriod": "ANALYSIS",
"scope": "OBJECT",
"variant": "NORMAL"
}
],
"viewMode": {
"active": "crossTable",
"crossTable": {
"metricName": "pages_pageImpressions",
"crossDimensionName": "browser_fullName",
"mainDimensionSortDirection": "",
"metricSortDirection": "DESCENDING",
"dimensionUpperLimit": 10,
"crossDimensionSortDirection": ""
}
},
"variant": "LIST",
"predefinedContainer": {
"filters": [
{
"name": "time_range",
"filterPredicate": "BETWEEN",
"connector": "AND",
"caseSensitive": false,
"context": "NONE",
"value1": "2025-06-05 00:00:00",
"value2": "2025-07-03 00:00:00"
}
],
"containers": []
}
}
}Example Result
{
"calculationDataType": "RAW_DATA",
"rows": [
[
"ProductPage",
10799,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"Home",
112,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/sale",
94,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/breathe-easy-tank.html",
8,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/what-is-new.html",
4,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/collections/yoga-new.html",
2,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/diva-gym-tee.html",
1,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/radiant-tee.html",
1,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/all-weather-tank.html",
1,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"exampleCoShop.com/messenger-bag.html",
1,
null,
null,
null,
null,
null,
null,
null,
null,
null
]
],
"rowCount": 1,
"rowCountTotal": 1,
"headers": [
{
"alias": "page_impressions|0",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages"
},
{
"alias": "page_impressions|1",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|2",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|3",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|4",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|5",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|6",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|7",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|8",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
},
{
"alias": "page_impressions|9",
"arrangeType": "page_impressions",
"name": "pages_pageImpressions",
"metric": true,
"dimension": false,
"viewModeDimension": "pages",
"viewModeDimensionValue": "-"
}
],
"columnCount": 11,
"information": [],
"warnings": [],
"timerange": [
"2025-06-05 00:00:00",
"2025-07-03 00:00:00"
],
"timestamp": "2025-07-07T07:48:55.608+0000"
}