As Christmas approaches, we have decided to modernize our marketing campaign in order to increase our sales. The OnlineRetail.com is an amazon like company created 2 years ago which sale a broad range of article online. However, we face issues to get known and spend a lot of money in useless marketing campaign (non-targeted ad on Facebook, mass email campaigns to our current customers). With the lockdown of Europe, we deeply believe in the fact that children and young active person will be willing to buy videogames for Christmas.
Our website looks attractive for customer in term of home appliance and home furniture (we have 13% of market share in France). Unfortunately, when customers seek a videogame, they go to Cdiscount or even worst, the diabolic Amazon.
To solve that big problem and develop our business on the videogame segment, we want to create a marketing campaign highly targeted toward videogame player so that each of them will know that OnlineRetail.com is the best place to find the game they need. We also want to develop our B2B business side by retailing games to smaller distributors.
The action plan
Until now, we were keeping a track of our previous sales into a spreadsheet. This method is outdated, we need now to use databases! Databases enable to store, modify, access and delate a large amount of data. To manage a database, we are selected Firebase which is a service from google that enable to host a NoSQL database. The advantage of this service is that data can be accessed by many users from anywhere with an internet access and is flexible. We are going to first create a database of potential customers. These initial data are going to be bought on Facebook. Then, after filtering the list to reach only the videogame lovers.
Step 1:
Create a Firebase and link it to glitch file thanks to the script provided on Firebase.
Step 2:
Download data from facebook from our previous ad campaigns. Here is a tutorial from facebook to help you downloading data:
go to facebook!
On that list of leads, you can find many information. Facebook can give you info about interest of people. Here is an example of my personal interests based on my Facebook account. As you can see, this is a json file. Then you can upload it on a glitch document. Now you know me a little bit more, let’s go to the next step!
To write this project description, I am using a
json generator website
which give random profile. But your goal is to use real data from real leads generated on Facebook.
Step 3:
Create a glitch with a .json file where you will import the data downloaded on Facebook. It could look like that:
In your html file don’t forget to link the JavaScript library, the Firebase language/version and your tab.js that contains your script in JavaScript.
Step 4:
Integrate your data with your leads list to the Firebase by using your script.js tab. You need a pair of firebase references: .ref and .set! You can find others on this link: https://firebase.google.com/docs/web/setup
First you declare a variable as a reference of your database like in the example.
Then, you set the value of this variable with .set by using the data you have collected and that are located into the json tab.
Then, you set the value of this variable with .set by using the data you have collected and that are located into the json tab.
You have now a firebase fulfilled with the data collected through our previous Facebook ad campaign. Note that the name of Corentin has been updated to Cocs with:
Now we want to use this database and filter the profile who like videogames to identify and contact them.
Step 5:
You can use the structure that follows to filter the data. In my example, I have filtered people who love video games and I display their names and emails so that we can contact through a targeted campaign! You can find here the result with my fake data. Take a look to my .js and.json tabs for more info.
Here is a video to explain more in detail how to filter data. To have access to the Firebase that works for real, you need an access, ask one by email!
