| leadSource |
Count |
| "" |
892 |
| Direct |
4939 |
| Directory |
1063 |
| Friends and Family |
1 |
| Google Ad Words |
2 |
| Google PPC |
7233 |
| Organic Search |
16338 |
| Other |
3162 |
| Phone |
3 |
| Search |
3 |
| Social |
552 |
| source |
17831 |
| SOURCE |
7 |
|
403 |
| leadSourceDetail |
Count |
| " |
8723 |
| ? |
16 |
| bing |
912 |
| direct |
5591 |
| facebook |
552 |
| FBofferNKM |
1 |
| Friends-Family:WinnResidential |
1 |
| gmb |
1 |
| GMB |
614 |
| GMBofferAPS2019 |
4 |
| GMBofferPES2019 |
3 |
| GMBofferSIS2019 |
1 |
| gmbSNKM |
1 |
| google |
20863 |
| Google Natural |
3 |
| Google PPC |
6 |
| other |
3193 |
| Phone App |
3 |
| SOURCEDETAIL |
9993 |
| superpages |
4 |
| yahoo |
468 |
| yellowpages |
8 |
| yelp |
1057 |
|
412 |
select
distinct(payload ->> 'leadSource') as leadSourc,
count(id) as Count
from
store_inquiries
where
contact_method = 'floorforce_inquiry'
group by
payload ->> 'leadSource';
select
distinct(payload ->> 'leadSourceDetail') as leadSourceDetail,
count(id) as Count
from
store_inquiries
where
contact_method = 'floorforce_inquiry'
group by
payload ->> 'leadSourceDetail';
