How we used IndustryComplete for Salesforce during the COVID-19 pandemic to optimize our business strategy

We eat our own dog food. Here’s a customer success story with a twist… because it’s our own story!

We eat our own dog food. Here’s a customer success story with a twist… because it’s our own story!

The COVID-19 pandemic has hit many industries hard. According to the UK Office for National Statistics, some of the worst affected industries such as accommodation, retail and food services shrank by as much as 90% in the opening months of the financial year 2021 (FY21).

Although the technology sector was less acutely impacted by the pandemic than many other industries, at ProvenWorks we have clients across the most adversely impacted sectors. It was important that we tailored our approach in FY21 in order to meet our customers’ needs. By using IndustryComplete for Salesforce, we were able to do just that!

In fact, we made FY21 our most successful year to date.

So what happened? And how did IndustryComplete help our business not just survive but thrive during COVID-19?

ProvenWorks before COVID-19

Before the pandemic, we based our renewals targets and forecasts on gut feel rather than data. We managed with this heuristic approach, despite our forecasts not always being as accurate as they potentially could be.

When notifying our customers about their upcoming renewals, we gave all of our clients the same notice before their licenses were due to expire, regardless of the industry in which the client operated.

The pandemic creates global business uncertainty

When the business world was shaken up by COVID-19 in early Spring 2020, many of our clients, particularly in sectors such as hospitality and retail, were understandably struggling with cash flow.

Suddenly, gut feel predictions based on clients’ previous purchasing behaviour were no longer sufficient to accurately forecast renewals revenue. Also, our blanket notice period before a customer’s license expiry date may have become inadequate for clients to gain purchasing approval due to procurement constraints.

As a consequence, we experienced fresh challenges in managing our own cash flow, quantifying the necessary investment in lead generation in order to hit sales targets, and assessing the time that renewal opportunities would take to close.

An industry data-enabled solution

We realized that the solution to overcoming these obstacles was right there — Salesforce industry data!

1. Our existing industry data was ready to work with

By ‘eating our own dog food’ and harnessing the power of IndustryComplete in our Salesforce org, we have always ensured that we have accurate and standardized industry values across our accounts.

Thanks to IndustryComplete, adding industry data to our accounts has been quick and painless. We have customised our org using the IndustryComplete component so that only those industries that contain specific keywords appear on the industry search. This way, when a member of our ProvenWorks sales team identifies a hot new lead and creates an account in our Salesforce org, they can be certain that they’ve selected the right industry value in no time at all.

2. We could quickly adjust and add additional industry values

What’s more, we have capitalized on IndustryComplete’s new feature of allocating a primary industry value to those accounts which operate in multiple sectors. This feature has been so useful during the pandemic as businesses are forced to diversify to survive. For example, we were able to re-prioritize the industry value for a firm that used to earn the majority of its revenue in the Retail industry, but now earns the bulk of its revenue in the Electronics industry. This account now appears with an industry value of ‘Electronics’ on our renewals reports.

3. We could predict renewals income based on exact industry distribution

We used our account industry data to more accurately forecast our customers’ likelihood of renewal and therefore our own guaranteed renewal income. Our greater understanding of our cash inflow meant that we could fine tune our budget across the business, including budgeting for acquiring new customers.

4. We could better support clients in struggling industries

We were able to alter our renewals approach for our clients in struggling industries, understanding that their purchasing processes may have been impacted by the pandemic. By giving these customers longer notice before their licenses expired, we were able to keep our renewal rate high and maintain our commitment to customer success.

Moving forward with IndustryComplete

As optimism starts to emerge in the business world once again, we plan to further utilize industry values in our reporting and analysis. Whether it be through investigating retention rates by industry, analysing sectors with opportunities for sales growth or identifying industries in which to launch targeted marketing campaigns, IndustryComplete has enabled us to shape our business strategy more concretely around industry data.

I’ve got a question about IndustryComplete?

