Customizable reports & inspections

Google Maps integration

Google Maps integration

Postby RyDim81 » Mon Mar 17, 2014 5:30 am

Has anyone invented a report that I can run the would place my customers addresses over a Google map? We'd like to get an accurate map out of where our customers are coming from, so we can come up with a better marketing plan.

Thanks
Ryan
Jeff's Lex-Toy
Londonderry, NH
603-965-3496
RyDim81
Member
 
Posts: 13
Joined: Mon Oct 07, 2013 4:54 am
Location: Londonderry, NH

Re: Google Maps integration

Postby Johnny5 » Mon Mar 17, 2014 1:32 pm

John Dwulet AKA: Johnny5
Sr. Product Marketing Manager - Mitchell1
Tuck in behind me, I'll show you where to crash. 8)
User avatar
Johnny5
System Guru / Moderator
System Guru / Moderator
 
Posts: 662
Joined: Wed May 26, 2004 2:03 pm
Location: Mitchell 1 John Dwulet, Sr. Product Marketing Manager

Re: Google Maps integration

Postby Johnny5 » Mon Mar 17, 2014 3:30 pm

So here is what I did, I used the mail merge query in 6.5 to generate an excel spread sheet of customers. I then eliminated all columns in the spreadsheet except name, address, city, state and zip. I saved the file as a CSV (comma separated value) files. I then uploaded that data to Google fusion. The result is amazing, the red dots are customer addresses found in the data, you can click on any dot and will give you the name and address of that customer.: (Note: I only used a small sampling of data)
Attachments
2014-03-17_16-27-07.gif
 
John Dwulet AKA: Johnny5
Sr. Product Marketing Manager - Mitchell1
Tuck in behind me, I'll show you where to crash. 8)
User avatar
Johnny5
System Guru / Moderator
System Guru / Moderator
 
Posts: 662
Joined: Wed May 26, 2004 2:03 pm
Location: Mitchell 1 John Dwulet, Sr. Product Marketing Manager

Re: Google Maps integration

Postby Rich » Tue Mar 18, 2014 4:10 am

We need a like button. That way I could click that instead of typing all this out just to say...

THATS COOL!!!!!!!!!!!!!!!!!
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3714
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Google Maps integration

Postby Rich » Tue Mar 18, 2014 4:57 am

I got the point of excitement, then was DENIED. UGH. I got to this point and zero information highlighted. However, I will go back and work on it a little later. Looks like a great way to show a door knocking advertisement sales person we really don't need to run ads in LA.

If your data does not have a column highlighted in yellow, that means that the Fusion Tables weren't able to automatically pick a column that specified a location. To do this, click the Edit menu, then select Edit Columns. From here you will click on the column that holds your location data. After clicking, on the right you will see a drop down list labeled Type. Select Location from the drop down list, then click Save in the bottom left of this screen. After this, your column should be highlighted yellow.
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3714
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Google Maps integration

Postby Johnny5 » Tue Mar 18, 2014 10:08 am

My CSV file had to have Lastname, street, city, st, zip for it to work.
John Dwulet AKA: Johnny5
Sr. Product Marketing Manager - Mitchell1
Tuck in behind me, I'll show you where to crash. 8)
User avatar
Johnny5
System Guru / Moderator
System Guru / Moderator
 
Posts: 662
Joined: Wed May 26, 2004 2:03 pm
Location: Mitchell 1 John Dwulet, Sr. Product Marketing Manager

Re: Google Maps integration

Postby Rich » Tue Mar 18, 2014 10:53 am

Will retry, i had thought I did just what you had done and followed the links. Not a huge deal. Just think it may be handy at times to see just where your customer are located.
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3714
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Google Maps integration

Postby MRISICH » Tue Mar 18, 2014 1:28 pm

Very cool!
2014_0318_AllActive.png
Bolt On - Connect The Dots
 
Michael Risich
Founder & CEO

BOLT ON TECHNOLOGY™

610-400-1019
http://boltontechnology.com/
User avatar
MRISICH
300 Club: Superstar Contributor
300 Club: Superstar Contributor
 
Posts: 351
Joined: Tue Jul 18, 2006 3:49 am
Location: Chalfont, PA

Re: Google Maps integration

Postby Rich » Wed Mar 19, 2014 4:12 am

Is that Guam in the LL??
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3714
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Google Maps integration

Postby MRISICH » Wed Mar 19, 2014 4:22 am

It is Guam!
Michael Risich
Founder & CEO

BOLT ON TECHNOLOGY™

610-400-1019
http://boltontechnology.com/
User avatar
MRISICH
300 Club: Superstar Contributor
300 Club: Superstar Contributor
 
Posts: 351
Joined: Tue Jul 18, 2006 3:49 am
Location: Chalfont, PA

Return to Report Pro

Who is online

Users browsing this forum: No registered users and 1 guest