Current status of the Ning Platform is always available on the Ning Status Blog.

FORUM

NC for Hire

Member maps are awesome... they give your members a way to visualize the growth of their community. I've shared many ways of building member maps over the years, but I seem to be getting a lot of questions about it lately so I figured it was time for an update. Today I am going to show you the most rapid method for creating a member map that I have found to date.   If you know of a faster way, please share.   Here are a few of my previous posts:

How to Map Your Members on a Ning Network

3.0 Tip: How To Map Your Ning Network Members -Updated-

3.0 Mapping Tip: Make Your Member Map Responsive

Here is the short version of how I do it now:

I use the Geocode Awesome addon for Google Drive.  

Export your member data from your community as CSV

Import it into Google Drive and open it as spreadsheet with addon installed to sheets

         -  i usually make a copy of the memberdata.csv and name it GEOmemberdata  and strip the email column out and other irrelevant columns the geocode the geo copy..

Combine the Location column with Country to create a new cell called "Full Address" in the sidebar (it will do it for you)

Geocode that column - it will generate two new columns for Latitude and Longitude and may take as much as an hour

NOTE:  While it geocodes your locations, leave the page open and do not switch to a new tabs to do other things....let it run... if you have a lot of members, watch a movie while it runs or it will stop and hang...best to use in Chrome

Then you'll be presented with an option to create a heat map from the sheet and you have two choices  

1) Either export the sheet as a CSV file to import into other map platforms like Carto.com or Mapbox

2) Generate your map using Awesome table...

          Either one you choose, you'll want to edit the HTML of the infobox.

I usually export the CSV file first before generating the heatmap because it adds extra filters to the sheet when you generate the map..  I do this so that I can import the CSV into Carto.com to create a more robust map like this:

I hope this helps with you member mapping questions. If you ever need advise or help with any aspect of your community, simply drop me a line here and we'll get it moving in the right direction, together...  Have a great weekend!

You need to be a member of Ning Creators Social Network to add comments!

Join Ning Creators Social Network

Email me when people reply –
 

Some interesting articles related to community management, digital marketing etc. could be found in our digest. Don't hesitate to leave a feedback so we would know that we should continue :-)

Latest Activity

Anastasia_Ning_Support replied to Fire-Tech's discussion
3.0 Tip: Insert Image Into Signin Page
"Hi there!
Thank you for your patience!
You have already contacted us via LiveChat, but I will leave…"
15 minutes ago
Ceddy J replied to Kyryl_Ning_Support's discussion
Changes on facebook, and new instructions how the app should be set up
"Do we have to make new Facebook apps, or can we edit the ones we have?"
Saturday
Philip Voice replied to Kyryl_Ning_Support's discussion
Changes on facebook, and new instructions how the app should be set up
"Sorry for the confusion.
Does this change affect any group pages that we have running or is it just…"
Friday
Matthew Aukai Wright replied to Fire-Tech's discussion
3.0 Tip: Insert Image Into Signin Page
"Yay!!!! Oh one more thing. Can I add random line of members with their sexuality and their location…"
Friday
Fabricio Giugni replied to Fabricio Giugni's discussion
Add Photos location problem.
"Hi Anastasia,
    Thanks for try... What Can I do to make it more easy. Maybe a code button code th…"
Friday
Anastasia_Ning_Support replied to Kyryl_Ning_Support's discussion
Changes on facebook, and new instructions how the app should be set up
"Hi there!
I apologize, but I`m not sure what you mean by "existing pages on Facebook". Are you refe…"
Friday
Anastasia_Ning_Support replied to Fire-Tech's discussion
3.0 Tip: Insert Image Into Signin Page
"Hi there!
I`ve passed your screenshot to Alex, the code will be corrected in the nearest future. Yo…"
Friday
Philip Voice replied to Kyryl_Ning_Support's discussion
Changes on facebook, and new instructions how the app should be set up
"Before I do this...what about exisiting pages on FB we have? Does this process start the page again…"
Friday
Matthew Aukai Wright replied to Fire-Tech's discussion
3.0 Tip: Insert Image Into Signin Page
"Hi there. we can do the second one. I took a screen shot where I will like the picture to be. "
Friday
AMZ replied to Ashish's discussion
Ning 3 - Not hapenning!
"The internet is different from early 2010s. Features aren't going anything. What you need is a stra…"
Thursday
Ashish replied to Ashish's discussion
Ning 3 - Not hapenning!
"Yes, thats not good.... But imagine i am sitting on duck! Not even 10members per week, can you plea…"
Thursday
Gavin Brown replied to Kyryl_Ning_Support's discussion
Changes on facebook, and new instructions how the app should be set up
"Thank you Anastasia!"
Thursday
More…

Meanwhile, you can check our social media channels