The Ultimate Guide to ARR book icon

The Ultimate
Guide to ARR

Table of Contents

Lead in real-time →

Live sales and ARR in one connected spreadsheet—no exports required.
The Ultimate Guide to ARR book icon

The Ultimate
Guide to ARR

Table of Contents

Lead in real-time →

Live sales and ARR in one connected spreadsheet—no exports required.

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