How to Export Number of Leads and MQLs by day only (dont need contact details)

[JDUnymira]

Reason: Setting up a Google Data Studio report  to simply show # of new leads on a daily basis + number of leads that became MQLs and SQLs

I don't care about the contact's details (name/email/etc).  So what I want to do is export (based on a filter so it's only leads for the US business) and get a table with these columns:

[Date]              [Total # of Leads] [Total MQLs] [Total SQLs]

01-Jan-2019  |           3                 |        0            |         1          |

Is this possible? Thanks

[Josh · Accepted solution]

Hi @JDUnymira,

Using the custom report feature you can do absolutely this.

1. Create a New Report for Contacts
2. Add data for Became MQL Date (or your other lifecylcle stages)
3. Add lifecycle stage
4. When visualize, change to table view
5. Show a summarized table view
6. Up in the right, you can export via CSV

See screenshot below.

 

I hope this helps!

Josh

[JDUnymira]

First of all - the initial issue was that our account had reached its limit for custom reports and wasn't letting me create it. 

Followup question - the report example you show uses "Became MQL" in the left most column when I rather need just the plain date and then 1 column for Became Lead and 1 column for Became MQL.  How do I set that up?

Trying now but can't seem to get the right configuration

[JDUnymira]

Awesome @Josh thanks so much for taking the time to explain and even attach a screenshot! Very helpful!