Brand Partners

Partners

This category displays information about your partners.

Grain: Each row represents a partner that is connected to you. Note that partners who were connected to you in the past but are not currently connected to you will not show in this category.

Key Name Description
Active Whether your brand is active or not.
Address 1 The address line 1 of your partner from their company account profile.
Address 2 The address line 2 of your partner from their company account profile.
City The city of your partner from their company account profile.
Country The country of your partner from their company account profile.
Email Address The email address of your partner from their company account profile.
Fax The fax of your partner from their company account profile.
Fax Ext The fax extensions of your partner from their company account profile.
Last Login Date The last login date of anyone on the partner company account.
Last Login Date Key The last login date formatted as an integer (YYYYMMDD).
Last Login Date Month The YYYYMM component of the last login date. This is is used to filter reporting by months or for splitting data by months in visualizations.
P Partner ID  The unique identifier for the partner.
Partner Name The name of the partner.
Phone The phone of your partner from their company account profile.
Phone Ext The phone extension of your partner from their company account profile.
Postal Code The postal code of your partner from their company account profile.
State The state of your partner from their company account profile.
Website The website of your partner from their company account profile.

Joins

Category Type
Partners:Precision Connect Inner Join. Each record returned in partners will have one matching record in the precision connect category.
Partners: Campaign Orders Right Outer Join. Each record returned in campaign orders may have 0 or 1 associated partner records. You may not see the partner details for a campaign order if you are not directly connected to that parter. This may happen if campaigns are being ordered through intermediaries.

Partner Metrics

This category displays metrics about your partners.

Grain: Each row represents a partner that is connected to you. Note that partners who were connected to you in the past but are not currently connected to you will not show in this category.

Key Name Description
P Partner ID The unique identifier for the partner.
Advanced Database Prospects The amount of prospects in the partner’s advanced database.
Quick List Prospects The amount of prospects in the partner’s quick lists.
Quick List Prospects    (Subscribed Only) The amount of prospects in the partner’s quick lists who have not unsubscribed.

Joins

Category Type
Partners:Partner Metrics Left Join. Each row in partners may return 0:1 rows in Partner Metrics. Partner Metrics may not have rows for newer partners who do not have any metrics.

Precision Connect

This category displays precision connect information from your partners.

Grain: Each row represents a partner that is connected to you, however, the partner data is not directly shown – only precision connect data in shown.

If you’d like to view the precision connect values for your partners, also use the partners category. Otherwise, this category can be used to filter reports based on your precision connect critieria.

This category is dynamically generated and will include 12 fields – two for each precision connect characteristic available. One field contains a comma separated list of precision connect values, the other contains a comma separated list the precision connect ID and value formatted as: “ID1-Value1,ID2-Value2”.

In order to set up effective filters for precision connect, use the contains operator if you possibly have multiple values selected for a single precision connect characteristic. If your precision connect values contain each other, for example, if you were using: “Premier Partner” and “Advanced Premier Partner”, use the ID-Value field to perform your filtering to avoid returning excess results.

Joins

Category Type
Partners:Precision Connect Inner Join. Each record returned in partners will have one matching record in the precision connect category.