Ryan (ryan@themedialab.agency)
2025-04-01 16:44:22

Media Buyers, with the /isl command not working, we rushed the new Leadspedia Sold Leads data pipe that is refreshed every five minutes and put your own leads into your dashboards, so tab / page 2 is now "Todays Sold Leads".

Go check it out now, hope you LOVE it!

If you want past days, let us know and I will have Zek add a new third tab that has all leads with filters

🔥 Jack A.
Jack A. (jack@crediready.com)
2025-04-01 16:49:10

@Ryan past days data would be great! Any chance to include the dupes/not sold ones as well to know what % of a certain s1 is generating sold vs unsold leads?

Ryan (ryan@themedialab.agency)
2025-04-01 16:51:15

@Jack A., we can but it may be a second page since that is on another table called allleads not allsold_leads. And yes, we'll add past days data, how far back in days do you want?

Jack A. (jack@crediready.com)
2025-04-01 16:57:34

@Ryan yea, second page should be fine. Data from the past 30 days would be nice if its not too much trouble. Also, will historical data remain accessible—for example, will we be able to select specific dates to view data from those time periods?

Ryan (ryan@themedialab.agency)
2025-04-01 17:00:31

Yes

👍 Jack A.
Ryan (ryan@themedialab.agency)
2025-04-01 17:00:51

Data is going nowhere ever , it’s warehoused

Ryan (ryan@themedialab.agency)
2025-04-02 12:55:44

@here, I have made each of your dashboard Todays Sold Leads go back 90 days, added Date and Vertical Controls so you can narrow down as needed.

Ryan (ryan@themedialab.agency)
2025-04-02 12:56:06

@Jack A., we'll work on Non Sold Leads tab ASAP.

Ryan (ryan@themedialab.agency)
2025-04-02 12:57:30

@Jack A., and /isl is working for me this AM. I think a Vertical was added without a channel yet causing the code to loop and timeout. FYI @Brian Hirst

Brian Hirst (brian@themedialab.agency)
2025-04-02 12:57:54

@Brian Hirst has joined the conversation

Jack A. (jack@crediready.com)
2025-04-02 12:57:57

awesome, thank you! @Ryan

Ryan (ryan@themedialab.agency)
2025-04-02 12:58:16

@Brian Hirst, FYI on /isl, I removed Vertical 419 (i think) and it began working.

Ryan (ryan@themedialab.agency)
2025-04-02 12:58:22

from the ldp_verticals table

Jack A. (jack@crediready.com)
2025-04-02 13:00:25

@Ryan currently not showing data when selecting a specific date.

Screenshot 2025-04-02 at 10.59.29 AM.png
Screenshot 2025-04-02 at 11.00.14 AM.png
Brian Hirst (brian@themedialab.agency)
2025-04-02 13:01:44

@Ryan What system?

Brian Hirst (brian@themedialab.agency)
2025-04-02 13:02:08

That vertical is Student Photo hacking and it has a channel and an ISL run in it

Ryan (ryan@themedialab.agency)
2025-04-07 12:06:23

@here, Media Buyers, your Daily Sold Leads pages in your dashboards are updated and working. @Zekarias Haile and I will work to get Daily Unsold Leads out to you this week.

Ryan (ryan@themedialab.agency)
2025-04-07 16:11:25

@Jack A., Cam said you need to be able to download the Daily Sold Leads from dashboard to a sheet, can you show me what a sheet looks like and why you need to that? We change the format of that page to be exactly what you need to avoid downloading and pivoting if possible.

Jack A. (jack@crediready.com)
2025-04-07 16:12:38

i dont need to download it to a sheet. Currently i use the dash and export the leads to a google sheet and turn it into a pivot table to see how leads each S1 got me.

Ryan (ryan@themedialab.agency)
2025-04-07 16:12:56

Oh, want a page for that instead?

Ryan (ryan@themedialab.agency)
2025-04-07 16:13:12

Vertical by S1 by Lead Count right @Jack A.?

