Meta data reference

A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.

Each tab below notes whether it uses the export date range or always exports a full current snapshot when that applies.

For configuration steps see Configuring Meta exports.

Campaigns

One row per campaign. Entity metadata for the ad account; use Insights tabs for performance metrics over a date range.

ColumnDescription
Account IDAccount ID from the source platform.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
ObjectiveObjective.
StatusStatus.
Created TimeCreated Time.
Updated TimeUpdated Time.
Start TimeStart Time.
Stop TimeStop Time.
Budget RemainingBudget Remaining in the row currency unless noted otherwise.
Daily BudgetDaily Budget in the row currency unless noted otherwise.
Lifetime BudgetLifetime Budget.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Ad Sets

One row per ad set, including budget and targeting summary fields.

ColumnDescription
Ad Set IDAd Set ID from the source platform.
Account IDAccount ID from the source platform.
Ad Set NameAd Set Name.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
StatusStatus.
Bid AmountBid Amount in the row currency unless noted otherwise.
Budget RemainingBudget Remaining in the row currency unless noted otherwise.
Daily BudgetDaily Budget in the row currency unless noted otherwise.
Lifetime BudgetLifetime Budget.
Start TimeStart Time.
End TimeEnd Time.
Min AgeMin Age.
Max AgeMax Age.
GendersGenders.
LocationsLocations.
InterestsInterests.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Ads

One row per ad creative object under its campaign and ad set.

ColumnDescription
Account IDAccount ID from the source platform.
Ad IDAd ID from the source platform.
Ad NameAd Name.
Ad Set IDAd Set ID from the source platform.
Ad Set NameAd Set Name.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
StatusStatus.
Created TimeCreated Time.
Updated TimeUpdated Time.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Insights

Account-level performance insights. Date range: uses the selected export date range and time granularity.

ColumnDescription
Account IDAccount ID from the source platform.
Date StartDate Start.
Date StopDate Stop.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Set IDAd Set ID from the source platform.
Ad Set NameAd Set Name.
Ad IDAd ID from the source platform.
Ad NameAd Name.
PlatformPlatform.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
CPCCost per click.
CPMCost per thousand impressions.
CTRClick-through rate.
ReachEstimated unique people reached.
FrequencyAverage impressions per person reached.
Unique ClicksUnique Clicks.
Link ClicksLink Clicks.
Post EngagementPost Engagement.
Page EngagementPage Engagement.
LikesLikes.
CommentsComments.
SharesShares.
PostsPosts.
Content ViewsContent Views.
Add to CartAdd to Cart.
Checkout InitiatedCheckout Initiated.
PurchasesPurchases.
Omni Add to CartOmni Add to Cart.
Omni PurchasesOmni Purchases.
Purchase Conversion ValuePurchase Conversion Value in the row currency unless noted otherwise.
LeadsLeads.
RegistrationsRegistrations.
Purchases (1d Click)Purchases (1d Click).
Purchases (7d Click)Purchases (7d Click).
Purchases (1d View)Purchases (1d View).
Purchases (7d View)Purchases (7d View).
Leads (1d Click)Leads (1d Click).
Leads (7d Click)Leads (7d Click).
Video 25% WatchedVideo 25% Watched.
Video 50% WatchedVideo 50% Watched.
Video 75% WatchedVideo 75% Watched.
Video 100% WatchedVideo 100% Watched.
Outbound ClicksOutbound Clicks.
Inline Link ClicksInline Link Clicks.
Website CTRWebsite CTR.
Cost per ActionCost per Action in the row currency unless noted otherwise.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Insights (Campaigns)

One row per campaign (per time bucket). Date range: uses the selected export date range.

ColumnDescription
Account IDAccount ID from the source platform.
Date StartDate Start.
Date StopDate Stop.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
PlatformPlatform.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
CPCCost per click.
CPMCost per thousand impressions.
CTRClick-through rate.
ReachEstimated unique people reached.
FrequencyAverage impressions per person reached.
Unique ClicksUnique Clicks.
Link ClicksLink Clicks.
Post EngagementPost Engagement.
Page EngagementPage Engagement.
LikesLikes.
CommentsComments.
SharesShares.
PostsPosts.
Content ViewsContent Views.
Add to CartAdd to Cart.
Checkout InitiatedCheckout Initiated.
PurchasesPurchases.
Omni Add to CartOmni Add to Cart.
Omni PurchasesOmni Purchases.
Purchase Conversion ValuePurchase Conversion Value in the row currency unless noted otherwise.
LeadsLeads.
RegistrationsRegistrations.
Purchases (1d Click)Purchases (1d Click).
Purchases (7d Click)Purchases (7d Click).
Purchases (1d View)Purchases (1d View).
Purchases (7d View)Purchases (7d View).
Leads (1d Click)Leads (1d Click).
Leads (7d Click)Leads (7d Click).
Video 25% WatchedVideo 25% Watched.
Video 50% WatchedVideo 50% Watched.
Video 75% WatchedVideo 75% Watched.
Video 100% WatchedVideo 100% Watched.
Outbound ClicksOutbound Clicks.
Inline Link ClicksInline Link Clicks.
Website CTRWebsite CTR.
Cost per ActionCost per Action in the row currency unless noted otherwise.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Insights (Ad Sets)

One row per ad set (per time bucket). Date range: uses the selected export date range.

