Using AI To Format Data Uploads For Revenue Reporting

Posted by: Macenzi Barker Date Posted: March 24, 2026
Back to Case Studies

Issue

The Tree Guardian brands have quite a few accounts with us now, and some of them use the same CRM software. While some brands use industry-specific platforms like ArborGold or ArboStar, the client team’s recommended software for all brands is SingleOps, and they eventually hope to get all other brands moved over to that CRM as well.

We’ve established a monthly CRM export cadence where the client exports job data and sends it to the WebFX team. Upon further review, we found that there are times when multiple contacts would be associated with one job.

The issue is that, if there is more than one contact for a single job in SingleOps, all of the name/email/phone data for all contacts is stored in a single cell in the export file (screenshot).

There was no perfect pattern for the order of data entered in each cell, so it wasn’t possible to create an Excel/GSheet formula to separate the cell contents.

While there are other columns in the sheet for name/email/phone, we found that these would be left blank if there’s more than one contact associated with the job (screenshot), which then prevents us from being able to tie the deal revenue back to a contact and therefore tracked conversion on the site (no marketing channel attribution for that deal revenue).

Solution

The solution to the problem was to use AI!

I found that the Claude models worked exceptionally well for this.

At the time, TeamAI did not support Excel file uploads, and with the formatting of the sheet, we could not convert it to CSV, so I used a paid and protected version of Claude to perform this update.

Claude also helped me build an optimized prompt that I have saved in the client notes to use for cleaning the exports each month.

After the prompt is entered and the file is uploaded to Claude, the output splits each contact into a new row and copies the remaining deal data (deal ID, value, start/close dates, etc.) into those same rows.

Because each of the contacts on a new line in the spreadsheet have the same deal ID and deal data, we get the best of both worlds to import all of the contact data and associated deal info into RCFX without duplicating revenue!

This process has allowed us to upload all contact information associated with a deal, which in turn provides RCFX with as much data as possible to tie deal revenue to tracked conversion on the website for ROI analysis!

This also provided a repeatable solution for all brands using SingleOps, so their team can continue recommending the system as their preferred CRM without any negative revenue reporting impacts!

Achievement

We refined the data upload process across multiple brands, improving data accuracy and enabling us to associate additional digital touchpoints with offline deals, resulting in more transparent revenue reporting by channel.

Snippet/Screenshot/Link

Screenshot of optimized prompt – used each month to clean up files for each brand’s SingleOps export