way to download "All of Alamy" search terms for most recent year?

[Jeffrey Isaac Greenberg]

https://www.alamy.com/Customersearch/Customersearchhistory.aspx

 

one can choose (100) items per page & see there are 28.7K+ more pages;

is there easy way to collect ALL search terms for further research...?

thanks in advance...

[wiskerke]

Just restrict the time span; download and combine in Excel.

However I don't think there's a simple way to download a result without a search term (of at least 3 characters): the Export to excel button is missing.

I'm sure you could build a scraper for that though. Or do it by hand.

 

wim

[Jeffrey Isaac Greenberg]

WimW & all

 

thanks for responsse;

can't find download button on "All of Alamy" search page;
when selecting 1 yr period, maximum allowed(?), I see this

page with indication of 26890 more pages:

 

Last Updated on : 01 Dec 2024 05:52

	Yesterday Last 7 days Last week (Mon-Sun) Last business week (Mon-Fri) Last month
			Search Term :

 

Results per page:  20 50 100

Page 1 of 26890

Go to page:

< Previous |   Next >

Search Term	UCO	Sales	Zooms	Views	CTR (%)
dog	700	5	154	109,940	0.14
alamy	575	0	2	78,369	0.00
cat	533	64	220	118,278	0.19
taylor swift	500	196	890	368,359	0.24
alarmy	409	0	6	177,413	0.00
car	359	5	111	67,454	0.16
donald trump	356	248	655	241,756	0.27
Kamala Harris	297	142	566	189,818	0.30
trump	280	101	257	137,932	0.19
v	279	0	3	42,834	0.01
manchester city	258	358	436	150,897	0.29
UK OR Wales OR England OR Scotland OR 'Northern Ireland' OR Britain OR British OR 'United Kingdom'	249	0	7	47,552	0.01
Manchester United	248	384	511	175,551	0.29
harry Kane	246	300	457	102,109	0.45
keir starmer	238	254	756	204,627	0.37
liverpool	226	389	628	175,972	0.36
Real Madrid	225	295	438	139,534	0.31
arsenal	222	395	490	124,586	0.39
cristiano ronaldo	219	240	317	129,416	0.24
football	207	55	190	87,422	0.22
paris	207	36	218	67,751	0.32
elon musk	190	59	186	84,998	0.22
Rishi sunak	189	297	691	156,202	0.44
christmas	188	19	93	56,735	0.16
euro 2024	184	270	409	90,161	0.45
landscapes	183	0	193	54,818	0.35
pep guardiola	183	260	361	103,469	0.35
barcelona	182	73	294	61,383	0.48
beyonce	181	29	193	72,606	0.27
king charles	181	58	210	84,243	0.25
london	175	40	266	55,662	0.48
marilyn monroe	174	40	321	96,742	0.33
erling haaland	172	188	245	72,588	0.34
Jude Bellingham	169	200	268	66,607	0.40
cole palmer	167	242	283	75,728	0.37
haaland	165	238	320	82,004	0.39
rachel reeves	164	58	174	99,059	0.18
messi	160	104	189	50,075	0.38
olympics	157	38	120	37,814	0.32
gaza	157	126	214	86,718	0.25
jurgen klopp	155	235	326	64,063	0.51
almy	155	0	3	20,848	0.01
rodri	154	149	177	54,490	0.32
titanic	153	95	326	71,278	0.46
winter	153	1	79	24,986	0.32
wildlife	152	2	136	45,385	0.30
blue	152	0	2	16,584	0.01
lamine yamal	151	247	308	62,050	0.50
erik ten hag	151	352	391	110,913	0.35
Aston Villa	150	144	198	61,697	0.32
chelsea	148	211	251	77,026	0.33
ronaldo	147	116	165	37,241	0.44
AI	147	40	127	33,501	0.38
gareth southgate	147	200	274	58,378	0.47
oasis	147	10	35	32,085	0.11
premier league	144	104	251	51,822	0.48
Artificial Intelligence	143	32	176	49,990	0.35
arne slot	140	192	286	73,020	0.39
The Beatles	140	17	280	64,187	0.44
champions league	139	137	233	57,650	0.40
kate middleton	138	54	289	115,526	0.25
lionel messi	138	95	172	44,542	0.39
vinicius junior	136	105	140	52,916	0.26
Joe Biden	135	96	229	56,007	0.41
oasis band	134	78	181	55,128	0.33
simone biles	133	62	161	47,884	0.34
elvis presley	130	25	253	80,488	0.31
lebron james	130	76	122	36,360	0.34
bayer leverkusen	129	145	179	56,540	0.32
rome	129	9	201	33,038	0.61
Ruben Amorim	127	100	134	51,106	0.26
liverpool fc	127	84	169	77,754	0.22
kylian mbappe	127	185	243	62,438	0.39
xabi alonso	126	92	149	51,517	0.29
taylor swift eras tour	126	81	377	71,747	0.53
bruno fernandes	125	145	188	42,999	0.44
Salah	125	149	189	46,800	0.40
david bowie	124	19	208	57,133	0.36
Michael Jordan	124	20	161	36,777	0.44
england	123	93	159	43,911	0.36
madonna	121	18	63	30,389	0.21
mike tyson	121	55	134	43,191	0.31
mohamed salah	120	96	132	44,602	0.30
spain	120	67	282	39,188	0.72
Paris Olympics	119	39	101	22,815	0.44
mikel arteta	119	147	189	67,751	0.28
New York	118	25	164	39,158	0.42
cultures	118	0	18	19,833	0.09
money	118	28	49	19,935	0.25
apple	118	4	82	21,479	0.38
FRIDA KAHLO	117	13	282	61,327	0.46
old trafford	116	98	151	25,473	0.59
france	116	44	75	35,873	0.21
taylor swift 2024	115	38	197	59,819	0.33
phil foden	114	114	142	44,647	0.32
kevin de bruyne	113	75	102	33,933	0.30
klopp	113	165	194	46,469	0.42
harry potter	113	9	55	28,526	0.19
lewis hamilton	112	183	248	64,344	0.39
enzo maresca	112	58	96	37,726	0.25

