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.

Schema Information - Hyros

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

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

Table of Contents

Tables/APIs Leads Sales Calls Ads Sources Ad Attribution

Schema Information - Hyros

Saras Pulse

Saras Daton