In addition to the myriad reports included with Barracuda PhishLine, you can create your own custom reports to see exactly the data you want to analyze in the way you want it presented.
Creating a Custom Report
To create a custom report:
- From the Results menu, select any entry.
- At the top of the page, click Custom Reporting.
- In the Custom Report Designer, click New.
- Complete the following information:
- Custom Report Name – Provide a familiar name for the custom report.
- Display Options – Specify if you want to display a chart, table, both, or nothing (hidden).
- Custom Report Description – Optional. Provide a description of this report.
- Summary Levels #1-3 – Specify up to three levels by which to group and subtotal results data. The levels are hierarchical. For example, you can see the Average Click Rate by Organizational Area, then by a specific Manager.
- Cross Tabulation – Optional. Specify a further level of breakdown for the results data.
Add up to five summary fields, describing the results you want to calculate, specifying the mathematical information for each field.
Here is an example showing the average click rate of emails, as a percentage of all emails sent.
- Aggregation – Select a function. Choose from: SUM, AVG, COUNT, MAX, MIN, STD, YES/NO.
- Measure A – Select a result type for your equation, like Clicked or Bounced.
- Measure Op – Select the first operator for your equation.
- Measure B – Select the second result type for your equation, if any, like Sent or Send Attempt.
- Operation – Select the second operator for your equation, if any.
- Constant – Specify a constant, if any, such as multiplying by 100 to calculate a percentage.
- Label – Specify a custom label for this value.
- Format – Select how you want to view the value.
- Seq – Specify the sequential order for the summary fields to display.
Specify the visual properties for how you want to display the results data.
- Chart Title – Specify a title for the chart.
- Chart Subtitle – Optional. Add a secondary title to display on the chart.
- Chart Type – Select the type of chart to visually represent the data. (For example, select from bar, column, and line charts.)
- Chart Size – The dimensions of the chart, width x height, in pixels.
- Hide Zero Values – Choose whether to display values of 0 or hide them.
- Show Values – Choose whether to display the numerical values next to the specified chart element.
- Show Legend – Choose whether to display a legend. This is helpful when there is more than one summary field in one chart.
- X-Axis Label – Optionally type a label for the horizontal axis of your chart.
- Y-Axis Label – Optionally type a label for the horizontal axis of your chart.
- Adaptive Y-Axis Minimum Value – Select this value if you only want to see a specific section of the vertical axis of your chart.
- Y-Axis Minimum Value – Specify the lower limit of the vertical axis of your chart.
- Y-Axis Maximum Value – Specify the upper limit of the vertical axis of your chart.
- Pie Chart Radius – If you are creating a Pie or Doughnut Chart, specify its radius, in pixels. To avoid cutting off the chart, be sure to keep the radius smaller than half of the length and width of the chart size.
- Summary Totals – Specify whether you want to display totals for each portion of the data, in addition to the grand total.
- Repeat Summary Labels – Specify whether you want to display labels for the Summary Totals (the field immediately above this field).
- Cross Tab Totals – For a Cross Tab report, specify whether you want to include totals for each measure.
- Cross Tab Measures First – For a Cross Tab report, specify whether you want to show the columns by measure, rather than by calculation.
- At the top of the page, click Save.
- Optionally click Preview to see what your results will look like.
- Based on your preview, make any adjustments as needed, then click Save again.
- Return to the page within results to see your new custom report.
Downloading a Custom Report
To download your custom report as a CSV:
- View the report.
- Click the download button .
The custom report downloads automatically as a CSV.