Feature Title: Campaign Playlog Reporting Template Selection
Objective:
Enable users to select between two distinct playlog reporting templates for campaign reporting:
Aggregate Report: Displays total ad plays and durations per device/screen over the entire campaign period or selected date range.
Daily Breakdown Report: Shows daily ad plays and durations per device/screen, segmented by each date within the selected range.
🧩 User Stories
As a user, I want to select a campaign and specify a date range so that I can generate a playlog report for that period.
As a user, I want to choose between an aggregate report and a daily breakdown report to view the data in my preferred format.
As a user, I want the ability to export the generated report in CSV or PDF format for further analysis or record-keeping.
🔧 Functional Requirements
Campaign Selection: Provide a dropdown or search field to select the desired campaign.
Date Range Selection: Implement a date picker to define the start and end dates for the report.
Report Type Selection: Offer a toggle or radio buttons to choose between the aggregate report and the daily breakdown report.
Data Display:
Aggregate Report: List of devices/screens with total ad plays and total duration for the selected period.
Daily Breakdown Report: List of devices/screens with daily ad plays and durations, segmented by each date within the selected range.
Export Options: Allow users to export the report in CSV and PDF formats.Wikipedia+2cmssignage+2playsignage.com+2
🎨 UI/UX Requirements
Intuitive Interface: Design a clean and user-friendly interface for selecting campaigns, date ranges, and report types.
Responsive Design: Ensure the feature is accessible and functional across various devices and screen sizes.
Export Buttons: Clearly visible buttons for exporting the report in desired formats.
📊 Data Requirements
Data Sources: Integrate with existing CMS databases to retrieve playlog data for selected campaigns and date ranges.
Data Fields:
Device/Screen ID
Ad Play Count
Total Duration
Date (for daily breakdown report)
🛠 Technical Requirements
Backend:
Implement API endpoints to fetch playlog data based on campaign, date range, and report type.
Ensure data aggregation logic is optimized for performance.
Frontend:
Develop components for campaign selection, date range picker, and report type toggle.
Use data visualization libraries (e.g., Chart.js, D3.js) for rendering the reports.
Export Functionality:
Utilize libraries like jsPDF for PDF generation and PapaParse for CSV export.
✅ Acceptance Criteria
Users can successfully select a campaign and define a date range.
Users can choose between the two report types and view the corresponding data.
Reports are accurately generated and reflect the selected parameters.
Export functionality works correctly for both CSV and PDF formats.
The feature is responsive and performs efficiently under typical load conditions.repeatsoftware.comDigiSignage
📅 Timeline
Design Phase: 2 weeks
Development Phase: 4 weeks
Testing & QA: 2 weeks
📈 Success Metrics
User Adoption Rate: Percentage of users utilizing the new reporting feature.
Export Frequency: Number of times reports are exported in a given period.
User Satisfaction: Feedback ratings from users regarding the usability and functionality of the feature.