Airship Reports

We only ever have "todays" snapshot of how may are in each segment. If we stored a snapshot each day, we could do trend charts and analysis.

You should be able to choose an Airship form from a drop-down picker, add a Date range and then pull the report. The report should show who filled in the form (with Contact details and opt in status) then the answers to all the Questions present on the form.

The report uses the following to find vouchers assigned or redeemed within the date range specified by users, however because it uses OR, that means that it can count vouchers assigned during the date range as redeemed, and redeemed during the date range as assigned because the case when statements consider all the data gathered and don't look at the specific dates. SUM( CASE WHEN nexumrollout.UniqueCodeLists.assignedDate = "0000-00-00 00:00:00" THEN 0 ELSE 1 END ) AS Assigned , SUM( CASE WHEN nexumrollout.UniqueCodeLists.redeemedDate = "0000-00-00 00:00:00" THEN 0 ELSE 1 END ) AS Redeemed , WHERE ( nexumrollout.UniqueCodeLists.assignedDate BETWEEN "{{daterange_from}}" AND "{{daterange_to}}" OR nexumrollout.UniqueCodeLists.redeemedDate BETWEEN "{{daterange_from}}" AND "{{daterange_to}}" ) A fix for this could be to include the date range in the case when statements, like below, or to use temporary tables to get the assigned and redeemed figures separately. Example: SUM( CASE WHEN nexumrollout.UniqueCodeLists.assignedDate BETWEEN "2025-08-04 00:00:00" AND "2025-08-11 00:00:00" THEN 1 ELSE 0 END ) AS Assigned, SUM( CASE WHEN nexumrollout.UniqueCodeLists.redeemedDate BETWEEN "2025-08-04 00:00:00" AND "2025-08-11 00:00:00" THEN 1 ELSE 0 END ) AS Redeemed Reported by Victors: https://chat.google.com/room/AAAAY0TYMxg/5YjeYAenz9o/5YjeYAenz9o?cls=10

Have the ability to analyse the time that a database is most actively engaged with the email and recommend sending times. Apparently Mail Chimp does this

How was the email opened Mobile vs Desktop for example.

In the overview dashboard test sends are bing included in the overall statistic numbers. This is a little odd as these sends are not representative of typical behaviour on the account.

Having the ability to choose a Tag within the Airship Report selection before processing, downloading and then filtering by Excel/Sheets "Having improved filtering, especially in reports or through tags, would save me a lot of time, as I currently have to do all of this manually in Excel."

We want to generate reports on PoPs from a specific folder or group, rather than just from specific emails. This would be useful for analyzing data from competitions or segmenting groups, such as comparing PoP activity between beer drinkers and cocktail drinkers over a certain period.

I need to analyze customer spend patterns, visit frequency, and points balances from the Zonal Loyalty integration. However, the current system doesn't provide dedicated loyalty reports in the Reports section. It would be beneficial to have specific reports that directly export these loyalty metrics, making it easier to access and analyze the data without having to look at individual contacts.

This report is currently giving different stats to the dashboard & simple search, this needs to be rebuilt to give the real figure for total opted in contacts and look at the same tables as the dashboard.