Important Notes

Discrepancies with the Fairing reporting UI

If you are experiencing discrepancies between the raw extracted Fairing data and the numbers reported in the Fairing user interface, it may be due to the following:

1. Extracted Fairing data uses the datetime of the response submission — not the datetime of the order. The event_at date dimension in the extracted Fairing data represents the time that the response was submitted to Fairing. The Fairing reporting interface, on the other hand, reports results based on the datetime of the order. These will be different if there is a lag between the order being placed and the Fairing result being recorded.

2. The Fairing event_at dimension is in UTC. The event_at date dimension in the extracted Fairing data is in the UTC timezone. This differs from the Fairing reporting interface, which will display data based on the order datetime in the time zone you specify in your Fairing app account settings