1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Matching Specific Ad Based On Various Filters

Discussion in 'Programming' started by Kuna, Sep 26, 2020.

  1. #1
    Hi, I need a little help with someting I’d like to implement, but not sure how to do it.

    I’m running eBay like classifieds site. There are a lot of filters on my site e.g. you can filter ads by price, by category, by city, by condition…
    Let’s say we have this use case:

    • User is able to filter ads on my site using filters
    • Once he does it he can save those filters and subscribe to get push notification when someone submits an ad that matches those filters
    • I save those filters in my database for that user
    For this example let’s say my site has around 100k active subscriptions.

    The first step is obviously to attack a place in a code where ad is being saved to the database. I’m having a problem with how to know if that specific ad matches those filters.

    I would need to go through 100k subscriptions and their filters to know which filter matches the ad that has been posted. It doesn’t sound too good for me, it could be 1M filters or more.

    Can someone help me with that or at least point me to the right direction.

    This is basic version.

    Filters:

    1. country, county, city
    2. min price, max price
    3. condition (new,old…)
    4. ads with/without picture
    User A subscribed to set of filters:

    1. England, London
    2. Min price: 200 €
    3. X
    4. X
    User B subscribed to set of filters:

    1. England
    2. Max Price: 500€
    3. New
    4. X
    User C subscribed to set of filters:

    1. Germany
    2. Min price: 200 €
    3. X
    4. With pictures
    User X submitted ad with following data:
    City: London
    Price: 300 €
    Condition: New

    In this case User A and User B need to get push notification because ad matches their filters.
    SEMrush
     
    Kuna, Sep 26, 2020 IP
    SEMrush