LogoLogo
  • The Moment Knowledge Base
  • Moment
  • My Pages
    • My Settings
    • Time
      • Timesheet
      • Hours Report
      • Time balance
      • Absence Overview
      • Absence Report
      • Planned absence
    • My overview
    • My Tasks
      • My Task Board
    • Project Management
      • To be invoiced
      • Project Report
      • Hours report
      • Invoices
    • My Travel & Expense
      • New Expense
      • Claims
    • Project Expenses
    • Education
    • Organization
    • My Stats
    • Menu items
  • Tasks
    • Planning
    • Recurring tasks
    • Tasks report
  • Customers
    • Overview
    • Customer profile page
    • Contacts and mailing lists
    • Invoicing settings for individual customers
  • Offers
    • How to activate the offer module in Moment
    • Sending offers from Moment
    • How do hours in activities from an offer show in Moment's capacity overview?
  • Quality
    • Checklists
      • Working with checklists
      • Importing checklist templates
      • Control column
      • Checklist Report
    • Nonconformities
      • Action types
      • Categorize with tags
      • Impact
    • Routines
    • Project reviews
    • Evaluations
    • Risk management
    • Risk report
    • Settings
    • How can Moment support ISO certification for your company?
  • Projects
    • Overview
      • On map
      • Status
    • Dashboard
    • Report
    • Price Lists
    • Forecast
    • How to setup hours approval in Moment
    • Project Roles
    • Projects Main Page
    • Template projects
    • Activities
      • How to copy activities, move hours from one activity and deleting activities.
    • Project plan
      • Project Plan features
      • Budgeted costs and revenue in Moment's Project Plan
      • Accrual report
    • Expenses
    • Price Model
      • Price model: Hourly rates
      • Price model: Fixed price
      • Price model: Subscription
    • Invoice settings
    • Profit Factor
      • Calculated profit factor
      • Fixed profit factor
    • Products
    • How to keep track of costs in non billable-projects
  • Resources
    • HR (Pro)
      • Configuration
      • Reports
    • Co-workers
      • Schedule
      • New user (co-worker)
        • First time login in Moment for new users
      • Access Rights
      • Education
      • Hourly rates
      • Licenses
      • 📆Absence Approval based on tags
      • How to register furloughing (permitteringer) in Moment?
      • Why do my co-workers and I have too many/few banked hours?
      • How to add co-workers to projects between two partner companies
    • Resource Planner
    • Reservations
    • Capacity
  • Finances
    • Invoices
      • Payment ID
        • Payment ID Examples
      • Credit invoices in Moment
      • Updating the invoice summary.
      • Can't export invoices to an external accounting system
      • Splitting invoices between two customers
    • Project expenses
    • Product sales
    • Subscriptions
    • To be invoiced
      • Invoice draft approval
      • Common problems that prevent invoicing
    • Payments and write off
      • Customer has paid an invoice twice/OCR file has been read twice
    • Customer ledger
    • Payment reminders
    • Invoicing in advance (A-konto)
    • OCR files (KID in Norway)
    • E-invoicing
      • Countries
        • Norway
        • Sweden
        • Iceland
        • Denmark
          • Background info and technical details
      • PEPPOL BIS Billing 3.0 (EHF 3.0)
      • Addresses / PEPPOL ID
  • Company
    • Hours overview
    • Absence
    • Timesheet status
    • Hours and vacation balance
    • Billable time report
    • Performance
    • Files
    • Logs
    • Forecast
    • Holidays
    • Export invoices
  • Setup
    • Access control
      • Settings for Role Based Access Control
    • Tags
    • Travel & Expense
      • T&E configuration
        • Expense types
          • Norway
            • 2022
            • 2023
            • 2024
    • Notifications
      • Export invoices
  • Moment - By topic
    • How to setup and test Moment
    • Education
      • Setup
      • Registration
      • Reporting
    • Partner Companies
    • Moment FAQ
      • Security
    • Integrations
      • Real-time integrations
        • 24SevenOffice
        • Azets
        • Business Central
          • Configuration
            • Business Central App
            • Business Central
            • Moment
          • Data flow
        • Business Central Payments
        • CatalystOne
        • DK+
        • DnB Regnskap
        • Fiken
          • Authorization
        • Fortnox
          • OAuth 2 authorization
        • Fortnox Payments
        • PowerOffice Go
        • SharePoint
          • Configuration
            • Azure Active Directory
              • Postman
            • SharePoint
              • Content Type
                • Activity
                • Year
                • Period
                • Tags
        • Sparebank1 Regnskap
        • Tripletex
          • VAT Settings
          • Cost category names
        • Uni Economy
        • Uniconta
        • Uniconta Payments
        • Visma e-conomic
          • Incoming expenses
          • Demo
        • Visma e-conomic Payments
        • Xledger
      • File exports
        • Accounting system
          • DK
          • Duett
          • Dynamics C5
          • eFina
          • InfoEasy
          • Mamut
          • SIE 4
          • Uni Economy
            • Import central
          • Uni Micro
          • Visma Business
          • Visma DI Systems
          • Visma Global
          • Visma Scenario
          • Visma.net
          • Xero
            • Xero templates
          • Xledger
            • Format AR10
            • Format GL02b
          • Factoring
            • SG Finans
              • File content
            • Sparebank1 factoring
        • Wage system
          • Hogia Lön
          • Huldt & Lillevik Lønn
          • Visma Lønn
        • Export templates
          • Template editor
            • Create template
            • Edit template
              • Content
            • Test template
          • Customers
          • Expenses (Claims)
          • Hours (Time records)
          • Projects
          • Custom template
      • File import
        • Integration/file import
          • SoMe Ad Expenses
            • Configuration
            • Import
            • Ad providers
            • Technical description
          • Visma Document Center
            • SFTP configuration
            • Visma Document Center CSV file
        • Moment Importer
        • Object import/update
          • Import
        • Tools
          • Checklist
          • Expenses from file
          • Import expenses
      • Other systems
        • Ambita
        • Holte
        • JIRA
        • MAKS
        • RecMan
      • SSO
        • Google
        • Microsoft
      • Webhooks
        • Claims
        • Customers
        • Invoices
        • Offers
        • Projects
      • Known issues
        • Tripletex
        • 24SevenOffice
        • General
          • Invoice not transferred due to VAT code
  • Change Log
  • For developers
    • API
      • Authorization
        • Postman
      • Rate limit
      • How to use the API
      • How to get the your data
        • projects/projectRegisteredHoursReport
        • timeRecords/getReport
      • Moment API Swagger
  • ProjectHelp
    • ProjectHelp Support
