location_id not null when ip_address is null

[davidstein]

Hi,
i have records in campaign_track_open
where location_id is not null and ip_address is null
how is it possible,
Are there more parameters that the location is derived from other than the ip?

Thanks

 

[ghimes]

Hello,
The field location_id is in fact a foreign key to the ip_location table which will give you the ip in this case.

Cosmin