campaigns (Campaigns)
Marketing campaigns with target, banner, and landing page information
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 |