Every Market Media - Business Executive Email Account Disposition

Owned by Helena Mak
Last updated: Jul 20, 2021
1 min read

For the D&B Project:

  • We are ingesting and dunsifying EMM B2B_* D.csv and EMM B2B_* D Small Business.csv only

  • Note that while the SFTP may contain other csv.gz file, we are only ingesting the above two files for the purpose of the project

  • Even though both CSV share the same layout, please ingest them as separate tables (this would prevent potential headache if the vendor decides to make changes to one file and not the other).

    • EVERY_MARKET_MEDIA_D_RAW

    • EVERY_MARKET_MEDIA_D_SMALL_BUSINESS_RAW

  • For data transformation:

    • Replace the "UNKNOWN" value of "Job Level" and "Job Function" fields with NULL starting from the next data refresh

  • For dunsification, please see match logic file - the same logic should apply to both tables. For the countryISOAlpha2Code, everything = ‘US’

Data Dictionary:

  • Latest Dictionary (06/16/2021):

  • Old Dictionary (Archive)

For Match Logic, please see the latest file on: