Hey Greg, I'm working on consolidating a dashboard and have a quick question for you on the google sheet that Ryan shared with you and Mal.
I wanted to know which one is being shared with client and also which one do you think you might share it in future. Here's the https://docs.google.com/spreadsheets/d/1h2KichEoFitU5KeHn_JQdRswiDTvlmvlA1mRyVdrwhQ/edit?gid=0#gid=0&fvid=2075497697|link for the google sheet.
No worries. Will you be setting up new dashboard going forward?
Ok, I do have a few that need to be set up. I will get you the list tomorrow.
Please create a dashboard for LegaFi - NEC Baby Formula
@Zekarias Haile i updated the active client looker file and moved some we dont need to "archive". Did you get the dashboard built for LegaFi - NEC? If so, can you send me the link.
Thank you! I started working on it but im having some issues accessing it and I will ask Ryan later and I will share with you once I completed.
Did you get the LegaFi dashboard built? @Zekarias Haile
@Greg Owen Yes, I just requested Ryan to take a look at it to make sure everything is good to go.
Greg, here's the URL . Thanks for your patience.
I just looked at it, it isn't even close to being correct
Can you give Jon Becker access to the Meadow Law dashboard ASAP, please. Email is: mlf.jbecker@gmail.com
@Zekarias Haile I need some customer dashboards created please:
Flanagan - Chowchilla (Flanagan has a dashboard already, this campaign just needs to be added to it) VAM Law - Firefighting Foam DLA - IL Juv Hall
*Thread Reply:* Okay. I will. is DLA - IL Juv Hall = Illinois Juv Hall Abuse - BG - DLA - Shield Legal?
Also, the LegaFi - NEC dashboard still isnt correct. This is the correct format for customer dashboards:
*Thread Reply:* Do you want me to put the "Leads", Conversion Rate".... in the same sequence with the one in the above? That's the only difference I can see
*Thread Reply:* Yes, please have all look just like the one above. Please make sure there is a totals as the bottom.
@Greg Owen Looker is giving some errors and I'm looking into it to fix the error. FYI
@Greg Owen please see the dashes and let me know if something needs to be fixed.
those look good @Zekarias Haile. thank you
@Zekarias Haile can you add the Loghmana - Chowchilla campaign to the Loghmana dashboard, please. Also, please remove the Bailey Glasser logo from the Loghmana dashboard.
*Thread Reply:* @Greg Owen I don't see Loghmana dashboard on looker studio. Can you please send the link?
*Thread Reply:* Looks like I don't have access to it. Requested access from Ryan
*Thread Reply:* @Greg Owen I see Loghmana has dash with ACTS(ACTS/loghmana Dash ), that you haven't had access but granted you access now. So do you wanna me to add Chowchilla-ACTS-Loghmana campaign to this campaign or to the BG/Loghmana one.
*Thread Reply:* Yes, you can add it to the ACTS/Loghmana dash. I didn't know that one existed
@Zekarias Haile I also need dashboards made for the campaigns listed below. Please make 1 dashboard for SGGH and add all their campaigns (they also have a campaign with AWD for Dr Barry Brock) to the dashboard and make 1 dashboard for GLF (Gough Law Firm) and add just those 4 campaigns to it.
SGGH/GLF - IL Catholic Clergy SGGH/GLF - IL Youth Treatment SGGH/GLF - MI Catholic Clergy SGGH/GLF - MI Youth Clergy
I also need a dashboard for Banafshe Law for their Chowchilla campaign with ACTS.
@Greg Owen I shared all the links via email except the Loghmana- chowchilla one (it wont allow me to add that campaign but will figure out ...). Please take a look and let me know.
@Zekarias Haile did you get the Loghmana - Chowchilla dashboard figured out?
Hey Greg, I haven't tried today. I will work on it.
@Greg Owen please take a look and let me know.
https://lookerstudio.google.com/reporting/a9257b38-f88d-489a-90e2-34910a848203
@Zekarias Haile Please give Carter Matzinger access to all AWD dashboards. His email is cm@gfoamllc.com
Good morning Greg, he has already access to all dashes
@Zekarias Haile Here is the response Carter is getting when trying to access his dashboard: We are sorry, but you do not have access to Looker Studio. Please log in to your Admin Console to enable it. Go here to learn more.
Im not quite sure why he is getting the error. But as you can see access has been granted. Probably tell him to try using different browser
And please ask him if he has alternative email that we can use?
He doesn't have another email address. He said it worked before but now this morning it isn't working
That's weird. I mean we haven't change anything on our end. I don't know why but their email address was giving me an error when I tried to add it last month when Cam told me. Btw his email was the only one that I was be able to add it.
may be he should try it later... unless he probably create another email, I don't think that's some thing we can fix on our end
@Greg Owen I scheduled the dash to be sent everyday to cm@gfoamllc.com. We will see tomorrow morning if he is able to received it.
Thanks @Zekarias Haile. Hopefully it was a temporary thing
Good morning @Greg Owen have you had a chance to hear from Carter to see if he received via the scheduled email?
Hey @Greg Owen I received a request access to GLF dash
@Zekarias Haile Yes, please give Felice access.
@Zekarias Haile Please add the AWD/SGGH - Dr Scott Lee Abuse campaign AND the AWD/ACTS - Chowchilla campaign to the AWD dashboard.
AWD/SGGH Can I add Dr Scott Lee in to this?
Yes you can. Can you add the AWD/ACTS to that dashboard as well. So AWD has an "all campaigns" dashboard?
it makes things easier for me and for the firms
It was as per Cam request that I did it that way. But If you prefer all to be in one I can do that.
ok, leave it that way then if that is what Cam asked for
so I will just add Dr Scott to AWD/SGGH right?
please check it out and let me know https://lookerstudio.google.com/u/0/reporting/964d0ea0-0363-43cd-adff-f02d8a9a3b2e/page/ASVvC
@Zekarias Haile if you saw my last message, ignore it. I deleted it.
@Zekarias Haile AWD would like all of their campaigns to be on 1 customer dashboard. These are the campaigns that need to be on 1 combined dashboard (like we have with Meadow Law):
Dr Barry Brock Abuse (SGGH) Dr Scott Lee Abuse (SGGH) Chowchilla (ACTS) Paraquat (Wagstaff) Transvaginal Mesh (Anapol Weiss) Mormon Victim Abuse (Dolman) Mormon Victim Abuse (HRSC) San Bernardino JDC (SGGH) San Bernardino JDC OSOL (SGGH) San Diego JDC (SGGH) San Diego JDC OSOL (SGGH)
*Thread Reply:* @Greg Owen please take a look and let me know https://lookerstudio.google.com/u/0/reporting/92b33e31-6d60-4f99-851d-25eb47b862b9/page/ASVvC
*Thread Reply:* Looks perfect. Thank you @Zekarias Haile
@Zekarias Haile Can I get the link for the John Ye/ELG - Firefighting Foam dashboard, please. If it's not created yet, can you get it created.
@Greg Owen is this dash for ELG or Ye? whose Logo should I use?
@Greg Owen please take a look and let me know.
https://lookerstudio.google.com/reporting/72cb8e30-2584-4739-b864-3a0440d1680b
@Zekarias Haile looks good. thank you
@Zekarias Haile Have you created a Wright & Schulte customer dashboard for their Mormon Sex Abuse and Video Gaming Sextortion campaigns? If so, can you send me the link and if not, please get that created today.
@Greg Owen please take a look and let me know https://lookerstudio.google.com/reporting/8317a49b-e8c4-4816-85da-8b8155e16f2b
Perfect, thank you @Zekarias Haile
@Zekarias Haile please grant access to the Wright Schulte dashboard to wrightschultecampaigns@gmail.com
Thank you sir
@Zekarias Haile another one for access to their dashboard. For John Ye jye@johnyelaw.com
@Greg Owen can you ask them to provide us an email that is linked to google? it wont let give them access
@Zekarias Haile Please add the Gaming Sextortion campaigns for AWD/Cooper Masterson and AWD/Anapol Weill to the AWD All Cases dashboard
*Thread Reply:* This should be good to go
Also need Ghozland/Meadow/SGGH - Gaming Sextortion added to the Ghozland Dashboard and also added to the Meadow Dashboard
@Greg Owen on which one do you want me to add the Ghozland? these two are the one I see for Ghozland https://lookerstudio.google.com/u/0/reporting/8b9a6958-6c46-4fff-b672-c3453b2ef016/page/ASVvC https://lookerstudio.google.com/u/0/reporting/c7b17460-6fe8-41c7-8b0d-7e1ffc971f0d/page/ASVvC
Meadow should be good to go... you don't see Gaming Sextortion on the Dash it's because we don't have leads yet
To this one: https://lookerstudio.google.com/u/0/reporting/29151c3f-1753-4c41-8a68-bfbccdf68557/page/ASVvC
it looks like I dont have access. Requested access. So will work on that when Ryan give me access. FYI
i didnt have access the first Ghozland one listed above so i sent you the one i do have access to
yeah when Ryan gave me access there are few that he missed to grant me access.
It definitely needs to be the one i sent you
Not sure when you need it but I will work on that once i get access.
Good Morning @Greg Owen Ghozland dash is good to go. Pls check it and let me know
@Zekarias Haile Can you please add Michigan Juvenile Hall Abuse AND MI Youth Treatment Abuse campaigns for AFG/SGGH/Meadow to the Adair Financial Group dashboard.
@Zekarias Haile Can you make a dashboard for Legal Case Advisors and their campaign, please. LCA/Slater/Alliant - Northwell Sleep Center
Northwell sleep center is the only campaign they have right?
@Greg Owen Shall I add to this?
https://lookerstudio.google.com/reporting/9a4efca7-037b-403c-b2e7-579b5943668f
@Greg Owen here's the new one. I Removed the old one as it has missing stuff https://lookerstudio.google.com/reporting/1d1fc05a-83b3-420a-a786-f659ec8a3390
@Greg Owen here's the new one. I Removed the old one as it has missing stuff https://lookerstudio.google.com/reporting/1d1fc05a-83b3-420a-a786-f659ec8a3390
Thank you @Zekarias Haile
@Zekarias Haile please allow access to the Legal Case Advisors dashboard for sean@themedialab.agency
@Greg Owen Can you please find this dash for Cam? I couldn't find it looks like I don't have access
I dont have one. it needs to come from you or ryan
no, I was wondering if you have access... Ryan forgot to give me access I guess
@Zekarias Haile Can i get a dashboard made for Milberg Coleman Bryson Phillips Grossman for their Chowchilla campaign with SGGH
I will also need a dashboard for Aaron Law for their PFAS and Video Gaming Sextortion campaigns
*Thread Reply:* @Greg Owen here is the link for Aaron Law Group. Please take a look and let me know. https://lookerstudio.google.com/reporting/09ddc73f-9c1d-48dd-8068-d396f15cac64
*Thread Reply:* Looks good. Thank you @Zekarias Haile
@Greg Owen this is Aaron right? https://aaronlawgroup.com/
Yes, he may have an old dashboard already built, but I dont have the link
thanks, I dont have it either. I will ask Ryan and will create one if we dont have one
@Greg Owen here is Milberg's dash. please take a look and let me know https://lookerstudio.google.com/reporting/ba19ee0d-f9bd-455b-9acf-e9340700355c
for Aarons I've asked Ryan to check to see if we have one
Milberg looks good
@Zekarias Haile Can you please reconcile the customer dashboard with Law Ruler for VAM Law - Firefighting Foam and Firefighting Foam 2. Attached are the reports for both campaigns along with a link to the dashboard.
https://lookerstudio.google.com/u/0/reporting/ccfbfb05-a06e-4bfd-8f75-000d307456ee/page/ASVvC
@Greg Owen Are we having more on Law ruler or the dashboard? I haven't looked at it yet
What is the reason for the reconcilation?
The customer noticed a discrepancy between the 2. And is asking as pricing is different for the 2 campaigns
@Greg Owen there was a discripancy on Nov 4, 2024 and Jan 29, 2025 and I have fixed those. Please take and a look and let me know
Thanks Zeke. I will take a look
@Greg Owen now it's all updated to Dicello/Flatirons . FYI
thank you @Zekarias Haile