Querying Contributions Received via TNEW

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. 

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