bigquery_json_schema.js

[
    {
        "name": "account_id",
        “type”: “STRING”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “account_name”,
        “type”: “INT64”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “account_status”,
        “type”: “STRING”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “account_update_date”,
        “type”: “DATE”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “campaign_id”,
        “type”: “INT64”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “campaign_name”,
        “type”: “STRING”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “campaign_status”,
        “type”: “STRING”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “campaign_update_date”,
        “type”: “DATE”,
        “mode”: “NULLABLE”
    },
    {
        “name”: “performance”,
        “type”: “RECORD”,
        “mode”: “REPEATED”,
        “fields”: [
            {
                “name”: “performance_date”,
                “type”: “DATE”,
                “mode”: “NULLABLE”
            },
            {
                “name”: “impressions”,
                “type”: “INT64”,
                “mode”: “NULLABLE”
            },
            {
                “name”: “clicks”,
                “type”: “INT64”,
                “mode”: “NULLABLE”
            },
            {
                “name”: “cost”,
                “type”: “FLOAT64”,
                “mode”: “NULLABLE”
            },
            {
                “name”: “load_date”,
                “type”: “DATE”,
                “mode”: “NULLABLE”
            }
        ]
    }
]