Attribute Purchases to Facebook and Google campaigns with Looker and Snowflake

You’re investing in user acquisition, so it’s critical to ensure you’re generating 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 a 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:
Tools you need:
Connect Segment + Looker

Collect data once with Segment and send it any tool you use. No more tedious integrations. No more engineering resources wasted.

Create a free Segment workspace

How Looker works with Segment

Looker is a unified Platform for Data that delivers actionable business insights to every employee at the point of decision. Looker integrates data into the daily workflows of users to allow organizations to extract value from data at web scale. Over 1600 industry-leading and innovative companies such as Sony, Amazon, The Economist, IBM, Spotify, Etsy, Lyft and Kickstarter trust Looker to power their data-driven cultures. For more information, connect with us on LinkedIn, Twitter, Facebook and YouTube or visit looker.com.

Learn more →

How Snowflake works with Segment

Snowflake is the only data warehouse built for the cloud, enabling the data-driven enterprise with instant elasticity, secure data sharing and per-second pricing, across multiple clouds. Snowflake combines the power of data warehousing, the flexibility of big data platforms and the elasticity of the cloud at a fraction of the cost of traditional solutions. Snowflake: Your data, no limits. Find out more at snowflake.com.

Learn more →

Getting started is easy

Be up and running in minutes.

Request a demo Get a free account