Skip to main content
Skip table of contents

Calendars

Overview

Calendars connector for Fiscal and Promo calendars to enable consistent reporting across Alli. This Imports the Airtable connector (a collaborative platform that blends spreadsheet simplicity with database functionality) to load the data and retain the source type values, Fiscal Calendar, and Promo Calendar.

Vendor/Partner

Internal (but imports Airtable )

Version

v2.0

API Documentation

N/A (imports airtable Airtable API Docs)

Sunset Date

Channel(s)

Refresh Time (CST)

Default backfill

N/A

Alli Data Library

(tick)

Getting Started

image-20250911-175410.png

Fiscal Calendar Connector

image-20250911-175430.png

Promo Calendar Connector

To get started with the Calendars datasource ( Fiscal Calendar/ Promo Calendar), ensure you have the following:

  • Access to an Airtable Base

Required Authorization

  • Click the Request Access button to log in to your Airtable instance and assign which base you want to give Alli access to.

  • Standardize the Airtable Table/Report names as Fiscal Calendar/Promo Calendar as required.

image-20250911-180556.png

Airtable View

Define your Data

Fiscal Calendar Dimensions

Name

Description

date

Date

fiscal_year

Fiscal Year

fiscal_quarter

Fiscal Quarter

fiscal_month

Fiscal Month

fiscal_week

Fiscal Week

Additional columns can be customized

Promo Calendar Dimensions

Name

Description

start_date

Start of Promotion

end_date

End of Promotion

country

Country in which the promo was like

event

The Occasion or Theme of the promotion

promo_type

The category or mechanic of the offer

promo_channel

where or how the promotion is offered

promo_name

Name of the promo

promo_offer

contains the offer

client_readable_promo_name

The client-readable promo name

Additional columns can be customized

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.