I'm not even remotely kidding when I say the cause of this is because Amazon sharded. Basically, the underlying data that populates the Amazon console, the manually exported reports from Amazon, and the API (your database) is separated into data... (More)
reportingDefinitions:Concept0 followers0 questions1 post
Do you have questions about reporting?
Log in to ask questions about reporting publicly or anonymously.
If you'd like the raw data for a certain time range, you could pull the full period of data and configure the comparisons via the report/table afterward. The below MySQL query pulls the last 3 months plus whatever days are... (More)
Here are the Where clauses to pull data for a specific time range via a MySQL query:
Last 30 days (uses "31" since we pull previous day data, not current day):
where DateTime BETWEEN CURDATE() - INTERVAL 31 DAY AND... (More)