<aside> ❗ Make sure you understand the concepts in Connecting to Data

</aside>

You can find an example for the different data source formats here: https://docs.google.com/spreadsheets/d/1RVntBrC1GkWoYY0qRQpm3H5vsa7y7mBe-BPQ7dZEIns

Basic Time-Series

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1376c4c2-381d-48e2-8b80-7c1a7830fb5a/Untitled.png

This is an example of the time-series format.

<aside> 🚨 Make sure that the values are actually formatted as Numbers, not Text.

</aside>

<aside> 🚨 Make sure that Google Sheets understands the Dates. Only then Causal can read them properly. The =ISDATE() function in Google Sheets can be used to check that.

</aside>

With Categories

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/85d25338-5ca3-40a4-9874-55c76e24b308/Untitled.png

This is an example of the time-series format with categories included. You can include several categories in your Google Sheet.

With Linked Categories

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/2fa43ec8-fc5d-4acb-897c-b595abeb3408/Untitled.png