Account-contact mapping

Account contact mapping controls identity. You decide which person belongs to which account record, which account should receive activity, and which relationships your team can act on. In Eloqua, a contact and account are associated only when linked field values are identical, so a small naming difference can leave a contact unlinked.^{1, 2} Eloqua applies the relationship across the entire instance,³ and the mapping cannot be undone once created.⁴ Build the account identifier first, test its uniqueness, then attach contacts and inspect exceptions before using the list. Treat every unmatched contact as a data problem to resolve before outreach.

Set the record rule

Decide what belongs in the working set and how each person will connect to an account. Write the rule down before you personalize anything, so one matching method guides the work from account research through outreach.

Write down the operating question: "Are you using Leads, Contacts, or both? How do you match Leads to Accounts?"⁵

After researching accounts, find their contacts and tailor the emails to those contacts.⁶ Then choose the contacts you need to pursue.⁷ When your source includes values such as usernames, focus on primary accounts from the relevant source or accounts that are not service accounts.⁸ Move on when you can explain which record types you will use, how a contact becomes attached to an account, and which contacts belong in the pursuit list.

Choose the account identifier

Choose the account identifier before connecting records. The field should resolve cleanly to the account that will receive contact activity and reporting.

Multiple contacts can be paired with one account, so the selected account field must contain a unique identifier.⁹ Check for duplicate values before creating the linkage, and continue only when each account value resolves to one account in the set you plan to use.

Treat the mapping as a commit point. The opening check matters because a broad linkage can affect records beyond the rows you are reviewing,³ and the mapping cannot be undone once created.⁴

Match values and repair exceptions

Compare the actual values in the contact and account fields before loading the contact rows. For example, linking the Company contact field to the Company Name account field in Eloqua reflects an association only when the values match.¹⁰ Put any row with a different value in an exception queue. Fix the account value, then check the relationship again before using the contact in outreach.

Similar names do not create a match. Stop only when every field pair used for the linkage contains an exact value match.

Import contacts without changing the account population

Account name

If same account name

Use the same account

If different account name

Creates a new account

Account name

• If same account name, use the same account
• If different account name, creates a new account

The import should attach contacts to existing account records and make unexpected account creation easy to spot. Prepare the file around the account names already in the system.

If you use ActiveCampaign, use the same account name in the CSV file as the existing account name.¹¹ A different account name creates a new account record during import.¹²

Prepare the contact file with an email address column and an Account column.^{13, 14} Ensure that the accounts in the file match existing accounts before you import.¹⁵ Then follow the contact import workflow to connect the contacts to those accounts.¹⁶

After the import, inspect the account records and a sample of attached contacts. Continue when the file has produced the expected relationships without adding account names that are spelling variants or unresolved exceptions.

Validate relationships you will use

A mapped contact should give the account enough context for follow-up, segmentation, and attribution. Validate the relationship at the account level before treating the list as ready.

Significant activity by a contact linked to an account can then be associated with that account.¹⁷ Account linking can also help create campaign segments targeted at relevant companies.¹⁸ Confirm that activity appears on the intended account and that the account can be selected for the audience you want.

Account Contact Relationships define relationships between individual contacts and business accounts.¹⁹ They can represent an individual working with multiple accounts or working with accounts in different capacities, including employee, agent, partner, affiliate, or contractor.^{20, 21} Use the relationship role when a person's influence depends on how they work with the account. The available role model includes Business user, Executive Sponsor, and Influencer.²² These relationships can help you navigate power dynamics within a prospect account and target messaging.²³

Check whether your lead to account matching supports attribution. Accurate lead to account matching is required so inbound leads are matched to existing accounts when appropriate.²⁴

What not to do

• Do not select an account field with duplicate values for linkage. The field is rejected by the dependency check before linkage.²⁵
• Do not expect an account import to connect contacts. Make the connection during a contact import.²⁶
• Do not force a one contact to one account structure when people work across account networks or hold different relationships with different accounts.²⁷