Campaign Funding Detail
This category provides the detailed breakdown of who contributed funding to a campaign order. There are four types of funding:
• My brand’s funds used on a campaign by allocation
• Partner’s credit card payments
• Funds my brand gave to an intermediary that was used on a campaign
• “Other” funds which include funding from other brands or intermediaries on a campaign.
Grain: Each row represents payment from a different fund allocation or credit card. A campaign order that had multiple funding sources will have multiple rows.
|Amount Paid||The USD amount paid by the line represented.|
|P*||Bundle Order ID||If the Order Type is ‘Bundle’, this is the unique ID for the bundle order. Otherwise, this is blank.|
|P*||Element Order ID||If this Order Type is ‘Element’, this is the unique ID for the element order. Otherwise, this is blank.|
|Fund Allocation Comments||The comments provided for the fund allocation whose funds were used to purchase the campaign.|
|Fund Allocation Name||The name provided for the fund allocation whose funds were used to purchase the campaign.|
|P*||Order ID||This field will show you the Bundle Order Id if the order type is ‘Bundle’, the Element Order Id if the order type is ‘Element’, or the Subscription Order Id if the order type is ‘Element’. The combination of this field and Order Type is unique.|
|P*||Order Type||May be ‘Bundle’, ‘Element’, or ‘Order’. See description for Order Id for key information.|
|Payment Made By||The name of the user who made the payment.|
|Payment Made By Account Type||The type of the account of the user who made the payment (Brand, Partner, Other).|
|Payment Made by User Type||The type of the user who made the payment (Brand, Partner, Brand Contact, Partner Contact, Other).|
|P*||Subscription Order ID||If the Order Type is ‘Subscription’, this is the unique ID for the subscription order. Otherwise, this is blank.|
|Category||Type||Campaign Funding Detail: Campaign Orders|| Full Outer Join. Each record in Campaign Orders may have one or many campaign funding rows. Note that when joining these tables together, you will get one row per fund used on the campaign order, which may result in multiple rows per campaign order.
Note that to see campaign funding, you must satisfy both the following criteria for the campaign order:
• You must be a funding sponsor on the campaign.
• Your money (either directly or via an intermediary) must have been spent on the campaign.
While rare, you may have been associated with a campaign when a purchase was made, then removed from it. The full join will ensure that you see all funds you supplied to campaign orders even if you are no longer associated with the campaign.