· IMO, I think you might get more mileage out of advertising on Adwords than by affiliate marketing.
· Also, I think you need to get the word 'course' into your titles and keyword-phrases.
Eg. 'Madrid One Day Photography Course and Tour'
· You need to explain more about the course/tour. What hour does it start?? Can two adults share the camera and pay just 150€? Is the route, course and restaurant suitable for children? Will they get bored? Can a girlfriend/boyfriend just go shopping and meet you all later at the restaurant? Where do you go roughly? How many photo opportunities are there? How far do we walk in those four hours? Where's the restaurant? What's the menu like? How do I get from there back to my hotel? How late back will I be?
I think the main ways your prospects will find you are:
1) Whilst booking their trip, they are served your advert on the travel site
2) The 'brick and mortar' travel agent where they live promotes your excursion as part of a short break or city break package. I don't know how this is set-up, but I have a friend who does a 'swimming-training vacation' who gets most of his clients (bus loads of them) through a travel agency. Another friend tried a sport/fitness holiday but relied 100% on his website, and it failed miserably, so be warned.
3) Before or after booking, whilst planning their trip, they search for something like 'things to do in madrid' and see your ad/review/entry on a site like viator.com, mydestination.com, tripadvisor.com, or gomadrid.com. You'd need to think of several search terms your prospects might use, and approach the top sites to see how you can get a presence on them. They won't do it per lead though - you'll need to blow some cash finding out which searches/sites bring positive return on your investment. Find the sites your competition is advertising on - they may have already found some winning sites for you.
4) They get to Madrid and the first thing they do is go collect leaflets at the nearest tourist information point.
5) They see your leaflet somewhere else - a restaurant, at another excursion (is it possible to network with any other activity providers?), in their hotel lobby (some hotels have catalogues patrons can browse through), etc.
Personally I think most of your prospects will come to you through the offline routes, and that is where you should put 80-90% of your effort. In fact, I'd put all of my effort into that until I had a comfortable business going, *then* I'd reinvest some cash into online advertising, to see if I could get some good return from it.
I also think a lot of people will be coming to you on a whim, rather than having a conversation with you by email before their trip. So you should be able to take people on a tour with a minimum of fuss or pre-arrangement - a simple telephone call or text should be enough to book. Or even better, if they can just turn up at the start of the tour at a certain day/time.