2025-05-08 TWINO Market Research Workshop

2025-05-08 TWINO Market Research WorkshopMetodePagaidu rezultāts Video no workshopUzvednes (Prompts)C1C2C3C4C4.1C5C7 C8C9Tabulu izgūšanas vaicājumu piemēri

Metode

Pārveidojam kritērijus informācijas svākšanas jautājumos (nevis vai APR lielāks par 30%, Find APR for each country)
Precīzi norādam visu valstu sarakstu vaicājuma beigās
Atšifrējam iekāvās visus saīsinājumus
Pievienojam info most recent available data
Pievienojam visur non-bank lenders, jo citādi miksē banku datus
Izmanotjam GPT o3 + Deep Research, palaižam fonā vairākus processus
Nokopējam linkus uz Deep Research C kritēriju meklēšanām un dokumentējam paalēli uzmanīgi dokumentā, lai vēlāk tiktu klāt šiem tiklīdz pabeigsies un paralēli nākamos meklējam
Pārbaudam iegūto rezultātu ticamību pret Poliju un Latviju
Kad dati savākti tad tajā paša sesijā ar GPT 4.5 veicam izgūšanu tabulas formā, var pieglabāt arī jēlos datus
Iekopējam kritērijus galvenajā tabulā, ja tiek kaut kas mainīts vai šķirots, tad spiežam edit vienu soli augstāk
Katru vaicājumu sēriju jaunā čatā sākam
Ranžējam kandidātus pēc kritēriju summas
Izvēlamies valsti

Līdzīgi rīkojamies Valsts ietvaros, lai atrastu labāko kandidātu.

Pagaidu rezultāts

Sākotnēji iegūtais ranžējuma fails pa valstīm (pagaidām 5 kritēriji un 2 tika atmesti analizējot jautājumus, jo tie bija vienādi visām valstīm)

https://docs.google.com/spreadsheets/d/1zimgUP-B3Ui19Tan9RN0uhF3ulWcOBZK8OAdxeVj60M/edit?usp=sharing

Video no workshop

Uzvednes (Prompts)

Kritērijus atzīmejam ar kādu kodu, piem C1, C2, .., lai pēc tam ērtāk operēt ar datiem

C1


xxxxxxxxxx
28
1
Find the maximum annual percentage rate APR (Annual Percentage Rate) for non-bank lenders in the following countries, unsecured consumer credit only, legal caps set by regulation and market APR:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681cb065-94ac-800a-bdbc-a9494b27ef30

C2


xxxxxxxxxx
28
1
Find out how long the passporting procedure is in months for payment institutions for following countries:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681cb156-fbe0-800a-959f-bf91c9616ca3

^ Likvidējām, jo visām valstīm 1-2 mēneši

C3


xxxxxxxxxx
27
1
Austria
2
Belgium
3
Bulgaria
4
Croatia
5
Cyprus
6
Czech Republic
7
Denmark
8
Estonia
9
Finland
10
France
11
Germany
12
Greece
13
Hungary
14
Ireland
15
Italy
16
Latvia
17
Lithuania
18
Luxembourg
19
Malta
20
Netherlands
21
Poland
22
Portugal
23
Romania
24
Slovakia
25
Slovenia
26
Spain
27
Sweden

https://chatgpt.com/c/681cb329-0b68-800a-8560-3e8b24e47e30

^ Likvidējām, jo visur atļauts

C4


x
1
Find non-performing loan NPL (A non-performing loan is a loan where the borrower has not made the required payments-like monthly installments-for a certain period, 90 days or more<br />) percentage in market for follwing countries:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681cb29e-c2c4-800a-ab5a-4ea3f48c7af4

C4.1


x
1
Find non-performing loan NPL (A non-performing loan is a loan where the borrower has not made the required payments-like monthly installments-for a certain period, 90 days or more), for non-bank lender, most recent available data, percentage in market for follwing countries:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681cb9b5-3b20-800a-bdd5-49392e49fb08

C5


xxxxxxxxxx
28
1
Find percentage of smartphone ownership in 18 – 55 age demographic in following countries:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681b46da-26d0-800a-84ae-1fa627ede72d

C7


x
1
Find payment transaction speed in minutes for domestic bank transactions, most recent available data, for countries:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681cb51c-9678-800a-8a27-22f2bd4dc38c

C8


xxxxxxxxxx
1
28
1
Find CAC (Client Acquisition Cost) and LTV (Lifetime Value) for non-bank lenders, in EUR, using the most recent available data for countries:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681cb633-b4c4-800a-a44c-16c4fd128a29?model=gpt-4-5

C9


xxxxxxxxxx
28
1
Find market share of non-bank percentage of total consumer-credit volume, most recent available data, lenders in each country:
2
Austria
3
Belgium
4
Bulgaria
5
Croatia
6
Cyprus
7
Czech Republic
8
Denmark
9
Estonia
10
Finland
11
France
12
Germany
13
Greece
14
Hungary
15
Ireland
16
Italy
17
Latvia
18
Lithuania
19
Luxembourg
20
Malta
21
Netherlands
22
Poland
23
Portugal
24
Romania
25
Slovakia
26
Slovenia
27
Spain
28
Sweden

https://chatgpt.com/c/681cbdde-1ba0-800a-bd7a-c68427abb693

Tabulu izgūšanas vaicājumu piemēri


xxxxxxxxxx
1
1
Make Table with Columns: "Country", "Share Percentage"


xxxxxxxxxx
1
1
Make table, Columns: Country, Column: NPL as scalar value


xxxxxxxxxx
1
1
Calculate median NPL from table


xxxxxxxxxx
1
1
Add column: C4, set value "1" if NPL above 2.5 else "0"


xxxxxxxxxx
1
1
Download as CSV


xxxxxxxxxx
1
1
Give table column Country; column Percentage where "percentage smartphone ownership in 18 – 55 age demographic"; column C5 where "1 if above 75% or more smartphone ownership in 18 – 55 age demographic" and "0 if below", for countries