Analysis of Brazil's Diplomatic Efficiency

The approach to evaluating public policies based on the rational model, with an emphasis on policy performance and results, is widely used in academia and contemporary governments. Below, we present the application of the input-output model, a traditional approach in public policy analysis and business administration, to assess the efficiency of Brazilian spending abroad, creating a quantitative measure for evaluating the country’s diplomatic representations.

The method chosen to assess the performance of Brazilian diplomatic representations is Data Envelopment Analysis (DEA). The method is used to estimate efficiency based on the comparison between similar units (DMUs – Decision Making Units), consuming similar resources (inputs) to produce the same products or results (outputs). In our case, the DMUs are the diplomatic representations of Brazil abroad, structuring the panel data by country and year.

Different types of DEA models have been developed in the literature to address different assumptions, data structures, and research objectives. Since our data structure is panel data, we apply the Dynamic DEA model, which was developed for this type of data structuring. Dynamic DEA allows the evaluation of efficiency in systems where past decisions affect future performance by modeling intertemporal dependencies (e.g., current diplomatic investments impact future bilateral relations).

The fundamental output of the proposed evaluation model is the Foreign Policy Index (FPI), assuming the objective of Brazilian foreign policy to increase or maintain engagement with countries. On the input side, we used expenditures on diplomatic representations, expenditures on diplomatic personnel, and the number of diplomatic staff assigned to the country’s diplomatic representations. The time series covers 2013 to 2022, 110 countries. Below we present the results of the diplomatic efficiency index created by the dynamic DEA analysis, ranging from 0 to 1, where 1 is the highest relative efficiency. 

Below we present the dynamic map with the diplomatic efficiency index data for the entire time series. Countries in white on the map do not have data (they generally do not have diplomatic representations or have had relations suspended with Brazil). The more intense the color on the map below, the greater the efficiency of the diplomatic representations in the country.

Next, we make the efficiency index data available in a spreadsheet for download. At the end of this page you will find the disaggregated data for replicating the DEA analysis, with the codes in R and a dynamic bar map to visualize the data according to the available filters.

Dynamic Map of the Diplomatic Efficiency Index

Below we present the table with the diplomatic efficiency index for download and use of the data reported in the dynamic map above.

wdt_ID wdt_created_by wdt_created_at wdt_last_edited_by wdt_last_edited_at country year efficiency_index isoa3
1176 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Angola 2013 0.042 AGO
1177 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Albania 2013 0.398 ALB
1178 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 United Arab Emirates 2013 0.062 ARE
1179 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Argentina 2013 0.951 ARG
1180 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Armenia 2013 1.000 ARM
1181 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Australia 2013 0.040 AUS
1182 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Austria 2013 0.042 AUT
1183 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Azerbaijan 2013 0.203 AZE
1184 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Belgium 2013 0.038 BEL
1185 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Bangladesh 2013 0.150 BGD
1186 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Bulgaria 2013 0.198 BGR
1187 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Bahamas 2013 0.310 BHS
1188 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Bosnia and Herzegovina 2013 0.334 BIH
1189 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Belarus 2013 0.342 BLR
1190 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Belize 2013 1.000 BLZ
1191 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Bolivia 2013 0.354 BOL
1192 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Barbados 2013 1.000 BRB
1193 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Botswana 2013 0.570 BWA
1194 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Canada 2013 0.078 CAN
1195 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Switzerland 2013 0.099 CHE
1196 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Chile 2013 0.807 CHL
1197 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 China 2013 1.000 CHN
1198 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Cameroon 2013 0.187 CMR
1199 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Congo 2013 0.271 COG
1200 pedrofeliu 30/06/2025 10:43 pedrofeliu 30/06/2025 10:43 Colombia 2013 0.809 COL
wdt_ID wdt_created_by wdt_created_at wdt_last_edited_by wdt_last_edited_at Variable Description
1 pedrofeliu 10/10/2024 12:00 pedrofeliu 30/06/2025 15:55 country Name of the country
2 pedrofeliu 10/10/2024 12:00 pedrofeliu 30/06/2025 15:55 year Year
3 pedrofeliu 10/10/2024 12:00 pedrofeliu 30/06/2025 15:56 efficiency_index Diplomatic Efficiency Index estimated with Dynamic DEA
4 pedrofeliu 10/10/2024 12:00 pedrofeliu 30/06/2025 15:56 isoa3 ISO 3 Country Code

