Following a number of queries we have received regarding data supply, here is some clarification on how to apply source channel at person, gift and pledge level
An example donor X started donating (in a F2F campaign) to organisation Y on 1st of January 2015 with a monthly pledge of $100. In September 2015 they made an online upgrade, modifying their original pledge donation to $150. They then lapsed in February 2016, but were reactivated in August 2016 via telemarketing that modified their pledge donation to $200.
In the table Account / Person level. The Original recruitment channel field will be F2F.
But in the Gifts table
Likewise in the Regular giving pledge table