Jack A. (jack@crediready.com)
2025-04-07 16:13:57

Ya ill take a page for it to help streamline. Currently the Verticals tab isnt correct for me.

Screenshot 2025-04-07 at 2.13.29 PM.png
Jack A. (jack@crediready.com)
2025-04-07 16:14:54

here’s an example of the pivot chart.

Screenshot 2025-04-07 at 2.14.46 PM.png
Ryan (ryan@themedialab.agency)
2025-04-07 16:24:40

@Jack A., fixed first thing, had 2 of same data source, using two different ones in filters by accident. Fixed

Ryan (ryan@themedialab.agency)
2025-04-07 16:24:47

@Jack A., check out Sold Leads Pivot tab, that work?

Jack A. (jack@crediready.com)
2025-04-07 16:27:04

ya thats perfect

Ryan (ryan@themedialab.agency)
2025-04-07 16:51:44

@Caleb Peters @Jack A. @John Ventura @Maximus, your dashboards now have a pivot of sold leads by S1s. This should save you some valuable time in assessing your sold leads. @Zekarias Haile and @Nicholas McFadden and I are working on getting you Unsold Leads.

@Jack A., thanks for the information. Really appreciated.

🔥 Jack A.
Ryan (ryan@themedialab.agency)
2025-04-07 16:51:54

@Caleb Peters @Jack A. @John Ventura @Maximus, your dashboards now have a pivot of sold leads by S1s. This should save you some valuable time in assessing your sold leads. @Zekarias Haile and @Nicholas McFadden and I are working on getting you Unsold Leads.

@Jack A., thanks for the information. Really appreciated.

Zekarias Haile (zhaile@shield-legal.com)
2025-04-16 15:28:06

@Jack A. when you get a chance please take a look at page 4 and let me know how it looks https://lookerstudio.google.com/reporting/b85c80f3-d715-49ad-8300-122a3b1e55ba

☝️:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2025-04-22 13:31:30

@Jack A., can you confirm tab #4 works for non-sold leads?

☝️:skin_tone_4: Ryan
☝️ Zekarias Haile
Jack A. (jack@crediready.com)
2025-04-22 13:32:20

Just the dates are out of order, other then that works fine.

Screenshot 2025-04-22 at 11.31.52 AM.png
👀 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-22 13:46:16

@Jack A. Fixed. Please check now

image.png
Jack A. (jack@crediready.com)
2025-04-22 14:00:37

Great thanks

:yourewelcome: Zekarias Haile, Ryan
Zekarias Haile (zhaile@shield-legal.com)
2025-04-23 11:06:06

@Caleb Peters and @Maximus please take a look at page #4(unsold Leads) and let me know how it looks

Caleb - https://lookerstudio.google.com/u/0/reporting/56efa2f1-258c-41cd-a4ec-859b376c4056/page/p_ed9sw3gtrd Maximus -https://lookerstudio.google.com/u/0/reporting/cbd69da3-673e-45c4-987a-692e04684ff4/page/p_5evdllitrd

Caleb Peters (caleb@shield-legal.com)
2025-04-23 12:11:41

*Thread Reply:* Looks good to me. Thanks

:yourewelcome: Zekarias Haile
Maximus (maximus@internetthings.com)
2025-04-23 11:06:51

let me look

Maximus (maximus@internetthings.com)
2025-04-23 11:07:04

looks great

✅ Zekarias Haile
Maximus (maximus@internetthings.com)
2025-04-23 11:07:24

i am assuming this is all the leads?

Maximus (maximus@internetthings.com)
2025-04-23 11:07:27

rather than converted?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-23 11:10:50

Correct this dash shows unsold leads, not the converted ones.

Zekarias Haile (zhaile@shield-legal.com)
2025-04-23 11:30:09

@John Ventura please take a look at page #4 and let me know https://lookerstudio.google.com/u/0/reporting/acc06e89-e1fe-4f71-8eaa-9370bd56d95f/page/p_rzp8a4curd