Change Details

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 second status code. 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|final_campaign|final_status_code|sample_rate|precentage_impressions |C1920_en6C_dsk_FR|6|None|None|C1920_en6C_dsk_FR|6|1|57.34118% |C1920_en6C_dsk_FR|2.2|wikiscience2019|2.2|wikiscience2019|2.2|1|21.52573% |C1920_en6C_dsk_FR|2.1|wikiscience2019|2.1|wikiscience2019|2.1|1|14.60489% |C1920_en6C_dsk_FR|2.2|wikiscience2019|6|wikiscience2019|6|1|2.73761% |C1920_en6C_dsk_FR|2.9|wikiscience2019|2.9|wikiscience2019|2.9|1|1.87039% |C1920_en6C_dsk_low_FR|6|None|None|C1920_en6C_dsk_low_FR|6|1|0.57835% |C1920_en6C_dsk_FR|7|None|None|C1920_en6C_dsk_FR|7|1|0.23875% |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.2|1|0.21992% |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|2.2|1|0.21982% |C1920_en6C_dsk_FR|2.2|wikiscience2019|2.1|wikiscience2019|2.1|1|0.20084% |C1920_en6C_dsk_FR|2.1|C1920_en6C_dsk_low_FR|2.1|wikiscience2019|2.1|1|0.14924% |C1920_en6C_dsk_low_FR|2.1|C1920_en6C_dsk_FR|2.1|wikiscience2019|2.1|1|0.14856% |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|6|1|0.02821% |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|6|1|0.02810% |C1920_en6C_dsk_FR|2.2|wikiscience2019|2.14|wikiscience2019|2.14|1|0.02370% |C1920_en6C_dsk_low_FR|2.9|C1920_en6C_dsk_FR|2.9|wikiscience2019|2.9|1|0.01861% |C1920_en6C_dsk_FR|2.9|C1920_en6C_dsk_low_FR|2.9|wikiscience2019|2.9|1|0.01861% |C1920_en6C_dsk_FR|2.14|wikiscience2019|2.14|wikiscience2019|2.14|1|0.01474% |C1920_en6C_dsk_FR|2.9|wikiscience2019|2.1|wikiscience2019|2.1|1|0.01415% |C1920_en6C_dsk_FR|2.2|wikiscience2019|7|wikiscience2019|7|1|0.00934% |C1920_en6C_dsk_low_FR|7|None|None|C1920_en6C_dsk_low_FR|7|1|0.00241% |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.1|1|0.00204% |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|2.1|1|0.00199% |wikiscience2019|2.2|None|None|wikiscience2019|2.2|0.01|0.00067% |wikiscience2019|6|None|None|wikiscience2019|6|0.01|0.00064% |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|2.14|1|0.00026% |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.14|1|0.00021% |C1920_en6C_dsk_low_FR|2.9|C1920_en6C_dsk_FR|2.9|wikiscience2019|2.1|1|0.00016% |C1920_en6C_dsk_FR|2.14|C1920_en6C_dsk_low_FR|2.14|wikiscience2019|2.14|1|0.00015% |C1920_en6C_dsk_low_FR|2.14|C1920_en6C_dsk_FR|2.14|wikiscience2019|2.14|1|0.00015% |C1920_en6C_dsk_FR|3|None|None|C1920_en6C_dsk_FR|3|1|0.00014% |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|7|1|0.00013% |C1920_en6C_dsk_FR|2.9|C1920_en6C_dsk_low_FR|2.9|wikiscience2019|2.1|1|0.00013% |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|7|1|0.00007% |C1920_en6C_dsk_low_FR|2.1|wikiscience2019|2.1|wikiscience2019|2.1|1|0.00003% |C1920_en6C_dsk_FR|5|None|None|C1920_en6C_dsk_FR|5|1|0.00003% |wikiscience2019|2.1|None|None|wikiscience2019|2.1|0.01|0.00002% |C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.2|wikiscience2019|2.2|1|0.00001% |wikiscience2019|7|None|None|wikiscience2019|7|0.01|0.00001% |asian_month_2019|2.2|wikiscience2019|2.2|wikiscience2019|2.2|0.01|0.00000% |C1920_en6C_dsk_low_FR|2.9|wikiscience2019|2.9|wikiscience2019|2.9|1|0.00000% |None|None|None|None|C1920_en6C_dsk_FR|6|1|0.00000%

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

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 second status code of the second campaign chosen, and when that campaign was fallen back from, there is a value for `status code2_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.34118%79 |C1920_en6C_dsk_FR|2.2|wikiscience2019|2.2|None|None|None|None|wikiscience2019|2.2|1|21.52573%27 |C1920_en6C_dsk_FR|2.1|wikiscience2019|2.1|None|None|None|None|wikiscience2019|2.1|1|14.60489%89 |C1920_en6C_dsk_FR|2.2|wikiscience2019|6|None|None|None|None|wikiscience2019|6|1|2.73761%1 |C1920_en6C_dsk_FR|2.9|wikiscience2019|2.9|None|None|None|None|wikiscience2019|2.9|1|1.87039%89 |C1920_en6C_dsk_low_FR|6|None|None|None|None|None|None|C1920_en6C_dsk_low_FR|6|1|0.57835%48 |C1920_en6C_dsk_FR|7|None|None|None|None|None|None|C1920_en6C_dsk_FR|7|1|0.23875%46 |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.2|None|None|wikiscience2019|2.2|1|0.21992%17 |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|2.2|None|None|wikiscience2019|2.2|1|0.21982%1 |C1920_en6C_dsk_FR|2.2|wikiscience2019|2.1|None|None|None|None|wikiscience2019|2.1|1|0.20084%0 |C1920_en6C_dsk_FR|2.1|C1920_en6C_dsk_low_FR|2.1|wikiscience2019|2.1|None|None|wikiscience2019|2.1|1|0.14924%35 |C1920_en6C_dsk_low_FR|2.1|C1920_en6C_dsk_FR|2.1|wikiscience2019|2.1|None|None|wikiscience2019|2.1|1|0.14856%57 |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|6|None|None|wikiscience2019|6|1|0.02821%06 |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|6|None|None|wikiscience2019|6|1|0.02810%099 |C1920_en6C_dsk_FR|2.2|wikiscience2019|2.14|None|None|None|None|wikiscience2019|2.14|1|0.02370%0 |C1920_en6C_dsk_low_FR|2.9|C1920_en6C_dsk_FR|2.9|wikiscience2019|2.9|None|None|wikiscience2019|2.9|1|0.01861%08 |C1920_en6C_dsk_FR|2.9|C1920_en6C_dsk_low_FR|2.9|wikiscience2019|2.9|None|None|wikiscience2019|2.9|1|0.01861%05 |C1920_en6C_dsk_FR|2.14|wikiscience2019|2.14|None|None|None|None|wikiscience2019|2.14|1|0.01474%1 |C1920_en6C_dsk_FR|2.9|wikiscience2019|2.1|None|None|None|None|wikiscience2019|2.1|1|0.01415%2 |C1920_en6C_dsk_FR|2.2|wikiscience2019|7|None|None|None|None|wikiscience2019|7|1|0.00934%4 |C1920_en6C_dsk_low_FR|7|None|None|None|None|None|None|C1920_en6C_dsk_low_FR|7|1|0.00241%3 |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.1|None|None|wikiscience2019|2.1|1|0.00204%3 |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|2.1|None|None|wikiscience2019|2.1|1|0.00199%2 |wikiscience2019|2.2|None|None|None|None|None|None|wikiscience2019|2.2|0.01|0.00067%5 |wikiscience2019|6|None|None|None|None|None|None|wikiscience2019|6|0.01|0.00064%39 |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|2.14|None|None|wikiscience2019|2.14|1|0.00026%0 |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.14|None|None|wikiscience2019|2.14|1|0.00021%2 |C1920_en6C_dsk_low_FR|2.9|C1920_en6C_dsk_FR|2.9|wikiscience2019|2.1|None|None|wikiscience2019|2.1|1|0.00016%58 |C1920_en6C_dsk_FR|2.14|C1920_en6C_dsk_low_FR|2.14|wikiscience2019|2.14|None|None|wikiscience2019|2.14|1|0.00015%46 |C1920_en6C_dsk_low_FR|2.14|C1920_en6C_dsk_FR|2.14|wikiscience2019|2.14|None|None|wikiscience2019|2.14|1|0.00015%46 |C1920_en6C_dsk_FR|3|None|None|None|None|None|None|C1920_en6C_dsk_FR|3|1|0.00014%3 |C1920_en6C_dsk_FR|2.2|C1920_en6C_dsk_low_FR|2.2|wikiscience2019|7|None|None|wikiscience2019|7|1|0.00013%4 |C1920_en6C_dsk_FR|2.9|C1920_en6C_dsk_low_FR|2.9|wikiscience2019|2.1|None|None|wikiscience2019|2.1|1|0.00013%1 |C1920_en6C_dsk_low_FR|2.2|C1920_en6C_dsk_FR|2.2|wikiscience2019|7|None|None|wikiscience2019|7|1|0.00007%5 |C1920_en6C_dsk_low_FR|2.1|wikiscience2019|2.1|None|None|None|None|wikiscience2019|2.1|1|0.00003%0 |C1920_en6C_dsk_FR|5|None|None|None|None|None|None|C1920_en6C_dsk_FR|5|1|0.00003%0 |wikiscience2019|2.1|None|None|None|None|None|None|wikiscience2019|2.1|0.01|0.00002%4 |C1920_en6C_dsk_low_FR|2.2|wikiscience2019|2.2|None|None|None|None|wikiscience2019|2.2|1|0.00001%5 |wikiscience2019|7|None|None|None|None|None|None|wikiscience2019|7|0.01|0.00001%09 |asian_month_2019|2.2|wikiscience2019|2.2|None|None|None|None|wikiscience2019|2.2|0.01|0.00000%3 |C1920_en6C_dsk_low_FR|2.9|wikiscience2019|2.9|wikiscience2019|2.9|None|None|None|None|None|None|None|None|C1920_en6C_dsk_FR|6|1|0.00000%3 ||C1920_en6C_dsk_low_FR|2.9|wikiscience2019|2.9|None|None|None|None|C1920_en6C_dsk_FR|6wikiscience2019|2.9|1|0.00000%3