google_activity_details
7 rows where name = "From Google Ads" sorted by created_at descending
This data as json, CSV (advanced)
Suggested facets: updated_at (date)
created_at (date) ✖
id | created_at ▲ | updated_at | deleted_at | action_id | name |
---|---|---|---|---|---|
26 | 2021-03-02 19:31:23.612424+03:00 | 2021-03-02 19:31:23.612424+03:00 | Visited https://www.youtube.com/watch?v=YVYDz_coSfY 26715 | From Google Ads | |
27 | 2021-03-02 19:31:23.612424+03:00 | 2021-03-02 19:31:23.612424+03:00 | Visited Explore the Entire World--from the Comfort of Quarantine--with 4K ... 26716 | From Google Ads | |
28 | 2021-03-02 19:31:23.612424+03:00 | 2021-03-02 19:31:23.612424+03:00 | Displayed Gmail ads 26717 | From Google Ads | |
29 | 2021-03-02 19:31:23.612424+03:00 | 2021-03-02 19:31:23.612424+03:00 | Displayed Gmail ads 26718 | From Google Ads | |
30 | 2021-03-02 19:31:23.612424+03:00 | 2021-03-02 19:31:23.612424+03:00 | Displayed Gmail ads 26719 | From Google Ads | |
31 | 2021-03-02 19:31:23.612424+03:00 | 2021-03-02 19:31:23.612424+03:00 | Used com.chess.iphone 26720 | From Google Ads | |
32 | 2021-03-02 19:31:23.612424+03:00 | 2021-03-02 19:31:23.612424+03:00 | Displayed Gmail ads 26721 | From Google Ads |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `google_activity_details` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`action_id` integer,`name` text,PRIMARY KEY (`id`),CONSTRAINT `fk_google_activity_details_action` FOREIGN KEY (`action_id`) REFERENCES `google_activity`(`id`),CONSTRAINT `fk_google_activity_details` FOREIGN KEY (`action_id`) REFERENCES `google_activity`(`id`)); CREATE INDEX `idx_google_activity_details_deleted_at` ON `google_activity_details`(`deleted_at`);