ColumnDescription
Account IDAccount ID from the source platform.
Date StartDate Start.
Date StopDate Stop.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Set IDAd Set ID from the source platform.
Ad Set NameAd Set Name.
PlatformPlatform.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
CPCCost per click.
CPMCost per thousand impressions.
CTRClick-through rate.
ReachEstimated unique people reached.
FrequencyAverage impressions per person reached.
Unique ClicksUnique Clicks.
Link ClicksLink Clicks.
Post EngagementPost Engagement.
Page EngagementPage Engagement.
LikesLikes.
CommentsComments.
SharesShares.
PostsPosts.
Content ViewsContent Views.
Add to CartAdd to Cart.
Checkout InitiatedCheckout Initiated.
PurchasesPurchases.
Omni Add to CartOmni Add to Cart.
Omni PurchasesOmni Purchases.
Purchase Conversion ValuePurchase Conversion Value in the row currency unless noted otherwise.
LeadsLeads.
RegistrationsRegistrations.
Purchases (1d Click)Purchases (1d Click).
Purchases (7d Click)Purchases (7d Click).
Purchases (1d View)Purchases (1d View).
Purchases (7d View)Purchases (7d View).
Leads (1d Click)Leads (1d Click).
Leads (7d Click)Leads (7d Click).
Video 25% WatchedVideo 25% Watched.
Video 50% WatchedVideo 50% Watched.
Video 75% WatchedVideo 75% Watched.
Video 100% WatchedVideo 100% Watched.
Outbound ClicksOutbound Clicks.
Inline Link ClicksInline Link Clicks.
Website CTRWebsite CTR.
Cost per ActionCost per Action in the row currency unless noted otherwise.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Insights (Ads)

One row per ad (per time bucket). Date range: uses the selected export date range.

ColumnDescription
Account IDAccount ID from the source platform.
Date StartDate Start.
Date StopDate Stop.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Set IDAd Set ID from the source platform.
Ad Set NameAd Set Name.
Ad IDAd ID from the source platform.
Ad NameAd Name.
PlatformPlatform.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
CPCCost per click.
CPMCost per thousand impressions.
CTRClick-through rate.
ReachEstimated unique people reached.
FrequencyAverage impressions per person reached.
Unique ClicksUnique Clicks.
Link ClicksLink Clicks.
Post EngagementPost Engagement.
Page EngagementPage Engagement.
LikesLikes.
CommentsComments.
SharesShares.
PostsPosts.
Content ViewsContent Views.
Add to CartAdd to Cart.
Checkout InitiatedCheckout Initiated.
PurchasesPurchases.
Omni Add to CartOmni Add to Cart.
Omni PurchasesOmni Purchases.
Purchase Conversion ValuePurchase Conversion Value in the row currency unless noted otherwise.
LeadsLeads.
RegistrationsRegistrations.
Purchases (1d Click)Purchases (1d Click).
Purchases (7d Click)Purchases (7d Click).
Purchases (1d View)Purchases (1d View).
Purchases (7d View)Purchases (7d View).
Leads (1d Click)Leads (1d Click).
Leads (7d Click)Leads (7d Click).
Video 25% WatchedVideo 25% Watched.
Video 50% WatchedVideo 50% Watched.
Video 75% WatchedVideo 75% Watched.
Video 100% WatchedVideo 100% Watched.
Outbound ClicksOutbound Clicks.
Inline Link ClicksInline Link Clicks.
Website CTRWebsite CTR.
Cost per ActionCost per Action in the row currency unless noted otherwise.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Date

One row per day (or selected time bucket) for account-level totals. Date range: uses the selected export date range.

ColumnDescription
Account IDAccount ID from the source platform.
Date StartDate Start.
Date StopDate Stop.
PlatformPlatform.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
CPCCost per click.
CPMCost per thousand impressions.
CTRClick-through rate.
ReachEstimated unique people reached.
FrequencyAverage impressions per person reached.
Unique ClicksUnique Clicks.
Link ClicksLink Clicks.
Post EngagementPost Engagement.
Page EngagementPage Engagement.
LikesLikes.
CommentsComments.
SharesShares.
PostsPosts.
Content ViewsContent Views.
Add to CartAdd to Cart.
Checkout InitiatedCheckout Initiated.
PurchasesPurchases.
Omni Add to CartOmni Add to Cart.
Omni PurchasesOmni Purchases.
Purchase Conversion ValuePurchase Conversion Value in the row currency unless noted otherwise.
LeadsLeads.
RegistrationsRegistrations.
Purchases (1d Click)Purchases (1d Click).
Purchases (7d Click)Purchases (7d Click).
Purchases (1d View)Purchases (1d View).
Purchases (7d View)Purchases (7d View).
Leads (1d Click)Leads (1d Click).
Leads (7d Click)Leads (7d Click).
Video 25% WatchedVideo 25% Watched.
Video 50% WatchedVideo 50% Watched.
Video 75% WatchedVideo 75% Watched.
Video 100% WatchedVideo 100% Watched.
Outbound ClicksOutbound Clicks.
Inline Link ClicksInline Link Clicks.
Website CTRWebsite CTR.
Cost per ActionCost per Action in the row currency unless noted otherwise.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Audiences

One row per custom audience. Full export each run: current audiences; the date range does not apply.

ColumnDescription
Account IDAccount ID from the source platform.
Audience IDAudience ID from the source platform.
Audience NameAudience Name.
DescriptionDescription.
Created TimeCreated Time.
Updated TimeUpdated Time.
SubtypeSubtype.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Related documentation

Something missing on this page? Email [email protected]

Start syncing your ecommerce data in minutes Start free today. No credit card required.