in adjust_report_etl/connector.py [0:0]
def schema(configuration: dict):
return [
{
"table": CSV_REPORT_TABLE_NAME,
"primary_key": DIMENSIONS,
"columns": {
# Dimensions
"adgroup": "STRING",
"adgroup_network": "STRING",
"app": "STRING",
"app_token": "STRING",
"campaign": "STRING",
"campaign_network": "STRING",
"channel": "STRING",
"country": "STRING",
"creative": "STRING",
"creative_network": "STRING",
"currency": "STRING",
"day": "STRING",
"network": "STRING",
"partner_name": "STRING",
"source_network": "STRING",
"store_type": "STRING",
# Metrics
"clicks": "INT",
"impressions": "INT",
"installs": "INT",
"cost": "FLOAT",
"ad_revenue": "FLOAT",
"revenue": "FLOAT",
"att_status_authorized": "INT",
"att_status_denied": "INT",
},
},
{
"table": SKAD_REPORT_TABLE_NAME,
"primary_key": DIMENSIONS,
"columns": {
# Dimensions
"adgroup": "STRING",
"adgroup_network": "STRING",
"app": "STRING",
"app_token": "STRING",
"campaign": "STRING",
"campaign_network": "STRING",
"channel": "STRING",
"country": "STRING",
"creative": "STRING",
"creative_network": "STRING",
"currency": "STRING",
"day": "STRING",
"network": "STRING",
"partner_name": "STRING",
"source_network": "STRING",
"store_type": "STRING",
# Metrics
"skad_installs": "INT",
"skad_total_installs": "INT",
"valid_conversions": "INT",
"conversion_1": "INT",
"conversion_2": "INT",
"conversion_3": "INT",
"conversion_4": "INT",
"conversion_5": "INT",
"conversion_6": "INT",
},
},
]