Time-based reporting of data using a database system

A method comprising:

• identifying a first plurality of records maintained using a non-relational database in a database system, the first records comprising at least first marketing campaign data for one or more dates;
• generating a second plurality of records based on the first records, the generating of each of the second plurality of records comprising:
• deriving second marketing campaign data for a designated date range from at least a portion of the first marketing campaign data and from at least a portion of the one or more dates, and
• populating a record with the second marketing campaign data for the designated date range;
• storing the second records in a relational database;
• receiving a query of the relational database, the query including at least one or more records from the second records;
• and
• generating a query result in response to the query in real time or substantially real time.

A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising instructions configurable to cause:

• identifying a first plurality of records maintained using a non-relational database, the first records comprising at least first marketing campaign data for one or more dates;
• generating a second plurality of records based on the first records, the generating of each of the second plurality of records comprising:
• deriving second marketing campaign data for a designated date range from at least a portion of the first marketing campaign data and from at least a portion of the one or more dates, and
• populating a record with the second marketing campaign data for the designated date range;
• storing the second records in a relational database;
• and
• generating a graphic based on the second records in the relational database to have graphical content corresponding to the second marketing campaign data and one or more designated date ranges of the second records, the graphic being displayable on a display of a device.