Page MenuHomePhabricator

Country mismatch between Civi and Acoustic causing incorrect email sends
Closed, ResolvedPublic

Description

CID 24698162 (ticket #1777636), currently listed as Canada in Civi, received a US fundraising email today that included language about the US campaign ending soon.

In Acoustic, this recipient is showing as country=US. In Civi, the donor previously had a US address, and it appears this was in place since 2023. It’s unclear when the country parameter was updated to Canada on the Civi side.

Could FR-Tech please investigate the country sync for this contact and confirm why Acoustic is still receiving/retaining country=US even though Civi now shows Canada? Thank you!

Event Timeline

@SHust It looks like this donor had a (incorrect) US primary address in Civi at the time of the last update to their Acoustic record, two days ago, and their address was only changed back to Canada in Civi earlier today. The country should be updated to Canada at the next Acoustic sync early tomorrow morning GMT.

Both Civi and Acoustic show CA as the country for this CID.

@NNgu-WMF can countries update between sends during 6C? I remember we used to not be able to update language for 6C donors mid-campaign as the lists were already cut (see slack thread). Is that still the case, and does the same apply for country? ie. in this case - will the country change be reflected in email 4, or should we snooze them?

@Lars follow up question: Why would the US address take precedence when all but one previous donation from 2017-2023 have been made in CAD with a CA address, including the most recent one prior to the email send. What are the parameters that make one country take precedence?

Finally, do we have these behaviours mapped and documented anywhere? It would be great to understand as we keep coming across this.

Related phabs in similar situations in the past:
https://phabricator.wikimedia.org/T381437 / https://phabricator.wikimedia.org/T407898

@krobinson The country is set based on the address we have in Civi for the donor with a fallback to a guess at their country based on past donations if they don't have an address with a country. So if their country is set in Civi, we don't check past donations at all (and if we do check past donations, I noticed that we aren't even selecting the most recent one, added T410924: Select most recent donation country when adding country to silverpop_missing_countries). This is documented here, but would it be better somewhere else?

I think the solution to countries changing in Acoustic is to prevent the country from changing in CiviCRM based on their IP address when they donate via banner, rather than trying to guess at what might be the real country based on address history. That one is also on the list for next year!

Interestingly, we just received another CID 66180543 from Canada, who reached out about receiving a USD email and requested a refund because their donation was charged in USD. However, their address is listed as CA in Acoustic and US in Civi, and their previous donation was also in CAD (ticket https://wikimedia.zendesk.com/agent/tickets/1774649).

@SHust That one looks like a case of the donor having two cids with two different email addresses and one with a US address based on a past donation (presumably via US IP, from their Paypal account or perhaps erroneously) and the other with a Canadian address. The US contact had country = US in Acoustic and Civi. I've now merged these two contacts into cid 61938254.

@NNgu-WMF can countries update between sends during 6C? I remember we used to not be able to update language for 6C donors mid-campaign as the lists were already cut (see slack thread). Is that still the case, and does the same apply for country? ie. in this case - will the country change be reflected in email 4, or should we snooze them?

@krobinson yep, the same thing applies for country. If the donor changed country mid-campaign, I believe they would just drop out of the flow completely - this is because we add another layer of query criteria on top of the list that was cut at the start of campaign, that says country = US. So I think snoozing them or not is up to you, but maybe snooze them just to be safe!