Alli Solutions - Data Augmented Bidding

Overview

This task is to build the Data Augmented Bidding Process

Variables

Name	Reference	Type	Required	Default	Options	Description
Uploading Platform	UPLOADING_PLATFORM	Select	✅	cm	Campaign Manager: cm SA360: sa360	Uploading platform (SA360 or Campaign Manager). Defaults to Campaign Manager.
Client DB	CLIENT_DB	Select	✅	bigquery	Big Query: bigquery Redshift: redshift Snowflake: snowflake	Client database name. Defaults to Big Query.
Big Query Project	BQ_PROJECT	Select	✅	pmg-datawarehouse	pmg-datawarehouse alli-data-camelot	BigQuery project name. Defaults to `pmg-datawarehouse`.
Big Query Override?	BQ_OVERRIDE	Boolean	✅	False	-	Override BigQuery source?
Redshift Connection For Conversions Data?	REDSHIFT_CONNECTION_FOR_CONVERSIONS_DATA	Boolean	✅	False	-	Use Redshift connection for conversions data?
Snowflake Connection For Conversions Data?	SNOWFLAKE_CONNECTION_FOR_CONVERSIONS_DATA	Boolean	✅	False	-	Use Snowflake connection for conversions data?
UDA Connection For Conversions Data?	UDA_CONNECTION_FOR_CONVERSIONS_DATA	Boolean	✅	False	-	Use UDA connection for conversions data?
Start Date	START_DATE	Date	✅	-	-	Start date for conversions range.
End Date	END_DATE	Date	➖	-	-	End date for conversions range. If left blank, single-day upload will run for selected Start Date.
Past X Day Upload	PAST_X_DAY_UPLOAD	Integer	✅	0	-	If non-zero, overrides Start Date and End Date and uses the last X days for conversions range. Defaults to 0.
Use Current Time For Dimension?	USE_CURRENT_TIME_FOR_DIMENSION	Boolean	✅	False	-	Use current time as a dimension for conversion data?
Operation Type	OPERATION_TYPE	Select	✅	insert	Insert: insert Update: update	Operation type (`insert` or update). Defaults to Insert.
Mutate Conversions?	MUTATE_CONVERSIONS	Boolean	✅	False	-	Enable mutate conversions feature?
Update Conversions Only?	ONLY_UPDATE	Boolean	✅	False	-	Only update existing conversions?
Concurrent Limit	CONCURRENT_LIMIT	Integer	✅	3	-	Max concurrent operations.
Unique Identifier	UNIQUE_IDENTIFIER	Alphanumeric	✅	gclid	-	Unique identifier. Defaults to `gclid`.
Conversion ID Column	CONVERSION_ID_COLUMN	Alphanumeric	✅	ordinal	-	Column name for conversion ID. Defaults to `ordinal`.
Conversion Data Origin	CONVERSION_DATA_ORIGIN	Select	✅	Google	Google Adobe/Salesforce: Adobe	Conversion data origin. Defaults to `Google`.
Conversion Data Table Name	CONVERSION_DATA_TABLE_NAME	Alphanumeric	✅	dab_conversion_data	-	Conversion data table name. Defaults to `dab_conversion_data`.
Conversion Data Additional Columns	CONVERSION_DATA_ADDITIONAL_COLUMNS	Alphanumeric	➖	-	-	Conversion data additional columns.
Uploaded Data Log Table Name	UPLOADED_DATA_LOG_TABLE_NAME	Alphanumeric	✅	conversion_upload_log_df	-	Uploaded data log table name. Defaults to `conversion_upload_log_df`.
Floodlight Activity IDs Table Name	FLOODLIGHT_ACTIVITY_IDS_TABLE_NAME	Alphanumeric	✅	floodlight_conversion_activity_ids	-	Floodlight activity IDs table name. Defaults to `floodlight_conversion_activity_ids`.
Multiplier?	MULTIPLIER	Boolean	✅	False	-	Enable multiplier feature?
Conversion As Multiplier?	CONVERSION_AS_MULTIPLIER	Boolean	✅	False	-	Enable conversion as multiplier feature?
Upload Multiplier Only?	UPLOAD_MULTIPLIER_ONLY	Boolean	✅	False	-	Upload multiplier only?
Get Multiplier DF Method	GET_MULTIPLIER_DF_METHOD	Select	✅	google_sheet	Google Sheet: google_sheet SQL	Get multiplier DF method. Defaults to Google Sheet.
Multiplier DF Table Name	MULTIPLIER_DF_TABLE_NAME	Alphanumeric	➖	-	-	Multiplier DF table name.
Matching Logic GSheet ID	MATCHING_LOGIC_GSHEET_ID	Alphanumeric	➖	-	-	Matching logic GSheet ID
Currency Conversion?	CURRENCY_CONVERSION	Boolean	✅	False	-	Enable currency conversion feature?
Currency Floodlight Variable Dimension	CURRENCY_FLOODLIGHT_VARIABLE_DIMENSION	Alphanumeric	➖	-	-	Currency floodlight variable dimension.
Custom Dimension?	CUSTOM_DIMENSION	Boolean	✅	False	-	Enable custom dimension?
Custom Dimension Name	CUSTOM_DIMENSION_NAME	Alphanumeric	➖	-	-	Custom dimension name
Custom Dimension Column Name	CUSTOM_DIMENSION_COLUMN_NAME	Alphanumeric	➖	-	-	Custom dimension column name.
Custom Metric?	CUSTOM_METRIC	Boolean	✅	False	-	Enable custom metric?
Custom Metric Name	CUSTOM_METRIC_NAME	Alphanumeric	➖	-	-	Custom metric name.
Custom Metric Column Name	CUSTOM_METRIC_COLUMN_NAME	Alphanumeric	➖	-	-	Custom metric column name.

