Skip to main content

I’m trying to create a report that shows which learners are associated with different subscriptions we’ve setup. While assigned subscriptions are reflected in the Access section of the learner profile, I’m having difficulty finding the associated data field in the Reporting Hub. Does anyone have suggestions or have experience building similar reports? The default Subscription Transaction Log isn’t helpful in this situation as it only reflects paid subscription purchases and not any associated with registration codes.

Hi there!

I have two ideas:

  1. Have you tried looking a subscription-based reports in Reporting Hub > Explore > Subscription Transactions, then reviewing the fields to see if you can find the one you are looking for? (I know some fields aren’t available to add to reports, which is hard when you are looking for a specific combination of data.)

    In the screen shot below, you’ll see All Fields, then Subscription Details field are revealed. Perhaps these will give you the info you want. You can click on the label to add it to the report or click on the green inverted triangle next to the label added as a filter. 
  2. If the above suggestions i not quite right since you are working on subscriptions + codes, try accessing Reporting Hub > Explore > How are learners enrolling in content? > Click redemptionCode on the pie chart, and that should give you a list of enrollments by redemption code. *I am not sure if subscriptions show here, so if they don’t, see #3.
  3. Is the report found on Users > Reg. Codes/Red. Codes > Actions > View Redemptions lacking info you need, or might that give you want you’re looking for?
     

I’d say check with your CSM if you haven’t already. They might know this answer, too, though I am really glad you posted here, so I don’t want to discourage that. :)

Take care!

 


  1.  

 


Hi @amberkleven! Thanks for the suggestions. Unfortunately, the first option only shows data for paid subscription purchases and doesn’t include registration or redemption code “purchases.” Suggestion 2 doesn’t get us to specific Subscription SKUs. The third suggestion results in a lot of .csv downloads since we have A LOT of registration codes, none of which contain the subscriptions that are associated with each registration code.

 

We’ve reached out for additional help with this, but thank you again for your suggestions.


Shoot! Thanks for taking the time to check out the options. One more idea-- you can use API to pull codes, so maybe that is an option. Here is the API call: redemptionshttps://api.thoughtindustries.com/#redemption-code-apis.

 

Have a great weekend.


@KKopp - were you ever able to get any acceptable Subscription reports? This is something we would love to have access to as well. We are currently allowing our customers to “gift” purchase subscriptions, which is a whole other ballgame!

Thanks for any input you might be able to share-

 


Hi ​@juliefiretech, I ended up having to have a custom report created by Support to view who/how many learners had each of our subscriptions since subscriptions aren’t only assigned by purchase and/or registration/redemption code. If you’re granting subscription access by codes, then you should be able to pull the data you need from the third option recommended. In our case, we manually grant subscriptions at times through the admin UI and also have a Salesforce automation setup that bypasses codes. 


We are actually trying to track gifted subscriptions and those don’t show up on the Subscription Transaction log.

I did some further digging and was able to find them in the regular Transaction Report as “Gift Subscriptions” and added the gift recipient email to the report.

But - this doesn’t help knowing who is actually enrolled in those subscriptions, which your custom report sounds like it did. How do I go about getting a customer report from Support? is that through PS? & extra cost I assume?

Thanks!


I had submitted a Support request ticket to inquire. They provided a one time report, but I’m sure if needed on a recurring basis, there’d be an associated cost.


Thanks ​@KKopp 


Reply