Smoke Alert Fire Safety has a few different sources of revenue and needed a way to report on each separately so they can better understand where their revenue is really coming from.
We had to complete a few steps to get this up and running:
Step One: We created a custom Quickbooks Online integration (now available for all clients on a Foundation plan) to pull in open and paid invoices. Since QuickBook’s API doesn’t send the invoice’s status, we had to get a little creative with the mapping we used.
We also used the C360FX Deal’s business_unit field to record the service location. Since Quickbooks doesn’t have a native way to store the location each person was serviced by, we determined it based on the contact’s zipcode.
Step Two: Standard WooCommerce Integration – no explanation needed here
Step Three: I created a separate Looker report for service revenue and online revenue.
To only see data for the service report, I filtered out ingestion data as well as open and closed lost deals. I filtered to only pull in deals with a close date from the last month, and then filtered to only see the appropriate location’s data using the business_unit field.
To only see data for the online revenue reporting, I filtered to only Closed Won ingestion deals with a close date from the last month.
Monthly reporting on offline and online sales data using IntegrationsFX data & Looker