Skip to main content
Schema - Spend
János Moldvay avatar
Written by János Moldvay
Updated over 3 years ago

COLUMN

SCHEMA

EXAMPLE

project_id

integer

243

project_name

varchar(50)

[CLIENTNAME]_DE

report_id

integer

201

report_name

varchar(50)

Transaction

date

date

2020-07-01

channel

varchar(1000)

Paid Search

source

varchar(1000)

Google Ads

campaign

varchar(1000)

summer_2020

spend

double precision

123123.45

Note: The column date will be used as partition key during incremental exports

Enjoy working with us? Please consider leaving a review.

Did this answer your question?