The Ultimate Guide to ARR book icon

The Ultimate
Guide to ARR

Table of Contents

All-in-one GTM analytics →

Surface the levers to grow faster with live ARR, pipeline, and more.
The Ultimate Guide to ARR book icon

The Ultimate
Guide to ARR

Table of Contents

All-in-one GTM analytics →

Surface the levers to grow faster with live ARR, pipeline, and more.

The Padded ARR table

  • By
  • Headshot of Chris Burgner Chris Burgner

    Headshot of Chris Burgner Chris Burgner

    12+ years of experience, most recently as a Director of Finance at Intercom.

    LinkedIn

Next, join the Date and Clean ARR tables together where the dates from the Date table are between the primary object’s start and end dates. We call this the Padded ARR table.

Here’s what the logic looks like:

FROM date_table d
LEFT JOIN clean_arr_table c ON d.date BETWEEN c.period_start_date_clean AND c.period_end_date_clean
Example SQL to join the date table with the clean table for ARR reporting

The end result returns a record each date the primary object was active. Extrapolating this across all customers makes it possible to pull ARR on any date.

An example table with output for a padded ARR table.
The Padded ARR table now reports ARR on each day

Next topic

Final ARR Table