Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!

Advanced Geomarketing

Avatar

Level 3

GeoMarketing filters within Adobe Campaign instance.  When performing a distance calculation, it appears that the distance measurement is calculated in kilometers as opposed to miles.  Does Adobe Campaign uses imperial or metric calculations on their backend for the product?

Advanced Filter GeoMarketing.PNG

4 Replies

Avatar

Level 6

Hi, it is in kilometres and we need to convert it into miles.

Avatar

Community Advisor

Hi,

Distance calculation formula used at backend is 'Law of Cosines'.

i.e

distance= acos( sin φ1 ⋅ sin φ2 + cos φ1 ⋅ cos φ2 ⋅ cos Δλ ) ⋅ R

where φ1= second parameter

           φ2= fourth parameter

           Δλ= differeence of first parameter and third parameter.

           R = 6371

And output of this calculation will be in kilometers.

Thanks.

Avatar

Level 4

Hi, 

i don't think is that hard to convert it to Miles, all what you need is multiply the result by 0.6214

Regards,

Badr.

Avatar

Level 3

Its by default in Kilometer, if you want to use it in Miles then Distance (@LongitudeA, @LatitudeA, @LongitudeB, @LatitudeB)*0.6213712 to be precise. We have implemented this on a recent project.

Disclaimer: Please don't expect it to be a logical distance measured by Google Map etc, because its total based on the mathematical calculation. In the back-end Adobe uses the below formula :

1847655_pastedImage_0.png