Analytics report
This is an example of a full set of slides for analytics reporting, using various features available in SlidePack.
Download: input.zip · output.pptx
template.pptx
1
2
3
4
5
6
output.pptx
1
2
3
4
5
6
7
8
data.json
{
"slides": [
{
"template": 1,
"client": "Blues Dream, Inc.",
"report-title": "User Activity Report",
"date": "June 1st, 2021"
},
{
"template": 2,
"period": "May 2021",
"m1icon": { "type": "image", "src": "icons/users.png", "scaling": "contain" },
"m1name": "Sessions",
"m1": "68,338",
"m1unit": "",
"m1growth": { "value": "-16.1%", "styles": { "font": { "color": "#EA8673" } } },
"m2icon": { "type": "image", "src": "icons/conversion.png", "scaling": "contain" },
"m2name": "Conversion Rate",
"m2": "2.47",
"m2unit": "%",
"m2growth": { "value": "+0.48", "styles": { "font": { "color": "#3FC862" } } },
"m3icon": { "type": "image", "src": "icons/bounce.png", "scaling": "contain" },
"m3name": "Bounce Rate",
"m3": "48.23",
"m3unit": "%",
"m3growth": { "value": "-11.5", "styles": { "font": { "color": "#3FC862" } } }
},
{
"template": 3,
"chart-title": "Users/Conversion Rates",
"line-chart": {
"type": "chart",
"labels": ["2020/6", "7", "8", "9", "10", "11", "12", "2021/1", "2", "3", "4", "5"],
"axis1": {
"bounds": { "minimum": 0, "maximum": 70000 },
"series": {
"Series 1": {
"name": "Users",
"values": [50619, 51369, 43932, 41395, 53330, 54263, 60800, 52627, 51957, 63027, 62708, 53121]
}
}
},
"axis2": {
"bounds": { "minimum": 0, "maximum": 0.04 },
"format": "0.00%",
"series": {
"Series 2": {
"name": "Conversion Rate",
"values": [0.0015, 0.0016, 0.0018, 0.0014, 0.001, 0.0017, 0.0122, 0.019, 0.02, 0.0201, 0.0197, 0.0247]
}
}
}
},
"comparisons": {
"type": "table",
"rows": [
["", "Last Month", "This Month"],
["Users", "62,708", "53,121"],
["New Users", "58,691", "49,206"],
["Session Duration", "2:49", "3:15"],
["Bounce Rate", "54.66%", "48.23%"],
["Conversions", "1,547", "1,689"],
["Conversion Rate", "1.97%", "2.47%"]
]
}
},
{
"template": 4,
"donut1-title": "Devices",
"donut1": {
"type": "chart",
"labels": ["Desktop", "Mobile"],
"axis1": {
"series": {
"Series": {
"values": [36146, 15980]
}
}
}
},
"donut2-title": "Languages",
"donut2": {
"type": "chart",
"labels": ["en-us", "en-gb", "es-es", "etc"],
"axis1": {
"series": {
"Series": {
"values": [29633, 4740, 2022, 10037]
}
}
}
}
},
{
"template": 5,
"message": "Clicks are stabilizing, but conversion rates from ads need a boost",
"chart1": {
"type": "chart",
"labels": ["2020/6", "7", "8", "9", "10", "11", "12", "2021/1", "2", "3", "4", "5"],
"axis1": {
"bounds": { "maximum": 35000, "minimum": 0 },
"series": {
"Series 1": {
"name": "Ad Clicks",
"values": [964, 560, 1079, 0, 0, 6891, 29593, 31534, 9692, 9815, 9170, 9093]
}
}
},
"axis2": {
"bounds": { "maximum": 250, "minimum": 0 },
"series": {
"Series 3": {
"name": "CPC",
"values": [0.38, 0.34, 0.18, 0.0, 0.0, 1.99, 1.48, 1.8, 1.28, 1.2, 1.33, 1.53]
}
}
}
},
"chart2": {
"type": "chart",
"labels": ["2020/6", "7", "8", "9", "10", "11", "12", "2021/1", "2", "3", "4", "5"],
"axis1": {
"bounds": { "maximum": 100, "minimum": 0 },
"series": {
"Series 1": {
"name": "Conversions from Ads",
"values": [2, 3, 2, 0, 1, 1, 66, 65, 79, 26, 12, 4]
}
}
},
"axis2": {
"bounds": { "maximum": 14000, "minimum": 0 },
"series": {
"Series 3": {
"name": "CPA",
"values": [183.55, 62.55, 98.35, 0, 0, 13681.99, 665.09, 875.16, 156.95, 452.15, 1019.14, 3469.54]
}
}
}
},
"comparisons": {
"type": "table",
"rows": [
["", "Impressions", "Cost", "Clicks", "CTR", "CPC", "Conversions", "CVR"],
["Total", "57191", "$13878.17", "9093", "15.9%", "153", "4", "0.53%"],
["MoM", "-3.9%", "+13.5%", "-0.9%", "+3.1%", "+14.4%", "-66.7%", "-61.8%"],
["YoY", "+4385%", "+115%", "+2768%", "-36.5%", "+320%", "+300%", "+168%"]
]
}
},
{
"template": 6,
"slide-title": "Ad Performance by Campaign",
"table1": {
"type": "table",
"rows": [
["", "Impressions", "Cost", "Clicks", "CTR", "CPC", "Conversions", "CVR"],
["Hoodies", "19,618", "910.08", "1,622", "8.27%", "0.56", "0", "0.00%"],
["YouTube", "6,280", "4,567.17", "1,932", "30.76%", "2.36", "0", "0.00%"],
["Tumbler", "4,974", "602.98", "746", "15.00%", "0.81", "0", "0.00%"],
["T-shirts", "2,688", "303.88", "357", "13.28%", "0.85", "0", "0.00%"],
["Apparel", "2,040", "2,289.38", "759", "37.21%", "3.02", "1", "7.14%"],
["Tumbler", "1,838", "604.03", "309", "16.81%", "1.95", "0", "0.00%"],
["Drinkware", "1,592", "684.81", "312", "19.60%", "2.19", "0", "0.00%"],
["Bags", "737", "885.68", "182", "24.69%", "4.87", "0", "0.00%"],
["Android Brand", "168", "43.81", "37", "22.02%", "1.18", "0", "0.00%"],
["Office", "106", "55.61", "18", "16.98%", "3.09", "0", "0.00%"],
["Accessories", "33", "207.35", "11", "33.33%", "18.85", "0", "0.00%"]
]
}
},
{
"template": 6,
"slide-title": "Ad Performance by Ad Group",
"table1": {
"type": "table",
"rows": [
["", "Impressions", "Cost", "Clicks", "CTR", "CPC", "Conversions", "CVR"],
["AW - YouTube Brand", "5,242", "$3,041.63", "1,645", "31.38%", "$1.85", "0", "0.00%"],
["AW - Hoodies", "4,417", "$119.39", "266", "6.02%", "$0.45", "0", "0.00%"],
["AW - Hoody", "3,810", "$109.47", "241", "6.33%", "$0.45", "0", "0.00%"],
["AW - Sweatshirt", "3,514", "$72.30", "160", "4.55%", "$0.45", "0", "0.00%"],
["AW - Hoodies", "3,293", "$264.59", "417", "12.66%", "$0.63", "0", "0.00%"],
["AW - Shirts", "3,055", "$303.81", "319", "10.44%", "$0.95", "0", "0.00%"],
["AW - Hoody", "2,989", "$238.93", "370", "12.38%", "$0.65", "0", "0.00%"],
["AW - Tumbler", "2,200", "$198.46", "327", "14.86%", "$0.61", "0", "0.00%"],
["AW - Apparel All", "1,663", "$1,805.35", "640", "38.48%", "$2.82", "1", "8.33%"]
]
}
},
{
"template": 6,
"slide-title": "Ad Performance by Device",
"table1": {
"type": "table",
"rows": [
["", "Impressions", "Cost", "Clicks", "CTR", "CPC", "Conversions", "CVR"],
["mobile", "43,021", "$8,959.98", "6,659", "15.48%", "$1.35", "0", "0.00%"],
["desktop", "10,507", "$4,009.69", "1,976", "18.81%", "$2.03", "4", "4.30%"]
]
}
}
]
}