Skip to main content
The Google Sheets Marketing Data Source allows you to track ad spend from platforms without an API integration. This is useful for tracking influencer spend, offline advertising, or any custom marketing channels.

​
Set up the Marketing Data Source

  1. Navigate to the Marketing Sources Tab in your Converge dashboard.
  2. Click on Connect a new ad platform and name your marketing source sync: e.g Google Sheets | Influencer Spend
  3. Select Google Sheets from the drop-down list and sign in with your Google Account to allow Converge to read your spreadsheets.
  4. Paste the URL of the Google Sheet you want to sync.
  5. Map your columns to Converge fields:
    • Date (required): Select the column containing dates.
    • Spend (required): Select the column containing spend amounts.
    • Channel (required): Select the column or use “Manual input value” for a constant.
    • Campaign (required): Select the column or use “Manual input value” for a constant.
    • Ad Set Name (optional): Select the column or use “Manual input value” for a constant.
    • Go Live (optional): Select the column if applicable.
  6. After pressing Create, your spend data will be pulled into Converge.
For columns like Channel, Campaign, and Ad Set Name, you can choose “Manual input value” during mapping. This sets a constant value for all imported spend rows, which is useful when tracking a single campaign or channel in a sheet.

​
Sheet format requirements

Your Google Sheet should follow these formatting guidelines:

​
Required columns

  • Date: Must be in date format (Google Sheets recognizes standard date formats).
  • Spend: Must be a number (no currency symbols or commas).
  • Channel: The marketing channel (e.g. Influencer, Podcast, Billboard).
  • Campaign: The campaign name.

​
Optional columns

  • Ad Set Name: For more granular tracking within campaigns.
  • Go Live: If you track when campaigns go live.

​
Example sheet structure

DateSpendChannelCampaignAd Set Name
1/15/20255000.00InfluencerWinter Launchfoodblogger
1/16/20253500.00InfluencerWinter Launchtechreviewer
1/17/20252000.00PodcastBrand Awarenesstech_talk_show
Best practices:
  • Format the date column as a date in Google Sheets (not as text).
  • Format the spend column as a number.
  • Keep your sheet updated regularly for accurate reporting in Converge.
  • Use consistent naming for channels and campaigns across rows.

​
Syncing and updates

  • Converge will automatically sync your Google Sheet data every hour.
  • You can manually trigger a sync from the Marketing Sources dashboard.
  • Each sync updates the entire sheet. The data in Converge will reflect the data in the sheet, so if anything is added, removed, or updated, it’ll be reflected after the sync.
If you modify the structure of your sheet (add/remove columns, change column names), you’ll need to update your sync configuration in Converge.

​
FAQ

Yes, you can include multiple campaigns in a single sheet. During setup, map the Campaign column so Converge properly segments your spend data by campaign.
Converge will skip rows with invalid data and log an error in your sync status. Common issues include:
  • Date column not formatted as a date in Google Sheets.
  • Non-numeric values in the spend column.
  • Missing required fields.
You can view sync errors in the Marketing Sources dashboard to identify and fix issues.
Use “Manual input value” when you want to set a constant value for all rows in your sheet. For example, if you’re tracking all influencer spend in one sheet, you can set Channel to “Influencer” as a manual input value instead of adding a Channel column to your spreadsheet.
You can import historical spend data as far back as your sheet contains records. There’s no limit on historical backfill, but keep in mind that very large datasets may take longer to initially sync.

​
What you can track

The Google Sheets integration imports spend data that can be analyzed alongside your other marketing channels in Converge:
  • Ad Spend: Track your total expenditure across custom channels.
  • Channel-level reporting: View spend broken down by channel (e.g. Influencer, Podcast, Offline).
  • Campaign-level reporting: Analyze spend across different campaigns.
  • Ad Set-level reporting: Get granular insights if you’ve mapped the Ad Set Name column.
Since this integration focuses on spend tracking, performance metrics like ROAS, CPA, and conversions are calculated by Converge based on your tracked events and the imported spend data.