Mobile Facebook Coverage

Author: Jessica White

Purpose: The script above will give site level Facebook coverage for both mobile and desktop. The script can be altered to pull by device type.

Inputs: Need to insert campaign_id and date (this script is set up to select max data date, but can be altered to select a specific date or date range). The script can also be changed to select device types instead of platform type, as noted above.

Server/DB: jdbc:netezza://nantz40.nielsen.com:5480/MCH_NOCR_REF

Note:

Platform_type_code
1= Desktop
2= Mobile

Device_type_code
1= Desktop
2= Portable Media Player
3= Smart Phone
4= Tablet
5= Unknown Device

Internet_media_credit_id = Site_ID