NEW: Heap for mobile. Track every interaction, on every platform.

Learn more
skip to content
Loading...
    • The Digital Insights Platform Transform your digital experience
    • How Heap Works A video guide
    • How Heap Compares Heap vs. competitors
    • The Future of Insights A comic book guide
  • Data Insights

    • Session Replay Complete context with a single click
    • Illuminate Data science that pinpoints unknown friction
    • Journeys Visual maps of all user flows

    Data Analysis

    • Segments User cohorts for actionable insights
    • Dashboards Share insights on critical metrics
    • Charts Analyze everything about your users
    • Playbooks Plug-and-play templates and analyses

    Data Foundation

    • Capture Automatic event tracking and apis
    • Mobile Track and analyze your users across devices
    • Enrichment Add context to your data
    • Integrations Connect bi-directionally to other tools

    Data Management

    • Governance Keep data clean and trusted
    • Security & Privacy Security and compliance made simple
    • Infrastructure How we build for scale
    • Heap Connect Send Heap data directly to your warehouse
  • Solutions

    • Funnel Optimization Improve conversion in user flows
    • Product Adoption Maximize adoption across your site
    • User Behavior Understand what your users do
    • Product Led Growth Manage PLG with data

    Industries

    • SaaS Easily improve acquisition, retention, and expansion
    • eCommerce Increase purchases and order value
    • Financial Services Raise share of wallet and LTV

    Heap For Teams

    • Product Teams Optimize product activation, conversion and retention
    • Marketing Teams Optimize acquisition performance and costs
    • Data Teams Optimize behavioral data without code
  • Pricing
  • Support

    • Heap University Video Tutorials
    • Help Center How to use Heap
    • Heap Plays Tactical how-to guides
    • Heap Updates
    • Professional Services

    Resources

    • Blog A community for digital builders
    • Content Library Ebooks, whitepapers, videos, guides
    • Press News from and about Heap
    • Webinars & Events Virtual and live events
    • Careers Join us

    Ecosystem

    • Customer Community Join the conversation
    • Partners Technology and Solutions Partners
    • Developers
    • Customers Over 8,000 successful companies
  • Free TrialRequest Demo
  • Log In
  • Free Trial
  • Request Demo
  • Log In

All Blogs

Product Insights

Heap and Looker Partner to Make Data Collection Painless

Erin Franz
February 25, 20163 min read
  • Facebook
  • Twitter
  • LinkedIn
Heap

Starting today, we’re excited to announce a new Looker for Heap SQL Block. With Looker and Heap, anyone can answer essential questions that drive growth like user engagement, attribution and application performance. Heap makes collecting data on web or mobile activity painless, and Looker for Heap SQL makes deploying a BI solution on top of the resulting data just as easy to deploy across an entire organization.

What is Heap SQL?

Web and mobile analytics can provide meaningful insights to any modern organization. Heap automatically captures user actions—clicks, taps, gestures, form submissions, page views—and allows you to add any additional custom properties you’d like without even having to touch code. What makes Heap unique is that as your analytics’ requirements continue to grow and change with your business and you add new events to track – these events are automatically updated historically, so you have a full view of the new event’s performance over time. The events defined in Heap can provide insights into user behavior, performance trends of key metrics, and retention data valuable for any website or application.

Heap recently launched Heap SQL, which provides retroactive data access in a managed Redshift data warehouse to all of these automatically defined and custom events. Users have direct SQL access to define any reporting or analysis they’d like. And as you make changes to your event definitions in Heap, these are reflected in your Redshift data warehouse too – so historical analysis is just as accurate as you need it to be.

Looker for Heap

Similar to Heap’s philosophy, at Looker, we know that requirements change over time for a growing and evolving business—and an analytics solution needs to keep up with new requests while still maintaining a centralized set of data definitions across an organization.

Looker’s LookML modeling layer is designed to easily accommodate modifications and additions, since it’s maintained in a version controlled repository that provides data transformation at time of query, not ahead of time. A data team can create and modify metrics for an entire organization just by modifying a few lines of LookML. Additionally what this means for reporting and analysis is that it’s curated directly from the source—the Redshift data warehouse—such data doesn’t have to be pre-aggregated and row level granularity can still be accessed.

Looker Blocks for Heap creates a starting point to get the most out of your Heap data with Looker. Metrics to explore users, events, and sessions are included in the LookML specifically for Heap SQL’s data in Redshift. These definitions can be directly utilized by any user in Looker’s Explore interface to create custom ad-hoc reports and analysis, even without any knowledge of SQL. We’ve highlighted some cool things you can do with Looker Blocks for Heap here:

Custom Reporting and Analysis for Sessions

blog-heap-partner-1

The holistic view of a user’s visit to a website or application can provide indicators of performance and user behavior. With Looker and Heap SQL, you can explore metrics like:

  • Session duration

  • Events per session

  • New versus returning user sessions

  • Average sessions per user

And you can slice and segment these metrics however you’d like, for instance by:

  • Referrer

  • Source medium

  • Device type

  • Region

This flexibility allows you to explore your application’s data to find limitless insights into user behavior and key metric performance.

Funnel Explorer

blog-heap-partner-2

Looker Blocks for Heap includes a Custom Conversion Funnel, so you can see conversion metrics for any combination of events you’d like. These can be filtered and segmented by any session metric. Trending conversion rates over time are useful to observe performance for any step of the funnel.

User Retention Analysis

bloh-heap-partner-3

Observe how segments of customers are returning over time, based on metrics like first visit. Filter on other user metrics like latest session, lifetime session count, and duration of time on the application to dig deeper into your retention analysis.

Try Looker and Heap

Refer to Looker’s discourse page for more details, or access the Heap Block by reaching out to your assigned Looker analyst or via a Looker trial. For a free trial of Heap, simply sign up here or reach out to sales@heapanalytics.com for information about Heap SQL.This article was originally published on Looker’s blog by Erin Franz, Alliances at Looker.

Erin Franz

Was this helpful?
PreviousNext

Related Stories

See All

  • Heap.io

    Data Stories

    Celebrating H&R Block as the inaugural winner of the Digital Innovator Award

    March 22, 2023

  • Heap.io

    Product Updates

    Introducing Heap for mobile: see Everything, Everywhere all at once

    March 14, 2023

  • Heap.io

    Data Stories

    How I shipped a mobile app without tracking and bad things™ happened

    March 15, 2023

Subscribe

Sign up to stay on top of the latest posts.

Better insights. Faster.

Request Demo
  • Platform
  • Capture
  • Enrichment
  • Integrations
  • Governance
  • Security & Privacy
  • Infrastructure
  • Illuminate
  • Segments
  • Charts
  • Dashboards
  • Playbooks
  • Use Cases
  • Funnel Optimization
  • Product Adoption
  • User Behavior
  • Product Led Growth
  • Customer 360
  • SaaS
  • eCommerce
  • Financial Services
  • Why Heap
  • The Digital Insights Platform
  • How Heap Works
  • How Heap Compares
  • The Future of Insights
  • Resources
  • Blog
  • Content Library
  • Events
  • Topics
  • Heap University
  • Community
  • Professional Services
  • Company
  • About
  • Partners
  • Press
  • Careers
  • Customers
  • Support
  • Request Demo
  • Help Center
  • Contact Us
  • Pricing
  • Social
  • Twitter
  • Facebook
  • LinkedIn
  • YouTube

© 2023 Heap Inc. All Rights Reserved.

  • Legal
  • Privacy Policy
  • Status
  • Trust