Integrating Segment with Data Warehouse/Visualization Tools

  • 4 April 2024
  • 2 replies
  • 72 views
Rob Craig
Rank
Badge

Hey folks, sharing a discussion that kicked off in this thread about integrating Segment events into a data warehouse + bringing those events into data visualization tools. Sharing in case the conversation is helpful for others:

At Wave, our team is just starting to tap into the potential of Segment events in our Redshift data warehouse - since we brought them into the warehouse a couple of month ago.

We use Looker as our data visualization platform so there’s an added layer of complexity bringing Segment events into that platform in a way that is properly modelled and ready for presentation to stakeholders.

Would love to hear of any other experiences others have had bringing Segment data into your warehouse and data visualization/dashboarding tools.

2 replies

Andrew Ferreira
Rank
Userlevel 1
Badge

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? 

AF
Denys Tkalich
Rank
Badge

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.

Reply


Terms & Conditions