twitter_ad_impressions
1 row where advertiser_id = 1
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date), impression_time (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 |
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`);