Integration: Hype Auditor

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.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

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:

  • Pro (V1 and V2)

NOTE: You are considered V2 if...

  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com

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:

Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity Hype Auditor integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.

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

  • 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

Related Resources