Advanced Queries allows you to run unlimited, customizable queries of your Chartbeat data. Larger and more complex queries can take considerably longer to complete. In order to minimize wait time but still get the data you want, you may consider the following tips.
- For year-long reporting, run multiple shorter queries for 3 months at a time with the same metrics and dimensions.
- In including multiple metrics, consider removing uniques for longer date ranges as this considerably adds to wait time.
- Allow submitted queries to complete before creating new ones.
You can also configure your settings to receive email and/or Slack alerts when queries are complete.