Breadcrumbs

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

https://agencypmg.atlassian.net/wiki/s/-1529285079/6452/4c2832860aad97c77f44f8794b470d79af5ad2a7/_/images/icons/emoticons/check.png

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