Get in touch with us via email here! Our team is more than happy to answer any queries:

A little bonus…

If you made it this far… congratulations! Why not stick around for one more minute, enjoy your coffee and find out a little bit more about IndustryComplete? Watch our video.

5 ways our new Managed Import UI makes importing into Salesforce even easier

We’ve given SimpleImport’s Managed Import Lightning component a new look with a redesigned user interface.

We’ve given SimpleImport’s Managed Import Lightning component a new look with a redesigned user interface

We’ve given SimpleImport’s Managed Import Lightning component a new look with a redesigned user interface. The new Managed Import component is easier to use than ever before with the ability to import your records in just two clicks via any configured Lightning Page or Community Cloud Digital Experience.

Let’s take a look at the new Managed Import component in action.

1. Designed for quick user adoption

Built on the Salesforce Lightning Design System, the new interface results in quicker user adoption as the solution is presented with hand-picked elements, carefully placed to feel natural to the end user.

2. Track your import progress

Introducing automated Path Progression! The live path updates so that import progress bars and dynamic results present exact information as the import is taking place. Say goodbye to the endless looping loading wheel and remove the guesswork of how long your import job has left

3. No more hyperlinks!

We’ve added dedicated actions for downloading result files and reverting an import. Import mistakes can now be reverted through the press of a button. No more hyperlinks – goodbye 2000s!

4. Responsive sizing

Whether you’re big or small, we’ve got your back (for clarity, we’re talking about your screen size). The responsive design now means the component looks great in any shape and size!

5. Perfect for Salesforce Digital Experiences

Did you know our Managed Import component supports Digital Experiences (formerly known as Communities)? The new user interface is streamlined, sleek and succinct which means this user-friendly interface is ideal for all of your partner-facing import needs!

How do I update my Managed Import component?

All you have to do to enjoy our new Managed Import interface is update SimpleImport to the latest version. Install the latest version of SimpleImport or try it for yourself here.

I want to try out Managed Import for myself!

Great news! Managed Import is a feature of SimpleImport Premium. Try it today for free on the AppExchange.

I’ve got a question about Managed Import?

Feel free to contact us via email, our team is more than happy to answer any queries:

Improve efficiency by importing related records with Record ID Merge: Managed Import for Salesforce

What’s a “Record ID Tag” in Managed Import for Salesforce?

If you’re already familiar with Mail Merge functionality in mass emailing services, then you may already grasp what a Record ID Tag is, and if not, then don’t worry, we’ll cover it all here!

The Record ID Tag lets you create a file for import that contains a dynamic reference to a Salesforce Record ID. This is automatically fed to the import job by our Managed Import component at the point of use.

For example, the component can be placed onto an Account’s record page and can pass through the current Account’s ID. This allows you to import related Contacts without the need to copy the Account’s record ID into the file

Why is the Record ID Tag so good?

Managed Import’s main focus is to save you time on repetitive tasks. A very common repeat task is inserting related records. This can be importing Contacts to existing Accounts, or importing Opportunity Line Items into existing Opportunities.

In a time before the Record ID Tag functionality, users would have to specify an ID for the related record in the file. An example can be seen below.

Each time you configure a file to do this, you have to ask yourself:

  • Do my users know how to get a correct ID?
  • Am I sure they’ve entered the right ID?
  • How much time are they spending fetching the IDs?

But now with Record ID Tags, all these questions are answered. The ID column’s cells simply need to contain {!Record.Id} and Managed Import does all the hard work!

Where can I use the Record ID Tag?

The Record ID Tag has two options available and is configured when adding the component to your desired destination:

  1. Pass custom record ID into this import – specify an 18 character record ID into the text field provided. The job will then use this value in the {!Record.Id} cells. This can be useful if using the component in a Salesforce Screen Flow but is available wherever the component is placed.
  2. Pass current record ID into this import – this requires the Managed Import component to be placed onto a Lightning Record Page. When viewing the record in Salesforce, the ID will then be passed to the job automatically!

