foreign for fundraise up and Salesforce integration overview omatic has been solving non-profit data ingestion and integration needs for over 20 years it has over 3 000 customers we have over 100 individuals on our team many coming from the non-profit Community as admins or part of development teams omatic is certified and available on the Salesforce app Exchange omatic is purpose built for non-profit data integration it helps power your mission by integrating and unifying disconnected data into consistent and personalized supporter experiences omatic serves as the single point of ingestion for all data coming in and out of
Salesforce regardless of whether you utilize a niche system that produces flat files or the most common systems that we have a direct API integration with with omatic you establish business rules for mapping duplicate prevention and data transformation one time then update as you make process changes going forward all of our domain expertise is built into our Solutions we believe in configuration versus customization to provide accessible integration for all non-profits versus custom coding and customization well Matic Cloud takes the best of our 20 years experience in data ingestion and couples it with the most advanced secure
Cloud technology the result is an easy to use intelligent data integration platform that supports CSV and Excel file formats corrects data while in route prevents duplicates and frees up hours of Staff time let's take a look at how we can integrate fundraise up transactions into Salesforce we're now looking at my file of transactions that I've downloaded from fundraise up this is a very large file and it contains well over a hundred Columns of data we're just looking at a few of those columns a few items to point out some donor names are whispering to us
While others are screaming in all caps lastly I don't know if these are new or existing records in Salesforce we're now going to go into a Matic cloud and import these fundraise up transactions to Salesforce and we'll see how omatic Cloud cleans up and transforms this data this is my home screen in omatic Cloud where I manage Imports and Integrations for Salesforce I have a template formula set up for fundraise up my formula includes where data is mapped between Salesforce and fundraise up how to clean up that data and record matching to import fundraise up
transactions I can drag and drop my Excel file onto the formula or I can click and browse to the file location upon selecting the file and clicking on open the import process begins the import runs in the background and I can import multiple files simultaneously and I can continue working in Salesforce while the import processes omatic Cloud enables importing and integration from any Source or platform that can produce an Excel or CSV file when the import integration completes the fundraise up transactions will be in Salesforce which is what we'll see next [Music] it's important for
my development team to view opportunity details for fundraise up transactions we're now inside of Salesforce looking at a simple report I've created displaying opportunity details along with some of the transactional data points from fundraise up such as did the donor cover the fundraise up fee fundraise up element name and the fundraise up payment ID being able to view all opportunity history inside of Salesforce gives me and my development team full insight into all of a person's activities this is the back end of my formula this is where I map fields from fundraise up and choose
where those data fields reside in Salesforce this is a simple one-time field mapping exercise I can map data to custom objects or fields that I've created within Salesforce with no installed packages or objects omatic Cloud gives me the flexibility to track data how it best fits my organization in Salesforce I can clean up data before it's transferred into Salesforce for example if names are in all caps or lowercase I can apply cleanup rules to proper case data when importing in email addresses I can set them to lowercase I can also set telephone formats date and
time formats as well as postcode formatting and more I also need to be able to transform data from my file into the appropriate format for Salesforce when I'm importing in Opportunities I can build the opportunity Name by concatenating multiple fields from my fundraise up file in this case last name campaign name and gift amount why does all of this matter omatic cloud is a flexible and robust tool to integrate math clean and synchronize fundraise up transactions with Salesforce omata Cloud helps eliminate data silos and creates a single source of Truth timely and accurately integrated data
means I can view up-to-date opportunity history inside of Salesforce and a full 360 view of supporters I can confidently report to my CFO on campaign progress and I can make strategic decisions on marketing efforts [Music] thank you