Hey @Rob Craig, we use BigQuery as our data warehouse and Tableau for data visualization. Most of the visualizations we have tries to answer mainly two questions that we refer to as conversion and journey.
Conversion: We usually try to measure the # of people exposed to an opportunity vs % of people who performed the event
Journey: For those who converted, how did they get there?
These are simple questions, but very hard to answer.
What metrics do you have on your Looker report and how would you describe your experience with the Segment data warehouse to build the visualization?
Hey @Rob Craig,
We utilize a combination of Google BigQuery and Looker Studio. While we mostly rely on data from our internal database, Segment events play a crucial role when we need a more granular approach. For instance, we'll use transaction data from the database, but we'll employ data from Segment events for funnel visualization. Another useful aspect of Segment events is their collection of system/browser data with each event, which we use for attribution and segmentation in our models.