Skip to content

Calendars

A calendar is a list of events: campaigns, public holidays, releases, incidents… Datama lays them over your KPIs, so you can see which events go along with a variation.

For example:

  • retail: paydays and Black Friday against conversion and revenue;
  • travel: school holidays and long weekends against bookings;
  • SaaS: product releases against usage and support tickets.

Once a calendar exists, enable it in the analysis: see Dates and calendar.

A calendar is a table with one row per event.

Field Required Content
Start date Yes When the event starts.
Event name Yes A short label.
End date No When the event ends. Empty: a one-day event.
Type No A category, for example Campaign, Public holiday, Launch.
Description No More context on the event.
Scope No The segment the event applies to, written Column=Value, for example Country=France.

The column of the scope must have the same name as in the dataset you analyse. Separate several scopes with commas: Country=France,Device=Mobile. When you filter on a segment, only the events of that segment are shown. The scope is also used by the event interest of Compare.

Web app

Open My account › Calendars, also in the side menu of the home page.

Click Connect Calendar, then:

  1. Select your data source: a file, a Google Sheets spreadsheet, a warehouse… The source must follow the structure above, except Google Analytics Annotation and Calendar, which already have the fields.
  2. Configure your source: account, URL, project or query, depending on the source. A preview of the data shows on the right.
  3. Map the fields: match each field of the calendar with a column of the source.
  4. Schedule a calendar refresh (optional): how often the calendar is reloaded in the stories that use it.
  5. Overview: check the settings, name the calendar, and save.

You can edit the connection at any time.

The Calendar source takes a .ics URL, a public Google Calendar, or an Outlook URL, or one of the calendars suggested by Datama. For a private Google Calendar, use its secret address in iCal format, from the settings of the calendar in Google Calendar.

Create Manual Calendar lets you type the events directly in the Datama calendar interface.

Connect the calendar to your data in the Datama block of the data layer, or select it in the Calendar panel of the analysis.

If your dataset already holds events, choose Current data in the Calendar panel, then map the event fields to its columns.

To build one, make a calendar table with the date as key, and left-join it to your KPI table: each row of KPIs then carries the event of its date, if any.

Tableau, Power BI

In Tableau and Power BI, you can add events from the visual:

  • in Compare, right-click the Start or End bar, then Add event;
  • in Detect, right-click a point, then Add event.

Fill in the fields of the event. Events are saved in a calendar named Calendar from Tableau or Calendar from Power BI, which you can use in other stories.