PromoRepublic Data Export lets you export supported datasets for reporting, BI tools, spreadsheets and automated workflows.
🗂️ Choose an export format
Where Data Export is available, choose CSV or JSON. CSV remains the default.
📄 CSV — convenient for spreadsheets
🧩 JSON — useful for BI tools, scripts, integrations and automated workflows because it preserves structured values such as numbers, Boolean values, arrays and null values
🔢 CSV and JSON values
CSV and JSON exports use consistent values for the same dataset.
When analysing exported data, distinguish between the following states:
0: the metric was tracked and its recorded value is zero.
Empty or null: the metric exists, but no value was recorded for that row.
N/A: the metric does not apply or is not available for that network or context.
💡 Do not automatically convert empty, 0 and N/A into the same value in BI tools or reporting workflows, because they represent different states.
✅ Supported datasets
JSON is available for supported Data Export datasets, including:
Social Page Performance
Content Performance
Google Business Profile Performance
Facebook Ad Performance
Facebook Ad Campaign Performance
Reputation Manager Conversations
Local SEO
Locations
⚙️ Availability depends on your account modules and permissions.
📍 Local SEO export
The Local SEO dataset is designed for keyword level ranking analysis across locations.
A Local SEO export can include:
Ranking by keyword
Location identifiers
Google search location or ZIP code used for the ranking
Last Run date
💡 Use these fields together when comparing rankings. A ranking value should be interpreted in the context of the keyword, location, search geography and Last Run date.
🏢 Locations export
Locations exports can include the reporting period, country name, location creation date, Brands, tags, pages and other location relationships. In JSON, structured relationships such as Brands, tags and pages are represented as arrays.
Locations exports also include Google Rating and Google Reviews Count where Google data is available.
Google Rating represents the location’s current overall rating reported by Google. It is not limited to the reporting period selected for the export. This is different from period-based reputation metrics such as Average Star Rating.
💡 Use the current Google Rating when you want to identify the overall reputation strength of a location, for example locations currently below 4.0 stars or locations with a current 5.0 rating.
📈 Content Performance
Content Performance exports include the content type where available, making it easier to distinguish text, image and video content.
🚚 Delivery
JSON files can be used with supported export delivery methods, including email, FTP and scheduled reporting.