Collect Data from Google Calendar

An Event Calendar can be populated automatically based on entries sourced from a Google Calendar. With this capability a User can maintain a set of planned events in a Google Calendar (for example, promotions or seasonal sales) and have them automatically appear in Metric Insights.  

PREREQUISITE:

This article assumes that you have already established connectivity with Google via Google Calendar Plugin that should serve as an Event Source.

RELATED ARTICLES:

For more information on Event Calendars and how they are applied to Metrics, refer to the Understanding Events article.

1. Open Event Calendars List

Access Admin > Reference Objects > Event Calendars

  1. [+ New Event Calendar]
  2. Name: Provide a descriptive name for the Calendar.
  3. Color: Select the color of the Calendar's marks on the Chart.
  4. Applies to list of: Assign this Event Calendar either to individual Metrics by adding them to the Event Calendar one by one, to Metrics of a specific Measure (for example, Sales, Profit, etc.), or to the Metrics belonging to certain Topics or Categories.
  5. Event Source: Select the Google Calendar plugin Data Source.
    • Trigger: Select the Data Collection Trigger that defines how often the Calendar will be updated.
    • Calendar: Choose the specific Calendar that includes the needed Events.
  6. [Save]

2. Configure the Data Collection

Scroll the Info tab of the Event Editor to the SQL query field.

  1. Input SQL command.
  2. [Validate]
  3. [Collect Data]
  4. [Save]

Once saved, the Event Calendar is ready to be used and associated with one or more Metrics. For more details, check the Associate an Event Calendar with Individual Metric article.

3. Review the Events

Open Events tab.