1. Home
  2. Docs
  3. My Click Boss Pro – Professional Version 2 – Users Manual
  4. Pass Through Data Handling
  5. Pass Through Query Builder Language

Pass Through Query Builder Language

Here is a list of the pass through query builder language variables that can be used when construction a pass through query string to be appended to an outbound exit link.

These are basically placeholders. When a click goes to an exit link that contains any of these, they are replaced with real data that was sent to the click tracker or rotator. Some placeholders are replaced with data about the click tracker, rotator or rotator link.

NOTE: Please be fully aware that when building a query string it can’t contain any spaces. This includes the data that will be used when replacing a placeholder with data. If you absolutely have to pass a space, the data must be encoded first.

All pass through placeholders start and end with two percentage signs.

%%qstringraw%%

This placeholder passes the entire query string to the exit URL.

For example, if a click tracker or rotator was sent the following query string:

?a=12345&sid=123&cpa=oto3

This place holder would be replaced in the outgoing exit URL with:

a=12345&sid=123&cpa=oto3

Please note that the click tracker or rotator code is also passed as in the example above.

%%qstring%%

This placeholder passes the entire query string minus the click tracker or rotator code portion of the query string to the exit URL.

For example, if a click tracker or rotator was sent the following query string:

?a=12345&sid=123&cpa=oto3

This place holder would be replaced in the outgoing exit URL with:

sid=123&cpa=oto3

Notice how the a= click tracker or rotator code was not passed?

%%sid%%

This placeholder would be replaced with the value of the sid (sub ID) key if it is found in the incoming query string.

For example, if a click tracker or rotator was sent the following query string:

?a=12345&sid=123&cpa=oto3

This place holder would be replaced in the outgoing exit URL with:

123

Note that only the value is inserted. The key is not passed on to the outgoing exit URL. If you want to pass the sid= portion just hard code that into your query link. Here is an example.

The following placeholder and code:

sid=%%sid%%

Using the above query string example would become:

sid=123

If the destination URL expects this value to have a different key name, you can hardcode that name in instead of sid. For example.

cpaid=%%sid%%

Would become:

cpaid=123

%%special=keyname%%

The best way to explain how this placeholder is used is to show an example.

Let’s say the following query string is passed to a click tracker or rotator.

?a=12345&sid=123&cpa=oto3

And you want to pass the cpa=oto3 to the exit destination URL.

You would create the following placeholder.

%%special=cpa%%

This placeholder would be replaced with.

oto3

So, if you wanted to pass both the key and value you could hard code it like.

cpa=%%special=cpa%%

In this example, it would pass.

cpa=oto3

You can create and use as many %%special=keyname%% placeholders as you need. Just replace keyname with the key you want to pass through.

%%clicktrackercode%%

This placeholder would be replaced with the click trackers code.

For example, if a click tracker or rotator was sent the following query string:

?a=12345&sid=123&cpa=oto3

This place holder would be replaced in the outgoing exit URL with:

12345

Note that only the value is inserted. The key is not passed on to the outgoing exit URL. If you want to pass the a= portion just hard code that into your query link. Here is an example.

The following placeholder and code:

a=%%clicktrackercode%%

Using the above query string example would become:

a=12345

If the destination URL expects this value to have a different key name, you can hard code that name in instead of a. For example.

cpapt=%%clicktrackercode%%

Would become:

cpapt=12345

%%rotatorrcode%%

This placeholder would be replaced with the rotators code.

For example, if a click tracker or rotator was sent the following query string:

?a=12345&sid=123&cpa=oto3

This place holder would be replaced in the outgoing exit URL with:

12345

Note that only the value is inserted. The key is not passed on to the outgoing exit URL. If you want to pass the a= portion just hard code that into your query link. Here is an example.

The following placeholder and code:

a=%%rotatorrcode%%

Using the above query string example would become:

a=12345

If the destination URL expects this value to have a different key name, you can hard code that name in instead of a. For example.

cpapt=%%rotatorrcode%%

Would become:

cpapt=12345

%%clicktrackerid%%

This placeholder would be replaced with the click trackers internal ID used by My Click Boss Pro.

%%rotaotrlinkid%%

This placeholder would be replaced with the rotators link internal ID used by My Click Boss Pro.

%%rotatorid%%

This placeholder would be replaced with the rotators internal ID used by My Click Boss Pro.

Was this article helpful to you? Yes No