macromator logo svg
Your Needs
B2B MARKETING
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 Marketing Concierge

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.

TECH SIMPLIFIED
MarTech Advisory & Training

Create a solid foundation of understanding and leveraging your digital tools.

Salesforce Consulting

Certified specialists for Salesforce solutions

Marketo Consulting

Marketo certified specialists

ZINFI Consulting

ZINFI expertise to support your partner marketing platform.

Pardot Consulting

Pardot certified specialists

HubSpot Consulting

HubSpot specialists for your marketing needs

MARKETING OPERATIONS
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.

Our Capabilities
HOW WE WORK
Our Clients

Explore the clients we've worked with.

Case Studies
WHAT WE THINK
Resources

Real Business Impact from Marketing Operations.

Our Expertise

Retainer or project based support.

WHERE TO FIND US
Community

Learn about the Martech Community.

Careers

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
Resources
Talent

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:

Account Based Marketing: Building Your Segmentation and Metrics That Matter

Macro President & Founder Dan Radu and Security Compass’ ABM Manager Heidi Vandermeer introduced and explored key aspects of Account Based Marketing in a recent webinar. Read more here about the lively discussion that took place.

Your Marketing Automation Platform Is Like a Ferrari

It would be a shame to spend a small fortune on an expensive car, only for it to sit in your garage, rarely used. This depressing story is something that happens to many modern organizations—except it’s not an expensive vehicle that they leave rusting in a garage, it’s their enterprise marketing automation platform (MAP)
MORE INSIGHTS
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.
crosschevron-downtext-align-right