Schema Information - Hyros

Discover the importance of schema information and how it impacts data organization and management within various systems. Explore how schema information helps users understand the structure and relationships of data to enhance overall efficiency and accuracy.

Need help with something?

Talk to data expert

Schema Information - Hyros

Discover the importance of schema information and how it impacts data organization and management within various systems. Explore how schema information helps users understand the structure and relationships of data to enhance overall efficiency and accuracy.

Tables/APIs 

The following table is associated with the Hyros connector.

Leads

Purpose: The Leads API in the Hyros platform is designed to capture and manage information related to potential customers or leads. 
 
Source API Documentation: Hyros- Leads.
 
Replication: Key-Based Replication

Primary Key: id- This is the unique identifier.

 
Fields
Field Name Data Type
email STRING
id STRING
creationDate TIMESTAMP
firstName STRING
lastName STRING
ips STRING
phoneNumbers STRING
tags STRING
firstSource RECORD
lastSource RECORD

Sales

Purpose: The Sales API is responsible for handling and organizing data related to completed sales transactions.
 
Source API Documentation: Hyros- Sales
 
Replication: Key-Based Replication

Primary Key: id- This is the unique identifier.

 
Fields
Field Name Data Type
email STRING
id STRING
creationDate TIMESTAMP
firstName STRING
lastName STRING
ips STRING
phoneNumbers STRING
tags STRING
firstSource RECORD
lastSource RECORD

Calls

Purpose: The Calls API focuses on managing data related to phone calls. It include call logs, details about the callers, call durations, and other relevant information to analyze and optimize call interactions.
 
Source API Documentation: Hyros- Calls.
 
Replication: Key-Based Replication

Primary Key: id- This is the unique identifier.

 
Fields
Field Name Data Type
id STRING
orderId STRING
creationDate STRING
qualified BOOLEAN
score NUMERIC
recurring BOOLEAN
quantity NUMERIC
lead RECORD
firstSource RECORD
lastSource RECORD
price RECORD
usdPrice RECORD
product RECORD
provider RECORD

Ads

Purpose: The Ads API is associated with tracking and analyzing data from advertising campaigns. 
 
Source API Documentation: Hyros- Ads.
 
Fields
Field Name  Data Type
name STRING
adSource RECORD
source RECORD
creationDate NUMERIC

Sources

Purpose: The Sources API deals with identifying and categorizing the sources of user interactions or leads.
 
Source API Documentation: Hyros- Sources.
 
Fields
Field Name  Data Type
name STRING
tag STRING
disregarded BOOLEAN
organic BOOLEAN
adSource RECORD
trafficSource RECORD
goal RECORD
category RECORD
creationDate NUMERIC

Ad Attribution

Purpose: The Ad Attribution API is focused on attributing conversions or specific actions to advertising efforts. 
 
Source API Documentation: Hyros- Ad Attribution.
 
Replication: Key-Based Replication

Primary Key: id- This is the unique identifier.

 
Fields
Field Name  Data Type
id STRING
sales NUMERIC
calls NUMERIC
unique_sales NUMERIC
refund NUMERIC
leads NUMERIC
new_leads NUMERIC
revenue NUMERIC
recurring_revenue NUMERIC
total_revenue NUMERIC
profit NUMERIC
cost NUMERIC
roi NUMERIC
roas NUMERIC
refund_count NUMERIC
refunded_revenue_percentage NUMERIC
refunded_sales_percentage NUMERIC
cost_per_call NUMERIC
cost_per_lead NUMERIC
cost_per_sale NUMERIC
cost_per_new_lead NUMERIC
cost_per_unique_sales NUMERIC
unique_customers NUMERIC
cost_per_unique_customer NUMERIC
unique_customers_revenue NUMERIC
net_profit NUMERIC
hard_costs NUMERIC
schema details data structure

Related Articles

Table of Contents

Tables/APIs Leads Sales Calls Ads Sources Ad Attribution