Hi there! Yesterday, using IBM's querying tools, I was trying to give myself an updated sense of what percentage of our list has given us a clear opt-in response and what percentage shows a NULL response. The numbers shook out as follows:
Some of these look reasonable to the naked eye: 43% of enGB have opted-in or out seems sane, for example. But others are very obviously incorrect: itIT has 41k opt-ins when according to my email performance data, 100k itIT donors have opted-in (optin = 1 / YES) through emails alone. Considering banners also ran, that opt-in number should be well over 100k.
svSE also looks off. I'm expecting about 16k - 20k opt-ins (optin = 1 / YES) but only see 3.
Why does this data seem out of date? Is it importing properly into IBM? Does it take longer to update than other fields? I need to know ASAP because our repermissioning testing is slated to start next week and I need to make sure I'm not emailing folks who have already opted-in.