Create a spreadsheet formula for us

  • Status: Closed
  • Prize: $250
  • Entries Received: 18
  • Winner: yhf8377

Contest Brief

About Footway

Footway.com is an online shoe store active in 11 European markets. With over 30 000 models and 600 brands we have shoes for every occasion. Our values fun, friend and customer are in everything we do.

About the contest

At Footway we manage 11 different sites and 9 languages. This means a lot of work every time we launch a campaign. This contest is about creating the best google spreadsheet solution to collect static words and build ready-to-go copy for different channels.

The goal is that Footway only has to fill out the campaign offer, and your great spreadsheet formula will deliver copy in all languages.

We have the static words already in each language. You only have to create the best solution for this. The best idea and or spreadsheet formula will win this contest.

Provide your idea as a pdf and the best idea will win.

Example

Footway is having a sale for 20% on more than 20,000 shoes.

We want to open the spreadsheet and only fill out four columns (or less if your idea would provide that).

A) The % of the sale
B) The number of shoes
C) The name of the sale (i.e. “Summer Sale” or “Black Friday)
D) The type of shoes or brand that are on sale (could be all shoes, or maybe just a sneaker sale)

Based on this information, your formula will collect the words for each language that is needed to build copy. Then it will present copy for different channels and languages based on criterias like maximum characters, headlines and image copy.

Be advised that since this is about text, the exact same structure probably can’t be used on all languages since the grammatical structure is different.

For example in English we write “25% Sale at Footway” and in french we write “Solde de 25 % sur Footway”, which means that the %-sign is placed on different positions in the sentence. We can’t demand you to know all languages, but please include this in your idea.

About the contest
At Footway we manage 11 different sites and 9 languages. This means a lot of work every time we launch a campaign. This contest is about creating the best google spreadsheet solution to collect static words and build ready-to-go copy for different channels.

Good luck!

Feedback
We have very limited capacity to answer questions or give individual feedback during the project, instead we will give collective feedback - this will then hopefully help you get a better understanding of what we are looking for.

Recommended Skills

Winner
Featured Contest
Post a Contest Like This

Employer Feedback

“Frank Y is very easy to work with. He follows instructions, communicates well and often, and always responds to feedback. I really recommend working with him.”

Profile image alexanderaberg, Sweden.

Top entries from this contest

View More Entries

Public Clarification Board

  • sarahmuhammad571
    sarahmuhammad571
    • 5 years ago

    There are many template also available here for business purpose...just we have to rewrite IN ANY LANGUAGE , formula remains same...and we can collect data from100s of sales on the same format.and with same calculations..:) Available online for further assistance .. visit my PORTFOLIO and my profile for my previous experience.

    • 5 years ago
  • sarahmuhammad571
    sarahmuhammad571
    • 5 years ago

    Hello there...I am going to submit a formula for ...but unable to submit though the contest timee is still not over ...

    • 5 years ago
  • alexanderaberg
    Contest Holder
    • 5 years ago

    I see some great entries, but also some "lazy" ones. Please remember that if you make your formula adaptable and easy to scale, you have a higher chance of winning.

    We won't write "Footway has a sale of X % on X amount of shoes" every time we have a sale.

    The more dynamic and flexible your formula is, the better.

    • 5 years ago
  • sarahmuhammad571
    sarahmuhammad571
    • 5 years ago

    Ok

    • 5 years ago
    1. alexanderaberg
      Contest Holder
      • 5 years ago

      Ok

      • 5 years ago
  • yhf8377
    yhf8377
    • 5 years ago

    Hi. Do you have a fixed sentence structure for your campaign message? For example, will it always be something like "20% off Black Friday sale on over 3,000 types of shoes!"? It will be more difficult if the message need to be free-form, so I'd like to have some clarification on this part.

    • 5 years ago
    1. alexanderaberg
      Contest Holder
      • 5 years ago

      Most of the time yes. The more scalable and adaptable the formula is, the better.

      • 5 years ago
  • Ravikiranhyd
    Ravikiranhyd
    • 5 years ago

    I am assuming that all the parameters (type of sale - winter sale/black friday, %, discount, no of footwear, brand) would not be present in each sale. Would that be a fair assumption?

    • 5 years ago
    1. alexanderaberg
      Contest Holder
      • 5 years ago

      Correct.

      • 5 years ago
  • alexanderaberg
    Contest Holder
    • 5 years ago

    Thanks everyone so far. A quick message: please don't involve google translate. This service is not good enough for campaign copy.

    We will provide the winner with all the words that are needed. Just focus on building the smartest and most effective formula for our purpose.

    At Footway we LOVE simplicity so try to keep things simple. Don't overcomplicate.

    Thank you.

    • 5 years ago
    1. tushartufan
      tushartufan
      • 5 years ago

      I figured out the formula. Just need the words to fill it up. No auto translate from google.

      • 5 years ago
  • valespasovska111
    valespasovska111
    • 5 years ago

    I'm interested to offer my idea for this contest and I have a question about the spreadsheet. Do you need all the "used" languages in one sheet?

    • 5 years ago
    1. alexanderaberg
      Contest Holder
      • 5 years ago

      In one google spreadsheet document yes. But it is okay to to have several sheets within that document.

      • 5 years ago
  • rachelmconnor
    rachelmconnor
    • 5 years ago

    Hi! I can build you a spreadsheet that meets the requirements you outlined - are you able to provide the list of static words in each language?

    • 5 years ago
    1. alexanderaberg
      Contest Holder
      • 5 years ago

      The static words can change and are not set in stone yet so just focus on the idea behind the structure. Don't worry about the words just yet.

      • 5 years ago
  • ExplorFreelancer
    ExplorFreelancer
    • 5 years ago

    I can do easily 12 no. Because I was working more data entry of more countries.

    • 5 years ago
    1. alexanderaberg
      Contest Holder
      • 5 years ago

      I don't understand. What do you mean with 12?

      • 5 years ago
  • Milon4646
    Milon4646
    • 5 years ago

    please give me one work, and one chance.

    • 5 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!