The Basics of Report Building
In this article, we'll cover the most commonly used chart types. If you're looking for guidance on building reports, please refer to this comprehensive guide.
In this post, we'll focus on our report feature. Reports in Camphouse are composed of a combination of charts, tables, and diagrams, allowing you to visualize data across all four datasets: targets, planning, forecast, and results. This offers a vast array of options and combinations to choose from. While choice is always a positive, it can also add to the challenge of getting started.
That's where this post comes in. We'll guide you through the basics of getting started by exploring two common report types and the five most common chart options for these reports. Remember, every setup is unique, and your visualization needs may differ. Use this as a quick start guide, but feel free to customize it in any way that aligns with your organizational requirements.
Campaign report
With a campaign report, you can get a quick overview of how your current campaigns are pacing. Here are some suggestions on what to include in the report:
1. Total Actual vs Planned Cost
Datasets: Planning and Results
Measure: Add 'Cost' for both datasets.
Visualization example: Gauge
2. Total Planned Spend per Media Type with Quarterly Grain
Datasets: Planning
Measure: Add your measure for planned Cost.
Dimension: Media Type
Visualization example: Table
Grain: Quarter
3. Media Spend per Media Type
Dataset: Planning
Measure: Add your measure for planned Cost.
Dimension: Media Type
Visualization example: Pie Chart or Column
4. Media Mix
Dataset: Planning
Measure:Add your measure for planned media (for example Planned Cost)
Dimension: Media Vehicle
Visualization example: Pie Chart
Global report
💡A global report has already been created, but you can add new charts if you are an admin or create your private reports.
With a Global Report, you can quickly see your budget allocations and spending across all your brands and/or regions. Here are some suggestions on what to include in the report:
1. Total Planned Spend
Dataset: Planning
Measure: Add your measure for planned media spend (for example Planned Cost)
Visualization example: Number
2. Total Planned Cost per Signature
Measure: Add your measure for planned media (for example, Planned Cost)
Dimension: Signature
Visualization example:Pie Chart or Column
3. Total Planned Cost per Country
Measure: Add your measure for planned media (for example Planned Cost)
Dimension: Add the tag 'Geography'
Visualization example: Map
💡Remember, these are merely suggestions for what you can visualize. Feel free to customize them to suit your specific needs!
Here's an example to illustrate what a report can look like
Curious to learn more about reports in Camphouse? Don't hesitate to reach out—we're happy to assist you!








