Cameron Rentch (cameron@internetthings.com)
2024-10-23 17:06:44

@deleted-U06N28XTLE7 @deleted-U06C7A8PVLJ hello gents - you guys ran me some reporting with pivot tables back in July for PA, IL Juv abuse where we had the amount of signed claimants by facilty and also current age. attached is example, can we get new reports through current for all of these? (all time, all campaigns)

PA NJ MD IL Ca Juv

Thanks gents!

PA-Juv-Hall-All-Campaigns-All-Firms-Specific_facilities-current_age-Report-07.24.24 (1).xlsx
👍 deleted-U06N28XTLE7
🆗 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2024-10-23 17:08:34

@Cameron Rentch Yes we can work on that for you 🙂

Cameron Rentch (cameron@internetthings.com)
2024-10-23 17:09:27

thanks gents

✅ deleted-U06C7A8PVLJ
Cameron Rentch (cameron@internetthings.com)
2024-10-23 17:55:12

@deleted-U06C7A8PVLJ @deleted-U06N28XTLE7 also add New Hampshire!

🆗 deleted-U06C7A8PVLJ
👍 deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-10-23 17:57:59

@Cameron Rentch we should have a majority of this to you by EOD tomorrow. the rest might by Friday morning.

Cameron Rentch (cameron@internetthings.com)
2024-10-23 18:18:00

great thanks I appreciate it!

deleted-U06N28XTLE7
2024-10-23 18:18:15

you are very welcome

deleted-U06N28XTLE7
2024-10-25 19:23:16

@Cameron Rentch here is 5 of the 6 requested reports, I should be able to get you the last one by Monday.

Sorry it took a little bit longer than I though it would.

Cameron Rentch (cameron@internetthings.com)
2024-10-25 20:13:27

Thanks @deleted-U06N28XTLE7 no worries I know it’s been a busy week

Cameron Rentch (cameron@internetthings.com)
2024-12-02 17:38:49

@deleted-U06N28XTLE7 @deleted-U06C7A8PVLJ I need a pivot table report run for the following campaigns and specific data points. I need these BOTH by EOD today, apologies for last minute notice. thank you.

Crump Napoli Depo Provera

All time e-signed count Diagnosed Brain Meningioma total count Of these diagnosis How many shots were given/received for each claimant Year of their LAST shot

--------------

Nations (All campaigns since Sept 1,2024)

All time e-signed count Of total signed, how many are Thyroid disease (all types) Ulcerative colitis

👀 deleted-U06C7A8PVLJ
👍 deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-12-02 17:56:33

@Cameron Rentch do you us to include today's date signed clients for the Depo provera report as well

Cameron Rentch (cameron@internetthings.com)
2024-12-02 20:11:41

Thank you both @deleted-U06N28XTLE7 @deleted-U06C7A8PVLJ !!

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06N28XTLE7
2024-12-02 20:27:55

@Cameron Rentch you are welcome

Cameron Rentch (cameron@internetthings.com)
2024-12-02 20:43:29

@deleted-U06N28XTLE7 @deleted-U06C7A8PVLJ for the Nations report, I need the total signed count of ALL diagnosis, then of the total count, how many are Thyroid disease and how many are Ulcerative colitits. Can you please re run for me? Thank you

deleted-U06C7A8PVLJ
2024-12-02 20:44:36

Yes let me get that for you. Sorry about that @Cameron Rentch for the confusion

deleted-U06C7A8PVLJ
2024-12-02 21:03:55

@Cameron Rentch I had updated the report in the same link Dennis shared above. It has all diagnosis, all diagnosis count, how many are thyroid disease and how many are Ulcerative colitis and total signed based on all nations campaigns since sept 1 2024 to today

Cameron Rentch (cameron@internetthings.com)
2024-12-02 21:04:47

Thanks @deleted-U06C7A8PVLJ

deleted-U06C7A8PVLJ
2024-12-02 21:05:07

You're welcome ! Let me know if it is good to go 🙌:skintone2:

Cameron Rentch (cameron@internetthings.com)
2024-12-03 13:33:06

@deleted-U06C7A8PVLJ @deleted-U06N28XTLE7 I think something is wrong, Your report is showing 1079 total signed from 9-1-2-24, I am showing only 273, so I need you guys to re run the report with the correct date ranges, then update the pivot counts. Need asap

✅ deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2024-12-03 13:35:12

Reviewing as we speak ! Will make the corrections and send it out shortly

deleted-U06C7A8PVLJ
2024-12-03 13:51:02

Here you go @Cameron Rentch Nations Sheet I uploaded the excel data there in the same folder and on this message as well based on 09-01-2024 to 12-02-2024 dates. Also from my end I am getting 279 for total signed e-signs and diagnosis count for all diagnosis

Nations - 09-01-2024 to 12-02-2024 - Signed E-Signs and Diagnosis Total Count.xlsx
deleted-U06C7A8PVLJ
2024-12-03 13:51:22

