Gephi converter master blank - Make a copy
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBI
1
CONTROL PANEL
2
Gephi converter for market map
Enter your vertical:
Colour group level:
3
Converts keyword group & volume data into the format required for visualisation of the Market Map in Gephi.
The output is 2 csv files ('Nodes' file & 'Edges' file)
NOT READY TO CONVERT - PLEASE WAIT FOR THE PROGRESS BAR
1
4
>> Make a copy first, then delete this cell<<
5
Vertical / client (auto-filled)Keyword search volume unitGroup Level 1 - No blanksGroup Level 2 - No blanksGroup Level 3 - Blanks are okHow to use
Visualisation examples - They show the Keyword groups in hierarchical order, with size representing search demand, and colour representing the parent group. All the key information is now available at a glance. It can be seen as a demand based site structure.
6
Enter your vertical in E3CREATE A COPY TO WORK IN
7
e.g.
Before starting, make sure you are working in your own copy of this master sheet.
8
* To make a copy, go to File > Make a copy. This is to preserve the master sheet
Visualisation example 1: Yifan Hu Proportional - For a site layout which resembles a site structure
Visualisation example 2: Reingold - For symmetry
9
10
1. Type the vertical (industry) of the search landscape into the 'Vertical' box (F3)
11
* whatever your client offers (jobs, fashion, travel insurance)
12
* this will be the centre of the Market Map
13
14
2. In your spreadsheet, prepare these columns in order with none in-between:
15
* keyword search volume
16
* group level 1 (parent)
17
* group level 2 (portfolio)
18
* group level 3 (sub portfolio)
19
20
* see the 'Example input data' sheet for a correctly formatted example
21
* Levels 1 & 2 can't have blanks; the fastest fix is to change these to 'General'
22
* Level 3 should have some blanks
23
* keyword search volume unit means the search volume for an individual keyword
24
* to get only these 4 columns in Excel, hide intervening columns and then copy
25
* keywords themselves are not needed, just their volume data
26
* leave out the column headings
27
28
3. Paste the data as values into cell C6 (the green one)
29
* 10,000 rows max
30
31
3.a. Choose which group level the graph colours will be based on, in the blue box in L3 (enter 1 or 2)
32
* this is usually the parent group (1)
33
34
4. Click 'Convert data'; you will need give permission to run the script the first time
35
* It takes 15 seconds to start
36
* It will say 'running script', and in a few moments the authorization required message
37
* to authorise, click 'Continue', your gmail, and 'Advanced' at the bottom of the page
38
* then, continue by clicking at the bottom left, then 'Allow'
39
* do this only if you are working in a copy of the master
40
41
5. Wait 10 minutes, or until the progress bar in the top right corner is gone
42
* the bar is usually active (on blanks), but won't start processing your data until you activate
43
* 'YOUR DATA IS BEING PROCESSED' will show in orange when it's working on your data
44
* When it's ready, it will say 'Data processed & validated'
45
46
6. For each of the red 'OUTPUT' sheets, download them as a .csv file
47
* FIle > Download as... > Comma-separated values (.csv, current sheet)
48
49
7. Upload your files to Gephi.
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
What the output will look like when imported to Gephi
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...