How to View Historical Nightly Prices

This is something I’ve never been able to figure out… say I want to see what I charged for last New Year’s Eve, how can I see that? Last year I had guests stay for 6 nights so all I seem to be able to find is an average of those nights. Any ideas?

1 Like

I keep a spreadsheet.

Without keeping your own history you might be hooped. You might have to look at your emails with last years renters to see what you charged and figure it out from there.

Click on “Your Reservations”. Find the reservation for last 2016 New Year’s Eve. Click on “Print Confirmation”. You will see all the details of the reservation including the nightly fee. I don’t know for sure, but I believe that if you charged different fees for different nights it will show the average nightly fee.

1 Like

Yes, unfortunately the confirmation and everything is on the site just shows the average nightly rate. I know that Beyond Pricing used to show the last price before a booking was received, but they disabled that (probably because it wasn’t always accurate). I may ask Airbnb if this info is stored and available somehow…

1 Like

I’m interested in this too. I built superhosttools.com so I’ve become somewhat familiar with parts of the (undocumented) airbnb api and I wanted to add something like this to superhost tools. Unfortunately, I haven’t found anything that shows the correct price paid for each night. Like you said, it gives the average nightly rate for the whole booking but not each night’s rate. It does return some nightly prices but I’m not sure what they are because they don’t add up. Here’s what I’m getting:

From querying the calendar:

[
  {
    "available": false,
    "date": "2017-01-02",
    "external_calendar": null,
    "group_id": "reservation:XXXXXX",
    "host_busy": false,
    "listing_id": XXXXXX,
    "nested_busy_details": null,
    "notes": null,
    "price": {
      "date": "2017-01-02",
      "local_adjusted_price": 80,
      "local_currency": "USD",
      "local_price": 80,
      "native_adjusted_price": 80,
      "native_currency": "USD",
      "native_price": 80,
      "type": "demand_based_pricing",
      "demand_based_pricing_overridden": false,
      "demand_based_pricing_opted_in": false,
      "is_last_dynamic_pricing_day": false,
      "native_demand_based_price": 80,
      "native_original_price": 80,
      "native_suggested_price": null,
      "native_suggested_price_levels": null,
      "pricing_rule_adjustment_types": [
        
      ]
    },
    "reason": null,
    "reservation": {
      "confirmation_code": "XXXXXX",
      "formatted_host_base_price": "$126",
      "guest": {},
      "guest_details": {
        "localized_description": "2 guests",
        "number_of_adults": 2,
        "number_of_children": 0,
        "number_of_infants": 0
      },
      "guest_checkin_at": null,
      "is_group_payment_enabled": false,
      "host_currency": "USD",
      "host_payout_formatted": "$195",
      "localized_payout_price": 195,
      "payout_price_in_host_currency": 195,
      "pending_payment_hours_remaining": null,
      "nights": 2,
      "number_of_guests": 2,
      "replace_guest_profile_photo_with_initial": false,
      "start_date": "2017-01-02",
      "status": "accepted",
      "status_string": "Accepted",
      "thread_id": 278603890
    },
    "smart_promotion": null,
    "subtype": null,
    "type": "reservation",
    "ds_night_named_events": null
  },
  {
    "available": false,
    "date": "2017-01-03",
    "external_calendar": null,
    "group_id": "reservation:XXXXXX",
    "host_busy": false,
    "listing_id": XXXXXX,
    "nested_busy_details": null,
    "notes": null,
    "price": {
      "date": "2017-01-03",
      "local_adjusted_price": 80,
      "local_currency": "USD",
      "local_price": 80,
      "native_adjusted_price": 80,
      "native_currency": "USD",
      "native_price": 80,
      "type": "demand_based_pricing",
      "demand_based_pricing_overridden": false,
      "demand_based_pricing_opted_in": false,
      "is_last_dynamic_pricing_day": false,
      "native_demand_based_price": 80,
      "native_original_price": 80,
      "native_suggested_price": null,
      "native_suggested_price_levels": null,
      "pricing_rule_adjustment_types": [
        
      ]
    },
    "reason": null,
    "reservation": {
      "confirmation_code": "XXXXXX",
      "formatted_host_base_price": "$126",
      "guest": {},
      "guest_details": {
        "localized_description": "2 guests",
        "number_of_adults": 2,
        "number_of_children": 0,
        "number_of_infants": 0
      },
      "guest_checkin_at": null,
      "is_group_payment_enabled": false,
      "host_currency": "USD",
      "host_payout_formatted": "$195",
      "localized_payout_price": 195,
      "payout_price_in_host_currency": 195,
      "pending_payment_hours_remaining": null,
      "nights": 2,
      "number_of_guests": 2,
      "replace_guest_profile_photo_with_initial": false,
      "start_date": "2017-01-02",
      "status": "accepted",
      "status_string": "Accepted",
      "thread_id": 278603890
    },
    "smart_promotion": null,
    "subtype": null,
    "type": "reservation",
    "ds_night_named_events": null
  }
  }
]

From querying the reservation:

"host_price_breakdown": {
	"host_payout_breakdown": {
		"localized_explanation": null,
		"localized_title": "You earn",
		"total": {
			"amount": 195,
			"amount_micros": null,
			"amount_formatted": "$195",
			"is_micros_accuracy": false,
			"currency": "USD"
		},
		"type": "HOST_EARNINGS",
		"price_items": [
			{
				"localized_explanation": null,
				"localized_title": "$63 x 2 nights",
				"total": {
					"amount": 126,
					"amount_micros": 126000000,
					"amount_formatted": "$126",
					"is_micros_accuracy": false,
					"currency": "USD"
				},
				"type": "ACCOMMODATION",
				"price_items": [
					
				]
			},
			{
				"localized_explanation": "This fee will apply to every reservation at your listing.",
				"localized_title": "Cleaning fee",
				"total": {
					"amount": 75,
					"amount_micros": 75000000,
					"amount_formatted": "$75",
					"is_micros_accuracy": false,
					"currency": "USD"
				},
				"type": "CLEANING_FEE",
				"price_items": [
					
				]
			},
			{
				"localized_explanation": null,
				"localized_title": "Service fee",
				"total": {
					"amount": -6,
					"amount_micros": -6000000,
					"amount_formatted": "-$6",
					"is_micros_accuracy": false,
					"currency": "USD"
				},
				"type": "HOST_SERVICE_FEE",
				"price_items": [
					
				]
			}
		]
	}
}