Hi,Check if your ACC rdbms supports federation, such as MS SQL's 'linked servers':Snowflake Community From there just expose the db table schemas per usual in Campaign.Thanks,-Jon
Hi,What you have is correct, though can be done with 1 enrichment, or 0 with schema-defined join.For 1:n you have to go through the wizard to specify how many rows to pivot into cols- deliveries are only sent to a single row per recipient in the target table. If unlimited rows are desired you'll hav...
Hi,Interesting, seems like this process is supposed to emulate Windows' recycle bin? Have to wonder why they didn't just reuse delivery's soft-delete mechanic instead. What happens if you delete a recipient directly?FWIW nms:subscription uses the same integrity in its join definition as your schema'...
Hi,Do you have an egress firewall blocking APNS' host/port?If your macOS and iOS clients aren't getting Apple push notifications - Apple SupportThanks,-Jon
Hi,Join recipient to broadlog and trackinglog, then group by recipient's country, summing sends, opens, and clicks.Primary key isn't used here, as you're grouping by country.Thanks,-Jon
Hi,Multitenancy exists on a spectrum of isolation and can vary depending on the client's needs.At one end is no isolation, usually seen in implementations by unskilled consulting shops, where everyone shares an instance and there are folders for different groups to use. At the other end is total iso...