How do I segment my SEO traffic by keyword?
Solution
- Marketing Mix Modeling
- Attribution
- Analytics
- Activation
Module
- Pilot & Analyze
- To plan
- Enable
- Data mining
- Privacy Center
Problematic
For several years, search engines, particularly Google, have reduced the visibility and sharing of data regarding keywords used by internet users to access websites. As a result, marketers have less information about the specific queries that generate organic traffic to their sites.
Objective
This guide presents a solution developed by Eulerian that allows its clients to regain visibility with respect to the keywords used by internet users in the context of organic traffic from search engines.
Difficulty
Simple
Intermediate
Advanced
The solution
Eulerian allows you to upload a csv file containing the URLs of your site to which you wish to associate one or more keywords .
Thus, each time a user arrives on your site through organic search, we refer to the uploaded mapping table to impact the right keywords based on the landing page.
Furthermore, it is possible to declare multiple keywords per URL , assigning them different weights. This will allow you to distribute traffic across the selected keywords based on the weight you have assigned them.
Set up
Step 1: Add the "Eulerian SEO Not Provided" connector
Path : Collection > Media Collection > Budget Connectors > Add a new connector >
Eulerian - SEO Not Provided
Step 2: Understanding the connector configuration
After confirming the creation of the connector, a new window appears:
1- Indicates the frequency of data updates ( daily )
2- Indicate the API endpoint that allows purging an existing table
3- Indicate the Endpoint API that allows you to upload your URL file.
Step 3: Build the URL file
Downloadable template :
Description of the url + regex template :
The header in the example below is provided for illustrative purposes only. It should not be included in the uploaded file.
Description of the url + regex template :
The header in the example below is provided for illustrative purposes only. It should not be included in the uploaded file.
Google
/cat/clothing
garment
50
Google
/cat/clothing
brand
50
Google
/universe/clothing/trousers
pants
100
Bing
/universe/shoes
shoe
100
Bing
/universe/cat
shoe
80
- Search engine : The two possible values are Google and Bing.
- URL : two types of values can be provided (choose one):
- A regular expression that matches the URL of the landing page where the user begins their visit in organic search. Multiple patterns can match the same URL. Limit = 2,000 entries.
- Raw URL value (without scheme/CGI parameters/anchor). Limit = 100,000 entries
- Page path: the page path must be provided in this column
Warning : You cannot fill in both the "URL" and "Page Path" columns in the same file. Only one of these columns should be completed.
- Keyword : Keyword impacted by the rule.
- Weight : The maximum weight for a keyword is 100.
- It is possible to declare multiple keywords per URL. Traffic will be distributed across the different keywords according to the weight you assign to them. Weight is a share of voice (a percentage) that can be defined between 0 and 100.
- The sum of the keyword weights can be equal to, less than, or greater than 100. We recalculate the ratio on our end.
Scenario: with the upload of the table presented above, 50% of users who start their visit on the page http://www.client.com/cat/vetement from Google in SEO will be assigned the keyword “vetement” and the other half will be assigned the keyword “marque”.
Step 4: Making the file available
Below is an example of a curl command to upload your file and automate its sending:
Syntax:
Example :curl -F file-name=@$nom_fichier.csv https://$domaine_api/ea/v2/$token_api/epc/$nom_site/seonp/upload.json
curl -F file-name=@filetestseo.csv https://et2.api.eulerian.com/ea/v2/QV.tEbjPNGLjgHPax6VWH_.66S767LgcsuHCOBSlNYIxHse9Xw--/epc/testlab/seonp/upload.json