Powered by GitBook
On this page
  • General
  • Facebook
  • Google
  • Digital & Video 360
  • Microsoft
  • LinkedIn
  • Snapchat

Was this helpful?

  1. Moment - By topic
  2. Integrations
  3. File import
  4. Integration/file import
  5. SoMe Ad Expenses

Ad providers

PreviousImportNextTechnical description

Last updated 3 years ago

Was this helpful?

General

For all providers these name standards are the same

  • Name of provider is the first part of the file name

  • Year and month is the second part of the name

Files can only be imported once, if the same period needs to be updated/appended the file must be updated with an appendix for iteration. No check on number used, only that it is unique.

Example:

  • Original file name: "facebook_202111.csv"

  • Second import of the file, eg: "facebook_202111_1.csv"

  • Third import of the file, eg: "facebook_202111_2.csv"

Facebook

Files to be used for Facebook ads import must follow the format defined here.

The header row is not imported, exact names are not significant. The number of columns is important. The columns must be:

Column title
Description

Account ID

The ID used in Facebook for the account

Campaign name

Name of campaign

Currency

Currency for the specific record

Cost

Total cost/amount

The file type is CSV (Comma Separated Values), using "," (comma) as separator.

Provider name used as filename: facebook

Example

Google

Files to be used for Google ads import must follow the format defined here.

The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:

Column title

Description

Customer ID

The ID used in Google for the customer

Budget name

Name of campaign

Currency

Currency for the specific record

Billed Cost

Total cost/amount

The file type is CSV (Comma Separated Values), using "," (comma) as separator.

Provider name used as filename: google

Note! Google can deliver the various currencies in separate files, to accommodate this it's possible to add currency code before the file extension. eg "Google_YYYYMM_NOK.csv"

Example

Digital & Video 360

Files to be used for DV360 import must follow the format defined here.

The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:

Column title
Description

Account ID

The ID used in DV360 for the customer

Campaign name

Name of campaign

Currency

Currency for the specific record

Cost

Total cost/amount

The file type is CSV (Comma Separated Values), using "," (comma) as separator.

Provider name used as filename: dv360

Example

Microsoft

Files to be used for Microsoft ads import must follow the format defined here.

The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:

Column title
Description

Month

Not used in the import

Manager account name

Name of campaign

Account number

The ID used in Microsoft for the customer

Bill-to country/region

Determines currency for the specific record

Bill-to-name

Not used in the import

Document number

Not used in the import

Document type

Not used in the import

Billing type

Not used in the import

Net due

Total cost/amount

The file type is XLSX (Microsoft Excel).

Provider name used as filename: microsoft

Example

LinkedIn

Files to be used for LinkedIn ads import must follow the format defined here.

The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:

Column title

Description

Account ID

The ID used in LinkedIn for the account

Campaign name

Name of campaign

Currency

Currency for the specific record

Cost

Total cost/amount

The file type is CSV (Comma Separated Values), using "," (comma) as separator.

Provider name used as filename: linkedin

Snapchat

Files to be used for Snapchat ads import must follow the format defined here.

The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:

Column title

Description

Account ID

The ID used in Snapchat for the account

Campaign name

Name of campaign

Currency

Currency for the specific record

Cost

Total cost/amount

The file type is CSV (Comma Separated Values), using "," (comma) as separator.

Provider name used as filename: snapchat

Facebook
Google
Display & Video 360
Microsoft
LinkedIn
Snapchat
Example file for January 2021
The file must contain three rows of text , all comma separated, prior to the data.
Example file for January 2021
The file must contain ten rows, prior to the data.