Understanding Tracking

[Jojjua]

Hello guys,

i'm having trouble understanding how to properly set up conversion tracking for my campaigns.

Can any good souls out there take 5 minutes of patience and explain it to me, please?

There are 3 subjects on this interaction as far as i understood:

1 - Affiliate network (provides an offerlink)
2- Traffic Source (let's say i'm using Mgid Native ads)
3 - Tracking Software (i'm using Bemob)

Bemob is extremely similar to Voluum so i had to create an "offer" and a "traffic Source".

I know i should ask to my Affiliate Manager for a postback url, but what about the traffic source? (Mgid) What should i set up with them?
If i launch two campaigns each with 5 different ads inside, how can i track the performance of each ad? Should i create as many campaigns as the ads i want to test (in order to generate unique tracking links?)

Sorry..it is just very confusing and i'm new.

thanks

 

[Maxim Denisov]

Hey Jojjua

First of all, let me thank you for choosing BeMob for tracking and optimizing your campaigns.
To track the performance of your each banner within a single campaign, it is required to add a custom parameter in traffic source template.

Feel free to reach out our support team in live chat to set the campaign.
BeMob managers are always glad to assist at any point.

 

[trackingdesk]

Hello guys,

i'm having trouble understanding how to properly set up conversion tracking for my campaigns.

Can any good souls out there take 5 minutes of patience and explain it to me, please?

There are 3 subjects on this interaction as far as i understood:

1 - Affiliate network (provides an offerlink)
2- Traffic Source (let's say i'm using Mgid Native ads)
3 - Tracking Software (i'm using Bemob)

Bemob is extremely similar to Voluum so i had to create an "offer" and a "traffic Source".

I know i should ask to my Affiliate Manager for a postback url, but what about the traffic source? (Mgid) What should i set up with them?
If i launch two campaigns each with 5 different ads inside, how can i track the performance of each ad? Should i create as many campaigns as the ads i want to test (in order to generate unique tracking links?)

Sorry..it is just very confusing and i'm new.

thanks

Hi @Jojjua - I will assume that you are using a landing page (if you're not, then you should definitely consider using one).

Before you can properly setup your tracker, you need to understand the role of each of the elements you are working with:

The Traffic Source:
- Sends traffic to your campaign URL according to settings you've defined in your campaign settings. Geo Target, devices etc...
- The Traffic Source should append to your campaign URL some tokens so you can identify the traffic segments which are generating traffic / conversions / revenues.

The Affiliate Network
- Provides you with offer / offer links
- Track conversions / revenues
- Sends conversion notifications by way of postback URL to your tracker

The Landing page
- Where the traffic will initially arrive from your campaign.
- You can configure it to capture the traffic source tokens or not
- The LP carries your call to action URL, which is meant to redirect visitors to the offer link(s)

The Tracking system: Let's say that you have defined your traffic source tokens as:

Then your campaign URL will look like

http://servedbytrackingdesk.com/cWn6qOtY1nAwLRhJL?utm_source={zone_id}&utm_medium=native&utm_content={category}&utm_term={keyword}&utm_campaign={campaign_id}&click_id={click_id}

When the Traffic Source will send traffic to your URL, all the tokens will be replaced by real campaign values.

http://servedbytrackingdesk.com/cWn6qOtY1nAwLRhJL?utm_source=zone_1234&utm_medium=native&utm_content=software&utm_term=tracking&utm_campaign=cid_8993&click_id=iayusd9fa9sd87f9asd7f9a8sd7f9asd87fa9sd87f

One of the token sent by the traffic source is click_id and it will be later used to track conversions

The tracking software will do a few things:
- Record the visits and all associated values
- Generate a unique click id
- Redirect the visitor to the landing page that has been defined in the campaign (in the tracking software)

Optional:
If your tracking software supports this feature, it can also forward the visits values (keyword etc...) to the landing page URL: This can be useful if you are using google analytics to build audiences for retargeting campaigns.

https://trackingdesk.com/?utm_source=native&utm_source=zone_1234&utm_medium=native&utm_content=software&utm_term=tracking&utm_campaign=cid_8993&click_id=iayusd9fa9sd87f9asd7f9a8sd7f9asd87fa9sd87f&td_eid=01617ed41e34043001000001

When the visitors click on your call to action, they will be redirected to the offer link that has been associated with the landing page.
One Essential action that the tracker should do:
- Redirect the visitor to the offer link
- During the redirect, it should append to the offer link, the click_id generated by the tracking software during the initial visit.

In the example above, you will see at the end of the landing page URL the value: td_eid=01617ed41e34043001000001

It is crucial to understand that every affiliate network or affiliate software records this value in a different query string. This is one of the common mistakes done when you make your first steps with a tracking software.
Examples:
Hasoffers: offerlinnk?aff_sub=01617ed41e34043001000001
Cake: offerlink?s2=01617ed41e34043001000001
peerfly: offerlink?s1=01617ed41e34043001000001
clickbank: offerlink?tid=01617ed41e34043001000001
ytz: offerlink?sub1=01617ed41e34043001000001

When a conversion occurs, a chain of events will happen:
1. The affiliate network will fire your tracking software postback URL while injecting the click_id and the conversion value into predefined placeholders.
Examples:
Hasoffers:
Postback URL with placeholders: https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1?h={aff_sub}&a={payout}
Postback URL where the placeholders have been filled with the conversion values:
https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1?h=01617ed41e34043001000001&a=12
Cake:
https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1&h=#s2#&a=#price#&_tdhop=1
https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1&h=01617ed41e34043001000001&a=12&_tdhop=1

The Tracking Software will receive the notification and associate the vale 01617ed41e34043001000001 with the appropriate campaign and the attributes that were at the origin of this click_id.

One of the tokens sent by the traffic source is the click_id and very much like the tracking software, it will allow the traffic source to associate a conversion with such click_id.
If the traffic source provides you with a postback URL, the tracking software will be able to fire the postback URL while injecting the traffic source click_id into the appropriate query strings.
Here again, newbies (and sometimes experienced marketers can make mistakes, so it's important to test your integrations).

Example:
Mgid postback URL:
http://a.mgid.com/postback?c={subacc}&e=action112498&r=replace_with_revenue
http://a.mgid.com/postback&c=iayusd9fa9sd87f9asd7f9a8sd7f9asd87fa9sd87f&e=action112498&r=12


We published a while ago a post which describes the chain of events with an illustration. You ar welcome to "bookmark" it.

I hope this helps
Good luck
Laurent

 

[trackingdesk]

Hi @Graybeard - Thank you for the feedback. Much appreciated.

Unfortunately, I do not have such list and as you probably know, some affiliate programs, such as Amazon do not have any sort of postback / pixel tracking in place. Generally speaking, it is very rare these days to come across programs that do not provide any kind of support for postback, but it can still happen.

Reasons for not providing postback / pixel support:
- Privacy issues.
- Outdated systems
- Lack of awareness


The query string can be any word:
subid, id, clickid, myid, ref, aff_sub, tid etc...
The parameter / token is a "placeholder" which is filled by the ad network. This placeholder needs to be precisely inserted in the URL as the ad network will recognize it and fill it with a value.
For instance, you can have:
trackingdesk.com/?utm_term={keyword}
trackingdesk.com/?keyword={keyword}

And you can add this url in Adwords, and the values will be updated regardless of the query string term, as long as the {keyword} placeholder is set properly.
The Analytics / tracking System you use will associate the query string with an internal parameter, so it can aggregate data across multiple traffic sources.

Google Analytics, for instance, use the query string "utm_term" to aggregate "keywords".

Consequently, you can send traffic to your site adding utm_term / values, and whether the traffic comes from bing, adwords or other search marketing platform, your google analytics (or trackingdesk for that matter) will always associate the values with the keyword reporting.
If for some reason you misconfigure the placeholder in your tracking link
ex: trackingdesk.com/?utm_term={adgroupid}
You will see your adwords adgroupid under your keyword report.

When machine learning and articifial intelligence will make their first steps in our world, the analytics systems will gather, aggregate, classify, reorder and rearrange data automatically Not today, tough

 

[Graybeard]

Hi @Jojjua - I will assume that you are using a landing page (if you're not, then you should definitely consider using one).

Before you can properly setup your tracker, you need to understand the role of each of the elements you are working with:

The Traffic Source:
- Sends traffic to your campaign URL according to settings you've defined in your campaign settings. Geo Target, devices etc...
- The Traffic Source should append to your campaign URL some tokens so you can identify the traffic segments which are generating traffic / conversions / revenues.

The Affiliate Network
- Provides you with offer / offer links
- Track conversions / revenues
- Sends conversion notifications by way of postback URL to your tracker

The Landing page
- Where the traffic will initially arrive from your campaign.
- You can configure it to capture the traffic source tokens or not
- The LP carries your call to action URL, which is meant to redirect visitors to the offer link(s)

The Tracking system: Let's say that you have defined your traffic source tokens as:
View attachment 11876

Then your campaign URL will look like

http://servedbytrackingdesk.com/cWn6qOtY1nAwLRhJL?utm_source={zone_id}&utm_medium=native&utm_content={category}&utm_term={keyword}&utm_campaign={campaign_id}&click_id={click_id}

When the Traffic Source will send traffic to your URL, all the tokens will be replaced by real campaign values.

http://servedbytrackingdesk.com/cWn6qOtY1nAwLRhJL?utm_source=zone_1234&utm_medium=native&utm_content=software&utm_term=tracking&utm_campaign=cid_8993&click_id=iayusd9fa9sd87f9asd7f9a8sd7f9asd87fa9sd87f

One of the token sent by the traffic source is click_id and it will be later used to track conversions

The tracking software will do a few things:
- Record the visits and all associated values
- Generate a unique click id
- Redirect the visitor to the landing page that has been defined in the campaign (in the tracking software)

Optional:
If your tracking software supports this feature, it can also forward the visits values (keyword etc...) to the landing page URL: This can be useful if you are using google analytics to build audiences for retargeting campaigns.

https://trackingdesk.com/?utm_source=native&utm_source=zone_1234&utm_medium=native&utm_content=software&utm_term=tracking&utm_campaign=cid_8993&click_id=iayusd9fa9sd87f9asd7f9a8sd7f9asd87fa9sd87f&td_eid=01617ed41e34043001000001

When the visitors click on your call to action, they will be redirected to the offer link that has been associated with the landing page.
One Essential action that the tracker should do:
- Redirect the visitor to the offer link
- During the redirect, it should append to the offer link, the click_id generated by the tracking software during the initial visit.

In the example above, you will see at the end of the landing page URL the value: td_eid=01617ed41e34043001000001

It is crucial to understand that every affiliate network or affiliate software records this value in a different query string. This is one of the common mistakes done when you make your first steps with a tracking software.
Examples:
Hasoffers: offerlinnk?aff_sub=01617ed41e34043001000001
Cake: offerlink?s2=01617ed41e34043001000001
peerfly: offerlink?s1=01617ed41e34043001000001
clickbank: offerlink?tid=01617ed41e34043001000001
ytz: offerlink?sub1=01617ed41e34043001000001

When a conversion occurs, a chain of events will happen:
1. The affiliate network will fire your tracking software postback URL while injecting the click_id and the conversion value into predefined placeholders.
Examples:
Hasoffers:
Postback URL with placeholders: https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1?h={aff_sub}&a={payout}
Postback URL where the placeholders have been filled with the conversion values:
https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1?h=01617ed41e34043001000001&a=12
Cake:
https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1&h=#s2#&a=#price#&_tdhop=1
https://servedbytrackingdesk.com/54faa56f8a2940523628cdf8/a.gif?anid=5a7eb1d1d6359c0c0b461259&c=1&h=01617ed41e34043001000001&a=12&_tdhop=1

The Tracking Software will receive the notification and associate the vale 01617ed41e34043001000001 with the appropriate campaign and the attributes that were at the origin of this click_id.

One of the tokens sent by the traffic source is the click_id and very much like the tracking software, it will allow the traffic source to associate a conversion with such click_id.
If the traffic source provides you with a postback URL, the tracking software will be able to fire the postback URL while injecting the traffic source click_id into the appropriate query strings.
Here again, newbies (and sometimes experienced marketers can make mistakes, so it's important to test your integrations).

Example:
Mgid postback URL:
http://a.mgid.com/postback?c={subacc}&e=action112498&r=replace_with_revenue
http://a.mgid.com/postback&c=iayusd9fa9sd87f9asd7f9a8sd7f9asd87fa9sd87f&e=action112498&r=12


We published a while ago a post which describes the chain of events with an illustration. You ar welcome to "bookmark" it.

I hope this helps
Good luck
Laurent

What sites (not affiliate networks) in the Adult vertical are posting back to your system (that you are aware of)? Any? You can PM/conversation (inbox) me if you would rather not publicly post names. Transparency is a big problem in the adult vertical.

My thinking is that someone willing to do sale postbacks will have a harder time selectively shaving -- there would be no time lag.

That infographic is great



The Tracking Flow


In URL query strings the correct terminology is ?{query} $parameter=$value & [next pair]

updated
Sat Feb 10 12:47:22 EST 2018
Do you work with click-cash?

View attachment 12410

They are an old line cam affiliate program (20 yrs est 1996 that I have not used in the past -- no endorsement intended).


Graybeard, Feb 10, 2018

Krekski likes this

 

[AshelyAnderson212]

is there any free tracking tool ???

 

[trackingdesk]

@Graybeard - quick info.
the party receiving the URL call (postback or click) is setting the querystrings ex: utm_source=
the party sending value into the querystrings is defining the token into which they will send a value.
So Trackingdesk sending traffic to hasoffers links will send {event_id} into aff_sub
hasofferlink/?aff_sub={event_id} transform to hasofferlink/?aff_sub=0012830218310239213

So it's really up to the receiving party to define what will be the query string.
- Website will use "utm" so they can be compatible with google analytics and other web analytics
- affiliate programs
Cake : s2={event_id}
hasoffers: aff_sub={event_id}

Same story goes for incoming traffic into trackingdesk

utm_term={keyword} - associated with Keyword alias (internal parameter) will work for google adwords
We will record any value sent to utm_term and associate it with the "keyword" internal parameter for reporting purposes.

gclid={gclid} set to var_1 will record the google clickid
this value will then be sent into the traffic source postback url

postbackurl?conversion_id=*TS_var_1*

Where the receiving party defines the querystring where it wants to receive the conversion id, and trackingdesk defines the "placeholder" which will be replaced by the "gclid" value.

So there is no correct terminology / setting. It's really up to the parties to define those values and settings. This is one of the reason we try to integrate as many programs and sources in TrackingDesk, so you don't have to get mad with those settings.

@AshelyAnderson212 - Sure we have a free version, but limited features, traffic and you will not benefit from our outstanding, kind and professional support as much as our paid subscribers.

 

[azgold]

is there any free tracking tool ???

There are free ones, as well as trackers with free trials. You can check out trackers in the Resources section.

 

[Jojjua]

great job! Bot traffic is killing my campaigns

 

[Graybeard]

This is how I can track from my server logs

<SSH>>>
i found a few duplications need to tweak this code

The sort -- spaghetti code

tac /home/xxx/xxx.com/logs/access.log|egrep -i '/x/1=100-000' |cut -d'-' -f1 |sed -e 's/\./*/g' |uniq -c |sort -nr |sed -e 's/^[ \t]*//;s/[ \t]*$//g'|uniq -c |sort -nr | sed -e 's/^[ \t]*//;s/[ \t]*$//g'|sed 's/ /,/g'| cut -d',' -f1,3 |less

Price = free + years of working with big data and server logs

Without getting into all the code

IP count on that campaign
Repetition in 6 hrs over 3 days:

Line Count    Repeat IP    Percentage
5973    1    57.28%
3590    2    34.43%
407    3    3.90%
194    4    1.86%
68    5    0.65%
36    6    0.35%
26    7    0.25%
26    8    0.25%
26    9    0.25%
8    10    0.08%
74    11-54    0.71%
10428    TOTALS    100.00%

tac /home/xxxxx/xxxxxxxx.com/logs/access.log|egrep -i '/x/1=100-000' |cut -d'-' -f1 |sed -e 's/\./*/g' |uniq -c |sort -nr |sed -e 's/^[ \t]*//;s/[ \t]*$//g'|uniq -c |sort -nr | sed -e 's/^[ \t]*//;s/[ \t]*$//g'|sed 's/ /,/g'| cut -d',' -f1,3 |egrep '^[5-9][0-9],|^[4-9][0-9],|^[3-9][0-9],|^[2-9][0-9],'|sed 's/*/\./g'


54,96.244.139.130
39,69.36.94.135
39,67.88.84.166
35,66.119.59.223
34,173.13.69.253
31,81.27.79.18
30,66.214.246.10
30,38.106.154.29
30,173.11.49.149
29,24.181.242.250
28,50.246.4.189
28,24.39.144.162
26,75.147.213.105
25,71.189.47.2
22,168.11.212.5
21,74.7.226.154
21,109.228.7.202
20,208.190.91.208

Your software going to tell me the repetition rates of IPs per campaign ?



And that is how you find the scammers and clickbots --

barry@DS10:~$ ./asinfo.sh
Pls enter your ip:
96.244.139.130
AS | IP | AS Name
701 | 96.244.139.130 | UUNET - MCI Communications Services, Inc. d/b/a Verizon Business, US
barry@DS10:~$ ./asinfo.sh
Pls enter your ip:
69.36.94.135
AS | IP | AS Name
27597 | 69.36.94.135 | SITESERVER-IDC1 - Siteserver Hosting, Inc., US

 

[Graybeard]

One scammer caught


$ ./asinfo.sh
Pls enter your ip:
96.244.139.130
AS | IP | AS Name
701 | 96.244.139.130 | UUNET - MCI Communications Services, Inc. d/b/a Verizon Business, US



tac /home/xxxx/xxxxxxxxxx.com/logs/access.log|egrep -i '/x/1=100-000' |grep '96\.244\.139\.130' |cut -d'-' -f5,6 |sed 's/?/*/g'|cut -d'*' -f2|cut -d'"' -f1|uniq -c |sort -nr
3 zoneid=1442730&var=1442723
3 zoneid=1442730&var=1442723
2 zoneid=1520912&var=1541663
2 zoneid=1472939&var=1472930
2 zoneid=1472939&var=1472930
2 zoneid=1442730&var=1442723
2 zoneid=1442730&var=1442723
2 zoneid=1442730&var=1442723
2 zoneid=1095797&var=1091596
1 zoneid=1541752&var=1541750
1 zoneid=1541499&var=1541469
1 zoneid=1520912&var=1541663
1 zoneid=1520912&var=1541663
1 zoneid=1520912&var=1541663
1 zoneid=1520912&var=1541663
1 zoneid=1505320&var=1541662
1 zoneid=1505320&var=1541662
1 zoneid=1505273&var=1541661
1 zoneid=1499984&var=1499963
1 zoneid=1499984&var=1499963
1 zoneid=1499984&var=1499963
1 zoneid=1499984&var=1499963
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1472939&var=1472930
1 zoneid=1442730&var=1442723
1 zoneid=1442730&var=1442723
1 zoneid=1442730&var=1442723
1 zoneid=1442730&var=1442723
1 zoneid=1442730&var=1442723
1 zoneid=1442730&var=1442723
1 zoneid=1442730&var=1442723
1 zoneid=1095797&var=1091596
1 zoneid=1095797&var=1091596
1 zoneid=1095797&var=1091596
1 zoneid=1095797&var=1091596

 

[Graybeard]

times hmmm probably a scraper?

1 96.244.139.130 - - [09/May/2018:08:15:02
2 96.244.139.130 - - [09/May/2018:08:14:27
3 96.244.139.130 - - [09/May/2018:08:13:02
4 96.244.139.130 - - [09/May/2018:08:12:57
5 96.244.139.130 - - [09/May/2018:08:12:34
6 96.244.139.130 - - [09/May/2018:08:12:17
7 96.244.139.130 - - [09/May/2018:08:11:47
8 96.244.139.130 - - [09/May/2018:08:11:09
9 96.244.139.130 - - [09/May/2018:08:10:01
10 96.244.139.130 - - [09/May/2018:08:08:50
11 96.244.139.130 - - [09/May/2018:08:07:20
12 96.244.139.130 - - [09/May/2018:08:07:11
13 96.244.139.130 - - [09/May/2018:08:05:54
14 96.244.139.130 - - [09/May/2018:08:05:10
15 96.244.139.130 - - [09/May/2018:08:04:44
16 96.244.139.130 - - [09/May/2018:08:04:11
17 96.244.139.130 - - [09/May/2018:08:03:51
18 96.244.139.130 - - [09/May/2018:08:02:11
19 96.244.139.130 - - [09/May/2018:08:01:50
20 96.244.139.130 - - [09/May/2018:08:00:46
21 96.244.139.130 - - [09/May/2018:08:00:20
22 96.244.139.130 - - [09/May/2018:07:59:50
23 96.244.139.130 - - [09/May/2018:07:59:14
24 96.244.139.130 - - [09/May/2018:07:57:27
25 96.244.139.130 - - [09/May/2018:07:57:10
26 96.244.139.130 - - [09/May/2018:07:56:27
27 96.244.139.130 - - [09/May/2018:07:56:08
28 96.244.139.130 - - [09/May/2018:07:55:29
29 96.244.139.130 - - [08/May/2018:08:05:29
30 96.244.139.130 - - [08/May/2018:08:05:19
31 96.244.139.130 - - [08/May/2018:08:05:16
32 96.244.139.130 - - [08/May/2018:08:04:16
33 96.244.139.130 - - [08/May/2018:08:04:13
34 96.244.139.130 - - [08/May/2018:08:03:32
35 96.244.139.130 - - [08/May/2018:08:01:26
36 96.244.139.130 - - [08/May/2018:07:59:45
37 96.244.139.130 - - [08/May/2018:07:59:44
38 96.244.139.130 - - [08/May/2018:07:58:16
39 96.244.139.130 - - [08/May/2018:07:58:08
40 96.244.139.130 - - [08/May/2018:07:58:03
41 96.244.139.130 - - [08/May/2018:07:57:53
42 96.244.139.130 - - [08/May/2018:07:57:37
43 96.244.139.130 - - [08/May/2018:07:57:11
44 96.244.139.130 - - [08/May/2018:07:56:26
45 96.244.139.130 - - [08/May/2018:07:55:58
46 96.244.139.130 - - [08/May/2018:07:55:58
47 96.244.139.130 - - [08/May/2018:07:55:32
48 96.244.139.130 - - [08/May/2018:07:55:21
49 96.244.139.130 - - [08/May/2018:07:55:02
50 96.244.139.130 - - [08/May/2018:07:54:36
51 96.244.139.130 - - [08/May/2018:07:53:47
52 96.244.139.130 - - [08/May/2018:07:52:17
53 96.244.139.130 - - [08/May/2018:07:51:29
54 96.244.139.130 - - [08/May/2018:07:50:44

Either that or he really likes looking at porn at work -- this was an adult website campaign

 

[Graybeard]

And viola ... sort out one bad IP and the ad variables of the ad network -- drill down and track the 'bad guy'

root@ljca:~# tac /home/xxxxx/xxxxxxxxxx.com/logs/access.log|egrep -i '/x/1=100-000' |grep '96\.244\.139\.130' |cut -d'-' -f5,6 |sed 's/?/*/g'|cut -d'*' -f1|cut -d'"' -f1|uniq -c |sort -nr
28 0003 HTTP/1.1
26 0001 HTTP/1.1
Campaign sub ID ^^

10 1472939
7 1442730
4 1520912
4 1499984
4 1095797
3 1442730
2 1505320
2 1472939
2 1442730
1 1541752
1 1541499
1 1520912
1 1505273
1 1095797
Zone id ^^
10 1472930
7 1442723
4 1541663
4 1499963
4 1091596
3 1442723
2 1541662
2 1472930
2 1442723
1 1541750
1 1541663
1 1541661
1 1541469
1 1091596
var= ^^
raw data -- grouped
3 zoneid=1442730&var=1442723
3 zoneid=1442730&var=1442723
2 zoneid=1520912&var=1541663
2 zoneid=1472939&var=1472930
2 zoneid=1472939&var=1472930
...etc

 

[Graybeard]

When machine learning and articifial intelligence will make their first steps in our world, the analytics systems will gather, aggregate, classify, reorder and rearrange data automatically Not today, tough

Now that I have done the initial coding -- I could create software (bash scripts really *.sh) to find this data with one 'click' or even compare patterns with other 'campaign' values (if I was so motivated)

I don't find the needed algorithms so difficult ...