Can I convert my existing mapping to use the Record ID Tag?

Yes! Firstly – ensure your SimpleImport package is up-to-date with the latest version from the AppExchange – this will guarantee you have these settings available for use.

Update your existing file that is being distributed to your users by replacing the ID column with {!Record.Id}. If the column is empty for your users to fill in, populate this column for them. Do not change the column header as this will invalidate your mapping!

Edit your existing Managed Import component to use either of the settings described in “Where can I use the Record ID Tag?” and save!

Can I only add related records with the Record ID Tag?

No – you also have the ability to update the record you are currently viewing or a record specified in the custom record ID field.

How do I try the Record ID Tag for myself?

The Record ID Tag is part of our Managed Import component which is a feature of SimpleImport on the Salesforce AppExchange. Try it today for free!

For Community and Experience use cases, check out our dedicated Managed Import for Communities listing!

Provide an Address Status to the Nonprofit Success Pack (NPSP) Address Object and display it on related Household Accounts and Contacts

This article covers how to add an “Address Status” field to the NPSP Address object and display it on Household Accounts and Contacts.

By treating the Address object as the “true source” of address information, this is where the custom field belongs. Creating formula fields provides your Org with the functionality it needs to view the custom field data when looking at the Contact or Account record.

This specific use case covers displaying the Address Status field provided with the AddressTools Premium managed package but the following steps can be followed to implement other custom fields added to the Address object.

Adding a Custom Fields to the Addresses Object

As this guide covers the Address Status field provided with AddressTools, we need to add a new field to the Address object.

Create a new field on the Addresses object:

  • Type: Picklist
  • Name: Address Status
  • API Name: AddressStatus (this can be customized to your requirement)
  • Values: Not checked, Not matched, Parsed but not found, Ambiguous, Corrected, Verified.
  • Restrict picklist to the values defined in the value set: False.

If you are following this guide for configuration with AddressTools, see this article to complete an AddressTools implementation on the Address object.

In AddressTools context, any Address Status other than Corrected or Verified are considered “bad addresses” and need reviewing before sending mail.

Creating a Formula on the Contact to Display the Address Status for the Current Address

For Contacts, the Nonprofit Success Pack provides a “Current Address” lookup field which refers to a matching Address record. We will use this lookup to display the Address Status.

Create a new lookup on the Contact object:

  • Type: Formula
  • Name: Address Status Formula
  • Formula Return Type: Text
  • Select Next to enter the formula.

Enter the following formula:

  • TEXT(npsp__Current_Address__r.AddressStatus__c)

Note: ensure the field API name matches what was created in the previous section and TEXT() is only used for picklist fields.

  • Select Next to Establish field-level security.
  • Select Next to Add reference field to Page Layouts
  • Select Save.

Creating a Lookup Field on the Account to Reference the Default Address

For Household Accounts, the Billing Address refers to the Address record where the Default Address equals True. This identifies the address record to fetch the Address Status from.

The Household Account does not have a lookup field as found in the Contact object, so we need to create a custom one.

Create a new field on the Account object:

  • Type: Lookup Relationship
  • Related To: Address
  • Field Label: Default Address
  • Field Name: DefaultAddress (this can be customized to your requirement)
  • Select Next to Establish field-level security.
  • Select Next to Add reference field to Page Layouts.
  • Select Next and uncheck Add Related List.
  • Select Save.

With the lookup field created, it needs to be automatically populated with the default address.

Populate the Lookup Field on the Account to Reference the Default Address

Create a new Process Builder by going Setup | Process Automation | Process Builder | New.

  • Process Name: Update Parent Account with Default Address
  • API Name: autofill
  • The process starts when: A record changes
  • Select Save.

Choose Object:

  • Object: Address
  • Start the process: when a record is created or edited
  • Select Save.

Add Criteria:

  • Criteria Name: When Address Is Default
  • Criteria for Executing Actions: Conditions are met

