1 of 1

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

start_time

description

credit_limit_local_micro

end_time

entity_status

io_header

currency

funded_amount_local_micro

created_at

type

able_to_fund

credit_remaining_local_micro

deleted

FUNDING_INSTRUMENT_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

funding_instrument_id ➤ FUNDING_INSTRUMENT_HISTORY

name

start_time

servable

daily_budget_amount_local_micro

end_time

duration_in_days

standard_delivery

total_budget_amount_local_micro

entity_status

frequency_cap

currency

created_at

deleted

CAMPAIGN_HISTORY ⇱

id 🔑

updated_at 🔑

name

business_name

timezone

timezone_switch_at

created_at

salt

business_id

approval_status�industry_type

deleted

ACCOUNT_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

tweet_id ➤ TWEET

entity_status

created_at

approval_status

deleted

PROMOTED_TWEET_HISTORY ⇱

id 🔑

updated_at 🔑

campaign_id ➤ CAMPAIGN_HISTORY

bid_type

advertiser_user_id

name

start_time

bid_amount_local_micro

automatically_select_bid

advertiser_domain

target_cpa_local_micro

primary_web_event_tag

charge_by

product_type

end_time

bid_unit

total_budget_amount_local_micro

objective

entity_status

optimization

currency

created_at

include_sentiment

creative_source

deleted

LINE_ITEM_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

account_media_id ➤ ACCOUNT_MEDIA_HISTORY

landing_url

serving_status

approval_status

deleted�created_at

MEDIA_CREATIVE_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

scheduled_tweet_id ➤ SCHEDULED_TWEET_HISTORY

tweet_id ➤ TWEET

entity_status

created_at

deleted

SCHEDULED_PROMOTED_TWEET_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

video_id ➤ VIDEO_HISTORY

media_url

creative_type

created_at�vast_url

deleted

ACCOUNT_MEDIA_HISTORY ⇱

campaign_id 🔑➤ CAMPAIGN_HISTORY.id

campaign_updated_at 🔑➤ CAMPAIGN_HISTORY.updated_at

index 🔑

reason_not_servable

CAMPAIGN_REASON_HISTORY ⇱

line_item_id 🔑➤ LINE_ITEM_HISTORY.id

line_item_updated_at 🔑➤ LINE_ITEM_HISTORY.updated_at

index 🔑

category

LINE_ITEM_CATEGORY_HISTORY ⇱

funding_instrument_id 🔑➤ FUNDING_INSTRUMENT_HISTORY.id

funding_instrument_updated_at 🔑➤ FUNDING_INSTRUMENT_HISTORY.updated_at

index 🔑

reason_not_able_to_fund

FUNDING_INSTRUMENT_REASON_HISTORY ⇱

line_item_id 🔑➤ LINE_ITEM_HISTORY.id

line_item_updated_at 🔑➤ LINE_ITEM_HISTORY.updated_at

index 🔑

placement

LINE_ITEM_PLACEMENT_HISTORY ⇱

tweet_id 🔑➤ TWEET

index 🔑

text

indices

TWEET_HASHTAG ⇱

tweet_id 🔑➤ TWEET

media_id 🔑

indices

media_url

media_url_https

url

display_url

expanded_url

type

TWEET_MEDIA ⇱

tweet_id 🔑 ➤ TWEET

index 🔑

url

expanded_url

display_url

indices

TWEET_URL ⇱

tweet_id 🔑 ➤ TWEET

id 🔑

screen_name

name

indices

TWEET_USER_MENTION ⇱

tweet_id 🔑➤ TWEET

index 🔑

text

indices

TWEET_SYMBOLS ⇱

account_id 🔑

date 🔑

segment 🔑

[metrics...]

ACCOUNT_[SEGMENTATION] ⇱

account_id 🔑

funding_instrument_id 🔑

date 🔑

segment 🔑

[metrics...]

FUNDING_INSTRUMENT_[SEGMENTATION] ⇱

account_id 🔑

campaign_history_id 🔑

date 🔑

segment 🔑

[metrics...]

