![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-1-300x128.gif\")
<\/p>\nThe majority of competing advertisers in your niche target the same audiences as you do. That\u2019s a fact. Everyone is competing in the same auctions causing high CPMs and audience fatigue. But what if you could target \u201chidden\u201d audiences that no one is targeting yet?<\/p>\n
<\/p>\n
Let\u2019s deep dive into it.<\/p>\n
Let\u2019s say your \u201cideal client\u201d is interested in Golf. You then want to target Golf & related interests. You create a new campaign, set up your ad set then have to choose interests to target.<\/p>\n
By default, Facebook retrieves 15 to 20 interest or additional interest.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-2.png\")
<\/p>\n
However, it pulls out the same results for every advertiser! Then you spend hours manually looking for additional interests…<\/p>\n
There are of course more related interests than the 15 to 20 interests Facebook shows you in the interface. What if you could access the entire interests and additional interests list?<\/p>\n
That\u2019s where the Facebook API enters into play.<\/strong><\/p>\n Let\u2019s have a look at our \u201cGolf\u201d interests retrieved from the API:<\/p>\n https:\/\/graph.facebook.com\/search?type=adinterest&q=[Golf<\/strong>]&limit=10000&locale=fr_BE<\/strong>&access_token=API-token<\/strong><\/p>\n Enter this URL in your browser and you’ll see something similar to the screenshot below (replace API-token by your own token. We’re explaining how to get it further down in the article).<\/p>\n You can see a huge list of interests related to your main theme. But let\u2019s face it, it\u2019s not very reader-friendly or easy to use. In this article, we\u2019ll explain how to easily get these results into a more user-friendly Excel file.<\/p>\n By using this method, we can for example find the \u201cEuropean PGA Tour\u201d and\u00a0 \u201cTiger Woods\u201d interests that Facebook initially didn\u2019t suggest and we didn\u2019t think of. From here, you could add other Golf stars as targeting such as \u201cRory McIlroy\u201d and other PGA tours.<\/p>\n Side note: The API doesn\u2019t return an output for each and every interest. In some cases, no additional suggestions will be returned. Additionally, the API results, for some reason, don\u2019t always contain all of the suggestions made in the interface. The result of the API call that shows you all of the suggested or related targeting options are unfortunately not very readable. Let\u2019s change that in 2 simple steps :<\/p>\n You need to create a developer account<\/a> Once your account is created, you have to create what Facebook calls an \u201capp\u201d in your developer account. This will create the access token that you need to access the API to retrieve your \u201chidden interests\u201d.<\/p>\n Once your app is created, you can find your access token over here:\u00a0https:\/\/developers.facebook.com\/tools\/accesstoken\/<\/p>\n This should look like this (use the User Token):<\/p>\n To be able to pull out the data into an easily readable excel sheet, we\u2019ll use a script CLICKTRUST is providing to you today.<\/p>\n We will use the R language and R Studio, both of which you\u2019ll need to install on your computer:<\/p>\n But no worries, you don\u2019t need any developer skills to do so, we have already created everything for you!<\/p>\n Once installed, open RStudio. You should see something similar to this.<\/p>\n The folder you create your project in will be the \u201cworking directory\u201d. This is also the folder in which we\u2019ll store the excel files that contain the API outputs.<\/p>\n Once your project is created, go to File > New File > R Script. The left hand side of the RStudio interface should now display two zones:<\/p>\n First, you need to install packages in R-Studio.<\/p>\n Packages are collections of R functions, data, and compiled code in a well-defined format. The directory where packages are stored is called the library. R comes with a standard set of packages. Others are available for download and installation. Once installed, they have to be loaded into the session to be used.<\/p>\n From https:\/\/www.statmethods.net\/interface\/packages.html<\/p>\n <\/p><\/blockquote>\n As you can read above, packages are used to build onto the default functionalities of the R language and will be used in most scripts.<\/p>\n To install a package, enter the following command in the console:<\/p>\n install.packages(\u201cpackagename\u201d)<\/p><\/blockquote>\n <\/p>\n To load a package enter the following command in the console:<\/p>\n library(packagename)<\/p><\/blockquote>\n <\/p>\n However, as each time you\u2019ll run the script you\u2019ll need to load the packages, it\u2019s better to enter these commands into the script file (see full script later). As packages are installed on your computer, there\u2019s no need to install them every time you run the script.<\/p>\n Instead of installing all packages separately, enter the following command into the console to install all necessary packages with one line of code:<\/p>\n install.packages(c(“jsonlite”, “readxl”, “writexl”, \u201curltools\u201d))<\/p><\/blockquote>\n <\/p>\n Once this process is completed, you can paste the script code in the script zone of Rstudio. With a few modifications, you can get all of the suggested interests from the hard-to-read JSON format into a readable, sortable and filterable Excel file.<\/p>\n We will not be going over each individual part of the code, only the parts that need modification.<\/p>\n You can find the script code below:<\/p>\n library(jsonlite) token <- “EAAsXdpZApFWyvW1tm8jXOnqsV1JSf” # locale is listed as ll_CC interestsUrl <- paste(“https:\/\/graph.facebook.com\/search?type=adinterest&q=[“,adinterest,”]”, print(interestsUrl)<\/p>\n interests <- fromJSON(interestsUrl) relatedInterestsUrl <- paste(“https:\/\/graph.facebook.com\/search?type=adinterestsuggestion&interest_list=[%22″,adinterest,”%22]”, Relinterests <- fromJSON(relatedInterestsUrl) pathname <- paste(adinterest,” – “,locale,”.xlsx”, sep =””) list_of_datasets <- list(“Interests” = interests, “Related Interests” = Relinterests) <\/p><\/blockquote>\n To quickly find the lines of code that need editing, look for the numbers in the left-hand sidebar.<\/p>\n On line 6<\/strong>, enter your API token. It\u2019ll be much longer than the one shown in the example below.<\/p>\n On line 7<\/strong>, enter the maximum amount of results you want to extract. In general, you can leave this at 10000.<\/p>\n On line 12, enter the locale for which you want to find related interests. The example above will return interests for Belgium in Dutch. (fr_fr, en_us,..)<\/p>\n On line 13, enter the interest category for which you want to find more targeting ideas.<\/p>\n That\u2019s it! That\u2019s all of the code-editing that\u2019s needed.<\/p>\n The rest of the code will make calls to the API URLs shown above and put the results in an excel format in your working directory. The file names will include the interest and locale for easy reference.<\/p>\n But let\u2019s save the script first! Press the save button marked in the screenshot below, give the script file a name and save it in the working directory.<\/p>\n Next, press the source button and the entire script will run, get the API results and save an excel file in the working directory.<\/p>\n There you go! All interests and their audience size directly in an excel sheet ready to use.<\/p>\n You only have to edit line 12 and\/or 13 if you want to run it for another interest category and press \u201cSource\u201d again.<\/p>\n [vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none”…<\/p>\n","protected":false},"author":20,"featured_media":42670,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"two_page_speed":[],"footnotes":""},"categories":[178],"tags":[259],"level":[199],"class_list":{"0":"post-38903","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ppc","8":"tag-facebook-fr","9":"level-channel-specialist-fr"},"acf":[],"yoast_head":"\n![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-3.png\")
<\/p>\n
\nAs a result, we suggest using both the interface suggestions and the results from API calls (if any) to find the ideal interest targeting for your campaigns.<\/p>\nHow to retrieve related interests and make the results reader-friendly?<\/h2>\n
\n
1) Create a Facebook API key.<\/h3>\n
\nIt\u2019s totally free and takes 1 minute to setup.<\/p>\n![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-4.png\")
<\/p>\n2) Making an RStudio project<\/h3>\n
\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-5-1024x746.png\")
\nNext, go to File > New Project and create your new project in an existing folder (= Directory) or create a new folder for this project.<\/p>\n![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-6.png\")
<\/p>\n\n
\nYou can recognize this by the numbers in the sidebar indicating the lines of code. These will make it easy to search and find specific lines of code you\u2019ll have to edit later.<\/li>\n
\nThis zone was already visible before you created the R script file. In the console, you can also enter lines of code, however, you can only run one line at a time (in the script zone, you can run multiple lines in sequence). For example, try entering \u201cgetwd()\u201d in the console (without the \u201c…\u201d). The console will return the working directory (= the folder where you created the project)<\/li>\n<\/ul>\n![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-7.png\")
<\/p>\n3) Installing packages<\/h3>\n
4) Installing the script<\/h3>\n
\nlibrary(readxl)
\nlibrary(writexl)
\nlibrary(urltools)<\/p>\n
\nlimit <- 10000<\/p>\n
\n# ll being langauge (lower case)
\n# CC being country (upper case)
\nlocale <- “fr_BE”
\nadinterest <- url_encode(“Golf”)<\/p>\n
\n“&limit=”,limit,
\n“&locale=”,locale,
\n“&access_token=”,token,
\nsep=””)<\/p>\n
\ninterests <- as.data.frame(interests)<\/p>\n
\n“&limit=”,limit,
\n“&locale=”,locale,
\n“&access_token=”,token,
\nsep=””)<\/p>\n
\nRelinterests <- as.data.frame(Relinterests)<\/p>\n
\nrequire(openxlsx)<\/p>\n
\nwrite.xlsx(list_of_datasets, file = pathname)<\/p>\n5) Adjusting the code<\/h3>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-8.png\")
<\/p>\n![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-9.png\")
<\/p>\n6) Run the script<\/h3>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-10.png\")
<\/p>\n![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Find-hidden-interests-in-facebook-ads-11.png\")
[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][nectar_global_section id=”31229″][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"