Import ad spend from a file

Any ad platform can bring its spend into Sporetag as a file. Sporetag then shows return on ad spend (ROAS) for it on the Attribution tab, next to the sales it credited. This is also how Google Ads spend comes in until its one-click connect ships (when shipped).

It is on paid plans: Solo, Studio, Agency and Custom. Free does not include it.

Import a file

1. Open your site, then Integrations. Under Ad spend, click Import a file.
2. Pick the Platform if your file has no platform column, like a Google Ads report.
3. Pick the file and click Import.

Or open Paste from Google Sheets, select the cells in your sheet with the header row, copy and paste.

Sporetag says how many rows it added, and lists any line it could not read with what to fix. Fix those lines and import the whole file again. A row with the same date, platform, campaign, ad set and ad replaces the one already there, so nothing counts twice.

Columns

Start from Download the template on the import page. The first row names the columns. Their order does not matter.

Common names from platform reports work too: Day, Campaign name, Ad group, Cost, Amount spent, Currency code, Impr..

• One row per day and campaign (or ad set, or ad). Add up duplicates into one row.
• Dates up to two years back. No future dates.
• Spend in the account's own currency. Sporetag never converts money.
• Meta or Google Ads connected? Leave their rows out. Their spend comes in by itself, and the import refuses those rows so nothing counts twice.

Google Ads

1. In Google Ads, open Campaigns. Pick the date range.
2. Click Segment, then Time, then Day.
3. Make sure the columns include Campaign, Cost and Currency code. Add Campaign ID for the best match.
4. Click Download and pick .csv.
5. In Sporetag, pick Google Ads as the platform and import the file. The title lines and the total row at the end are skipped for you.

For ad group or ad detail, download the same report from Ad groups or Ads.

TikTok, Microsoft and others

Export a report by day with the campaign name, cost and currency, then import it with that platform picked. If the report has no currency column, add one to the file. The platform's help pages name the report screens.

Matching spend to sales

Spend joins the sales Sporetag credits by the tags on each ad's link: by campaign id (utm_id, or Google's {campaignid}) first, then by names. utm_campaign, utm_term and utm_content are matched to the campaign, ad set and ad, written the way the link builder writes them: lowercase, with hyphens for spaces. So "Spring Sale" in the file matches spring-sale on the link.

Campaigns with spend but no tracked visit show as spend we could not match to tracked links. Add the platform's URL template to those ads. See Tracking ads with UTMs.

Delete imported spend

The import page lists what came in, per platform. Click Delete next to a platform to remove all its imported spend.