etc.

[Mr Standfast]

Ask Alamy for help. It's in their interest. 😊

 

[wiskerke]

4 hours ago, Jeffrey Isaac Greenberg said:

WimW & all

 

thanks for responsse;

can't find download button on "All of Alamy" search page;
when selecting 1 yr period, maximum allowed(?), I see this

page with indication of 26890 more pages:

 

Last Updated on : 01 Dec 2024 05:52

	Yesterday Last 7 days Last week (Mon-Sun) Last business week (Mon-Fri) Last month
			Search Term :

 

Results per page:  20 50 100

Page 1 of 26890

Go to page:

< Previous |   Next >

Search Term	UCO	Sales	Zooms	Views	CTR (%)
dog	700	5	154	109,940	0.14
alamy	575	0	2	78,369	0.00
cat	533	64	220	118,278	0.19
taylor swift	500	196	890	368,359	0.24
alarmy	409	0	6	177,413	0.00
car	359	5	111	67,454	0.16
donald trump	356	248	655	241,756	0.27
Kamala Harris	297	142	566	189,818	0.30

 

As I said: There's no simple way to download a result without a search term (of at least 3 characters): the Export to excel button is missing.

Btw even with a regular search term, downloading the result just chokes the database, sending you to the kid with the binoculars page.

It probably helps to choose a moment with very low server activity.

 

wim

[Jeffrey Isaac Greenberg]

1 hour ago, wiskerke said:

without a search term (of at least 3 characters): the Export to excel button is missing.

got it;

noticed "Export to Excel" appears when using %-----%, too;

but not with %(a or e or i or o or u)% as a way to get most searches in an Excel;

pondering what word or phrase %X% might return most searches, then feed that Excel doc to ChatGPT
& tell it to only keyword with those words-phrases...

[wiskerke]

Using %-----% I don't see a result.

The only way a query of AoA can generate meaningful keywords in my opinion is to include a keyword that's known to be used by clients in a search for the subject in your image.

Clearly you will not find synonyms or alternative search phrases this way. Just usable phrases. (Mind you not correct ones either because clients can and will perform stupid funny searches.)

For finding synonyms we traditionally have a thesaurus. Luckily also online ones. Having to put every synonym in AoA becomes tedious and very time consuming very fast. (Ask me how I know 😁)

 

So ChatGPT would be an enormous help here. Provided you give it the right prompt.
A good prompt could be something like

Give 10 different descriptions of an image that contains x; y; z and where a; b; c is happening, using as many different words as possible. Maybe even include UK plus US spelling.

This together with a straightforward instruction keyword this image would give you many different keywords and key phrases. Is it quicker than thinking up keywords yourself? Will it result in more sales? Dunno.

 

