Data Library
scope · market = sloalerts
10 columns
idbigint
client_idbigint
created_attimestamp with time zone
tonetext
categorytext
messagetext
actiontext
statustext
generated_bytext
generated_attimestamp with time zone NULL
briefs
12 columns
client_idbigint
weekdate
titletext
generated_labeltext
summarytext
statsjsonb
kpisjsonb
winsjsonb
risksjsonb
watchingjsonb
generated_bytext
created_attimestamp with time zone
campaign_snapshots
12 columns
client_idbigint
datedate
campaign_nametext
spend_28dnumeric
roasnumeric
search_impression_sharenumeric NULL
healthinteger
verdicttext
statustext
drivertext
actiontext
in_headroomboolean
category_snapshots
7 columns
client_idbigint
datedate
categorytext
demand_per_monthinteger
revenue_28dnumeric
rev_per_1knumeric
verdicttext
channel_snapshots
5 columns
client_idbigint
datedate
channeltext
spend_28dnumeric
roasnumeric
clients
6 columns
idbigint
slugtext
nametext
markettext
currencytext
created_attimestamp with time zone
funnel_snapshots
5 columns
client_idbigint
datedate
categorytext
viewsinteger
atc_to_purchase_pctnumeric
health_snapshots
8 columns
client_idbigint
weekdate
scoreinteger
delta_vs_last_weekinteger NULL
pillarsjsonb
narrativejsonb NULL
generated_bytext
generated_attimestamp with time zone NULL
keyword_snapshots
7 columns
client_idbigint
datedate
keywordtext
quality_scoreinteger NULL
roasnumeric
impression_share_pctinteger
verdicttext
kpi_snapshots
11 columns
client_idbigint
datedate
spend_28dnumeric
revenue_28dnumeric
mernumeric
orders_28dinteger
aovnumeric
forecast_spendnumeric
forecast_revenuenumeric
forecast_mernumeric
forecast_ordersinteger
materialize_runs
4 columns
idbigint
started_attimestamp with time zone
finished_attimestamp with time zone
resultjsonb
metrics_daily
7 columns
client_idbigint
datedate
sourcetext
channeltext
spendnumeric
revenuenumeric
ordersinteger
moves
13 columns
idbigint
client_idbigint
rankinteger
titletext
whytext
ownertext
statustext
committed_attimestamp with time zone NULL
outcometext NULL
reviewed_attimestamp with time zone NULL
generated_bytext
generated_attimestamp with time zone NULL
impacttext NULL
page_content
5 columns
client_idbigint
pagetext
contentjsonb
generated_bytext
generated_attimestamp with time zone
reviews_snapshots
6 columns
client_idbigint
datedate
businesstext
is_selfboolean
ratingnumeric
review_countinteger
search_volumes
4 columns
client_idbigint
categorytext
monthdate
volumeinteger
serp_rankings
6 columns
client_idbigint
datedate
categorytext
domaintext
is_selfboolean
ranknumeric
threads
6 columns
idbigint
client_idbigint
titletext
messagesjsonb
created_attimestamp with time zone
updated_attimestamp with time zone
ui_specs
8 columns
idbigint
client_idbigint
placementtext
prompttext
documentjsonb
validboolean
generated_bytext
created_attimestamp with time zone
watch_events
8 columns
idbigint
client_idbigint
detected_attimestamp with time zone
tagtext
tonetext
titletext
detailtext
notetext NULL
weekly_rollups
5 columns
client_idbigint
week_startdate
spendnumeric
revenuenumeric
mernumeric NULL
whitespace_terms
6 columns
client_idbigint
termtext
notetext NULL
vol_per_monthinteger
competitionnumeric
cpcnumeric