kbzbG38r

1{
2  "md5": [
3    "c9bf72706e11fe3e621bf6f9f33fdca2"
4  ],
5  "createdAt": ISODate("2010-09-22T08:30:05.0Z"),
6  "email": {
7    "values": [
8      "franck.munch@gmail.com"
9    ],
10    "events": [
11      {
12        "serial": "t0o5vkh7cxcowgcwo0sw8kkwcww8sgs",
13        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
14        "value": "franck.munch@gmail.com",
15        "isTrigger": false,
16        "date": ISODate("2015-12-22T09:30:05.0Z"),
17        "project": {
18          "$ref": "project",
19          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
20          "$db": "dwh_data"
21        },
22        "brand": {
23          "$ref": "brand",
24          "$id": ObjectId("567284ae98a50b5a128b4680"),
25          "$db": "dwh_data"
26        },
27        "type": "add"
28      },
29      {
30        "serial": "1wi7jq5up7hcgcokccggg044g48cswg",
31        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
32        "value": "franck.munch@gmail.com",
33        "isTrigger": false,
34        "date": ISODate("2015-12-22T09:30:05.0Z"),
35        "project": {
36          "$ref": "project",
37          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
38          "$db": "dwh_data"
39        },
40        "brand": {
41          "$ref": "brand",
42          "$id": ObjectId("567284af98a50b5a128b4682"),
43          "$db": "dwh_data"
44        },
45        "type": "add"
46      },
47      {
48        "serial": "fkitp2p6abs4so04c80ccg08gwoc8ws",
49        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
50        "value": "franck.munch@gmail.com",
51        "isTrigger": false,
52        "date": ISODate("2015-12-22T09:30:05.0Z"),
53        "project": {
54          "$ref": "project",
55          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
56          "$db": "dwh_data"
57        },
58        "brand": {
59          "$ref": "brand",
60          "$id": ObjectId("567284b098a50b5a128b4683"),
61          "$db": "dwh_data"
62        },
63        "type": "add"
64      },
65      {
66        "serial": "bs4kd660orkgkwk84oo0kwgswg4kgkc",
67        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
68        "value": "franck.munch@gmail.com",
69        "isTrigger": false,
70        "date": ISODate("2015-12-22T09:30:05.0Z"),
71        "project": {
72          "$ref": "project",
73          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
74          "$db": "dwh_data"
75        },
76        "brand": {
77          "$ref": "brand",
78          "$id": ObjectId("567284b098a50b5a128b4684"),
79          "$db": "dwh_data"
80        },
81        "type": "add"
82      },
83      {
84        "serial": "dbx8ua3s9v4sw4k0cc0gg8wow4c4s0g",
85        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
86        "value": "franck.munch@gmail.com",
87        "isTrigger": false,
88        "date": ISODate("2015-12-22T09:30:05.0Z"),
89        "project": {
90          "$ref": "project",
91          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
92          "$db": "dwh_data"
93        },
94        "brand": {
95          "$ref": "brand",
96          "$id": ObjectId("567284b998a50b5a128b4696"),
97          "$db": "dwh_data"
98        },
99        "type": "add"
100      },
101      {
102        "serial": "sqo8qppq2kg04cwkw0wwgwc800wskkw",
103        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
104        "value": "franck.munch@gmail.com",
105        "isTrigger": false,
106        "date": ISODate("2015-12-22T09:30:05.0Z"),
107        "project": {
108          "$ref": "project",
109          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
110          "$db": "dwh_data"
111        },
112        "brand": {
113          "$ref": "brand",
114          "$id": ObjectId("567284ba98a50b5a128b469a"),
115          "$db": "dwh_data"
116        },
117        "type": "add"
118      },
119      {
120        "serial": "4jjpdnx6fqiow0wsgkss0kokoc0cwow",
121        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
122        "value": "franck.munch@gmail.com",
123        "isTrigger": false,
124        "date": ISODate("2015-12-22T09:30:05.0Z"),
125        "project": {
126          "$ref": "project",
127          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
128          "$db": "dwh_data"
129        },
130        "brand": {
131          "$ref": "brand",
132          "$id": ObjectId("567284be98a50b5a128b46a3"),
133          "$db": "dwh_data"
134        },
135        "type": "add"
136      },
137      {
138        "serial": "74pts0uxomos4kkkkcwkso4880cccs",
139        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
140        "value": "franck.munch@gmail.com",
141        "isTrigger": false,
142        "date": ISODate("2015-12-22T09:30:05.0Z"),
143        "project": {
144          "$ref": "project",
145          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
146          "$db": "dwh_data"
147        },
148        "brand": {
149          "$ref": "brand",
150          "$id": ObjectId("567284bf98a50b5a128b46a5"),
151          "$db": "dwh_data"
152        },
153        "type": "add"
154      },
155      {
156        "serial": "e4xwddre73swk0w08wcogcw0c8ossgc",
157        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
158        "value": "franck.munch@gmail.com",
159        "isTrigger": false,
160        "date": ISODate("2015-12-22T09:30:05.0Z"),
161        "project": {
162          "$ref": "project",
163          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
164          "$db": "dwh_data"
165        },
166        "brand": {
167          "$ref": "brand",
168          "$id": ObjectId("567284c198a50b5a128b46aa"),
169          "$db": "dwh_data"
170        },
171        "type": "add"
172      },
173      {
174        "serial": "nygl0nclye8k4w80ogocgco8osgkkw0",
175        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
176        "value": "franck.munch@gmail.com",
177        "isTrigger": false,
178        "date": ISODate("2015-12-22T09:30:05.0Z"),
179        "project": {
180          "$ref": "project",
181          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
182          "$db": "dwh_data"
183        },
184        "brand": {
185          "$ref": "brand",
186          "$id": ObjectId("567284c598a50b5a128b46b2"),
187          "$db": "dwh_data"
188        },
189        "type": "add"
190      }
191    ]
192  },
193  "domain": {
194    "values": [
195      "gmail.com"
196    ],
197    "events": [
198      {
199        "serial": "t0o5vkh7cxcowgcwo0sw8kkwcww8sgs",
200        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
201        "isTrigger": true,
202        "date": ISODate("2015-12-22T09:30:05.0Z"),
203        "value": {
204          "$ref": "domain",
205          "$id": ObjectId("5667f5c398a50bfd278b4569"),
206          "$db": "dwh_data"
207        },
208        "project": {
209          "$ref": "project",
210          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
211          "$db": "dwh_data"
212        },
213        "brand": {
214          "$ref": "brand",
215          "$id": ObjectId("567284ae98a50b5a128b4680"),
216          "$db": "dwh_data"
217        },
218        "type": "add"
219      },
220      {
221        "serial": "1wi7jq5up7hcgcokccggg044g48cswg",
222        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
223        "isTrigger": true,
224        "date": ISODate("2015-12-22T09:30:05.0Z"),
225        "value": {
226          "$ref": "domain",
227          "$id": ObjectId("5667f5c398a50bfd278b4569"),
228          "$db": "dwh_data"
229        },
230        "project": {
231          "$ref": "project",
232          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
233          "$db": "dwh_data"
234        },
235        "brand": {
236          "$ref": "brand",
237          "$id": ObjectId("567284af98a50b5a128b4682"),
238          "$db": "dwh_data"
239        },
240        "type": "add"
241      },
242      {
243        "serial": "fkitp2p6abs4so04c80ccg08gwoc8ws",
244        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
245        "isTrigger": true,
246        "date": ISODate("2015-12-22T09:30:05.0Z"),
247        "value": {
248          "$ref": "domain",
249          "$id": ObjectId("5667f5c398a50bfd278b4569"),
250          "$db": "dwh_data"
251        },
252        "project": {
253          "$ref": "project",
254          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
255          "$db": "dwh_data"
256        },
257        "brand": {
258          "$ref": "brand",
259          "$id": ObjectId("567284b098a50b5a128b4683"),
260          "$db": "dwh_data"
261        },
262        "type": "add"
263      },
264      {
265        "serial": "bs4kd660orkgkwk84oo0kwgswg4kgkc",
266        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
267        "isTrigger": true,
268        "date": ISODate("2015-12-22T09:30:05.0Z"),
269        "value": {
270          "$ref": "domain",
271          "$id": ObjectId("5667f5c398a50bfd278b4569"),
272          "$db": "dwh_data"
273        },
274        "project": {
275          "$ref": "project",
276          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
277          "$db": "dwh_data"
278        },
279        "brand": {
280          "$ref": "brand",
281          "$id": ObjectId("567284b098a50b5a128b4684"),
282          "$db": "dwh_data"
283        },
284        "type": "add"
285      },
286      {
287        "serial": "dbx8ua3s9v4sw4k0cc0gg8wow4c4s0g",
288        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
289        "isTrigger": true,
290        "date": ISODate("2015-12-22T09:30:05.0Z"),
291        "value": {
292          "$ref": "domain",
293          "$id": ObjectId("5667f5c398a50bfd278b4569"),
294          "$db": "dwh_data"
295        },
296        "project": {
297          "$ref": "project",
298          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
299          "$db": "dwh_data"
300        },
301        "brand": {
302          "$ref": "brand",
303          "$id": ObjectId("567284b998a50b5a128b4696"),
304          "$db": "dwh_data"
305        },
306        "type": "add"
307      },
308      {
309        "serial": "sqo8qppq2kg04cwkw0wwgwc800wskkw",
310        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
311        "isTrigger": true,
312        "date": ISODate("2015-12-22T09:30:05.0Z"),
313        "value": {
314          "$ref": "domain",
315          "$id": ObjectId("5667f5c398a50bfd278b4569"),
316          "$db": "dwh_data"
317        },
318        "project": {
319          "$ref": "project",
320          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
321          "$db": "dwh_data"
322        },
323        "brand": {
324          "$ref": "brand",
325          "$id": ObjectId("567284ba98a50b5a128b469a"),
326          "$db": "dwh_data"
327        },
328        "type": "add"
329      },
330      {
331        "serial": "4jjpdnx6fqiow0wsgkss0kokoc0cwow",
332        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
333        "isTrigger": true,
334        "date": ISODate("2015-12-22T09:30:05.0Z"),
335        "value": {
336          "$ref": "domain",
337          "$id": ObjectId("5667f5c398a50bfd278b4569"),
338          "$db": "dwh_data"
339        },
340        "project": {
341          "$ref": "project",
342          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
343          "$db": "dwh_data"
344        },
345        "brand": {
346          "$ref": "brand",
347          "$id": ObjectId("567284be98a50b5a128b46a3"),
348          "$db": "dwh_data"
349        },
350        "type": "add"
351      },
352      {
353        "serial": "74pts0uxomos4kkkkcwkso4880cccs",
354        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
355        "isTrigger": true,
356        "date": ISODate("2015-12-22T09:30:05.0Z"),
357        "value": {
358          "$ref": "domain",
359          "$id": ObjectId("5667f5c398a50bfd278b4569"),
360          "$db": "dwh_data"
361        },
362        "project": {
363          "$ref": "project",
364          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
365          "$db": "dwh_data"
366        },
367        "brand": {
368          "$ref": "brand",
369          "$id": ObjectId("567284bf98a50b5a128b46a5"),
370          "$db": "dwh_data"
371        },
372        "type": "add"
373      },
374      {
375        "serial": "e4xwddre73swk0w08wcogcw0c8ossgc",
376        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
377        "isTrigger": true,
378        "date": ISODate("2015-12-22T09:30:05.0Z"),
379        "value": {
380          "$ref": "domain",
381          "$id": ObjectId("5667f5c398a50bfd278b4569"),
382          "$db": "dwh_data"
383        },
384        "project": {
385          "$ref": "project",
386          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
387          "$db": "dwh_data"
388        },
389        "brand": {
390          "$ref": "brand",
391          "$id": ObjectId("567284c198a50b5a128b46aa"),
392          "$db": "dwh_data"
393        },
394        "type": "add"
395      },
396      {
397        "serial": "nygl0nclye8k4w80ogocgco8osgkkw0",
398        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
399        "isTrigger": true,
400        "date": ISODate("2015-12-22T09:30:05.0Z"),
401        "value": {
402          "$ref": "domain",
403          "$id": ObjectId("5667f5c398a50bfd278b4569"),
404          "$db": "dwh_data"
405        },
406        "project": {
407          "$ref": "project",
408          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
409          "$db": "dwh_data"
410        },
411        "brand": {
412          "$ref": "brand",
413          "$id": ObjectId("567284c598a50b5a128b46b2"),
414          "$db": "dwh_data"
415        },
416        "type": "add"
417      }
418    ]
419  },
420  "firstname": {
421    "values": [
422      
423    ],
424    "events": [
425      
426    ]
427  },
428  "lastname": {
429    "values": [
430      
431    ],
432    "events": [
433      
434    ]
435  },
436  "title": {
437    "values": [
438      
439    ],
440    "events": [
441      
442    ]
443  },
444  "gender": {
445    "values": [
446      
447    ],
448    "events": [
449      
450    ]
451  },
452  "birthdate": {
453    "values": [
454      
455    ],
456    "events": [
457      
458    ]
459  },
460  "phone": {
461    "values": [
462      
463    ],
464    "events": [
465      
466    ]
467  },
468  "cellPhone": {
469    "values": [
470      
471    ],
472    "events": [
473      
474    ]
475  },
476  "address": {
477    "values": [
478      
479    ],
480    "events": [
481      
482    ]
483  },
484  "zipcode": {
485    "values": [
486      
487    ],
488    "events": [
489      
490    ]
491  },
492  "city": {
493    "values": [
494      
495    ],
496    "events": [
497      
498    ]
499  },
500  "brand": {
501    "events": [
502      {
503        "serial": "t0o5vkh7cxcowgcwo0sw8kkwcww8sgs",
504        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
505        "isTrigger": false,
506        "date": ISODate("2010-09-21T22:00:00.0Z"),
507        "ip": null,
508        "value": {
509          "$ref": "brand",
510          "$id": ObjectId("567284ae98a50b5a128b4680"),
511          "$db": "dwh_data"
512        },
513        "project": {
514          "$ref": "project",
515          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
516          "$db": "dwh_data"
517        },
518        "brand": {
519          "$ref": "brand",
520          "$id": ObjectId("567284ae98a50b5a128b4680"),
521          "$db": "dwh_data"
522        },
523        "type": "subscribe"
524      },
525      {
526        "serial": "1wi7jq5up7hcgcokccggg044g48cswg",
527        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
528        "isTrigger": false,
529        "date": ISODate("2010-09-21T22:00:00.0Z"),
530        "ip": null,
531        "value": {
532          "$ref": "brand",
533          "$id": ObjectId("567284af98a50b5a128b4682"),
534          "$db": "dwh_data"
535        },
536        "project": {
537          "$ref": "project",
538          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
539          "$db": "dwh_data"
540        },
541        "brand": {
542          "$ref": "brand",
543          "$id": ObjectId("567284af98a50b5a128b4682"),
544          "$db": "dwh_data"
545        },
546        "type": "subscribe"
547      },
548      {
549        "serial": "fkitp2p6abs4so04c80ccg08gwoc8ws",
550        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
551        "isTrigger": false,
552        "date": ISODate("2010-09-21T22:00:00.0Z"),
553        "ip": null,
554        "value": {
555          "$ref": "brand",
556          "$id": ObjectId("567284b098a50b5a128b4683"),
557          "$db": "dwh_data"
558        },
559        "project": {
560          "$ref": "project",
561          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
562          "$db": "dwh_data"
563        },
564        "brand": {
565          "$ref": "brand",
566          "$id": ObjectId("567284b098a50b5a128b4683"),
567          "$db": "dwh_data"
568        },
569        "type": "subscribe"
570      },
571      {
572        "serial": "bs4kd660orkgkwk84oo0kwgswg4kgkc",
573        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
574        "isTrigger": false,
575        "date": ISODate("2010-09-21T22:00:00.0Z"),
576        "ip": null,
577        "value": {
578          "$ref": "brand",
579          "$id": ObjectId("567284b098a50b5a128b4684"),
580          "$db": "dwh_data"
581        },
582        "project": {
583          "$ref": "project",
584          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
585          "$db": "dwh_data"
586        },
587        "brand": {
588          "$ref": "brand",
589          "$id": ObjectId("567284b098a50b5a128b4684"),
590          "$db": "dwh_data"
591        },
592        "type": "subscribe"
593      },
594      {
595        "serial": "dbx8ua3s9v4sw4k0cc0gg8wow4c4s0g",
596        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
597        "isTrigger": false,
598        "date": ISODate("2012-07-31T22:00:00.0Z"),
599        "ip": null,
600        "value": {
601          "$ref": "brand",
602          "$id": ObjectId("567284b998a50b5a128b4696"),
603          "$db": "dwh_data"
604        },
605        "project": {
606          "$ref": "project",
607          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
608          "$db": "dwh_data"
609        },
610        "brand": {
611          "$ref": "brand",
612          "$id": ObjectId("567284b998a50b5a128b4696"),
613          "$db": "dwh_data"
614        },
615        "type": "subscribe"
616      },
617      {
618        "serial": "sqo8qppq2kg04cwkw0wwgwc800wskkw",
619        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
620        "isTrigger": false,
621        "date": ISODate("2010-09-21T22:00:00.0Z"),
622        "ip": null,
623        "value": {
624          "$ref": "brand",
625          "$id": ObjectId("567284ba98a50b5a128b469a"),
626          "$db": "dwh_data"
627        },
628        "project": {
629          "$ref": "project",
630          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
631          "$db": "dwh_data"
632        },
633        "brand": {
634          "$ref": "brand",
635          "$id": ObjectId("567284ba98a50b5a128b469a"),
636          "$db": "dwh_data"
637        },
638        "type": "subscribe"
639      },
640      {
641        "serial": "sqo8qppq2kg04cwkw0wwgwc800wskkw",
642        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
643        "isTrigger": false,
644        "date": ISODate("2013-07-31T13:38:11.0Z"),
645        "ip": null,
646        "value": {
647          "$ref": "brand",
648          "$id": ObjectId("567284ba98a50b5a128b469a"),
649          "$db": "dwh_data"
650        },
651        "project": {
652          "$ref": "project",
653          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
654          "$db": "dwh_data"
655        },
656        "brand": {
657          "$ref": "brand",
658          "$id": ObjectId("567284ba98a50b5a128b469a"),
659          "$db": "dwh_data"
660        },
661        "type": "unsubscribeOptin"
662      },
663      {
664        "serial": "4jjpdnx6fqiow0wsgkss0kokoc0cwow",
665        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
666        "isTrigger": false,
667        "date": ISODate("2010-09-21T22:00:00.0Z"),
668        "ip": null,
669        "value": {
670          "$ref": "brand",
671          "$id": ObjectId("567284be98a50b5a128b46a3"),
672          "$db": "dwh_data"
673        },
674        "project": {
675          "$ref": "project",
676          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
677          "$db": "dwh_data"
678        },
679        "brand": {
680          "$ref": "brand",
681          "$id": ObjectId("567284be98a50b5a128b46a3"),
682          "$db": "dwh_data"
683        },
684        "type": "subscribe"
685      },
686      {
687        "serial": "74pts0uxomos4kkkkcwkso4880cccs",
688        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
689        "isTrigger": false,
690        "date": ISODate("2010-09-21T22:00:00.0Z"),
691        "ip": null,
692        "value": {
693          "$ref": "brand",
694          "$id": ObjectId("567284bf98a50b5a128b46a5"),
695          "$db": "dwh_data"
696        },
697        "project": {
698          "$ref": "project",
699          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
700          "$db": "dwh_data"
701        },
702        "brand": {
703          "$ref": "brand",
704          "$id": ObjectId("567284bf98a50b5a128b46a5"),
705          "$db": "dwh_data"
706        },
707        "type": "subscribe"
708      },
709      {
710        "serial": "e4xwddre73swk0w08wcogcw0c8ossgc",
711        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
712        "isTrigger": false,
713        "date": ISODate("2010-09-21T22:00:00.0Z"),
714        "ip": null,
715        "value": {
716          "$ref": "brand",
717          "$id": ObjectId("567284c198a50b5a128b46aa"),
718          "$db": "dwh_data"
719        },
720        "project": {
721          "$ref": "project",
722          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
723          "$db": "dwh_data"
724        },
725        "brand": {
726          "$ref": "brand",
727          "$id": ObjectId("567284c198a50b5a128b46aa"),
728          "$db": "dwh_data"
729        },
730        "type": "subscribe"
731      },
732      {
733        "serial": "e4xwddre73swk0w08wcogcw0c8ossgc",
734        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
735        "isTrigger": false,
736        "date": ISODate("2013-07-02T10:44:23.0Z"),
737        "ip": null,
738        "value": {
739          "$ref": "brand",
740          "$id": ObjectId("567284c198a50b5a128b46aa"),
741          "$db": "dwh_data"
742        },
743        "project": {
744          "$ref": "project",
745          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
746          "$db": "dwh_data"
747        },
748        "brand": {
749          "$ref": "brand",
750          "$id": ObjectId("567284c198a50b5a128b46aa"),
751          "$db": "dwh_data"
752        },
753        "type": "unsubscribeOptin"
754      },
755      {
756        "serial": "nygl0nclye8k4w80ogocgco8osgkkw0",
757        "md5": "c9bf72706e11fe3e621bf6f9f33fdca2",
758        "isTrigger": false,
759        "date": ISODate("2010-09-21T22:00:00.0Z"),
760        "ip": null,
761        "value": {
762          "$ref": "brand",
763          "$id": ObjectId("567284c598a50b5a128b46b2"),
764          "$db": "dwh_data"
765        },
766        "project": {
767          "$ref": "project",
768          "$id": ObjectId("5666eb4c98a50be43e8b4567"),
769          "$db": "dwh_data"
770        },
771        "brand": {
772          "$ref": "brand",
773          "$id": ObjectId("567284c598a50b5a128b46b2"),
774          "$db": "dwh_data"
775        },
776        "type": "subscribe"
777      }
778    ],
779    "optin": [
780      {
781        "$ref": "brand",
782        "$id": ObjectId("567284ae98a50b5a128b4680"),
783        "$db": "dwh_data"
784      },
785      {
786        "$ref": "brand",
787        "$id": ObjectId("567284af98a50b5a128b4682"),
788        "$db": "dwh_data"
789      },
790      {
791        "$ref": "brand",
792        "$id": ObjectId("567284b098a50b5a128b4683"),
793        "$db": "dwh_data"
794      },
795      {
796        "$ref": "brand",
797        "$id": ObjectId("567284b098a50b5a128b4684"),
798        "$db": "dwh_data"
799      },
800      {
801        "$ref": "brand",
802        "$id": ObjectId("567284b998a50b5a128b4696"),
803        "$db": "dwh_data"
804      },
805      {
806        "$ref": "brand",
807        "$id": ObjectId("567284be98a50b5a128b46a3"),
808        "$db": "dwh_data"
809      },
810      {
811        "$ref": "brand",
812        "$id": ObjectId("567284bf98a50b5a128b46a5"),
813        "$db": "dwh_data"
814      },
815      {
816        "$ref": "brand",
817        "$id": ObjectId("567284c598a50b5a128b46b2"),
818        "$db": "dwh_data"
819      }
820    ],
821    "account": [
822      {
823        "$ref": "brand",
824        "$id": ObjectId("567284ae98a50b5a128b4680"),
825        "$db": "dwh_data"
826      },
827      {
828        "$ref": "brand",
829        "$id": ObjectId("567284af98a50b5a128b4682"),
830        "$db": "dwh_data"
831      },
832      {
833        "$ref": "brand",
834        "$id": ObjectId("567284b098a50b5a128b4683"),
835        "$db": "dwh_data"
836      },
837      {
838        "$ref": "brand",
839        "$id": ObjectId("567284b098a50b5a128b4684"),
840        "$db": "dwh_data"
841      },
842      {
843        "$ref": "brand",
844        "$id": ObjectId("567284b998a50b5a128b4696"),
845        "$db": "dwh_data"
846      },
847      {
848        "$ref": "brand",
849        "$id": ObjectId("567284ba98a50b5a128b469a"),
850        "$db": "dwh_data"
851      },
852      {
853        "$ref": "brand",
854        "$id": ObjectId("567284be98a50b5a128b46a3"),
855        "$db": "dwh_data"
856      },
857      {
858        "$ref": "brand",
859        "$id": ObjectId("567284bf98a50b5a128b46a5"),
860        "$db": "dwh_data"
861      },
862      {
863        "$ref": "brand",
864        "$id": ObjectId("567284c198a50b5a128b46aa"),
865        "$db": "dwh_data"
866      },
867      {
868        "$ref": "brand",
869        "$id": ObjectId("567284c598a50b5a128b46b2"),
870        "$db": "dwh_data"
871      }
872    ]
873  }
874}