11

I know that some Stack Exchange sites (e.g. Writing) have community ads that they submit on other sites (example below). Is there a list of all such SE sites? I assume based on past questions that there isn't a list of all community ads. I am looking for a list (not necessarily comprehensive), of all SE sites with these promotional community ads. Quoting @Catija "sites that create community ads for themselves and post them on other sites' metas."

enter image description here

Improve this question
6
  • 1
    So, there's two sides to this - first, the sites that host these ads - all "graduated" sites are able to host community ads (for example)... second, sites that create community ads for themselves and post them on other sites' metas... that list is ... going to be difficult to create. Which is it you want?
    – Catija StaffMod
    Commented May 21, 2019 at 5:04
  • @Catija Good point! Either would be fine. I prefer the second, but I understand the difficulties in making such a list.
    – Barry Harrison
    Commented May 21, 2019 at 5:11
  • 1
    I originally understood your question backwards, but I think I've managed to write another SEDE query for your intended purpose, see below.
    – Glorfindel Mod
    Commented May 21, 2019 at 15:35
  • 1
    That's very generous of you, but let me do some additional research first to make sure the query covers everything. It assumes a very specific format of the post (which is typical of Community Ads), if somebody manages to deviate the query might miss the instance.
    – Glorfindel Mod
    Commented May 21, 2019 at 20:12
  • 1
    I've now updated the query and found a few more instances.
    – Glorfindel Mod
    Commented May 22, 2019 at 8:35
  • Thanks to all users for the edits that have significantly improved an originally ambiguous question.
    – Barry Harrison
    Commented May 27, 2019 at 5:33

2 Answers 2

Reset to default
11
+150

I originally understood your question backwards, but here is a SEDE query which tries to extract the links to sites. Only direct links to sites count, like this one in the example you mentioned. There are currently 27 sites doing this, some on multiple sister sites:

enter image description here

To make sure all links are considered (sometimes, they use a trailing slash, sometimes not; some links are still HTTP instead of HTTPS), I've wrote another SEDE query which lists all links and another one for the few ads which don't satisfy the format.

If you just want to browse all posts of a certain year, here is a cross-database SEDE query listing all questions.

enter image description here

SEDE is updated once a week on Sunday morning, but that should be sufficient for this specific purpose.

Improve this answer
2
  • That query doesn't look too bad. You are lucky the format to expect is rather strict.
    – rene Mod
    Commented May 21, 2019 at 15:59
  • Otherwise I wouldn't even try (with SEDE; maybe the API + some custom logic would work).
    – Glorfindel Mod
    Commented May 21, 2019 at 16:03
4

You can easily get a list of all community ad answers that link to Stack Exchange sites via several global searches:

You can cut down the number of results shown in these searches by adding title:2019, which will only return the current ads or score:6.., which will only return the ads which have enough score to actually be shown as ads.

Improve this answer
1
  • Thanks for sharing! Looks like it will be a long process to get a complete list.
    – Barry Harrison
    Commented May 21, 2019 at 5:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .