twitter_ad_impressions
4 rows where "updated_at" is on date 2021-02-22 sorted by advertiser_id
This data as json, CSV (advanced)
Suggested facets: impression_time (date)
created_at (date) ✖
id | created_at | updated_at | deleted_at | device_info_id | display_location | promoted_tweet_id | advertiser_id ▼ | impression_time |
---|---|---|---|---|---|---|---|---|
1 | 2021-02-22 22:06:08.842931+03:00 | 2021-02-22 22:06:08.842931+03:00 | 1 1 | TimelineHome | 1324737045659553793 1324737045659553793 | @aliexpress 1 | 2020-11-09 08:42:16+00:00 | |
2 | 2021-02-22 22:06:08.842931+03:00 | 2021-02-22 22:06:08.842931+03:00 | 1 1 | TimelineHome | 1320729353219616769 1320729353219616769 | 6 | 2020-11-09 08:43:47+00:00 | |
3 | 2021-02-22 22:06:08.842931+03:00 | 2021-02-22 22:06:08.842931+03:00 | 1 1 | TimelineHome | 1318971783182225414 1318971783182225414 | 18 | 2020-11-09 08:42:41+00:00 | |
4 | 2021-02-22 22:06:08.842931+03:00 | 2021-02-22 22:06:08.842931+03:00 | 1 1 | TimelineHome | 1302968378961858560 1302968378961858560 | 30 | 2020-11-09 08:42:33+00:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `twitter_ad_impressions` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`device_info_id` integer,`display_location` text,`promoted_tweet_id` integer,`advertiser_id` integer,`impression_time` datetime UNIQUE,PRIMARY KEY (`id`),CONSTRAINT `fk_twitter_ad_impressions_device_info` FOREIGN KEY (`device_info_id`) REFERENCES `twitter_device_infos`(`id`),CONSTRAINT `fk_twitter_ad_impressions_promoted_tweet` FOREIGN KEY (`promoted_tweet_id`) REFERENCES `twitter_tweets`(`id`),CONSTRAINT `fk_twitter_ad_impressions_advertiser` FOREIGN KEY (`advertiser_id`) REFERENCES `twitter_advertisers`(`id`)); CREATE INDEX `idx_twitter_ad_impressions_deleted_at` ON `twitter_ad_impressions`(`deleted_at`);