campaigns (Campaigns)

Marketing campaigns with target, banner, and landing page information

Field name

Type

Mode

Description

Field name

Type

Mode

Description

id

STRING

NULLABLE

 

name

STRING

NULLABLE

 

status

STRING

NULLABLE

 

promoted

STRING

NULLABLE

 

cuid

STRING

NULLABLE

 

widgets

STRING

REPEATED

 

allWidgets

STRING

NULLABLE

 

segmentUseCases

RECORD

REPEATED

 

segmentUseCases. id

STRING

NULLABLE

 

segmentUseCases. useCaseModelSource

STRING

NULLABLE

 

segmentUseCases. useCaseModelId

STRING

NULLABLE

 

segmentUseCases. useCaseModelVersion

STRING

NULLABLE

 

segmentUseCases. useCaseModelSubVersion

STRING

NULLABLE

 

segmentUseCases. name

STRING

NULLABLE

 

segmentUseCases. _order

STRING

NULLABLE

 

segmentUseCases. orGroup

STRING

NULLABLE

 

segmentUseCases. fromIndex

STRING

NULLABLE

 

segmentUseCases. toIndex

STRING

NULLABLE

 

segmentUseCases. maxWeight

STRING

NULLABLE

 

segmentUseCases. variant

STRING

NULLABLE

 

segmentUseCases. scope

STRING

NULLABLE

 

segmentUseCases. overwriteLevel

STRING

NULLABLE

 

segmentUseCases. overwriteLabel

STRING

REPEATED

 

segmentUseCases. globalTargetTags

STRING

REPEATED

 

segmentUseCases. active

STRING

NULLABLE

 

segmentUseCases. parameters

RECORD

REPEATED

 

segmentUseCases.parameters. name

STRING

NULLABLE

 

segmentUseCases.parameters. value

RECORD

NULLABLE

 

segmentUseCases.parameters.value. format

STRING

NULLABLE

 

segmentUseCases.parameters.value. value

STRING

NULLABLE

 

segmentUseCases.parameters. scope

STRING

NULLABLE

 

segmentUseCases. segmentationIds

STRING

NULLABLE

 

segmentUseCases. segmentationUniqueKeys

STRING

NULLABLE

 

segmentUseCases. CPOInitiativeId

STRING

NULLABLE

 

segmentUseCases. notes

STRING

NULLABLE

 

segmentUseCases. options

STRING

NULLABLE

 

trafficSegmentIds

STRING

REPEATED

 

conditionalSegments

STRING

NULLABLE

 

marketingContentUseCases

RECORD

REPEATED

 

marketingContentUseCases. id

STRING

NULLABLE

 

marketingContentUseCases. useCaseModelSource

STRING

NULLABLE

 

marketingContentUseCases. useCaseModelId

STRING

NULLABLE

 

marketingContentUseCases. useCaseModelVersion

STRING

NULLABLE

 

marketingContentUseCases. useCaseModelSubVersion

STRING

NULLABLE

 

marketingContentUseCases. name

STRING

NULLABLE

 

marketingContentUseCases. _order

STRING

NULLABLE

 

marketingContentUseCases. orGroup

STRING

NULLABLE

 

marketingContentUseCases. fromIndex

STRING

NULLABLE

 

marketingContentUseCases. toIndex

STRING

NULLABLE

 

marketingContentUseCases. maxWeight

STRING

NULLABLE

 

marketingContentUseCases. variant

STRING

NULLABLE

 

marketingContentUseCases. scope

STRING

NULLABLE

 

marketingContentUseCases. overwriteLevel

STRING

NULLABLE

 

marketingContentUseCases. overwriteLabel

STRING

REPEATED

 

marketingContentUseCases. globalTargetTags

STRING

REPEATED

 

marketingContentUseCases. active

STRING

NULLABLE

 

marketingContentUseCases. parameters

RECORD

REPEATED

 

marketingContentUseCases.parameters. name

STRING

NULLABLE

 

marketingContentUseCases.parameters. value

RECORD

NULLABLE

 

marketingContentUseCases.parameters.value. format

STRING

NULLABLE

 

