BigQuery for Google Analytics App + Web: Get User Counts By Date Between Two Fixed Dates
Below BigQuery looks at extracting unique user counts using day parting between two fixed dates from a Google Analytics App + Web property.
SELECT event_date and user counts FROM ‘table-name.*’ goes through all the partitioned tables [by day] to pull the user counts.
WHERE event_date BETWEEN checks between two dates [All of August 2020] while ORDER BY event_date ASC sorts it in ascending order.
Query and Result below:
