Aggregating LavaSurf’s Facebook Data

THE CLIENT

Founded in 2012, LavaSurf is a Utah-based SaaS company that helps multi-unit brands manage and scale their social media efforts. Lava Surf’s platform effectively provides the ability to manage, monitor, and optimize social media, reviews, and local listings for all locations in a centralized dashboard.  

 

THE PAIN

LavaSurf set a goal to revolutionize its SaaS offering by creating a new user interface that would allow clients to see their individual Facebook page performance.  

The source of LavaSurf’s data troubles was Facebook’s practice of storing data in JSON format (JSON is difficult to read and ultimately unusable without a more advanced data warehouse solution). LavaSurf could access this data through the Facebook’s page manager services, but LavaSurf couldn’t easily aggregate this data to measure or share the collective performance of their pages.  

 

THE SOLUTION

LavaSurf decided to go the DWaaS route and signed up for the Xerva platform. We immediately took LavaSurf through our five-step process. 

DiscoveryWe sat down with LavaSurf to assess their goals, needs, and current data sources and reporting tools. We made a plan to help them accomplish their goal to create their own client-facing user interface using Facebook JSON data. 

ExtractWe created a data warehouse and connected it to LavaSurf’s Facebook pages.  

TransformWe created a custom solution so that LavaSurf’s JSON (profile, location, and post) data is extracted into a relational database where it can be queried.  

ReportingFor visualizations and reporting, we recommended LavaSurf use Power BI. Once we had Power BI connected to the data warehouse, we helped get adoption by providing training. We then helped them embed their Power BI client reports into their new user interface.  

MonitoringWe host their data and perform routine audits and maintenance to keep things running smoothly. 

 

THE RESULTS

-LavaSurf can now organize reports by company and franchise data 

-LavaSurf can now track aggregate Facebook data (reach, likes, unique impressions)

Xerva enabled LavaSurf for the first time to create a user interface for their clients

-Lava Surf’s data warehouse is managed by Xerva, eliminating the expense of hiring new ETL developers 

Emmett is a graduate from the BYU Marriott School of Management. He has been the marketing team lead at Xerva since July 2017.