Report Builder
Create custom reports with SQL queries
Query Builder
Available Tables
Projects
projects Transactions
transactions KDP Raw Data
kdp_raw_data Google Play Raw Data
play_raw_data Draft2Digital Raw Data
d2d_raw_data Authors
authors Publishers
publishers Aggregators
aggregators Quick Tips:
- Use date(field, 'unixepoch') for timestamp fields
- JOIN tables using their ID relationships
- Use LIMIT to avoid large result sets
- Test queries before saving