How to add keyword URLs to Baidu bidding?

L coding is a data statistics and monitoring technique commonly used in bidding promotions. It is convenient to count the conversion effect.

1. How to add URL parameters

Bidding promotion mainly monitors several sources, namely through accounts, platforms, plans, and keywords. Once a conversation occurs, we can easily know from which dimension the conversion is brought about.

The settings are as shown below:

Explanation: from=bd means it comes from the bd account. If Baidu has multiple accounts, you can set bd1, bd2, bd3 respectively. Similarly, if you are monitoring 360 or Sogou, you can change to different codes.

Explanation: kw=2898, this is the unique code of the keyword. It can be produced very conveniently in EXCEL. Specific operations:

Copy all the keywords in the assistant into the table. Add &kw=1 to the URL and then scroll down to the bottom, a progressive code will be generated, thus ensuring the uniqueness of the keyword code.

Explanation: jh=syjg, this is the code of the plan, which can be represented by numbers or letters, and can be named arbitrarily (it must be unique)

Explanation: ly=PC&YD, which distinguishes between mobile and computer terminals.

2. How to use URL encoding

Because an account may have thousands or even hundreds of thousands of keywords, it is impossible to remove them one by one in the face of such a large number of keywords.

Search in the household. So we can perform batch operations through commands in several tables.

Step 1: Export the conversation records from the consulting tool and sort the first-visit URLs.

Step 2: Use the COUNTIF command to find the number of conversions of the code (this change can be a plan or a keyword. It depends on what dimension of effect you want to count).

Step 3: Export the consumption data for the same period of time to a table. You can copy it directly from Baidu Assistant.

Step 4: Use the VLOOKUP command to find the conversion quantity of the corresponding code. In this way, the conversion effect of keywords or plans can be counted.

3. How to analyze statistical effects

After the effect data is statistically analyzed, the data needs to be sorted. The most basic thing is to calculate the conversion rate and conversion cost.

The entire analysis can utilize the methods of increasing revenue and reducing costs, and can perform volume increase and decrease operations based on conversion data. Good results are achieved by increasing volume, while poor results are achieved by collecting volume.

When controlling traffic, it is necessary to make adjustments based on keyword click price, display, click volume, matching, search terms and other data. Different words will have different optimization methods.