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
template.pptx slide 1
2
template.pptx slide 2
3
template.pptx slide 3
4
template.pptx slide 4
5
template.pptx slide 5
6
template.pptx slide 6

output.pptx

1
output.pptx slide 1
2
output.pptx slide 2
3
output.pptx slide 3
4
output.pptx slide 4
5
output.pptx slide 5
6
output.pptx slide 6
7
output.pptx slide 7
8
output.pptx slide 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%"]
        ]
      }
    }
  ]
}