Aggregated Data Table Structure

1. Table Columns

Field	Type	Null	Key	Default	Extra
sparkle_id	bigint	NO	PRI		auto_increment
parent_companies-name	varchar(44)	YES
parent_companies-qid	varchar(18)	YES
companies-child_company_name	varchar(30)	YES
companies-qid	varchar(18)	YES
companies-id	bigint	YES
type	varchar(16)	YES
item_company_id	bigint	YES
ticket_id	double	YES
action_at	datetime	YES
action_at_date_in_tz	datetime	YES
scheduled_at	text	YES
scheduled_at_date_in_tz	text	YES
created_at	datetime	YES
created_at_date_in_tz	datetime	YES
item_start_at	datetime	YES
item_start_at_date_in_tz	datetime	YES
adjustment_id	double	YES
item_id	double	YES
item_type	varchar(20)	YES
item_label	varchar(62)	YES
item_class	varchar(62)	YES
item_quantity	text	YES
item_employee_id	double	YES
item_employee_name	varchar(24)	YES
item_client_id	double	YES
item_client_name	varchar(36)	YES
item_client_email	varchar(70)	YES
item_client_mobile_phone	varchar(28)	YES
item_client_home_phone	varchar(28)	YES
item_client_work_phone	varchar(28)	YES
item_child_id	double	YES
item_child_label	varchar(88)	YES
item_child_secondary_label	varchar(66)	YES
item_child_is_deceased	varchar(10)	YES
source	varchar(16)	YES
appt_status	text	YES
service_duration	text	YES
appt_id	text	YES
days_since_last_appointment	text	YES
client_appointment_rank	text	YES
item_amount	text	YES
item_amount_before_discount	text	YES
discount_amount	double	YES
product_cost_amount	text	YES
sub_item_id	double	YES
sub_item_type	varchar(36)	YES
sub_item_label	varchar(74)	YES
sub_item_class	text	YES
category_id	text	YES
category_type	text	YES
category_label	text	YES
category_class	text	YES
in_membership	varchar(8)	YES
in_package	varchar(10)	YES
usage_amount	text	YES
usage_original_amount	text	YES
gift_cards_prepaid_amount	text	YES
memberships_prepaid_amount	text	YES
packages_prepaid_amount	text	YES
gift_cards_prepaid_amount_v2	text	YES
item_return_id	text	YES
refund_amount	text	YES
item_edit_id	double	YES
edit_amount	text	YES
edit_amount_before_discount	text	YES
item_tax_id	text	YES
tax_amount	text	YES
payment_item_id	text	YES
payment_id	text	YES
payment_type	text	YES
payment_label	text	YES
payment_class	text	YES
payment_amount	text	YES
payment_amount_collected	text	YES
payment_hold_amount	text	YES
payment_deposit	text	YES
payment_charged_at	text	YES
payment_status	text	YES
time_zone	datetime	YES
location_id	double	YES
ticket_uuid	varchar(16)	YES
ticket_raw_status	double	YES
ticket_status	varchar(12)	YES
ticket_closed_at	datetime	YES
ticket_closed_at_date_in_tz	datetime	YES
locations-qid	varchar(18)	YES
location_nickname	varchar(30)	YES
location_store_id	varchar(14)	YES
location_entity_id	text	YES
location_street_address	varchar(48)	YES
location_street_address_2	varchar(18)	YES
location_zip_code	bigint	YES
location_city	varchar(30)	YES
location_state	varchar(4)	YES
location_time_zone	datetime	YES
location_resource_count	text	YES
employees-qid	varchar(18)	YES
employee_name	varchar(26)	YES
ticket_client_id	double	YES
ticket_client_walk_in	double	YES
ticket_client_name	varchar(34)	YES
ticket_client_email	varchar(70)	YES
client_visit_rank	double	YES
is_member	varchar(10)	YES
import_date	date	NO	MUL
import_timestamp	timestamp	YES	MUL	CURRENT_TIMESTAMP	DEFAULT_GENERATED

2. Sample Data (5 rows)

