How can we help?

New post
0

Marketo Static List - pulling in number of leads on the list to a klip

Avatar
Alexandra J Larkman
None
Follow

I have created a Marketo static list and it is linking to Klipfolio fine as a data source. However, I want to display the number of people on this list in one of my Klips and have no idea how to do this. Any suggestions?

Date Votes

6 comments

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Alex,

    Thanks for posting in our Community!

    You can use the COUNT function to count how many entries there are in a list.
    If you have names repeated multiple times, you can first GROUP them, and then use the COUNT function.

    Hope this helps!


    Best regards,
    Joshua
    _________________
    Joshua Cohen-Collier,
    Technical Support Specialist, Klipfolio

  • 0
    Avatar
    Alexandra J Larkman

    But how do I link the count function to this specific list? And/or what is the actual command?

    I have tried the command @/leads_count already but this doesn't work.

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Alex,

    Unfortunately, without actually seeing the data and Klip, it would be difficult to give more specific answers.
    However, if you'd like, I would be happy to create a support ticket for this so we can investigate manually?

    I would just need your OK, as well as you to enable support access, and direct me to the Klip in question.

    Joshua
    _________________
    Joshua Cohen-Collier,
    Technical Support Specialist, Klipfolio

  • 0
    Avatar
    Alexandra J Larkman

    Hi Joshua,

    Ok - I would be happy for you to log in to my instance and take a look. Sure you'll be able to fix it quickly. Would be great if you could then give me some instructions around this type of Marketo list / report.

    How do I enable support access to this?

    Thanks.

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Alex,

    I have gone ahead and created a ticket for you.
    To enable support access, you can follow these instructions here.

    Warm regards,
    Joshua

  • 0
    Avatar
    Alexandra J Larkman

    Hi Joshua,

    I have just granted support access as me (Alex Larkman - Admin). Please let me know if this doesn't work.

    The Dashboard in question is: My Dashboards > Business.

    Klip in question is: Database building and the number in question is Blog Subscribers row and Number of Subscribers column (currently shows 2,878 which as you will see when you go into the edit, I have just typed this number in)

    What I want this to show: is the number of leads on the Marketo list in the data source "Blog Subscriber List Marketo". The data source is being pulled into the data section of the Klip already, but I just don't know how to show the number of leads I have on this list in the Klip. I can see in the data source it says "Show the next 25 elements (out of 2878 total) - it is this total number, 2878, that I would like to display in the Klip (without typing it in each time!!).

    Let me know if any of this doesn't make sense.

    Thanks, Alex.

Please sign in to leave a comment.