macromator logo svg
Your Needs
Partner & Channel Marketing

Empower your channel partners. Build a marketing and sales pipeline together.

Campaigns & Programs

B2B campaigns powered by content and experiences that resonate in today’s modern world.

Global Localization Resources

Cost-efficient and seamless global marketing operations experts.

Webinar Services

Supercharge your online events and webinars in the new remote age.

Account Based Marketing

Target accounts, but speak to people.

Salesforce Consulting

Certified specialists for Salesforce solutions

Marketo Consulting

Marketo certified specialists

HubSpot Consulting

HubSpot specialists for your marketing needs

ZINFI Consulting

ZINFI expertise to support your partner marketing platform.

Pardot Consulting

Pardot certified specialists

Zift Consulting

Zift expertise to support your partner marketing platform.

Managed Services

Extend your marketing team.

Content & Template Design

Deliver your message with the right content.

Demand Gen Strategies

Macro’s demand generation strategies.

Business Process Outsourcing

Eliminate marketing bottlenecks.

Data Operations

Fine tuning and optimization of your marketing tech stack.

Global Concierge Service

Cost-efficient and seamless global marketing operations experts.

Our Capabilities
Our Clients

Explore the clients we've worked with.

Case Studies

Real Business Impact from Marketing Operations.

Our Expertise

Retainer or project based support.


Learn about the Martech Community.


We're hiring, take a look why you should join Macro today.

Contact Us

We want to help you create magical customer experiences.

About Us

Optimization of Act-On Software Marketing with Extended Lists

Great results can be achieved using Extended Lists in Act-On Software. Improve your marketing list, synch faster with CRM, improve data integrity and reduce the chances of error due to data redundancy by using Extension Lists. In this blog post I will show how the Extended List feature in Act-On Software can be used to accomplish similar results to related tables in a database.  

The example I am going to give is a use case of a Microsoft Dynamics CRM integration where emails need to be deployed from a few personalized senders who are the Account Managers (AM). Act-On Software will not synch with any other table than Contacts so the Account Managers information needs to live in Act-On Software.

You need to make sure the correct sales rep information such as the sales rep’s phone and email is associated with each contact. When you design a personalized email the correct sales rep signature must show for each contact, and this signature information comes from the sales rep’s table.  

For the purpose of this example let’s say you only have Contact fields such as Name, Email and an Account Manager synchronized from Microsoft Dynamics CRM to your marketing list in Act-On Software. This is your “All Microsoft Dynamics Contacts” marketing list.

  1. Act-On Integration with Microsoft Dynamics
  2. Extension Lists in Act-On Software
  3. Related Tables in Act-On Software

Act-On Integration with Microsoft Dynamics

You would need to have more Account Manager information for each AM assigned to your contacts because you need this information to generate signatures at the bottom of every email to these contacts. In this case, a separate list called “Account Managers” will be an extension of “All Microsoft Dynamics Contacts”.

Extension List in Act-On Software

As a first step, go to Lists and create a new Extended List called “Account Managers” which would hold the RepName, Email, JobTitle and Phone information for the sales reps. Prepare a list of your sales reps, where each sales rep is a unique record and upload it via CSV to your new Extended List.   The second step is to define an extended list for All Microsoft Dynamics Contacts. The feature is still in testing, so if you do not have this feature activate, contact Act-On Software to activate it for you. Extension Lists can be set up similar to defining a segment for a marketing list. Hover over your marketing list, go to More and select “Define Extended List”. In the pop up window you need to establish the relationship between the two lists by defining:  

  • Marketing List Column to Extend: AccountManager
  • Extension List to Lookup: Account Managers
  • Lookup Column: RepName
  • Joined Column Prefix: AM

  It basically defines AccountManager field as a foreign key in “All Microsoft Dynamics Contacts” and Account Managers list as a related table with the primary key “RepName”.   “AM” will be the prefix used for personalization coding. The Personalization Variables button automatically generates the coding needed for email design. For your email signature use the following coding:  

  • {{AM:JobTitle}}
  • {{AM:Phone}}
  • {{AM:Email}}

  While previewing your emails you will see the correct email signature pulling in for each contact.   If you check your All Microsoft Dynamics Contacts list you will see how the two tables are now "joined". This way, all the assigned Account Manager information cascades down to each contact.

Related Tables in Act-On Software

This improves data integrity and you will always have the correct Account Manager information for each contact. If you were synchronizing any Account Manager fields in Contacts table before, you don't need to do that anymore. Your synchronization with Microsoft Dynamics CRM will now run faster, since there is no need to synchronize anymore the Account Manager information. It can now all be easier maintained in the Extension List.  

Hope this will make things easier for you. There are many other applications of Extension Lists and would love to hear from you what you discovered. For more information visit Act-On Software official website or reach out to us to see how we can help you.

You Might Want to Also Learn About:

What B2B Marketers Needs to Know About Apple's New "Mail Privacy Protection"

Apple announced during this year’s Worldwide Developer Conference that the upcoming iOS 15 will have a Mail Privacy Protection feature. This is super important for digital marketers to know and reevaluate the metrics they focus on. In the Mail app, Mail Privacy Protection stops senders from using invisible pixels to collect information about the user. […]

Marketo & Salesforce Sync Health-Check

A comprehensive way to check how Marketo and Salesforce sync data and what issues you should check for In this article you will learn how to troubleshoot the data syncing between Marketo and Salesforce. Learn how your CRM and marketing automation platform can better operate in tandem. By taking a look under the hood, you […]
Macro makes it easy for companies to grow and scale their operations. Creating alignment between sales, marketing and tech, our experts enable companies to make better data-driven decisions.