As reported in T411382: CentralNotice Banner Status Codes are broken in Turnilo the status codes reported in our existing Turnilo cube are for the last campaign considered, which is not necessarily the fundraising campaign when fallback is active. We can parse the first campaign's status code out of the campaignStatuses URL parameter, e.g.
...&campaignStatuses=[{"statusCode":"6","campaign":"soso","bannersCount":1}]&status=banner_shown&statusCode=6...Let's add three new dimensions to the banner_activity_minutely Turnilo cube (in https://github.com/wikimedia/operations-puppet/blob/ef99835a63e71d5a1ebf5fa8c8a191b1c75fc7d4/modules/turnilo/templates/config.yaml.erb)
- first_campaign
- first_campaign_status_code
- campaign_fallback (calculated boolean to indicate when campaign fallback occurs)
They also have to be added to the banner_activity_minutely source in Druid (in the analytics/refinery repo)