CAMPAIGN_[SEGMENTATION] ⇱

account_id 🔑

line_item_id 🔑

date 🔑

segment 🔑

[metrics...]

LINE_ITEM_[SEGMENTATION] ⇱

account_id 🔑

promoted_tweet_id 🔑

date 🔑

segment 🔑

[metrics...]

PROMOTED_TWEET_[SEGMENTATION] ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

start_time

description

credit_limit_local_micro

end_time

entity_status

io_header

currency

funded_amount_local_micro

created_at

type

able_to_fund

credit_remaining_local_micro

deleted

FUNDING_INSTRUMENT_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

funding_instrument_id ➤ FUNDING_INSTRUMENT_HISTORY

name

start_time

servable

daily_budget_amount_local_micro

end_time

duration_in_days

standard_delivery

total_budget_amount_local_micro

entity_status

frequency_cap

currency

created_at

deleted

CAMPAIGN_HISTORY ⇱

id 🔑

updated_at 🔑

name

business_name

timezone

timezone_switch_at

created_at

salt

business_id

approval_status�industry_type

deleted

ACCOUNT_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

tweet_id ➤ TWEET

entity_status

created_at

approval_status

deleted

PROMOTED_TWEET_HISTORY ⇱

id 🔑

updated_at 🔑

campaign_id ➤ CAMPAIGN_HISTORY

bid_type

advertiser_user_id

name

start_time

bid_amount_local_micro

automatically_select_bid

advertiser_domain

target_cpa_local_micro

primary_web_event_tag

charge_by

product_type

end_time

bid_unit

total_budget_amount_local_micro

objective

entity_status

optimization

currency

created_at

include_sentiment

creative_source

deleted

LINE_ITEM_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

account_media_id ➤ ACCOUNT_MEDIA_HISTORY

landing_url

serving_status

approval_status

deleted�created_at

MEDIA_CREATIVE_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

scheduled_tweet_id ➤ SCHEDULED_TWEET_HISTORY

tweet_id ➤ TWEET

entity_status

created_at

deleted

SCHEDULED_PROMOTED_TWEET_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

video_id ➤ VIDEO_HISTORY

media_url

creative_type

created_at�vast_url

deleted

ACCOUNT_MEDIA_HISTORY ⇱

campaign_id 🔑➤ CAMPAIGN_HISTORY.id

campaign_updated_at 🔑➤ CAMPAIGN_HISTORY.updated_at

index 🔑

reason_not_servable

CAMPAIGN_REASON_HISTORY ⇱

line_item_id 🔑➤ LINE_ITEM_HISTORY.id

line_item_updated_at 🔑➤ LINE_ITEM_HISTORY.updated_at

index 🔑

category

LINE_ITEM_CATEGORY_HISTORY ⇱

funding_instrument_id 🔑➤ FUNDING_INSTRUMENT_HISTORY.id

funding_instrument_updated_at 🔑➤ FUNDING_INSTRUMENT_HISTORY.updated_at

index 🔑

reason_not_able_to_fund

FUNDING_INSTRUMENT_REASON_HISTORY ⇱

line_item_id 🔑➤ LINE_ITEM_HISTORY.id

line_item_updated_at 🔑➤ LINE_ITEM_HISTORY.updated_at

index 🔑

placement

LINE_ITEM_PLACEMENT_HISTORY ⇱

tweet_id 🔑➤ TWEET

index 🔑

text

indices

TWEET_HASHTAG ⇱

tweet_id 🔑➤ TWEET

media_id 🔑

indices

media_url

media_url_https

url

display_url

expanded_url

type

TWEET_MEDIA ⇱

tweet_id 🔑 ➤ TWEET

index 🔑

url

expanded_url

display_url

indices

TWEET_URL ⇱

tweet_id 🔑 ➤ TWEET

id 🔑

screen_name

name

indices

TWEET_USER_MENTION ⇱

tweet_id 🔑➤ TWEET

index 🔑

text

indices

TWEET_SYMBOLS ⇱

account_id 🔑

date 🔑