Feliu Ribeiro, P. (2024). POLEN (v1.01) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.14015246. Avaiable at: polen.iri.usp.br

Dynamic Bar Chart Diplomatic Efficiency Index

Use the filters below to manipulate the bar chart above, colored by the “efficieny index” variable

Disaggregated data from the Diplomatic Efficiency Index

country year efficiency_index isoa3 fpi funcionarios embaixada salario
wdt_ID wdt_created_by wdt_created_at wdt_last_edited_by wdt_last_edited_at country year efficiency_index isoa3 fpi funcionarios embaixada salario
1 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Angola 2013 0.042 AGO 0.67 25 8,488,249 370,276
2 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Albania 2013 0.398 ALB 0.50 13 1,825,440 162,483
3 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 United Arab Emirates 2013 0.062 ARE 0.61 9 5,262,340 136,021
4 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Argentina 2013 0.951 ARG 0.99 101 39,594,851 1,541,041
5 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Armenia 2013 1.000 ARM 0.24 5 1,566,443 71,210
6 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Australia 2013 0.040 AUS 0.72 23 12,304,439 433,296
7 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Austria 2013 0.042 AUT 0.72 17 10,684,537 348,646
8 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Azerbaijan 2013 0.203 AZE 0.30 7 2,177,042 102,542
9 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Belgium 2013 0.038 BEL 0.78 45 24,745,206 858,459
10 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Bangladesh 2013 0.150 BGD 0.37 4 2,815,679 86,545
11 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Bulgaria 2013 0.198 BGR 0.65 6 2,365,279 77,632
12 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Bahamas 2013 0.310 BHS 0.59 4 2,593,368 57,011
13 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Bosnia and Herzegovina 2013 0.334 BIH 0.14 4 2,179,743 59,357
14 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Belarus 2013 0.342 BLR 0.63 3 2,274,192 59,085
15 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Belize 2013 1.000 BLZ 0.69 3 2,098,870 32,847
16 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Bolivia 2013 0.354 BOL 0.90 55 22,188,575 155,126
17 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Barbados 2013 1.000 BRB 0.70 2 2,793,569 27,425
18 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Botswana 2013 0.570 BWA 0.42 6 1,760,771 73,274
19 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Canada 2013 0.078 CAN 0.82 128 28,301,663 1,630,091
20 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Switzerland 2013 0.099 CHE 0.83 63 57,927,900 1,283,439
21 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Chile 2013 0.807 CHL 0.97 16 22,364,087 332,340
22 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 China 2013 1.000 CHN 1.00 58 70,307,946 1,121,159
23 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Cameroon 2013 0.187 CMR 0.63 5 2,398,407 79,585
24 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Congo 2013 0.271 COG 0.52 5 2,592,635 60,086
25 pedrofeliu 30/06/2025 11:13 pedrofeliu 30/06/2025 11:13 Colombia 2013 0.809 COL 0.96 33 9,772,420 579,039
Variable Name Description
wdt_ID wdt_created_by wdt_created_at wdt_last_edited_by wdt_last_edited_at Variable Name Description
1 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 country Country name in English
2 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 year Year
3 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 efficiency_index Diplomatic Efficiency Index estimated via dynamic DEA
4 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 isoa3 ISO 3 country code
5 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 fpi Foreign Policy Index
6 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 employees Number of diplomatic staff (sum) in the country
7 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 embassy Expenditure in reais deflated in diplomatic representations by country (sum)
8 pedrofeliu 30/06/2025 16:01 pedrofeliu 30/06/2025 16:01 salary Expenditure in reais deflated of the salaries of diplomatic staff in diplomatic representations by country (sum)

Feliu Ribeiro, P. (2024). POLEN (v1.01) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.14015246. Avaiable at: polen.iri.usp.br

Click the link below to download the commands in R