marketingContentUseCases.parameters.value. value

STRING

NULLABLE

 

marketingContentUseCases.parameters. scope

STRING

NULLABLE

 

marketingContentUseCases. segmentationIds

STRING

NULLABLE

 

marketingContentUseCases. segmentationUniqueKeys

STRING

NULLABLE

 

marketingContentUseCases. CPOInitiativeId

STRING

NULLABLE

 

marketingContentUseCases. notes

STRING

NULLABLE

 

marketingContentUseCases. options

STRING

NULLABLE

 

marketingContentSelectionUseCases

STRING

NULLABLE

 

productSelectionUseCases

RECORD

REPEATED

 

productSelectionUseCases. id

STRING

NULLABLE

 

productSelectionUseCases. useCaseModelSource

STRING

NULLABLE

 

productSelectionUseCases. useCaseModelId

STRING

NULLABLE

 

productSelectionUseCases. useCaseModelVersion

STRING

NULLABLE

 

productSelectionUseCases. useCaseModelSubVersion

STRING

NULLABLE

 

productSelectionUseCases. name

STRING

NULLABLE

 

productSelectionUseCases. _order

STRING

NULLABLE

 

productSelectionUseCases. orGroup

STRING

NULLABLE

 

productSelectionUseCases. fromIndex

STRING

NULLABLE

 

productSelectionUseCases. toIndex

STRING

NULLABLE

 

productSelectionUseCases. maxWeight

STRING

NULLABLE

 

productSelectionUseCases. variant

STRING

NULLABLE

 

productSelectionUseCases. scope

STRING

NULLABLE

 

productSelectionUseCases. overwriteLevel

STRING

NULLABLE

 

productSelectionUseCases. overwriteLabel

STRING

REPEATED

 

productSelectionUseCases. globalTargetTags

STRING

REPEATED

 

productSelectionUseCases. active

STRING

NULLABLE

 

productSelectionUseCases. parameters

RECORD

REPEATED

 

productSelectionUseCases.parameters. name

STRING

NULLABLE

 

productSelectionUseCases.parameters. value

RECORD

NULLABLE

 

productSelectionUseCases.parameters.value. format

STRING

NULLABLE

 

productSelectionUseCases.parameters.value. value

STRING

NULLABLE

 

productSelectionUseCases.parameters. scope

STRING

NULLABLE

 

productSelectionUseCases. segmentationIds

STRING

NULLABLE

 

productSelectionUseCases. segmentationUniqueKeys

STRING

NULLABLE

 

productSelectionUseCases. CPOInitiativeId

STRING

NULLABLE

 

productSelectionUseCases. notes

STRING

NULLABLE

 

productSelectionUseCases. options

STRING

NULLABLE

 

productSelectionExpressionBuilderUniqueKeys

STRING

NULLABLE

 

productSelectionExpressionBuilderAndLogic

STRING

NULLABLE

 

combineProductSelectionExpressionBuilderWithUseCases

STRING

NULLABLE

 

productSelectionItemRules

STRING

REPEATED

 

conditionalProductSelections

STRING

NULLABLE

 

contextualParameters

STRING

NULLABLE

 

seoContent

RECORD

NULLABLE

 

seoContent. title

RECORD

REPEATED

 

seoContent.title. language

STRING

NULLABLE

 

seoContent.title. value

STRING

NULLABLE

 

seoContent. metaTags

STRING

REPEATED

 

seoContent. h1

RECORD

REPEATED

 

seoContent.h1. language

STRING

NULLABLE

 

seoContent.h1. value

STRING

NULLABLE

 

seoContent. others

RECORD

REPEATED

 

seoContent.others. name

STRING

NULLABLE

 

seoContent.others. value

RECORD

REPEATED

 

seoContent.others.value. language

STRING

NULLABLE

 

seoContent.others.value. value

STRING

NULLABLE

 

contentParameters

STRING

REPEATED

 

parameters

STRING

REPEATED

 

extraction_tm

DATETIME

REQUIRED

timestamp without a timezone indicating when the records were extracted from the source table

client_id

INTEGER

REQUIRED

ID of the client company