This is for 09-01-2024 to 12-02-2024

deleted-U06C7A8PVLJ
2024-12-03 13:52:01

Firefighting Foam - Nations - Levinson (TC) - Shield Legal Firefighting Foam - Nations - Van - Shield Legal Firefighting Foam - Nations - Van/Levinson - Shield Legal Are the three campaigns I checked against since these should be the ones opened from Sep 1 2024 to current

Cameron Rentch (cameron@internetthings.com)
2024-12-03 15:15:03

great thank you @deleted-U06C7A8PVLJ

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Cameron Rentch (cameron@internetthings.com)
2024-12-12 21:46:53

@deleted-U06N28XTLE7 @deleted-U06C7A8PVLJ can you please , tmrw, run me a report:/pivot

AFFF (all firms last 120 days) Diagnosis S1 tag

I want to see diagnosis by s1 tags over the last 120 days. Need this tmrw as early as possible. Thank you 🙏

👍 deleted-U06N28XTLE7
👍:skin_tone_2: deleted-U06C7A8PVLJ
Cameron Rentch (cameron@internetthings.com)
2024-12-13 11:43:04

@deleted-U06N28XTLE7 @deleted-U06C7A8PVLJ ok this is a great start. Can you think of another way to sort these to be more easily digestible? How about "grouping" everything under the media buyer "initials", (IE "JA", "ML", "CP").

👀 deleted-U06C7A8PVLJ
deleted-U06N28XTLE7
2024-12-13 11:43:26

yes i can do that

deleted-U06N28XTLE7
2024-12-13 11:43:40

give me a few minutes and i can get that to you

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06N28XTLE7
2024-12-13 12:47:45

@Cameron Rentch

🙌 Cameron Rentch
Cameron Rentch (cameron@internetthings.com)
2024-12-19 12:37:39

@deleted-U06C7A8PVLJ @deleted-U06N28XTLE7 DL asking me for a pivot table report. I’m unsure of intake questions so review below and let me know sample data you suggest grabbing based on their request

Number of clients; Categories of damages; Number of client who have each category of damages; and Location of clients(city, zip)

👀 deleted-U06C7A8PVLJ
deleted-U06N28XTLE7
2024-12-19 12:39:37

@Cameron Rentch are they wanting all campaigns signed with them or a particular campaign or campaigns?

Cameron Rentch (cameron@internetthings.com)
2024-12-19 12:39:53

Sorry counters biolab

Cameron Rentch (cameron@internetthings.com)
2024-12-19 12:39:58

Conyers

👍 deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-12-19 13:02:32

@Cameron Rentch do you any client that was signed today or any client before today

Cameron Rentch (cameron@internetthings.com)
2024-12-19 13:08:07

@deleted-U06N28XTLE7 I dont understand the question

deleted-U06C7A8PVLJ
2024-12-19 13:08:21

I believe he is asking for time range

Cameron Rentch (cameron@internetthings.com)
2024-12-19 13:08:24

all BIO lab claimants signed all time

✅ deleted-U06C7A8PVLJ
deleted-U06N28XTLE7
2024-12-19 13:08:29

got it

✅ deleted-U06C7A8PVLJ
🙌:skin_tone_2: deleted-U06C7A8PVLJ
Cameron Rentch (cameron@internetthings.com)
2024-12-19 13:08:32

ty

deleted-U06N28XTLE7
2024-12-19 13:38:54

@Cameron Rentch .

👀 deleted-U06C7A8PVLJ
deleted-U06N28XTLE7
2024-12-19 13:39:26

if this works , then I can give you a full report based on this

Cameron Rentch (cameron@internetthings.com)
2024-12-19 15:50:36

@deleted-U06N28XTLE7 this seems good are there cases where there is property damage only and assuming there are a ton of other injuries? (more than just the 4 listed?)

👀 deleted-U06N28XTLE7, deleted-U06C7A8PVLJ
deleted-U06N28XTLE7
2024-12-19 16:37:15

@Cameron Rentch

Cameron Rentch (cameron@internetthings.com)
2024-12-19 17:42:48

@deleted-U06N28XTLE7 this is good. Please proceed and run with pivot

👍 deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-12-19 17:54:41

@Cameron Rentch

Cameron Rentch (cameron@internetthings.com)
2025-01-16 17:29:03

@deleted-U06N28XTLE7 @deleted-U06C7A8PVLJ can you, or feel free to assign to the right person, create a daily google sheet for DL/Flatirons

Depo Provera

I need a daily pivot that populates the following day (ie today's sign ups populate tomorrow)

Total signed claimants (count) How many shots recevied State where shots were given/received Of each shot received, brand or generic Treatment received, Radiation, surgery, both, none

Thanks

👍 deleted-U06N28XTLE7
👍:skin_tone_2: deleted-U06C7A8PVLJ