Attribute purchases with Looker and Snowflake

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 Segment event 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

• Segment

• Facebook and/or Google Ads

• Snowflake

• Looker