Madhive Standardized Data Feeds

Data Feeds Example Schema

The following tables contain all of the dimensions that can be tracked for Madhive supported standardized reporting. The attached one-sheet provides best practices and more information on this offering. 

Aggregate Report

Column Name	Description	Data Type	Sample Value
date_et	ET date of impression	Date (ET) in YYYY-MM-DD	2021-05-03
advertiser_id	MadHive Advertiser ID	String	9KBjEkuet9Um0Sweg3dEjoCv2ZWe
advertiser_name	Advertiser Name	String	Test Advertiser
campaign_id	MadHive Campaign ID	String	XrceyXLFloYig9hqonIn9PrUOt9a
campaign_name	Campaign Name	String	Test Campaign
line_item_id	MadHive Line Item ID	String	pzXzY2ChdpAvsC0orl4SSo56tpYv
line_item_name	Line Item Name	String	Test Line Item
creative_id	MadHive Creative ID	String	xZlUpZ81phpp6vYyAUA7hSLtTGBp
creative_name	Creative Name	String	Test Creative
publisher_id	MadHive Publisher ID	String	hl3Yy0rTJ8mVWimTkxv4D2NE9ofn
publisher_name	Publisher Name	String	HGTV
impressions_total	Count of Impression events	Integer	1
impressions_video_start	Count of video start events	Integer	1
impressions_q1	Count of video 1st quartile events	Integer	1
impressions_q2	Count of video midpoint events	Integer	1
impressions_q3	Count of video 3rd quartile events	Integer	1
impressions_video_complete	Count of video complete events	Integer	1

Impression Report

Column Name	Description	Data Type	Sample Value
impression_timestamp_et	ET timestamp of impression	Timestamp (ET) in YYYY-MM-DD HH:MM:SS	2021-05-03 19:37:48 ET
impression_tx	Unique transaction ID of impression	String	C285230welD8rJ0Tll2Z0VvbG1BQdl0
client_id	Madhive Client ID	String	s3cR4tY7u8i0o9p1q2w3e4r5T
client_name	Madhive Client Name	String	Test Client
advertiser_id	MadHive Advertiser ID	String	9KBjEkuet9Um0Sweg3dEjoCv2ZWe
advertiser_name	Advertiser Name	String	Test Advertiser
campaign_id	MadHive Campaign ID	String	XrceyXLFloYig9hqonIn9PrUOt9a
campaign_name	Campaign Name	String	Test Campaign
campaign_start_date_et	Campaign Start Date ET	Date (ET) in YYYY-MM-DD	2021-05-03
campaign_end_date_et	Campaign End Date ET	Date (ET) in YYYY-MM-DD	2021-05-03
campaign_external_id	Campaign External ID	String	{"placements_io_id": "111"}
campaign_oms_id	Campaign OMS ID	String	111
campaign_ext_meta	Campaign Ext Meta	String	111
line_item_id	MadHive Line Item ID	String	pzXzY2ChdpAvsC0orl4SSo56tpYv
line_item_name	Line Item Name	String	Test Line Item
line_item_start_date_et	Line Item Start Date ET	Date (ET) in YYYY-MM-DD	2021-05-03
line_item_end_date_et	Line Item End Date ET	Date (ET) in YYYY-MM-DD	2021-05-03
line_item_oms_id	Line Item OMS ID	String	222
line_item_external_id	Line Item External ID	String	222
line_item_ext_meta	Line Item Ext Meta	String	{"placements_io_id": "12345", "placements_io_group_id": "1234"}
line_item_media_type	Line Item Media Type	String	VIDEO
impressions_goal	Line Item Booked Impressions	Integer	10000
creative_id	MadHive Creative ID	String	xZlUpZ81phpp6vYyAUA7hSLtTGBp
creative_name	Creative Name	String	Test Creative
creative_isci_code	Creative ISCI Code	String	HZLDALLEN_30_OTT
creative_duration_sec	Creative Duration	Integer	31
creative_vast_url	Creative Vast URL	String	https://ad.doubleclick.net/ddm/pfadx/....
creative_created_at	Creative Created Date (UTC)	Timestamp (UTC) in YYYY-MM-DD HH:MM:SS	2023-09-11 16:18:54.390263 UTC
publisher_id	MadHive Publisher ID	String	hl3Yy0rTJ8mVWimTkxv4D2NE9ofn
publisher_name	Publisher Name	String	HGTV
product_id	Madhive Product ID	String	2b9d3Fg5H7j8k1L2m3n4o5p6q7
product_name	Madhive Product Name	String	Test Product
station_id	Madhive Station ID	String	A8b9c1D2e3F4g5H6i7j8k9l0M1
station_name	Madhive Station Name	String	Test Station
agency_id	Madhive Agency ID	String	Q2w3e4R5t6Y7u8i9o0p1q2r3s4T
agency_name	Madhive Agency Name	String	Test Agency
ip_address_hashed_sha256	Hashed IP address of corresponding impression	String	882876355e5dd97ed5c02af284fccfeb0ec6d95086ad065fd783c9de4c2215b0
media_type	Media Type of corresponding impression	String	VIDEO
congressional_district	Congressional District of corresponding impression	String	FL03
device_ifa	Device Identifier of corresponding impression	String	66c52d2d54774799ac3c510ca83d6588
device_type	Type of device impression was served to	String	TV
country	Country	String	US
state_abbr	State (Abbreviated)	String	NV
postal_code	Postal Code	String	89121
dma_code	Nielsen DMA Code	String	839
dma_name	Nielsen DMA Name	String	Las Vegas
impressions_total	Count of Impression events	Integer	1
impressions_video_start	Count of video start events	Integer	1
impressions_q1	Count of video 1st quartile events	Integer	1
impressions_q2	Count of video midpoint events	Integer	1
impressions_q3	Count of video 3rd quartile events	Integer	1
impressions_video_complete	Count of video complete events	Integer	1

Attribution Report

Column Name	Description	Data Type	Sample Value
ip_address_hashed_sha256	Hashed IP address of corresponding impression	String	882876355e5dd97ed5c02af284fccfeb0ec6d95086ad065fd783c9de4c2215b0
advertiser_id	MadHive Advertiser ID	String	9KBjEkuet9Um0Sweg3dEjoCv2ZWe
advertiser_name	Advertiser Name	String	Test Advertiser
pixel_id	ID of the web pixel	String	3ZLhQfhmg3Vd5Agrx3dEjoLh5XTr
pixel_name	name of web pixel	String	Test Signup Pixel
pixel_timestamp_et	ET timestamp of pixel fire	Timestamp (ET) in YYYY-MM-DD HH:MM:SS	2021-05-04 13:23:52 ET
pixel_tx	Unique transaction ID for each conversion	String	2611336598665650000
impression_tx	Unique transaction ID of the attributed impression	String	C285230welD8rJ0Tll2Z0VvbG1BQdl0
impression_timestamp_et	ET timestamp of impression	Timestamp (ET) in YYYY-MM-DD HH:MM:SS	2021-05-03 19:37:48 ET
campaign_id	MadHive Campaign ID	String	XrceyXLFloYig9hqonIn9PrUOt9a
campaign_name	Campaign Name	String	Test Campaign
line_item_id	MadHive Line Item ID	String	pzXzY2ChdpAvsC0orl4SSo56tpYv
line_item_name	Line Item Name	String	Test Line Item
days_to_conversion	date difference (in number of days) between impression & beacon events	integer	1