In many cases, when a campaign cedes a page view to another campaign, the second campaign gets as its status code the code for the first campaign.
Here is data for one day of impressions. status0_code is the status code of the first campaign in campaignStatuses. When a campaign was fallen back from, there is a value for status1_code, which should be the status code of the second campaign chosen, and when that campaign was fallen back from, there is a value for status2_code, etc. final_status_code is the legacy status code field and should should be the status code of the last campaign chosen.
Actual impression numbers have been replaced here by the percentage of total impressions for the day, 2019-12-03.
Here is the query used for this data: P9870.
Note, for example, several cases of the non-fundraising campaign getting a 2.9 status code, which is for when a FR banner is hidden because the user donated.
status0_campaign | status0_code | status1_campaign | status1_code | status2_campaign | status2_code | status3_campaign | status3_code | final_campaign | final_status_code | sample_rate | precentage_impressions |
C1920_en6C_dsk_FR | 6 | None | None | None | None | None | None | C1920_en6C_dsk_FR | 6 | 1 | 57.341179 |
C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 2.2 | None | None | None | None | wikiscience2019 | 2.2 | 1 | 21.525727 |
C1920_en6C_dsk_FR | 2.1 | wikiscience2019 | 2.1 | None | None | None | None | wikiscience2019 | 2.1 | 1 | 14.604889 |
C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 6 | None | None | None | None | wikiscience2019 | 6 | 1 | 2.737611 |
C1920_en6C_dsk_FR | 2.9 | wikiscience2019 | 2.9 | None | None | None | None | wikiscience2019 | 2.9 | 1 | 1.870389 |
C1920_en6C_dsk_low_FR | 6 | None | None | None | None | None | None | C1920_en6C_dsk_low_FR | 6 | 1 | 0.578348 |
C1920_en6C_dsk_FR | 7 | None | None | None | None | None | None | C1920_en6C_dsk_FR | 7 | 1 | 0.238746 |
C1920_en6C_dsk_FR | 2.2 | C1920_en6C_dsk_low_FR | 2.2 | wikiscience2019 | 2.2 | None | None | wikiscience2019 | 2.2 | 1 | 0.219917 |
C1920_en6C_dsk_low_FR | 2.2 | C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 2.2 | None | None | wikiscience2019 | 2.2 | 1 | 0.219821 |
C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 2.1 | None | None | None | None | wikiscience2019 | 2.1 | 1 | 0.200840 |
C1920_en6C_dsk_FR | 2.1 | C1920_en6C_dsk_low_FR | 2.1 | wikiscience2019 | 2.1 | None | None | wikiscience2019 | 2.1 | 1 | 0.149235 |
C1920_en6C_dsk_low_FR | 2.1 | C1920_en6C_dsk_FR | 2.1 | wikiscience2019 | 2.1 | None | None | wikiscience2019 | 2.1 | 1 | 0.148557 |
C1920_en6C_dsk_FR | 2.2 | C1920_en6C_dsk_low_FR | 2.2 | wikiscience2019 | 6 | None | None | wikiscience2019 | 6 | 1 | 0.028206 |
C1920_en6C_dsk_low_FR | 2.2 | C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 6 | None | None | wikiscience2019 | 6 | 1 | 0.028099 |
C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 2.14 | None | None | None | None | wikiscience2019 | 2.14 | 1 | 0.023700 |
C1920_en6C_dsk_low_FR | 2.9 | C1920_en6C_dsk_FR | 2.9 | wikiscience2019 | 2.9 | None | None | wikiscience2019 | 2.9 | 1 | 0.018608 |
C1920_en6C_dsk_FR | 2.9 | C1920_en6C_dsk_low_FR | 2.9 | wikiscience2019 | 2.9 | None | None | wikiscience2019 | 2.9 | 1 | 0.018605 |
C1920_en6C_dsk_FR | 2.14 | wikiscience2019 | 2.14 | None | None | None | None | wikiscience2019 | 2.14 | 1 | 0.014741 |
C1920_en6C_dsk_FR | 2.9 | wikiscience2019 | 2.1 | None | None | None | None | wikiscience2019 | 2.1 | 1 | 0.014152 |
C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 7 | None | None | None | None | wikiscience2019 | 7 | 1 | 0.009344 |
C1920_en6C_dsk_low_FR | 7 | None | None | None | None | None | None | C1920_en6C_dsk_low_FR | 7 | 1 | 0.002413 |
C1920_en6C_dsk_FR | 2.2 | C1920_en6C_dsk_low_FR | 2.2 | wikiscience2019 | 2.1 | None | None | wikiscience2019 | 2.1 | 1 | 0.002043 |
C1920_en6C_dsk_low_FR | 2.2 | C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 2.1 | None | None | wikiscience2019 | 2.1 | 1 | 0.001992 |
wikiscience2019 | 2.2 | None | None | None | None | None | None | wikiscience2019 | 2.2 | 0.01 | 0.000675 |
wikiscience2019 | 6 | None | None | None | None | None | None | wikiscience2019 | 6 | 0.01 | 0.000639 |
C1920_en6C_dsk_low_FR | 2.2 | C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 2.14 | None | None | wikiscience2019 | 2.14 | 1 | 0.000260 |
C1920_en6C_dsk_FR | 2.2 | C1920_en6C_dsk_low_FR | 2.2 | wikiscience2019 | 2.14 | None | None | wikiscience2019 | 2.14 | 1 | 0.000212 |
C1920_en6C_dsk_low_FR | 2.9 | C1920_en6C_dsk_FR | 2.9 | wikiscience2019 | 2.1 | None | None | wikiscience2019 | 2.1 | 1 | 0.000158 |
C1920_en6C_dsk_FR | 2.14 | C1920_en6C_dsk_low_FR | 2.14 | wikiscience2019 | 2.14 | None | None | wikiscience2019 | 2.14 | 1 | 0.000146 |
C1920_en6C_dsk_low_FR | 2.14 | C1920_en6C_dsk_FR | 2.14 | wikiscience2019 | 2.14 | None | None | wikiscience2019 | 2.14 | 1 | 0.000146 |
C1920_en6C_dsk_FR | 3 | None | None | None | None | None | None | C1920_en6C_dsk_FR | 3 | 1 | 0.000143 |
C1920_en6C_dsk_FR | 2.2 | C1920_en6C_dsk_low_FR | 2.2 | wikiscience2019 | 7 | None | None | wikiscience2019 | 7 | 1 | 0.000134 |
C1920_en6C_dsk_FR | 2.9 | C1920_en6C_dsk_low_FR | 2.9 | wikiscience2019 | 2.1 | None | None | wikiscience2019 | 2.1 | 1 | 0.000131 |
C1920_en6C_dsk_low_FR | 2.2 | C1920_en6C_dsk_FR | 2.2 | wikiscience2019 | 7 | None | None | wikiscience2019 | 7 | 1 | 0.000075 |
C1920_en6C_dsk_low_FR | 2.1 | wikiscience2019 | 2.1 | None | None | None | None | wikiscience2019 | 2.1 | 1 | 0.000030 |
C1920_en6C_dsk_FR | 5 | None | None | None | None | None | None | C1920_en6C_dsk_FR | 5 | 1 | 0.000030 |
wikiscience2019 | 2.1 | None | None | None | None | None | None | wikiscience2019 | 2.1 | 0.01 | 0.000024 |
C1920_en6C_dsk_low_FR | 2.2 | wikiscience2019 | 2.2 | None | None | None | None | wikiscience2019 | 2.2 | 1 | 0.000015 |
wikiscience2019 | 7 | None | None | None | None | None | None | wikiscience2019 | 7 | 0.01 | 0.000009 |
asian_month_2019 | 2.2 | wikiscience2019 | 2.2 | None | None | None | None | wikiscience2019 | 2.2 | 0.01 | 0.000003 |
None | None | None | None | None | None | None | None | C1920_en6C_dsk_FR | 6 | 1 | 0.000003 |
C1920_en6C_dsk_low_FR | 2.9 | wikiscience2019 | 2.9 | None | None | None | None | wikiscience2019 | 2.9 | 1 | 0.000003 |