Hype Auditor Extractor Info

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

Was this article helpful?
0 out of 0 found this helpful