Integration Overview
Find fake influencers, followers, likes, comments, and engagement. Check influencer's Instagram, YouTube, and TikTok stats, discover and evaluate influencers
Hype Auditor (https://hypeauditor.com/) is a platform that allows users to extract information about a Social Influencer (Youtube, Instagram) such as follower information, follower trends and much more.
Integration overview
The Daasity integration with HypeAuditor extracts data from the Report endpoint for the influencers that the merchant submits in the Daasity UI. The integration then breaks the returned data into several tables allowing the merchant to perform analytics on the influencer
This integration is available for:
- Pro V1
- Pro V2
ERD
Endpoint: Returns
Data is retrieved by accessing the https://hypeauditor.com/api/method/auditor.report API endpoint.
INFLUENCER TABLE
Data Mapping
|
Database Column |
JSON Element |
|
influencer_id |
MD5(username) |
|
username |
username |
|
full_name |
full_name |
|
private_flag |
is_private |
|
about |
about |
|
photo_url |
photo_url |
|
location |
location |
|
total_posts |
posts_count |
|
total_followers |
followers_count |
|
total_following |
followings_count |
|
average_likes |
avg_likes |
|
average_comments |
avg_comments |
|
aqs |
aqs |
|
aqs_title |
aqs_name |
|
aqs_description |
aqs_description |
|
likes_spread_value |
likes_spread NESTED JSON -> value |
|
likes_spread_average |
likes_spread NESTED JSON -> avg |
|
likes_spread_title |
likes_spread NESTED JSON -> title |
|
likes_comments_ratio_value |
likes_comments_ratio NESTED JSON -> value |
|
likes_comments_ratio_average |
likes_comments_ratio NESTED JSON -> avg |
|
like_comments_ratio_title |
likes_comments_ratio NESTED JSON -> title |
|
audience_reachability_value |
audience_reachability NESTED JSON -> value |
|
audience_reachability_average |
audience_reachability NESTED JSON -> avg |
|
audience_reachability_title |
audience_reachability NESTED JSON -> title |
|
audience_authenticity_value |
audience_authenticity NESTED JSON -> value |
|
audience_authenticity_average |
audience_authenticity NESTED JSON -> avg |
|
audience_authenticity_title |
audience_authenticity NESTED JSON -> title |
|
audience_type_real_pct |
audience_type NESTED JSON -> real |
|
audience_type_susp_pct |
audience_type NESTED JSON -> susp |
|
audience_type_infs_pct |
audience_type NESTED JSON -> infs |
|
audience_type_mass_pct |
audience_type NESTED JSON -> mass |
|
er_value |
er NESTED JSON -> value |
|
er_average |
er NESTED JSON -> avg |
|
er_title |
er NESTED JSON -> title |
|
global_rank |
global_rank |
|
average_ad_er |
advertising_data NESTED JSON -> avg_ad_er |
|
average_er |
advertising_data NESTED JSON -> avg_er |
|
post_frequency |
post_frequency |
Business Rules
|
Business Rule |
Value |
|
Load Type |
INSERT |
|
Extraction Frequency |
One-Time on Demand |
|
Sync Key |
Influencer ID |
INFLUENCER AUDIENCE ETHNICITY TABLE
Data Mapping
|
Database Column |
JSON Element |
|
influencer_audience_ethnicity_id |
MD5(username || ':' || ethnicity) |
|
influencer_id |
MD5(username) |
|
ethnicity |
name |
|
ethnicity_pct |
value |
Business Rules
|
Business Rule |
Value |
|
Load Type |
INSERT |
|
Extraction Frequency |
One-Time on Demand |
|
Sync Key |
Influencer ID + Ethnicity |
INFLUENCER FOLLOWERS TABLE
Data Mapping
|
Database Column |
JSON Element |
|
influencer_follower_id |
MD5(username || ':' || date) |
|
influencer_id |
MD5(username) |
|
follower_date |
convert "date" to timestamp |
|
total_followers |
count |
Business Rules
|
Business Rule |
Value |
|
Load Type |
INSERT |
|
Extraction Frequency |
One-Time on Demand |
|
Sync Key |
Influencer ID + Date |
INFLUENCER AUDIENCE COUNTRIES TABLE
Data Mapping
|
Database Column |
JSON Element |
|
influencer_audience_country_id |
MD5(username || ':' || code) |
|
influencer_id |
MD5(username) |
|
country_name |
name |
|
country_code |
code |
|
audience_pct |
value |
Business Rules
|
Business Rule |
Value |
|
Load Type |
INSERT |
|
Extraction Frequency |
One-Time on Demand |
|
Sync Key |
Influencer ID + Country Code |
INFLUENCER AUDIENCE INTERESTS TABLE
Data Mapping
|
Database Column |
JSON Element |
|
influencer_audience_interest_id |
MD5(username || ':' || interest_name) |
|
influencer_id |
MD5(username) |
|
interest_name |
Title of the value within "audience_interests" |
|
audience_pct |
Value within "audience_interests" |
Business Rules
|
Business Rule |
Value |
|
Load Type |
INSERT |
|
Extraction Frequency |
One-Time on Demand |
|
Sync Key |
Influencer ID + Title |
INFLUENCER AUDIENCE DEMOGRAPHICS TABLE
Data Mapping
|
Database Column |
JSON Element |
|
influencer_audience_demographic_id |
MD5(username || ':' || gender || ':' || group) |
|
influencer_id |
MD5(username) |
|
gender |
gender from first-level nested JSON |
|
age_range |
group from second-level nested JSON |
|
audience_pct |
value from second-level nested JSON |
Business Rules
|
Business Rule |
Value |
|
Load Type |
INSERT |
|
Extraction Frequency |
One-Time on Demand |
|
Sync Key |
Influencer ID + Gender + Group |