Skip to content

Instantly share code, notes, and snippets.

@gillissm

gillissm/SampleReportData.json

Created March 4, 2016 19:49
Show Gist options
  • Save gillissm/7e76184b140b31c25a2b to your computer and use it in GitHub Desktop.
Save gillissm/7e76184b140b31c25a2b to your computer and use it in GitHub Desktop.
Download ZIP
Sample of the JSON from a Sitecore Experience Anayltics Report Query
Raw
SampleReportData.json
{
"totalRecordCount": 13,
"messages": [],
"data": {
"localization": {
"fields": [
{
"field": "key",
"translations": {}
},
{
"field": "segment",
"translations": {
"786fba3a-4573-445e-a745-04e3ca5e48c1": "All visits by channel type"
}
}
]
},
"content": [
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "6 Dec '15",
"date": null,
"key": null,
"visits": 0,
"value": 0,
"conversions": 0,
"timeOnSite": 0,
"pageViews": 0,
"bounces": 0,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0,
"avgVisitDuration": 0,
"conversionRate": 0,
"avgVisitPageViews": 0,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "13 Dec '15",
"date": null,
"key": null,
"visits": 0,
"value": 0,
"conversions": 0,
"timeOnSite": 0,
"pageViews": 0,
"bounces": 0,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0,
"avgVisitDuration": 0,
"conversionRate": 0,
"avgVisitPageViews": 0,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "20 Dec '15",
"date": null,
"key": null,
"visits": 0,
"value": 0,
"conversions": 0,
"timeOnSite": 0,
"pageViews": 0,
"bounces": 0,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0,
"avgVisitDuration": 0,
"conversionRate": 0,
"avgVisitPageViews": 0,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "27 Dec '15",
"date": null,
"key": null,
"visits": 0,
"value": 0,
"conversions": 0,
"timeOnSite": 0,
"pageViews": 0,
"bounces": 0,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0,
"avgVisitDuration": 0,
"conversionRate": 0,
"avgVisitPageViews": 0,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "3 Jan '16",
"date": null,
"key": null,
"visits": 0,
"value": 0,
"conversions": 0,
"timeOnSite": 0,
"pageViews": 0,
"bounces": 0,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0,
"avgVisitDuration": 0,
"conversionRate": 0,
"avgVisitPageViews": 0,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "10 Jan '16",
"date": null,
"key": null,
"visits": 4,
"value": 0,
"conversions": 0,
"timeOnSite": 227,
"pageViews": 6,
"bounces": 3,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0.75,
"avgVisitDuration": 56.75,
"conversionRate": 0,
"avgVisitPageViews": 1.5,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "17 Jan '16",
"date": null,
"key": null,
"visits": 4,
"value": 0,
"conversions": 0,
"timeOnSite": 0,
"pageViews": 4,
"bounces": 4,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 1,
"avgVisitDuration": 0,
"conversionRate": 0,
"avgVisitPageViews": 1,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "24 Jan '16",
"date": null,
"key": null,
"visits": 7,
"value": 44,
"conversions": 44,
"timeOnSite": 81,
"pageViews": 31,
"bounces": 2,
"count": 0,
"valuePerVisit": 6.29,
"bounceRate": 0.2857,
"avgVisitDuration": 11.57,
"conversionRate": 6.29,
"avgVisitPageViews": 4.43,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "31 Jan '16",
"date": null,
"key": null,
"visits": 13,
"value": 0,
"conversions": 2,
"timeOnSite": 2833,
"pageViews": 49,
"bounces": 5,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0.3846,
"avgVisitDuration": 217.92,
"conversionRate": 0.15,
"avgVisitPageViews": 3.77,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "7 Feb '16",
"date": null,
"key": null,
"visits": 4,
"value": 0,
"conversions": 0,
"timeOnSite": 777,
"pageViews": 9,
"bounces": 3,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0.75,
"avgVisitDuration": 194.25,
"conversionRate": 0,
"avgVisitPageViews": 2.25,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "14 Feb '16",
"date": null,
"key": null,
"visits": 0,
"value": 0,
"conversions": 0,
"timeOnSite": 0,
"pageViews": 0,
"bounces": 0,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0,
"avgVisitDuration": 0,
"conversionRate": 0,
"avgVisitPageViews": 0,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "21 Feb '16",
"date": null,
"key": null,
"visits": 3,
"value": 0,
"conversions": 0,
"timeOnSite": 60,
"pageViews": 9,
"bounces": 1,
"count": 0,
"valuePerVisit": 0,
"bounceRate": 0.3333,
"avgVisitDuration": 20,
"conversionRate": 0,
"avgVisitPageViews": 3,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
},
{
"segment": "786fba3a-4573-445e-a745-04e3ca5e48c1",
"dateLabel": "28 Feb '16",
"date": null,
"key": null,
"visits": 3,
"value": 2,
"conversions": 2,
"timeOnSite": 1573,
"pageViews": 17,
"bounces": 1,
"count": 0,
"valuePerVisit": 0.67,
"bounceRate": 0.3333,
"avgVisitDuration": 524.33,
"conversionRate": 0.67,
"avgVisitPageViews": 5.67,
"avgVisitCount": 0,
"avgPageCount": 0,
"avgCountValue": 0
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment