# Best Practices ## Recommended setup


Use the Calendars entity first	Before setting up an Events data flow, run the "List of my calendars" entity to get all your calendar IDs and names. This makes it much easier to pick the right calendar when configuring your Events source.
Set meaningful date ranges	Always set both a start and end date for Events and Free/Busy reports. Leaving these open-ended can pull unexpected results. For ongoing reporting, use a rolling window that aligns with your reporting cadence — like the current month or current quarter.
Use Append mode to build history	Since Google Calendar only allows pulling data from the last 4 weeks, enable Append mode in your destination to accumulate a historical record over time. Each scheduled run will add new rows without overwriting past data.
Combine multiple calendars with Append transformation	If you need events from several calendars in one dataset, add multiple sources to the same data flow and use the Append transformation. This is cleaner than maintaining separate data flows for each calendar.

## Data refresh and scheduling


Match refresh frequency to your use case	For live scheduling dashboards, refresh every hour or every few hours. For weekly time-tracking reports, a daily refresh is sufficient. Avoid over-refreshing if your date range is narrow — you'll pull the same data repeatedly.
Use "Updated since" for incremental runs	The "Updated since" parameter on the Events entity lets you pull only events modified after a specific date. This is useful for catching last-minute changes like rescheduled or cancelled meetings without re-pulling your entire date range.

## Performance optimization


Keep date windows tight	Pulling 4 weeks of events from a busy calendar can return thousands of rows. Narrow your date range to what you actually need — this speeds up runs and avoids hitting row limits on lower-tier plans.
Filter empty rows at the source	Use advanced filters to exclude events where key fields like "summary" are empty. This prevents blank rows from cluttering your destination and keeps downstream formulas and charts clean.

## Common pitfalls {% hint style="danger" %} **Recurring events may show incorrect dates.** The date returned for a recurring event is often the original creation date, not the actual occurrence within your date range. Always verify recurring event data before using it in reports — and consider filtering by `updated` date rather than `start.dateTime` if accuracy is critical. {% endhint %} {% columns %} {% column %} **Do** * Use Append mode to work around the 4-week historical limit * Verify recurring event dates against Google Calendar directly * Apply filters to remove blank rows before they reach your destination * Use the `colorId` field to categorize events by type in your reports {% endcolumn %} {% column %} **Don't** * Expect to pull data older than 4 weeks in a single run * Use the `attendees` field in advanced filters — export it and filter downstream instead * Assume times are already in your local timezone without checking DST offsets * Overwrite your destination on every run if you need a historical record {% endcolumn %} {% endcolumns %}