Logs

working with firebase analytics

6 min read

for 2024-08-05, we have three groups of firebase credentials worth of attention:

  • old firebase credentials
  • new firebase credentials (added in 2024-07-28) [2130, 2129, 2128, 2157, 2156, 2155, 2154, 2153, 2152, 2151, 2150, 2149, 2148, 2147, 2146, 2145, 2144, 2143, 2142, 2141, 2140, 2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131]
  • another batch of new firebase credentials (added in 2024-08-01) [2196, 2195, 2194, 2192, 2191, 2190, 2219, 2218, 2217, 2216, 2215, 2214, 2213, 2212, 2211, 2210, 2209, 2208, 2206, 2205, 2204, 2203, 2202, 2201, 2200, 2198, 2197, 2193]

Collecting data

Old firebase credentials

select date, sum(delivered_count) as deliveries from sender_firebase_statistics where date > '2024-07-27'  and  firebase_id not in [2130, 2129, 2128, 2157, 2156, 2155, 2154, 2153, 2152, 2151, 2150, 2149, 2148, 2147, 2146, 2145, 2144, 2143, 2142, 2141, 2140, 2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2196, 2195, 2194, 2192, 2191, 2190, 2219, 2218, 2217, 2216, 2215, 2214, 2213, 2212, 2211, 2210, 2209, 2208, 2206, 2205, 2204, 2203, 2202, 2201, 2200, 2198, 2197, 2193] group by date order by date;

New firebase credentials

select date, sum(delivered_count) as deliveries from sender_firebase_statistics where date > '2024-07-27'  and  firebase_id not in [2130, 2129, 2128, 2157, 2156, 2155, 2154, 2153, 2152, 2151, 2150, 2149, 2148, 2147, 2146, 2145, 2144, 2143, 2142, 2141, 2140, 2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131] group by date order by date;

Finding old but still active firebase accounts

query = Subscriber.objects.exclude(firebase_app__in=new).filter(subscribed_date__gt='2024-08-01')
channels = set()
for s in query.values('channel_id'):
    channels.add(s['channel_id'])

Than we use these channels to find out their owners, groups they belong to and whether they have some hardcoded accounts attached to them.

channel_ids = {33282, 33283, 28164, 9733, 9734, 9735, 9736, 28179, 29206, 29215, 28199, 28200, 7740, 7741, 7742, 7744, 7746, 7747, 29252, 7749, 7750, 29251, 22084, 4683, 33892, 29285, 29286, 33895, 33896, 33897, 33898, 33899, 33894, 26221, 33893, 9839, 9840, 33900, 10357, 29845, 26774, 27286, 26776, 26778, 26781, 27294, 27300, 12458, 33451, 33452, 30896, 33982, 33987, 33988, 15050, 33998, 33999, 34001, 27862, 28886, 29400, 27864, 29401, 28391, 34025, 33519, 28405, 23797, 34044, 27905, 25864, 34063, 34069, 34070, 34071, 11036, 32545, 32546, 32547, 28967, 34087, 18220, 28977, 10547, 10548, 10549, 10550, 10551, 28984, 28985, 28986, 28987, 10552, 28989, 34109, 6978, 32580, 34117, 32582, 32581, 11080, 11081, 34116, 11078, 11084, 11085, 11086, 11087, 11088, 11092, 15191, 33113, 29020, 17252, 29038, 29039, 29040, 29041, 29042, 7538, 33146, 29055, 29057, 34177, 34187, 11147, 10637, 21391, 31643, 34203, 29091, 34212, 34213, 34214, 26537, 29610, 34219, 34220, 6573, 6574, 27054, 9648, 9136, 10566, 14253, 9652, 10676, 9655, 9656, 9657, 9658, 31165, 22984, 34256, 34257, 34258, 6611, 6610, 34260, 34261, 34259, 10713, 28637, 9696, 9697, 30689, 9698, 28136, 28145}
for c in Channel.objects.filter(id__in=channel_ids):
    print(c.owner, c.firebase_app, c.push_service_group)

The output is interesting and shows us that the majority of these channels are either don’t belong to admin group or have some firebase accounts manually attached to them.

