Jump to:
Company Schema
The schemas provided originate from our BigQuery bulk dataset. These fields remain consistent across other data shares - including Snowflake, Google Cloud Storage (GCS), and Amazon S3.
Company Schema
[
{
"name": "id",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "entity_urn",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "funding_attribute_null_status",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "initialized_date",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "updated_at",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "tags",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "type",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "display_value",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "date_added",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "entity_urn",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "snapshots",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "entity_urn",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "initialized_date",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "funding_attribute_null_status",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "ownership_status",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "socials",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "FACEBOOK",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "like_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "following_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "TWITTER",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "LINKEDIN",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "INSTAGRAM",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "CRUNCHBASE",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "PITCHBOOK",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "ANGELLIST",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "INDEED",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "MONSTER",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "STACKOVERFLOW",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "GLASSDOOR",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "website",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "domain",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "is_broken",
"mode": "",
"type": "BOOLEAN",
"description": null,
"fields": []
}
]
},
{
"name": "logo_url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "name",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "legal_name",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "description",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "customer_type",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "founding_date",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "date",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "granularity",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "company_type",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "location",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "address_formatted",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "street",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "city",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "state",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "zip",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "country",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "funding",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "funding_total",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "num_funding_rounds",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "last_funding_at",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "last_funding_type",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "last_funding_total",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
},
{
"name": "funding_stage",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "investors",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "entity_urn",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "name",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "contact",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "phone_numbers",
"mode": "REPEATED",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "emails",
"mode": "REPEATED",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "headcount",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "people",
"mode": "REPEATED",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "ownership_status",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "website",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "domain",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "is_broken",
"mode": "",
"type": "BOOLEAN",
"description": null,
"fields": []
}
]
},
{
"name": "logo_url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "name",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "legal_name",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "description",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "customer_type",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "founding_date",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "date",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "granularity",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "company_type",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "location",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "address_formatted",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "street",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "city",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "state",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "zip",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "country",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "funding",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "funding_total",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "num_funding_rounds",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "last_funding_at",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "last_funding_type",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "last_funding_total",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
},
{
"name": "funding_stage",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "investors",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "entity_urn",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "name",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "socials",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "FACEBOOK",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "like_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "following_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "TWITTER",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "LINKEDIN",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "INSTAGRAM",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "follower_count",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "CRUNCHBASE",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "PITCHBOOK",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "ANGELLIST",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "INDEED",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "MONSTER",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "STACKOVERFLOW",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "GLASSDOOR",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "url",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "traction_metrics",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "headcount",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "external_headcount",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_advisor",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_customer_success",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_data",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_design",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_engineering",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_finance",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_legal",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_marketing",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_operations",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_other",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_people",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_product",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_sales",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "headcount_support",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "instagram_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "external_instagram_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "facebook_like_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "external_facebook_like_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "facebook_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "external_facebook_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "facebook_following_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "external_facebook_following_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "twitter_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "external_twitter_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "linkedin_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "external_linkedin_follower_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "funding_total",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
},
{
"name": "web_traffic_count",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "ago_14d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_30d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_90d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_180d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "ago_365d",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "change",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "percent_change",
"mode": "",
"type": "FLOAT",
"description": null,
"fields": []
}
]
},
{
"name": "metrics",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "timestamp",
"mode": "",
"type": "TIMESTAMP",
"description": null,
"fields": []
},
{
"name": "metric_value",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
}
]
},
{
"name": "headcount",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "external_headcount",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
},
{
"name": "highlights",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "category",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "text",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "date_added",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "contact",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "phone_numbers",
"mode": "REPEATED",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "emails",
"mode": "REPEATED",
"type": "STRING",
"description": null,
"fields": []
}
]
},
{
"name": "website_domain_aliases",
"mode": "REPEATED",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "external_description",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "related_companies",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "beta_notice",
"mode": "",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "acquisitions",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "company_id",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "acquired_by",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "company_id",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "subsidiaries",
"mode": "REPEATED",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "company_id",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
},
{
"name": "subsidiary_of",
"mode": "",
"type": "RECORD",
"description": null,
"fields": [
{
"name": "company_id",
"mode": "",
"type": "INTEGER",
"description": null,
"fields": []
}
]
}
]
}
]
Changelog
5/4/24
New fields:
external description: this field will contain descriptions of companies that we scrape from LinkedIn. This used to live in the description field.related_companies: this field will contain any acquisition or subsidiaries, identifying both the parent and child. Relationship data is in beta and may not be accurate, please reach out with any feedback.
Changes to existing fields:
description: this field will contain a concise description generated with various inputs including LinkedIn description, website text, and more. If you prefer to use the LinkedIn description for your existing workflows, please refer to the new field,external_description.
4/7/24
New external_{traction_metric}s in traction_metrics -
external_instagram_follower_count,external_facebook_like_count,external_facebook_follower_count,external_facebook_following_count,external_twitter_follower_count,external_linkedin_follower_count****How does external_{traction_metric_type} differ from {traction_metric_type}?
external_{traction_metric_type} stores only the accurate, real observed values, eliminating any periods of no change that might imply stale or inaccurate data. This field focuses on preserving the integrity of the actual data points without any algorithmic modifications, providing a clear view of when genuine changes occurred.
{traction_metric_type} (without the "external_" prefix), on the other hand, includes both the real observed values and algorithmically derived values to fill in the gaps where data was missing. This interpolation ensures a continuous and smooth trend line, making it easier to visualize changes over time, even when actual data points were not available.
3/25/24
Company snapshots have headcount populated.