Export calls vs export leads

[dspaan]

I'm getting weird results when exporting sales today.

Result of export leads report:

12 sales:

lead_id
45330
45855
86486
147594
147900
148150
148342
148510
148829
150282
150905
151094

Result of export calls report over the same time period:

15 sales

lead_id
45330
45855
86486
146293
147594
147897
147900
148150
148342
148510
148829
149587
150282
150905
151094

Now i don't see double lead id's here. So why am i getting two sales less with the export leads report?

[spacejanitor]

Are you sure you selected the exact same export options at each screen?

Same statuses, user groups, campaigns?

[Trying]

Is the LATEST STATUS of all those leads in the Calls Report SALE? Remember in the calls report if somebody changed the status from sale to something else during the time of the report it will still show that record where the status was still SALE. The Leads Report simply gives you the leads where the LATEST STATUS is sale for the period that you are running it for.

[spacejanitor]

Good point, Trying... that is also one of the differences between the Lead Report vs Calls Report

[dspaan]

Thanks for the feedback guys

I figured out what happened. This was indeed regarding export of SALE leads. I always use the export leads report for that for the reason that you mentioned Trying.

However we recently started using an SQL trigger that changes leads who have reached the callcount limit to status code MAX. It turns out that the 3 missing sales from the export leads report were made at the last allowed call attempt. So after they were flagged as SALE the script had changed them to status MAX.

[Trying]

Excellent! Thank you for reporting back!