In Adobe Illustrator, a custom funnel was designed. With the Domo Illustrator plugin, the funnel design was uploaded into the client’s Domo instance.
Next, the client’s data was connected using the Google Analytics, CSV and MYSQL connectors. A custom SQL query pulled in the relevant data periodically.
To connect the data together and transform the data appropriately, Domo’s Magic ETL function was used.
Using a Domo Card, the transformed data was filtered and then pulled in.
The business has an automatic, at a glance, view of business performance in Real-Time, each week and each month. The view compares the changes month over month and week over week. An 'at a glance' card provides an overall view and also by State.
The presentation of the information is completely automated.