sparkle_id	parent_companies-name	parent_companies-qid	companies-child_company_name	companies-qid	companies-id	type	item_company_id	ticket_id	action_at	action_at_date_in_tz	scheduled_at	scheduled_at_date_in_tz	created_at	created_at_date_in_tz	item_start_at	item_start_at_date_in_tz	adjustment_id	item_id	item_type	item_label	item_class	item_quantity	item_employee_id	item_employee_name	item_client_id	item_client_name	item_client_email	item_client_mobile_phone	item_client_home_phone	item_client_work_phone	item_child_id	item_child_label	item_child_secondary_label	item_child_is_deceased	source	appt_status	service_duration	appt_id	days_since_last_appointment	client_appointment_rank	item_amount	item_amount_before_discount	discount_amount	product_cost_amount	sub_item_id	sub_item_type	sub_item_label	sub_item_class	category_id	category_type	category_label	category_class	in_membership	in_package	usage_amount	usage_original_amount	memberships_prepaid_amount	packages_prepaid_amount	gift_cards_prepaid_amount_v2	item_return_id	refund_amount	item_edit_id	edit_amount	edit_amount_before_discount	item_tax_id	tax_amount	payment_item_id	payment_id	payment_type	payment_label	payment_class	payment_amount	payment_amount_collected	payment_hold_amount	payment_deposit	payment_charged_at	payment_status	time_zone	location_id	ticket_uuid	ticket_raw_status	ticket_status	ticket_closed_at	ticket_closed_at_date_in_tz	locations-qid	location_nickname	location_store_id	location_entity_id	location_street_address	location_street_address_2	location_zip_code	location_city	location_state	location_time_zone	location_resource_count	employees-qid	employee_name	ticket_client_id	ticket_client_walk_in	ticket_client_name	ticket_client_email	client_visit_rank	is_member	import_date	import_timestamp
3367	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	service	143134	43446270	2025-08-12 01:24:21	2025-08-11 00:00:00	2025-08-11 22:30:00	2025-08-11 00:00:00	2025-08-08 21:12:30	2025-08-08 00:00:00	NULL	NULL	132742069	97979183	Appointment	Unlimited	SlotVariation	1.00	306655	Kwatrelle B.	21843934	Beth Bliss	Bebebliss22@gmail.com	(480) 273-0978	(480) 278-0099	NULL	3051770	Angel	Old English Sheepdog	False	in_store	completed	60.0	65507220.0	17.0	12.0	115.0	115.0	NULL	NULL	NULL	NULL	NULL	NULL	263953.0	Service Category	Members	Deal	True	False	115.0	0.0	NULL	NULL	NULL	NULL	NULL	NULL	-115.0	-115.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-05 18:13:49	158462	RJUON3LO	1	closed	2025-08-12 01:24:21	2025-08-11 00:00:00	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-06-05 18:13:49	NULL	qid306655	Kwatrelle B.	21843934	0	BethBliss	Bebebliss22@gmail.com	12	True	2026-06-05	2026-06-05 11:13:50
5761	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	service	143134	NULL	NULL	NULL	2025-08-11 18:30:00	2025-08-11 00:00:00	2025-05-11 20:30:41	2025-05-11 00:00:00	NULL	NULL	NULL	93829538	Appointment	Trim	SlotVariation	1.00	NULL	NULL	21704080	Hamid Shojaee	Hamid@shojaee.com	(602) 295-5216	NULL	NULL	3008697	Biscuit	Goldendoodle	False	in_store	completed	NULL	62659531.0	0.0	13.0	35.0	35.0	NULL	NULL	NULL	NULL	NULL	NULL	263952.0	Service Category	Add-ons	Deal	False	False	0.0	0.0	NULL	NULL	NULL	NULL	NULL	NULL	-35.0	-35.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-05 18:13:53	158462	NULL	NULL	NULL	NULL	NULL	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-06-05 18:13:53	NULL	NULL	In-House Sale	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-05	2026-06-05 11:13:54
6766	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	service	143134	43365361	2025-08-11 17:55:53	2025-08-11 00:00:00	2025-08-11 17:30:00	2025-08-11 00:00:00	2025-08-08 18:56:04	2025-08-08 00:00:00	NULL	NULL	132405012	97971813	Appointment	The Essentials	SlotVariation	1.00	300465	Megan K.	23096008	Alison Collins	alison@collinsaz.com	(602) 743-4675	NULL	NULL	3129200	Riley	Boston Terrier	False	online	completed	26.0	65502418.0	35.0	4.0	55.0	55.0	NULL	NULL	NULL	NULL	NULL	NULL	263953.0	Service Category	Members	Deal	True	False	55.0	55.0	NULL	NULL	NULL	NULL	NULL	NULL	-55.0	-55.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-05 18:13:55	158462	G38OS4CI	1	closed	2025-08-11 17:55:53	2025-08-11 00:00:00	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-06-05 18:13:55	NULL	qid300465	Megan K.	23096008	0	AlisonCollins	alison@collinsaz.com	4	True	2026-06-05	2026-06-05 11:13:56
6767	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	service	143134	43365361	2025-08-11 17:55:53	2025-08-11 00:00:00	2025-08-11 17:30:00	2025-08-11 00:00:00	2025-08-08 18:56:04	2025-08-08 00:00:00	NULL	NULL	132405013	97971814	Appointment	Plaque Reduction Treatment	SlotVariation	1.00	300465	Megan K.	23096008	Alison Collins	alison@collinsaz.com	(602) 743-4675	NULL	NULL	3129200	Riley	Boston Terrier	False	online	completed	0.0	65502418.0	35.0	4.0	12.0	15.0	NULL	NULL	NULL	NULL	NULL	NULL	263952.0	Service Category	Add-ons	Deal	False	False	0.0	0.0	NULL	NULL	NULL	NULL	NULL	NULL	-12.0	-15.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-05 18:13:55	158462	G38OS4CI	1	closed	2025-08-11 17:55:53	2025-08-11 00:00:00	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-06-05 18:13:55	NULL	qid300465	Megan K.	23096008	0	AlisonCollins	alison@collinsaz.com	4	True	2026-06-05	2026-06-05 11:13:56
8509	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	service	143134	43302705	NULL	NULL	2025-08-11 16:15:00	2025-08-11 00:00:00	2025-08-06 15:15:43	2025-08-06 00:00:00	NULL	NULL	132177038	97866919	Appointment	The Essentials (Non-Member)	SlotVariation	1.00	300465	Megan K.	23696384	Cale Connors	caleconnors13@gmail.com	(816) 854-9380	NULL	NULL	3341528	Reid	Australian Shepherd	False	online	canceled_by_merchant	60.0	65434596.0	NULL	NULL	0.0	0.0	NULL	NULL	NULL	NULL	NULL	NULL	265356.0	Service Category	Non-Members	Deal	False	False	0.0	0.0	NULL	NULL	NULL	NULL	NULL	NULL	0.0	0.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-05 18:13:59	158462	J0RM4BCX	2	void	NULL	NULL	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-06-05 18:13:59	NULL	qid300465	Megan K.	23696384	0	CaleConnors	caleconnors13@gmail.com	NULL	NULL	2026-06-05	2026-06-05 11:14:00

3. Key Field Values

Unique values in 'appt_status':

completed: 209259 records
canceled_by_merchant: 19271 records
booked: 17535 records
canceled_by_consumer: 10774 records
confirmed: 1151 records
canceled_waiting: 406 records
no_show: 29 records

Unique values in 'payment_type':

Card: 89447 records
Cash: 85412 records

Unique values in 'item_child_label':

Lucy: 4442 records
Charlie: 4408 records
Luna: 3832 records
Daisy: 3715 records
Lola: 2670 records
Stella: 2647 records
Winston: 2282 records
Bella: 2260 records
Teddy: 2241 records
Rocky: 2177 records

Unique values in 'client_membership_status':

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'client_membership_status' in 'field list' in /home2/dataforsparkle/public_html/reports/explore-aggregated-table.php:70 Stack trace: #0 /home2/dataforsparkle/public_html/reports/explore-aggregated-table.php(70): mysqli_query(Object(mysqli), 'SELECT DISTINCT...') #1 {main} thrown in /home2/dataforsparkle/public_html/reports/explore-aggregated-table.php on line 70