Skip to main content
Solved

Exporting Klaviyo Data for Analytics

  • December 17, 2020
  • 6 replies
  • 642 views

Forum|alt.badge.img+2

Hello,

I am fairly new to Klaviyo and was hoping to get some help with Klaviyo data that is captured in the tables. Is there a way to capture the click-to-action (CTA) data in one of the tables as a column? The idea is to track how many users clicked on the links/URLs in an email campaign. Also, is there a table that contains the actual email text (I know that it is stored within a bunch of HTML tags) to determine how many characters/words an email is?

If these data elements don’t already exist, is it possible to access those through an API?

Thanks,

Gautham

Best answer by David To

Hey @gautham,

Building off of @k.mcevoy, you can certainly utilize Klaviyo’s Metric API to export click data to your own external database. You can learn more about exporting metrics from Klaviyo for use externally from the following documents we offer:

@jenny13857, to elaborate further on this discussion, the screenshot provided by Gautham illustrates a report of the Clicked Email metric within their Klaviyo account broken down by URL. You can use these reports in a number of ways depending on your business and marketing goals. For example, sending an email which contains a promotion with a button directing customers to the specific promotion’s page; you can see how many users have actually clicked on this specific button in your email to see how engaging your recipients and content are. 

Hope this helps!

-David

View original
Did this topic or the replies in the thread help you find an answer to your question?

6 replies

k.mcevoy
Klaviyo Employee
Forum|alt.badge.img+6
  • Klaviyo Employee
  • 47 replies
  • December 17, 2020

HI Guatham, 

 

Thanks so much for contributing to the Klaviyo Community! If I’m understanding your end goal correctly you can use our segment builder to create a group of profiles who clicked a specific URL within an email: 

 

 

As for determining the size of an email prior to send, there is no native tool within Klaviyo but you can use this free online tool: http://bytesizematters.com/

 

Kelsey


Forum|alt.badge.img+2
  • Author
  • Contributor I
  • 1 reply
  • December 17, 2020

Hi Kelsey,

Thank you for the prompt response. I was hoping to accomplish that using the tables in the database, so I can use our reporting environment to build dashboards off of that. Would essentially want to recreate something like this plus more. Is that possible with the current setup? Or is there a way to get those additional data elements (in an automated way) into our database?

 

As for the email text, would be nice to automate that as well, but it’s not a high priority.


jenny13857
Contributor II
Forum|alt.badge.img+1
  • Contributor II
  • 3 replies
  • December 28, 2020

Can someone please tell me the main points to consider in this data pool? 


David To
Klaviyo Employee
Forum|alt.badge.img+60
  • Klaviyo Employee
  • 2456 replies
  • Answer
  • April 28, 2021

Hey @gautham,

Building off of @k.mcevoy, you can certainly utilize Klaviyo’s Metric API to export click data to your own external database. You can learn more about exporting metrics from Klaviyo for use externally from the following documents we offer:

@jenny13857, to elaborate further on this discussion, the screenshot provided by Gautham illustrates a report of the Clicked Email metric within their Klaviyo account broken down by URL. You can use these reports in a number of ways depending on your business and marketing goals. For example, sending an email which contains a promotion with a button directing customers to the specific promotion’s page; you can see how many users have actually clicked on this specific button in your email to see how engaging your recipients and content are. 

Hope this helps!

-David


Forum|alt.badge.img+1
  • Contributor II
  • 4 replies
  • May 20, 2021
david.to wrote:

Hey @gautham,

Building off of @k.mcevoy, you can certainly utilize Klaviyo’s Metric API to export click data to your own external database. You can learn more about exporting metrics from Klaviyo for use externally from the following documents we offer:

@jenny13857, to elaborate further on this discussion, the screenshot provided by Gautham illustrates a report of the Clicked Email metric within their Klaviyo account broken down by URL. You can use these reports in a number of ways depending on your business and marketing goals. For example, sending an email which contains a promotion with a button directing customers to the specific promotion’s page; you can see how many users have actually clicked on this specific button in your email to see how engaging your recipients and content are. 

Hope this helps!

-David

Hi, I’ve been through those links and where I”m getting stuck is in terms of Exporting data using “by” instead of “where”.    https://apidocs.klaviyo.com/reference/metrics#metric-export I’d like to export the data by campaign name, but I don't now what value to put in the &by= parameter in order to do this.  Do you have a reference so that I know what parameter names to use depending on how I want to segment the data?


Forum|alt.badge.img+1
  • Contributor II
  • 4 replies
  • May 20, 2021

Just replying to my own question here.  I found this thread and used &by=$message which worked: