Home / Distributed Marketing / Business Intelligence / Data Categories / Brand Allocations

Brand Allocations

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.

Key	Name	Description
	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.

Joins

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.

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.