Duplicate Spot ID numbers in my LeadsRx download data

Within LeadsRx, each spot has a unique ID number. If you have downloaded a list of broadcast activity by spot, you may notice that the spotID is being converted to scientific notation. If you convert this to a number, you may see duplicate spotID numbers. This happens because of a rounding issue with Excel. 

This rounding issue can be worked around, but may require converting the column(s) to TEXT prior to importing the CSV data.

Here is an article from Microsoft that you may find helpful. It includes instructions on turning long number strings to text.
Excel auto roundoff long numbers in the .csv file

Please reach out to us if you are continuing to have problems.