Integration Specifications

This article will help you learn about how Daasity replicates data from Hype Auditor, limitations to the data we can extract and where the data is stored in the Hype Auditor schema.

Integration Overview

Hype Auditor is an influencer marketing platform that allows businesses to analyze social media influencers, get statistics for any account and channel, and prepare quality and rapid marketing plans.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

• Enterprise

API Endpoints

The Daasity Hype Auditor extractor is built based on this Hype Auditor API Documentation. The following endpoint is used by Daasity to replicate data from Hype Auditor:

• Auditor Report

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Hype Auditor integration illustrating the different tables and keys to join across tables.

Hype Auditor Schema

The Daasity Hype Auditor extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

• Influencers

• Influencer Followers

• Influencer Audience Countries

• Influencer Audience Demographics

• Influencer Audience Ethnicity

• Influencer Audience Interests

Influencers

• Endpoint: Auditor Report

• Update Method: UPSERT

• Table Name: [hypeauditor.influencers]

JSON Element	Database Column
MD5(influencer::username)	influencer_id
influencer::username	username
influencer::full_name	full_name
influencer::is_private	private_flag
influencer::about	about
influencer::photo_url	photo_url
influencer::location	location
influencer::posts_count	total_posts
influencer::followers_count	total_followers
influencer::followings_count	total_following
influencer::avg_likes	average_likes
influencer::avg_comments	average_comments
influencer::aqs	aqs
influencer::aqs_name	aqs_title
influencer::aqs_description	aqs_description
influencer::likes_spread.value	likes_spread_value
influencer::likes_spread.avg	likes_spread_average
influencer::likes_spread.title	likes_spread_title
influencer::likes_comments_ratio.value	likes_comments_ratio_value
influencer::likes_comments_ratio.avg	likes_comments_ratio_average
influencer::likes_comments_ratio.title	likes_comments_ratio_title
influencer::audience_reachability.value	audience_reachability_value
influencer::audience_reachabilityavg	audience_reachability_average
influencer::audience_reachability.title	audience_reachability_title
influencer::audience_authenticity.value	audience_authenticity_value
influencer::audience_authenticity.avg	audience_authenticity_average
influencer::audience_authenticity.title	audience_authenticity_title
influencer::audience_type.real	audience_type_real_pct
influencer::audience_type.susp	audience_type_susp_pct
influencer::audience_type.infs	audience_type_infs_pct
influencer::audience_type.mass	audience_type_mass_pct
influencer::er.value	er_value
influencer::er.avg	er_average
influencer::er.title	er_title
influencer::global_rank	global_rank
influencer::advertising_data.avg_ad_er	average_ad_er
influencer::advertising_data.avg_er	average_er
influencer::post_frequency	post_frequency
Daasity: account_id	_account_id
Daasity: MD5(influencer::username)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Influencer Followers

• Endpoint: Auditor Report

• Update Method: UPSERT

• Table Name: [hypeauditor.influencer_followers]

JSON Element	Database Column
MD5(influencer::username + follower::date)	influencer_follower_id
MD5(influencer::username)	influencer_id
follower::count	total_followers
follower::date	follower_date
Daasity: account_id	_account_id
Daasity: MD5(influencer::username + follower::date)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Influencer Audience Countries

• Endpoint: Auditor Report

• Update Method: UPSERT

• Table Name: [hypeauditor.influencer_audience_countries]

JSON Element	Database Column
MD5(influencer::username + country::code)	influencer_audience_country_id
MD5(influencer::username)	influencer_id
country::name	country_name
country::code	country_code
country::value	audience_pct
Daasity: account_id	_account_id
Daasity: MD5(influencer::username + follower::date)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Influencer Audience Demographics

• Endpoint: Auditor Report

• Update Method: UPSERT

• Table Name: [hypeauditor.influencer_audience_demographics]

JSON Element	Database Column
MD5(demography_by_age::gender + by_age_group::group)	influencer_audience_demographic_id
MD5(influencer::username)	influencer_id
demography_by_age::gender	gender
by_age_group::group	age_range
by_age_group::value	audience_pct
Daasity: account_id	_account_id
Daasity: MD5(influencer::username + demography_by_age::gender + by_age_group::group)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Influencer Audience Ethnicity

• Endpoint: Auditor Report

• Update Method: UPSERT

• Table Name: [hypeauditor.influencer_audience_ethnicity]

JSON Element	Database Column
MD5(audience_ethnicity::name)	influencer_audience_ethnicity_id
MD5(influencer::username)	influencer_id
audience_ethnicity::name	ethnicity
audience_ethnicity::value	ethnicity_pct
Daasity: account_id	_account_id
Daasity: MD5(influencer::username + audience_ethnicity::name)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Influencer Audience Interests

• Endpoint: Auditor Report

• Update Method: UPSERT

• Table Name: [hypeauditor.influencer_audience_interests]

JSON Element	Database Column
MD5(audience_interests[0])	influencer_audience_interest_id
MD5(influencer::username)	influencer_id
audience_interests[0]	interest_name
audience_interests[1]	audience_pcnt
Daasity: account_id	_account_id
Daasity: MD5(influencer::username + audience_interests[0])	__sync_key
Daasity: timestamp when loaded into DB	__synced_at