Advanced Queries allows you to run unlimited, customizable queries on up to two years 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. Thank you for your patience while we work to improve the product experience.
If you're still experiencing issues, please let us know at firstname.lastname@example.org.