** We are self-hosted**
Any tips on how to identify contributions received via TNEW?
Thanks,
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Contributions made through orders (including those on TNEW) would inherit the channel value of the order. The Fund Activity Report has a Channel parameter, and it pulls through into Analytics for analysis. In the database you'll find it in T_CONTRIBUTION.channel. The values come from TR_SALES_CHANNEL.
Manually entered contributions, such as those that were made on TNEW to an On Account payment method, should be entered with a "web" or similar Channel value. The rest of this guidance would then apply.
**SOVLED**
UGH! *facepalm*
I was using media_type instead of channel last week!
That "13 rows" had me pulling my hair out!
Ashley