YAML

Below is the YAML template

YAML


source:
  template: Alli Solutions - Data Augmented Bidding
  inputs:
    UPLOADING_PLATFORM: cm
    CLIENT_DB: bigquery
    BQ_PROJECT: pmg-datawarehouse
    BQ_OVERRIDE: false
    REDSHIFT_CONNECTION_FOR_CONVERSIONS_DATA: false
    SNOWFLAKE_CONNECTION_FOR_CONVERSIONS_DATA: false
    UDA_CONNECTION_FOR_CONVERSIONS_DATA: false
    START_DATE:
    END_DATE:
    PAST_X_DAY_UPLOAD: '0'
    USE_CURRENT_TIME_FOR_DIMENSION: false
    OPERATION_TYPE: insert
    MUTATE_CONVERSIONS: false
    ONLY_UPDATE: false
    CONCURRENT_LIMIT: '3'
    UNIQUE_IDENTIFIER: gclid
    CONVERSION_ID_COLUMN: ordinal
    CONVERSION_DATA_ORIGIN: Google
    CONVERSION_DATA_TABLE_NAME: dab_conversion_data
    CONVERSION_DATA_ADDITIONAL_COLUMNS:
    UPLOADED_DATA_LOG_TABLE_NAME: conversion_upload_log_df
    FLOODLIGHT_ACTIVITY_IDS_TABLE_NAME: floodlight_conversion_activity_ids
    MULTIPLIER: false
    CONVERSION_AS_MULTIPLIER: false
    UPLOAD_MULTIPLIER_ONLY: false
    GET_MULTIPLIER_DF_METHOD: google_sheet
    MULTIPLIER_DF_TABLE_NAME:
    MATCHING_LOGIC_GSHEET_ID:
    CURRENCY_CONVERSION: false
    CURRENCY_FLOODLIGHT_VARIABLE_DIMENSION:
    CUSTOM_DIMENSION: false
    CUSTOM_DIMENSION_NAME:
    CUSTOM_DIMENSION_COLUMN_NAME:
    CUSTOM_METRIC: false
    CUSTOM_METRIC_NAME:
    CUSTOM_METRIC_COLUMN_NAME:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 1