Schema Information for X Ads

Saras Daton

Need help with something?

Talk to data expert

In this article, we will look at the schema information of the supported APIs and tables for X Ads.

Find the links to other articles related to X Ads Below:

The following are the Tables or APIs associated with the X Ads connector.

Purpose: This API retrieves all ad accounts for the specified Organization.

Source API Documentation: Campaign_Stats

Primary Key: id - This is the unique identifier.

Name	Data Type
id	STRING
start_time	DATE
end_time	DATE
CampaignName	STRING
id_data	RECORD
id_data.metrics	RECORD
id_data.metrics.impressions	STRING
id_data.metrics.tweets_send	STRING
id_data.metrics.billed_charge_local_micro	STRING
id_data.metrics.media_engagements	STRING
id_data.metrics.follows	STRING
id_data.metrics.app_clicks	STRING
id_data.metrics.retweets	STRING
id_data.metrics.auto_created_conversion_session	STRING
id_data.metrics.likes	STRING
id_data.metrics.engagements	STRING
id_data.metrics.clicks	STRING
id_data.metrics.auto_created_conversion_landing_page_view	STRING
id_data.metrics.media_views	STRING
id_data.metrics.replies	STRING
id_data.metrics.url_clicks	STRING
id_data.metrics.billed_engagements	STRING
id_data.metrics.unfollows	STRING
id_data.metrics.conversion_purchases	RECORD
id_data.metrics.conversion_site_visits	RECORD
id_data.metrics.conversion_purchases.sale_amount_engagement	STRING
id_data.metrics.conversion_purchases.post_engagement	STRING
id_data.metrics.conversion_purchases.sale_amount	STRING
id_data.metrics.conversion_purchases.metric	STRING
id_data.metrics.conversion_purchases.sale_amount_view	STRING
id_data.metrics.conversion_purchases.post_view	STRING
id_data.metrics.conversion_site_visits.post_view	STRING
id_data.metrics.conversion_site_visits.post_engagement	STRING
id_data.metrics.conversion_site_visits.metric	STRING

rakuten authtoken

Table of Contents

Tables/APIs Supported Campaign_Stats