ready to build the future?

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Avalara Inc: The leading provider of cloud-based tax compliance solutions.

Go Back To Case Studies
The Client
Project Category
Data Analytics
Business Intelligence
Customer Engagement
Master Data Management
650+ Pre-Build Connectors
Industry Vertical
Cloud-Native Tax Compliance Solutions | Finance | Sales | IT
Timeline
Since September 2016

Measuring the impact of marketing campaigns and the effects on customer satisfaction.

Avalara–a leading provider of cloud-based tax compliance solutions–was looking for a trusted technology partner to help solve a rather complex business challenge.

Helping over 20,000 businesses achieve compliance with transaction taxes coupled with employees headquartered in Seattle and offices throughout the world, their robust organization was looking to meld its dedication to customer service with the efforts made within its marketing department through data. The goals shared a direct correlation–revenue.

Together with InfoMagnus, Avalara was able to achieve a path forward by taking disparate databases in marketing, sales, finance and IT and unifying them under a new data warehouse using relevant data from both customer satisfaction efforts and marketing campaigns into one platform.

What We Did
Implementation of Microsoft SSIS (SQL Server Integration Services)
Microsoft SQL Server 2012
SQL Server Analysis Services
Excel-based reporting with the use of PowerPivot
Reports and dashboards published through SharePoint

The business challenge: accurately measure marketing program effectiveness and customer satisfaction.

Avalara partnered with InfoMagnus to help solve a business challenge both internally within the organization and externally with their customers: marketing department’s wanted to measure the effectiveness of sales promotions, website content, and social media impact on sales performance, while adhering to company's culture of customer satisfaction.  

At Avalara, entire departments and individual executives are rewarded based on the results of their customer satisfaction scorecard.  

Although these challenges were diverse in nature, these two business goals are related through their effect on revenue; more effective marketing programs and higher customer satisfaction produce higher revenue in this software subscription model.

Accomplishing these business challenges proved to be even more difficult as the data was spread out among dozens of disparate databases in Marketing, Sales, Information Technology, and Finance. The data needed to be unified from Salesforce, Microsoft Dynamics GP (ERP) and multiple other systems in order to build analytics and reporting on top of it.

Project Scope

Avalara partnered with InfoMagnus to create a data warehouse where relevant data from all sources was extracted, transformed, and loaded into one platform. Together, we implemented Master Data Management (MDM) to ensure data integrity throughout the supported systems.

InfoMagnus automated all steps of extracting data from disparate sources, transforming, loading, and producing reports using the new data platform. We developed analytical and reporting solutions, both in a relational database as well as a big data environment, to demonstrate effectiveness of marketing and sales campaign.

Also, customer satisfaction dashboards could now be developed at the department and executive level.

From The Client
"The complex data warehouse and analytical system InfoMagnus developed has become our backbone for customer satisfaction and sales trending analytics."
Project Goals

With more than 20,000 clients, 6.7 billion transactions processed, $30 billion prepared in taxes, 18 million tax documents managed, and 1,500 employees, the opportunities to capture and analyze customer satisfaction data are exponential and so are the opportunities to measure marketing program effectiveness on over $272 million in sales.

The Outcome

Although difficult to measure the exact impact, it is important to note that Avalara has grown significantly since these programs were implemented almost 5 years ago.

Revenue grew from approximately $60 million in 2013 to over $272 million in 2018.

share the future
want to learn more about how InfoMagnus is changing the technology landscape? reach out!
By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Cookies Policy for more information.