Attribute purchases with Looker and Snowflake

Marketing Analytics Advanced
Measure impact on revenue growth in minutes by building your own attribution dashboard using Looker to pre-model your Segment data in Snowflake.
What do you need?
  • Segment Source
  • Facebook Lead Ads
  • Looker
  • Snowflake
Attribute your ad spend with Segment
Collect data once with Segment and send it any tool you use. No more tedious integrations. No more engineering resources wasted.
Start with Segment

You’re investing in user acquisition, so it’s critical to ensure you’re generating a return on your investment. Beyond just measuring impressions and clicks, you need to measure impact on revenue growth.

Using Segment with a data warehouse and business intelligence solution enables you to build revenue attribution models. But rather than building it yourself from scratch, this recipe enables you to launch a revenue attribution dashboard using the Marketing Attribution by Segment Looker Block that pre-models your Segment data in Snowflake. Then you’re live in minutes, not weeks. You can then modify the dashboard to fit your unique business needs. Learn more.

How this works

  • Connect Segment and Snowflake to sync your website

    page calls as well as events like Product Viewed, Product Added, and Order Completed.

  • Use Segment Sources to pull the Facebook campaigns and Google Ads campaigns data and send to Snowflake.

  • The Marketing Attribution by Segment Looker Block is pre-built LookML (their proprietary coding language, similar to SQL) that links the datasets of Segment’s standard schema. It links user-level events to campaigns based on UTM parameters via first touch or last touch attribution methodology.

Steps to get started

  • Configure event tracking with Segmentevent tracking spec here

  • Configure Facebook and/or Google Ads sources via Segment.

  • Route events, Facebook campaign, and Google campaign data to Snowflake

  • Connect Looker to your Snowflake database

  • Implement the Marketing Attribution by Segment Looker Block from their directory. The directions provide a dashboard with minimal customization.

  • Log in to your dashboard!

Tools you need