Skip to main content
Solved

Compatibility of Fulfilled Order and Campaign Name

  • November 3, 2022
  • 6 replies
  • 113 views

Forum|alt.badge.img+3
  • Active Contributor I
  • 14 replies

Hi!

I tried using the metric “Fulfilled Order” with the measurement parameter “value” and the “by” parameter “Campaign Name”, but I seem to never be able to get data for this combination. The segment in the response is always “Everyone” and there’s no data. Is this a valid combination? And if not, what are the segments available with the e-commerce metrics such as “Fulfilled Order”?

FYI, I use the endpoint https://developers.klaviyo.com/en/v1-2/reference/metric-export

Thank you!

 

Marie

 

Best answer by alex.hong

Hi there @Nymesia ,
Although there isn’t an entirely structured doc regarding that I believe this community article might point you in the right direction.

Let me know if that helps!
Alex

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

6 replies

alex.hong
Forum|alt.badge.img+58
  • Klaviyo Alum
  • 1552 replies
  • November 3, 2022

Hi there @Nymesia ,

The Fulfilled Order event is tracked when an order's status updates to either Shipped or Completed.

 

Fulfilled Order is a tricky metric to report on because the email that receives the attribution isn't always related to the original purchase.

  • For example, you might make your purchase on Friday, but the fulfillment doesn't happen until Sunday
  • Between Friday and Sunday, you may open/click other marketing emails that end up receiving the attribution for the Fulfilled Order event (instead of the email that originally caused the purchase)
  • There could also be cases where someone doesn't open/click any emails within the conversion window prior to a purchase, but prior to the Fulfilled Order syncing they do, which causes attribution to take place here
  • For more info on conversion tracking see here: https://help.klaviyo.com/hc/en-us/articles/115005248128-Understanding-Conversion-Tracking

 
With that being said, if you're trying to track revenue, Placed Order is a preferred metric for this as opposed to Fulfilled Order.

  • The Placed Order metric fires only once for each Placed Order. The Placed Order metric will include the price of the entire order, including shipping, fees, and any discounts.

 
The Ordered Product metric will fire once for each individual product ordered. This metric includes only details about the single product ordered and will only include the price of the product without any shipping, fees, or discounts.
 
You can read more about the difference between metrics in this Help Center article.

A bit of background, our Conversion tracking uses a last-touch model, so if someone clicks on or opens an email prior to making a purchase, and did so within the Conversion window, their purchase will be attributed to that Campaign. Your conversion settings are set to a 5 day window. More information here: Understanding Conversion Tracking.

?name=inline-205491501.png
 

Hope that helped,

Alex


Forum|alt.badge.img+3
  • Author
  • Active Contributor I
  • 14 replies
  • November 3, 2022

Hey @alex.hong !

 

Thank you so much for the detailed answer! I’ll definitely update my client as to the use of Placed Order instead of Fulfilled Order to calculate revenue.

 

As for the compatibility with the “Campaign Name” attribute, it seems that there isn’t any Placed or Fulfilled Order that is attributed to a Campaign, because I can’t get any data with the “by Campaign Name” parameter in the query I use. The results I get always look like these:

"results": [
        {
            "segment": "Everyone",
            "data": [
                {
                    "date": "2022-07-01 00:00:00",
                    "values": [
                        0.0
                    ]
                }
            ]
        }
    ]

 

However, if I use the value “$attributed_flow” as the “by” attribute, then I get results for Placed orders for each flow, like this:

"results": [
        {
            "segment": "AZA-MM-Post-Purchase / Replenishment Series (YcagZB)",
            "data": [
                {
                    "date": "2022-07-01 00:00:00",
                    "values": [
                        9963.66
                    ]
                }
            ]
        },

Do you know if there’s a way to obtain Orders data by Campaign Name through the API?

 

Thank you!

 

Marie


alex.hong
Forum|alt.badge.img+58
  • Klaviyo Alum
  • 1552 replies
  • November 3, 2022

Hi @Nymesia ,

Glad I could help!

Would something like this article be useful?

 

 


Forum|alt.badge.img+3
  • Author
  • Active Contributor I
  • 14 replies
  • November 3, 2022

Hey @alex.hong,

Actually, this is already the query I’m using! I was wondering if there was a compatibility page for e-commerce (or conversion) metrics (such as Placed Order), kind of like this one: https://developers.klaviyo.com/en/v1-2/reference/klaviyo-metrics-attributes. This is where I could get the compatibility between Klaviyo metrics and their corresponding attributes, so I could know which metric was compatible with which attribute.

For reference, my query is: 

https://a.klaviyo.com/api/v1/metric/LAFHTJ/export?start_date=2022-07-01&end_date=2022-07-31&count=1000&measurement=value&api_key=&by=$attributed_flow&unit=day

and I was wondering why, if I used this query instead: 

https://a.klaviyo.com/api/v1/metric/LAFHTJ/export?start_date=2022-07-01&end_date=2022-07-31&count=1000&measurement=value&api_key=&by=Campaign Name&unit=day

I wasn’t getting any data (compared to the previous one using $attributed_flow). There must be something I’m missing!

 

Thank you!

 

Marie


alex.hong
Forum|alt.badge.img+58
  • Klaviyo Alum
  • 1552 replies
  • Answer
  • November 4, 2022

Hi there @Nymesia ,
Although there isn’t an entirely structured doc regarding that I believe this community article might point you in the right direction.

Let me know if that helps!
Alex


Forum|alt.badge.img+3
  • Author
  • Active Contributor I
  • 14 replies
  • November 7, 2022

Hi @alex.hong ,

 

Yes!! That’s exactly what I was looking for: I understand that the equivalent segment of “Campaign Name” for conversion metrics is “$attributed_message”. I tested it, and the data indeed fits!

 

Thank you very much!

 

Marie