segment 🔑

[metrics...]

ACCOUNT_[SEGMENTATION] ⇱

account_id 🔑

funding_instrument_id 🔑

date 🔑

segment 🔑

[metrics...]

FUNDING_INSTRUMENT_[SEGMENTATION] ⇱

account_id 🔑

campaign_history_id 🔑

date 🔑

segment 🔑

[metrics...]

CAMPAIGN_[SEGMENTATION] ⇱

account_id 🔑

line_item_id 🔑

date 🔑

segment 🔑

[metrics...]

LINE_ITEM_[SEGMENTATION] ⇱

account_id 🔑

promoted_tweet_id 🔑

date 🔑

segment 🔑

[metrics...]

PROMOTED_TWEET_[SEGMENTATION] ⇱

funding_instrument_id 🔑

date/month 🔑

average _frequency

total_audience_reach

FUNDING_INSTRUMENT_[AGGREGATION] ⇱

id 🔑

updated_at 🔑

name

business_name

timezone

timezone_switch_at

created_at

salt

business_id

approval_status�industry_type

deleted

ACCOUNT_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

start_time

description

credit_limit_local_micro

end_time

entity_status

io_header

currency

funded_amount_local_micro

created_at

type

able_to_fund

credit_remaining_local_micro

deleted

FUNDING_INSTRUMENT_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

funding_instrument_id ➤ FUNDING_INSTRUMENT_HISTORY

name

start_time

servable

daily_budget_amount_local_micro

end_time

duration_in_days

standard_delivery

total_budget_amount_local_micro

budget_optimization

entity_status

frequency_cap

currency

created_at

deleted

CAMPAIGN_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

tweet_id ➤ TWEET

entity_status

created_at

approval_status

deleted

PROMOTED_TWEET_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

scheduled_tweet_id ➤ SCHEDULED_TWEET_HISTORY

tweet_id ➤ TWEET

created_at

deleted

SCHEDULED_PROMOTED_TWEET_HISTORY ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

account_media_id ➤ ACCOUNT_MEDIA_HISTORY

landing_url

serving_status

approval_status

deleted�created_at

MEDIA_CREATIVE_HISTORY ⇱

id 🔑

updated_at 🔑

campaign_id ➤ CAMPAIGN_HISTORY

bid_type

advertiser_user_id

name

start_time

bid_amount_local_micro

automatically_select_bid

advertiser_domain

target_cpa_local_micro

primary_web_event_tag

charge_by

product_type

end_time

bid_unit

total_budget_amount_local_micro

objective

entity_status

optimization

currency

created_at

include_sentiment

creative_source

deleted

LINE_ITEM_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

video_id ➤ VIDEO_HISTORY

media_url

creative_type

created_at�vast_url

deleted

ACCOUNT_MEDIA_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

tweet_id ➤ TWEET

card_uri

completed_at

text

user_id

scheduled_status

nullcast

created_at

scheduled_at

SCHEDULED_TWEET_HISTORY ⇱

id 🔑

updated_at 🔑

account_id ➤ ACCOUNT_HISTORY

name

googleplay_app_id

image_display_height

image_display_width

country_code

media_url

media_key

created_at

card_uri

app_cta

deleted

card_type

first_cta

first_cta_welcome_message_id

recipient_user_id

thank_you_text

first_cta_tweet

title

website_shortened_url

website_display_url

website_dest_url

website_title

website_url

video_poster_height�video_height

video_url

content_duration_seconds

video_owner_id

video_width

video_hls_url

video_poster_url

poster_media_url

video_poster_width

start_time

first_choice

second_choice

end_time

duration_in_minutes

​

CARD_HISTORY

id 🔑

name�account_id ➤ ACCOUNT_HISTORY

created_at

full_text

truncated

source

in_reply_to_status_id

in_reply_to_user_id

in_reply_to_screen_name

retweet_count

favorite_count

favorited

retweeted

lang�tweet_type�media_key�card_uri�geo_type

geo_coordinates

coordinates_type

coordinates_coordinates�followers�user_id

TWEET ⇱

media_key🔑�updated_at

tweeted

duration

name

file_name

media_url

media_category

created_at

media_status

media_type

deleted

original_width

original_height

poster_media_key

poster_media_url

MEDIA_LIBRARY ⇱

campaign_id 🔑➤ CAMPAIGN_HISTORY.id

campaign_updated_at 🔑➤ CAMPAIGN_HISTORY.updated_at

index 🔑

reason_not_servable

CAMPAIGN_REASON_HISTORY ⇱

funding_instrument_id 🔑➤ FUNDING_INSTRUMENT_HISTORY.id

funding_instrument_updated_at 🔑➤ FUNDING_INSTRUMENT_HISTORY.updated_at

index 🔑

reason_not_able_to_fund

FUNDING_INSTRUMENT_REASON_HISTORY ⇱

line_item_id 🔑➤ LINE_ITEM_HISTORY.id

line_item_updated_at 🔑➤ LINE_ITEM_HISTORY.updated_at

index 🔑

category

LINE_ITEM_CATEGORY_HISTORY ⇱

line_item_id 🔑➤ LINE_ITEM_HISTORY.id

line_item_updated_at 🔑➤ LINE_ITEM_HISTORY.updated_at

index 🔑

placement

LINE_ITEM_PLACEMENT_HISTORY ⇱

tweet_id 🔑➤ TWEET

index 🔑

text

indices

TWEET_HASHTAG ⇱

tweet_id 🔑➤ TWEET

media_id 🔑

indices�media_key

media_url

media_url_https

url

display_url

expanded_url

type

TWEET_MEDIA ⇱

tweet_id 🔑 ➤ TWEET

index 🔑

url

expanded_url

display_url

indices

TWEET_URL ⇱

tweet_id 🔑 ➤ TWEET

id 🔑

screen_name

name

indices

TWEET_USER_MENTION ⇱

tweet_id 🔑➤ TWEET

index 🔑

text

indices

TWEET_SYMBOLS ⇱

account_id 🔑

date 🔑

segment 🔑

[metrics...]

ACCOUNT_[SEGMENTATION] ⇱

account_id 🔑

funding_instrument_id 🔑

date 🔑

segment 🔑

[metrics...]

FUNDING_INSTRUMENT_[SEGMENTATION] ⇱

account_id 🔑

campaign_history_id 🔑

date 🔑

segment 🔑

[metrics...]

CAMPAIGN_[SEGMENTATION] ⇱

account_id 🔑

line_item_id 🔑

date 🔑

segment 🔑

[metrics...]

LINE_ITEM_[SEGMENTATION] ⇱

account_id 🔑

promoted_tweet_id 🔑

date 🔑

segment 🔑

[metrics...]

PROMOTED_TWEET_[SEGMENTATION] ⇱

funding_instrument_id 🔑

date/month 🔑

average _frequency

total_audience_reach

FUNDING_INSTRUMENT_[AGGREGATION] ⇱

account_id 🔑

campaign_history_id 🔑

date/month 🔑

average _frequency

total_audience_reach

CAMPAIGN_[AGGREGATION] ⇱

id 🔑

updated_at 🔑

line_item_id ➤ LINE_ITEM_HISTORY

call_to_action_url

call_to_action

created_at

deleted

​

PREROLL_CALL_TO_ACTIONS_HISTORY

id🔑

updated_at 🔑

line_item_id 🔑➤ LINE_ITEM_HISTORY.id

tracking_tag_url

created_at�tracking_tag_type

deleted

TRACKING_TAGS_HISTORY ⇱

id 🔑

updated_at 🔑

campaign_id ➤ CAMPAIGN_HISTORY

bid_strategy

advertiser_user_id

name

start_time

bid_amount_local_micro

advertiser_domain

target_cpa_local_micro

primary_web_event_tag

charge_by

product_type

end_time

bid_unit

total_budget_amount_local_micro

objective

entity_status

optimization

currency

created_at

include_sentiment

creative_source

deleted

LINE_ITEM_HISTORY ⇱