Leads/Brand Lead Hub Leads

This category contains the lead records from lead hub. Brands will see:

  • Records for leads that they own.
  • Records for leads that partners have shared with the Brand.
  • Records for leads that were generated off campaigns that a brand has visibility to (see the “Data Security” section at the top of this document for the definition of “campaigns that a brand has visibility to”).

Grain:  Each row in this category represents a lead.

Caution! When displaying campaign level data (for example, clicks or impressions), if you have brought in this category, your campaign rows may be duplicated when multiple leads registered on a campaign. In order to eliminate this, sort your data by CampaignMetrics.CampaignOrderId, group by CampaignMetrics.CampaignOrderId, and use the MAX() function on campaign metric values to get accurate counts.

Enhancements are planned to associate lead hub counts and opportunity value to a campaign order much simpler.

Key Name Description
Campaign Order ID The campaign order ID that the lead is tied to (note that is a lead was added to lead hub manually or via API, this may not be populated).
City The city of the lead.
Company Name The company name of the lead.
Country The country of the lead.
Created Date The date the lead was created.
Created Date Key The date the lead was created in integer (YYYYMMDD) format.
P Lead ID The unique identifier for the lead.
Lead Status The status of the lead.
Lead Status ID The unique identifier for the status of the lead.
Last Modified Date The last modified date of the lead.
Last Modified Date Key The last modified date of the lead in integer (YYYYMMDD) format.
State/Province The state/province of the lead.

Joins

Category Type
Leads:Campaign Orders Full Join. By default, all campaign orders and leads will be returned. This means that leads which are not associated to campaigns will also be returned..
Leads:Brand Opportunities Left Outer. By default, all leads will be returned and all opportunities associated with those leads. If more than one opportunity is associated with a lead, the lead data will be doubled.

Opportunities/ Brand Opportunities

This category contains the opportunity records from lead hub. Brands will see:

  • Records for opportunities on leads that they own.
  • Records for opportunities on leads they have shared with their partners.
  • Records for opportunities on leads that were generated off campaigns that a brand has visibility to (see the “Data Security” section at the top of this document for the definition of “campaigns that a brand has visibility to”).

Grain:  Each row in this category represents a single opportunity.

Caution! When displaying campaign level data (for example, clicks or impressions), if you have brought in this category, your campaign rows may be duplicated when multiple opportunities exist on a campaign. In order to eliminate this, sort your data by CampaignMetrics.CampaignOrderId, group by CampaignMetrics.CampaignOrderId, and use the MAX() function on campaign metric values to get accurate counts.

Enhancements are planned to associate lead hub counts and opportunity value to a campaign order much simpler.

Key Name Description
Campaign Order ID The campaign order ID that the opportunity is tied to (note that if a lead was added manually or via API, this may not be populated.
Created Date The date the opportunity was created.
Estimated Close Date The estimated close date of the opportunity.
Last Modified Date The last date the opportunity was modified.
P Lead ID The unique identifier for the lead this opportunity is tied to.
Opportunity ID The unique identifier for the opportunity.
Quantity The quantity entered into the opportunity.
Status The status of the opportunity.
Total Value Will always equal quantity * unit value.
Unit Value The unit value entered into the opportunity.

Joins

Category Type
Brand Opportunities:Leads Right Outer. By default, all leads will be returned and all opportunities associated with those leads. If more than one opportunity is associated with a lead, the lead data will be doubled.