Set Conditions:

  • Field: Default Address
  • Operator: Equals
  • Type: Boolean
  • Value: True
  • Select Save.

Add Action:

  • Action Type: Update Records
  • Action Name: Update Parent Account – Record Type: Select a record related to the npsp__Address__c – Type to filter list…: Account
  • Choose
  • Criteria for Updating Records: No criteria—just update the records!

Set new field values for the records you update:

  • Field: Address
  • Type: Field Reference
  • Value: npsp__Address__c > Record ID
  • Save.
  • Active the process builder.

Note: A mass update will have to be run on the Address object to update existing records. You can use a data loading solution such as SimpleImport Premium to complete this job.

Creating a Formula on the Account to Reference the Address Status for the Current Address.

Create a new lookup on the Account object:

  • Type: Formula
  • Name: Address Status Formula
  • Formula Return Type: Text
  • Select Next to enter the formula.

Enter the following formula:

  • TEXT(DefaultAddress__r.AddressStatus__c)

Note: ensure the field API name matches what was created in the previous section and TEXT() is only used for picklist fields.

  • Select Next to Establish field-level security.
  • Select Next to Add reference field to Page Layouts
  • Press Save.


Your Organization will now have a field on both the Contact and Account referencing the Address Status value stored on the Address record. By leveraging Automated Address Verification in AddressTools, this address status will update automatically removing any requirement for end-user interaction.

Like the sound of AddressTools?

AddressTools is our 5* app for Salesforce which takes the worry out of bad address data by keeping all of your addresses validated, verified, corrected, and standardized. Like the sound of it? Try it for yourself on the AppExchange!

To find out more about how AddressTools Premium can improve the Nonprofit Success Pack, please do get in touch!

AddressTools Premium: Purchase address verification credits

Address verification credit pricing

Purchasing address verification credits is nice and simple, you’ll need one credit per address you verify, so we advise making a rough calculation to how many credits you’ll need for a year (but don’t worry if you’re short, you can always top-up your account if you’re running low).

The more credits you buy will result in a lower cost per credit, you can find our credit pricing guide here.

How to buy address verification credits In-App

When you’re ready to purchase address verification credits, you can do so by credit card In-App.

Note: A payment handling fee of 8% is added to any purchase made with a credit card. For payment via wire transfer, or if you require a custom quote, see the request a quote section.

  • Go to AddressTools Administration | Licensing & Credits.
  • Under Address Verification Credits, select Quote.
  • For either 5,000 or 10,000:
    • Select Quote under either 5,000 or 10,000 to add to your basket.
    • You will be redirected to your MyCommerce basket.
    • Enter your Billing Information.
    • Enter your Payment Information.
    • For us to associate your purchase with your Salesforce environment, enter your Salesforce Organization ID under the specified field in Additional Ordering Information.
    • Select Buy Now.
  • For a quantity over 10,000:
    • Under Custom, type the quantity.
    • Select Quote to generate an email to
    • Add any additional notes to the body of the email and Send.
    • A custom invoice will be generated for you by a member of the ProvenWorks team.

If you run out of credits or predict you’ll need some more, you can come back to this page any time to top-up, or speak to your ProvenWorks Account Manager if you already have an active subscription.

Note: After any credit purchase, a member of the ProvenWorks team will be in contact to verify the organization where you’d like to apply the credits.

Request a quote for address verification credits

Our team at ProvenWorks are here to help and will be able to work with you to purchase verification credits for your organization. If you’re buying credit volumes in excess of 10,000, we recommend speaking direct with our team.

Additionally, if you would like to:

  • Pay by wire transfer.
  • Add a Purchase Order Number to an invoice.
  • Add credits mid-year.

…or if you would prefer to deal with a human, send an email to listing the amount of credits you’d like to purchase. A member of the sales team will get back to you to with a custom quote for your approval. Once signed-off, you will receive an invoice to be paid.

<– back to AddressTools Premium installation walkthrough.