Maybe ask ChatGPT what keywords future clients will use, using ChatGPT.

Could be the result will be one of the all Cretans are liars said the Cretan philosopher paradoxes though.

 

wim

[Jeffrey Isaac Greenberg]

On 02/12/2024 at 18:09, wiskerke said:

Using %-----% I don't see a result.

To clarify, by "-----" I meant 3 or more characters. e.g., below, which includes Export Excel link:
(if only I could instruct ChatGPT to, "add keywords to mine but never
any words-phrases NOT searched on Alamy in most recent rolling year...)
(even though its true new searches tomorrow will fit that description)

ChatGPT suggested some phrases which seem logical but weren't searched in year
& its time consuming to manual check one by one, e.g..
"shopping culture", "cafe atmosphere"

 

Search Term : %a or b%

Return to all searches

Results per page:  20 50 100

Page 1 of 1

Go to page:

< Previous |   Next >

Search Term	UCO	Sales	Zooms	Views	CTR (%)
antigua and barbuda grey map	1	0	0	380	0.00
madonna and brother	1	0	1	100	1.00
kamala and biden	1	0	0	100	0.00
cup of tea and biscuit	1	0	0	100	0.00
modena and bologna	1	0	0	100	0.00
sea and beach	1	0	0	100	0.00
venezuela and brazil	1	1	1	100	1.00
sofa and backpack	1	0	0	100	0.00
old canon camera and battery	1	0	0	19	0.00
princess diana AND bernie taupin	1	0	1	19	5.26
Croatia and Bosnia and Herzegovina satellite view	1	0	1	10	10.00
Alison Victoria and Brandt Andersen	1	0	0	2	0.00
antigua and barbuda postage stamps	1	0	0	1	0.00
modena and bologna war	1	0	1	1	100.00
zamba and Beau Bridges	1	0	0	1	0.00
princess diana AND bernie taupinm	1	0	0	0	0.00
Alison Victoria and Brand Andersen	1	0	0	0	0.00
bud spencer pasta and beans	1	0	0	0	0.00

Export to excel

Edited December 4 by Jeffrey Isaac Greenberg

[wiskerke]

9 hours ago, Jeffrey Isaac Greenberg said:

To clarify, by "-----" I meant 3 or more characters. e.g., below, which includes Export Excel link:
(if only I could instruct ChatGPT to, "add keywords to mine but never
any words-phrases NOT searched on Alamy in most recent rolling year...)
(even though its true new searches tomorrow will fit that description)

ChatGPT suggested some phrases which seem logical but weren't searched in year
& its time consuming to manual check one by one, e.g..
"shopping culture", "cafe atmosphere"

 

 

Yes I got the 3 or more characters. I used like %AMS% and %WAS%. And when I'm uncertain of what spelling clients will use something like %COLO%R%.

However I did try %   % (three empty spaces). Which does get you the Export button, but only with funny searches.

Trying to construct a dictionary of all words used on Alamy by clients would (if possible) get you just that: an incomplete dictionary. While you would want a dictionary of all words to avoid.

 

Have you tried using ChatGPT searching for images on Alamy?

My guess is that clients will use it to look for images, but without specifying Alamy or any other library. Maybe they will put in the prompt: and please find the cheapest.

 

Has anybody tried that yet?

 

wim

 

edit:  I just tried % % (one space) and it gets you all two or more word searches. All 25767 pages @100 for the rolling year.  No Export button though.

The same search on 1-4 Dec did get me the button. Aha so it's just a limit on the amount of results. My guess is that the limit is at or around 600 pages @100. Which is abot 8 days. It could very well also be a time limit on how quick the server is able to come up with the results. Meaning that it may well be limited to a fraction of that during Internet Rush Hour.

 

Edited December 5 by wiskerke

[Jeffrey Isaac Greenberg]

22 hours ago, wiskerke said:

My guess is that the limit is at or around 600 pages @100. Which is abot 8 days.

I tested "% %" & confirm 600 pages of 100 rows seems the Excel export borderline = 7 days worth...

[M.Chapman]

On 06/12/2024 at 00:17, Jeffrey Isaac Greenberg said:

I tested "% %" & confirm 600 pages of 100 rows seems the Excel export borderline = 7 days worth...

But "% %" appears to omit single word searches from the results. Does that matter?

 

Mark

Edited Monday at 18:04 by M.Chapman