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.
If you're still experiencing issues, please let us know at firstname.lastname@example.org.