La Drupalera

based on Apache and Apache Jena Fuseki Stanbol for the improvement of the Solr data.

business objectives of the website were met. After that we developed, through the use of Drupal, a promotional and public website: a digital workspace for young entrepreneurs, a Facebook application and a control panel to evaluate and manage the ideas for the staff of the project Think Big.

SEO (strategy and technique).

Technical level: the biggest challenge was undoubtedly the migration of millions of records and multimedia material generated by the Tourism Agency by different agents: news, places, events, accommodation, etc. We also highlight the software architecture and site performance optimization with more than 500,000 visits per month. Finally, the integration of different information systems.

processes and services which were not being used.

We provided recommendations for the configuration of the different services they used:

• Varnish: we analysed the URLs to be cached and proposed a list of new URLs that could be cached without any problem
• Apache: It was badly configured which only allowed only 15 requests per node. 
• Redis: We gave some guidelines in order to improve its performance.
• MySQL: We provided a more suitable configuration for its current use, working on caches and slow queries.

We performed an audit at Drupal Development level:

• Recommendation of a development flow based on GitFlow and with continuous integration to avoid large misalignments between development, preproduction and production environments.
• Control of the drupal_http_request function for requests to external subsystems
• Security breaches
• Incorrect permissions on important Drupal files. 
• Updating of modules, with priority given to security updates.
• Coding errors

engage in social action, develop digital skills and gain the self-confidence necessary to get ahead in the job market. 

Maintenance costs were reduced by 30%.

Improved user experience and satisfaction.

infrastructure in Amazon, where we adapted all its services to Drupal (both Drupal6 and Drupal7). AWS was chosen as a cloud infrastructure provider to ensure high availability and quality performance.

We used cache layers to lighten the load of web servers and database; high availability (redundancy of all services) to avoid possible system crashes; AWS self-scaling to horizontal growth; and CDN (Akamai in our case) to download all the multimedia content and their services.

Once the process of creating the infrastructure and migration of contents (source code, files, database, configuration files ...) was finished, we had to orchestrate the deployment and upload of new improvements to the different environments.

To achieve this, we created a new workflow, based on GitFlow and continuous integration: Git, Drush and Jenkins were the basic tools on which we relied.

the aim of aligning ideas and strategies with the client's team and also unifying the graphic line of Sevilla FC towards the Digital Media, content workbooks and style guides were created and a Branded Content strategy was created. 

From Communication to Content Marketing

Starting from the analysis of the structure and typology of publications, the evolution of channels from mere Communication to Digital Marketing and Digital Content Marketing was established as a starting point for strategical improvement and standardization. Web Analytics, Content Curation and Inbound Marketing

SMO and SEO

In order to keep improving both the traffic acquisition strategies and audience growth objectives, an analysis and proposal for the writing of content focused on SEO and search engines marketing applicable to the social channels of the main search engine worldwide -Google + and Youtube- were made.