9735 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9733 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9736 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
7740 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
18220 ivashe4ca@gmail.com None admin
33146 larrynasgul@gmail.com None free_customers
33452 larrynasgul@gmail.com None free_customers
33519 ivashe4ca@gmail.com None admin
33893 khitsd013@gmail.com None free_customers
10566 admin@almightypush.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
33894 khitsd013@gmail.com None free_customers
10549 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
33896 etolog2023@gmail.com None free_customers
33900 alanbran53@gmail.com None paid_customers
28977 admin@almightypush.com None admin
29215 etolog2023@gmail.com None free_customers
28986 cpark2023cp@gmail.com None free_customers
10637 alinavavilchenkova@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
11147 admin@almightypush.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
7750 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
29038 cpark2023cp@gmail.com None free_customers
29039 cpark2023cp@gmail.com None free_customers
29041 cpark2023cp@gmail.com None free_customers
29055 etolog2023@gmail.com None free_customers
21391 admin@almightypush.com None admin
7538 admin@almightypush.com c4f16a90-516c-417e-afef-5f561c79b52e admin
7742 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9839 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
7744 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9734 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9840 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
7746 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
10552 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
9136 admin@almightypush.com c4f16a90-516c-417e-afef-5f561c79b52e admin
10548 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
34063 dkhits6@gmail.com None free_customers
34256 admin@almightypush.com None admin
34257 khitsd013@gmail.com None free_customers
34258 dkhits6@gmail.com None free_customers
34259 larrynasgul@gmail.com None free_customers
34260 alanbran53@gmail.com None paid_customers
34261 etolog2023@gmail.com None free_customers
9658 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
25864 alinavavilchenkova@gmail.com None admin
33987 khitsd013@gmail.com None free_customers
33988 alanbran53@gmail.com None paid_customers
33998 alanbran53@gmail.com None paid_customers
33999 etolog2023@gmail.com None free_customers
34025 imbuhlak@gmail.com None free_customers
34070 dkhits6@gmail.com None free_customers
34071 dkhits6@gmail.com None free_customers
34116 ivashe4ca@gmail.com None admin
34117 cpark2023cp@gmail.com None free_customers
27864 alanbran53@gmail.com None paid_customers
34177 admin@almightypush.com None admin
34187 alinavavilchenkova@gmail.com None admin
26781 khitsd013@gmail.com None free_customers
34203 ivashe4ca@gmail.com None admin
34212 cpark2023cp@gmail.com None free_customers
34213 cpark2023cp@gmail.com None free_customers
34214 cpark2023cp@gmail.com None free_customers
34219 ivashe4ca@gmail.com None admin
34220 ivashe4ca@gmail.com None admin
11036 admin@almightypush.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
10551 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
28200 ivashe4ca@gmail.com None None
10713 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
29252 etolog2023@gmail.com None free_customers
29400 cpark2023cp@gmail.com None free_customers
28637 ivashe4ca@gmail.com None admin
26221 alinavavilchenkova@gmail.com None admin
29401 cpark2023cp@gmail.com None free_customers
22084 admin@almightypush.com None admin
27862 alanbran53@gmail.com None paid_customers
28886 etolog2023@gmail.com None free_customers
30689 admin@almightypush.com None admin
7741 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
33451 larrynasgul@gmail.com None free_customers
34001 ivashe4ca@gmail.com None admin
12458 admin@almightypush.com None admin
7747 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
10357 admin@almightypush.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
7749 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9696 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
10547 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
10550 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
11087 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
10676 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
9657 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
11078 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
11086 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
4683 ivashe4ca@gmail.com None admin
6573 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
9655 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9656 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
11085 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
6574 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
28405 etolog2023@gmail.com None free_customers
33892 khitsd013@gmail.com None free_customers
33898 alanbran53@gmail.com None paid_customers
32582 larrynasgul@gmail.com None free_customers
33283 larrynasgul@gmail.com None free_customers
33899 alanbran53@gmail.com None paid_customers
33895 etolog2023@gmail.com None free_customers
33897 etolog2023@gmail.com None free_customers
29042 cpark2023cp@gmail.com None free_customers
11081 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
32581 larrynasgul@gmail.com None free_customers
28987 cpark2023cp@gmail.com None free_customers
33282 larrynasgul@gmail.com None free_customers
32580 larrynasgul@gmail.com None free_customers
29040 cpark2023cp@gmail.com None free_customers
23797 admin@almightypush.com 030bdf97-d628-4f97-a6dc-aa714196be4b admin
29020 admin@almightypush.com None admin
31165 admin@almightypush.com None admin
29610 cpark2023cp@gmail.com None free_customers
26537 admin@almightypush.com 6af9dee8-b2cc-42cc-ae3e-5826cd6a3e6e admin
30896 admin@almightypush.com None admin
34109 cpark2023cp@gmail.com None free_customers
31643 etolog2023@gmail.com None free_customers
29206 ivashe4ca@gmail.com None admin
11080 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
9698 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
34087 admin@almightypush.com None admin
29286 khitsd013@gmail.com None free_customers
28989 cpark2023cp@gmail.com None free_customers
34069 dkhits6@gmail.com None free_customers
29251 admin@almightypush.com None admin
32546 larrynasgul@gmail.com None free_customers
29285 khitsd013@gmail.com None free_customers
28967 khitsd013@gmail.com None free_customers
28391 etolog2023@gmail.com None free_customers
33113 larrynasgul@gmail.com None free_customers
29845 admin@almightypush.com None admin
28985 cpark2023cp@gmail.com None free_customers
28136 ivashe4ca@gmail.com None None
11084 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
28199 ivashe4ca@gmail.com None None
26778 khitsd013@gmail.com None free_customers
33982 ivashe4ca@gmail.com None admin
32547 larrynasgul@gmail.com None free_customers
29091 cpark2023cp@gmail.com None free_customers
34044 alanbran53@gmail.com None paid_customers
17252 admin@almightypush.com None admin
28984 cpark2023cp@gmail.com None free_customers
32545 larrynasgul@gmail.com None free_customers
27054 alinavavilchenkova@gmail.com None admin
26774 khitsd013@gmail.com None free_customers
26776 khitsd013@gmail.com None free_customers
14253 ivashe4ca@gmail.com None admin
15191 admin@almightypush.com None admin
11088 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
6611 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
9648 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
9652 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
27294 etolog2023@gmail.com None free_customers
6978 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
11092 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
9697 ivashe4ca@gmail.com c4f16a90-516c-417e-afef-5f561c79b52e admin
6610 ivashe4ca@gmail.com ceaf81d3-308f-4c9c-a996-6aaca837666b admin
28145 ivashe4ca@gmail.com None None
29057 igorglavin@gmail.com None paid_customers
27286 etolog2023@gmail.com None free_customers
27905 admin@almightypush.com None admin
27300 admin@almightypush.com None admin
15050 admin@almightypush.com 6af9dee8-b2cc-42cc-ae3e-5826cd6a3e6e admin
28179 ivashe4ca@gmail.com None None
22984 ivashe4ca@gmail.com None admin
28164 ivashe4ca@gmail.com None None

Graph View